PostgreSQL DBA

Summary of the position

We are seeking a skilled and detail-oriented PostgreSQL Database Administrator to join our PMC India Office in Vadodara. The role is supervised by the Database Service Manager and involves the administration and support of enterprise-level, business-critical PostgreSQL environments.

This position requires a strong foundation in PostgreSQL architecture, performance tuning, high availability configurations, and data security. You will be expected to manage both routine and project-based database tasks, provide RCA for incidents, and ensure optimal performance of databases supporting various applications.

Responsibilities include implementing proactive monitoring, managing backup and DR processes, tuning OS and PostgreSQL configurations, and supporting developers across various environments (Dev, UAT, Prod).

The role also involves participation in a rotational 24/7 out-of-hours (OOH) support schedule including weekends and bank holidays. As the team matures, this will evolve into an on-desk 24/7 support model.

Key Accountabilities

• Provide incident resolution for PostgreSQL environments ensuring application availability and performance.

• Lead and manage incidents raised within the PMC resolver group while maintaining SLA compliance.

• Perform regular DBA responsibilities:

• PostgreSQL database maintenance, housekeeping, and vacuuming.
• Performance monitoring and alerting setup using tools like pg_stat_statements, pgBadger, and Prometheus/Grafana.
• Tuning of PostgreSQL and OS-level parameters for performance and reliability.
• Manage logical and physical replication setups, including streaming replication.
• Define and maintain backup/restore and DR procedures using tools like pgBackRest, Barman, or native pg_dump.

• Change Management:

• Evaluate and implement all PostgreSQL-related change requests.
• Support QA and production deployments, including rollback strategies.

• Project-Based Work:

• Schema design and implementation in collaboration with data architects.
• Review and optimize SQL and PL/pgSQL code.
• Perform PostgreSQL upgrades, patching, and extension management.
• Recommend tuning parameters and assist in capacity planning.
• Support integration with third-party tools and applications.

• Ensure database environments are prepared for backup, recovery, and DR scenarios.

• Participate in DR drills and provide support during DR events.

• Provide scheduled support during off-hours for maintenance and critical deployments.

• Offer technical leadership in PostgreSQL database architecture and future strategy.

• Ensure adherence to PMC and client-specific information security policies.

• Undertake additional responsibilities as required.

Skills and Experience | Essential

• Strong hands-on experience as a PostgreSQL DBA in a high-availability, high-throughput environment.
• Expertise in PostgreSQL configuration, performance tuning, replication, backup/restore, and disaster recovery.
• Familiarity with PostgreSQL on Linux systems, including scripting and automation using Bash or Python.
• Experience with monitoring and logging tools such as pgBadger, Prometheus, Grafana, and ELK stack.
• Good understanding of cloud platforms like AWS (especially RDS and Aurora), Azure, or GCP.
• Proficiency with PostgreSQL extensions like PostGIS, TimescaleDB, etc.
• Knowledge of connection pooling tools like PgBouncer or Pgpool-II.
• Experience in a 24/7 production support environment.
• Bachelor's degree in Computer Science or equivalent technical discipline.

Skills and Experience | Desirable

• Experience in full lifecycle PostgreSQL project implementations.
• Familiarity with CI/CD pipelines for database deployment.
• Experience with NoSQL and cloud-native databases.
• Working knowledge of version control systems (e.g., Git) and DevOps practices.
• ITIL certification or equivalent understanding of IT service management.
• Exposure to other RDBMS (e.g., MySQL, Oracle) and data migration tools.