Senior Database Administrator I - PostgreSQL

We at Bottomline Technologies (Nasdaq: EPAY) has excellent opportunity for Sr. Database Admin (PostgreSQL) based in Bengaluru. We have flexible working environment with global exposure to work with internal product development teams across Europe, North America as well as locally from India.

Position Title: Database Administrator Senior I - PostgreSQL

Essential Job Functions:
• The PostgreSQL Database Performance Engineer will be responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases.
• Must have strong experience in DB tuning and implementing optimized configurations as per application load
• Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime.
• Develop Stored Procedures and Database Triggers in support of application development.
• Participate in application development projects and be responsible for database architecture and design.
• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
• Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Responsible for efficient recovery of databases in case of crashes.
• Responsible for regular maintenance of databases and proactive remediation of database operational problems.
• Responsible for Query tuning and preventative maintenance.
• Support complex web-based applications.

Required Skills:
• Experience as DBA in high-load, large-sized production DB
• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
• Good Knowledge of pgbadger and pgclue report analysis
• Hands-on experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster).
• Must have strong knowledge of Linux operating systems
• Strong understanding of command line and server administration.
• Knowledge of shell scripting (e.g., Bash, Perl).
• Strong experience in Performance tuning
• Excellent communication and presentation skills with the ability to communicate at all levels of the organization.
• Technical leadership and mentoring skills to guide and act as SME.
• Exceptional problem-solving skills
• Keen to learn new technology with enthusiasm and critical thinking
• Experience with encryption methodologies for databases
• Experience with database clustering technologies

Education and Experience:
• 7+ or more years hands-on Database Administration experience with 5+ yeras in PostgreSQL.
• Bachelor’s Degree in Computer Science, Information Systems, Engineering or relevant experience