PostgreSQL DBA with DevOps

Role Overview:

We are seeking a proactive PostgreSQL Database Administrator who can manage, optimize, and secure large-scale PostgreSQL environments, while also bringing strong DevOps automation and cloud deployment expertise. Youll involve on the reliability, performance, security and operability of mission-critical PostgreSQL systems, design and automate runbooks, and work closely with development, cloud and operations teams to deliver scalable, highly available database platforms.

Key Responsibilities:

• Administer, monitor, and tune PostgreSQL databases (backup, recovery, performance tuning, security).
• Automate database provisioning, scaling, and deployments using tools like Ansible, Terraform, or similar.
• Implement CI/CD pipelines and integrate DB changes into DevOps workflows.
• Manage database operations in cloud platforms (AWS/Azure/GCP) including high availability and disaster recovery.
• Troubleshoot production incidents; perform root-cause analysis and post-mortems.
• Work closely with developers, cloud engineers, and security teams for performance and scalability improvements.
• Coordinate with clients/stakeholders for approvals, change windows and reporting.
• Ability to lead cross-functional teams during high-severity incidents and drive quick resolution.

Required Skills & Qualifications:

• 36 years of hands-on experience as a PostgreSQL DBA.
• Solid understanding of database internals, query optimization, Data modelling, RBAC and replication.
• Solid Linux administration and shell scripting (bash); comfortable debugging OS-level issues impacting DB.
• Scripting & automation: Python and/or advanced shell scripting.
• Experience with DevOps tools (Git, Jenkins, Docker/Kubernetes, Ansible/Terraform, Packer, etc.).
• Hands-on exposure to at least one major cloud provider (AWS RDS/Aurora, Azure Database for PostgreSQL, or GCP Cloud SQL).
• Containerization basics: Docker; awareness of running DBs in container/k8s environments.
• Monitoring & logging: Prometheus, Dynatrace, Grafana, ELK/Fluentd or other observability stacks.
• Ability to leverage strong troubleshooting and incident management skills, with challenges and delivering timely resolutions.
• Willingness to work in rotational shifts, including weekends.

Nice-to-Have:

• Experience with database migration, upgrade projects, logical replication, BDR or Patroni.
• Knowledge of monitoring tools such as Prometheus, Grafana, or ELK.
• Familiarity with Yugabyte or distributed SQL systems (helpful given project context).
• Prior experience in Banking environment clients.
• Certifications: PostgreSQL, AWS/Azure Cloud certs.
• Experience in multi-tenant DB architectures and large scale OLTP systems.

Soft Skills & Other Expectations:

• Good communicator; able to explain technical issues to non-technical stakeholders.
• Client-facing experience and comfort with shift-based on-call rotations.
• Proactive mindset, documentation oriented, team mentorship capability.

Criteria:

• Should not have any accepted offer on hand
• Should be willing to sign an employee mutual agreement to pay 2x monthly salary in the event of offer-drop. The company will compensate 4x monthly salary, if we are unable to honour our offer.
• Notice period should not more than 45 days.

Please do not apply, if you can't meet any of the above criteria.