Postgresql Database Administrator

Open Position- PostgreSQL DBA

Exp- 10+ years

Location- Chennai

Job Requirements*

• Deep knowledge of PostgreSQL architecture, internals, configuration parameters, and common system tables
• Expertise in identifying and troubleshooting performance issues, including query optimization, indexing strategies, analyzing execution plans, and managingautovacuumsettings and concurrency
• Hands-on experience with high-availability solutions (e.g., streaming replication,repmgr,pgpool,efm), backup strategies, and Point-In-Time Recovery (PITR) with tools likepg_dump,pg_restore, andpgBackRest
• Proficiency in day-to-day operations, including installation, configuration, minor and major version upgrades, patching, and routine maintenance tasks likeVACUUMandANALYZE
• Experience deploying and managing PostgreSQL databases in cloud environments such as GCP
• Strong scripting skills (e.g., Unix shell, Python, PL/pgSQL) for automating maintenance, deployment, and monitoring tasks, with a preference for infrastructure-as-code tools like Ansible or Terraform

Key Responsibilities*

• Administering multi-terabyte, mission-critical databases in high-volume, 24x7 environments
• Leading complex database migration projects, often from other systems like Oracle to PostgreSQL
• Collaborating with development teams on schema design, query optimization, and implementing database security best practices
• Planning for capacity, forecasting future needs, and implementing scaling measures
• Participating in on-call support rotations and leading incident management and troubleshooting efforts