PostgreSQL Database Administration

Location: Bangalore, Chennai

- 8+ years experience in PostgreSQL Database Administration.

- Design, configure, test, and support high-availability clustering utilizing PostgreSQL technologies.

- Responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission-critical Production PostgreSQL databases.

- Responsible for all Logical and Physical backup & recovery even PITR recovery.

- Deep understanding about streaming replication and barman backups\recovery.

- Should poses knowledge on authentication and privilege management.

- Manage Clusters and upgrading/migrating various PostgreSQL database version.

- Performance Tuning, Replication, and develop database automation scripts and maintenance.

- Proficiency logical and physical design of database, monitoring and troubleshooting.

- Knowledge in DB2 LUW and Mongodb administration is added advantage.

- Provide technical guidance for integration, testing, design, development, planning of new production systems/databases.

Key Responsibilities :

- Must be able to handle multiple tasks and changing priorities.

- Perform database installations, migrations, patches, and upgrades.

- Implement problem detection and prevention strategies to reduce database issues and improve service quality.

- Perform production support administration tasks including proactive monitoring, troubleshooting, tracing, backup, recovery, and on-call support to ensure availability and performance requirements are achieved.

Education Qualification & Certification :

- Bachelors or masters degree preferred.

- Any Professional certification on Database technologies value add.