Administrator - L3

Mandaroty -PostgreSQL with multiple versions

Skill- Postgres

We are looking for Database Administrator with strong Postgre and preferably with DB2 LUW experience. Candidate will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects and support. Monitor and tune database and database application performance

• 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 backupsecovery.
• 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

1. Must be able to handle multiple tasks and changing priorities
2. Perform database installations, migrations, patches, and upgrades
3. Implement problem detection and prevention strategies to reduce database issues and improve service quality
4. 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