PostgreSQL Database Administrator (DBA)

Apply
  • Role: PostgreSQL Database Administrator (DBA)
  • Employment: Full Time
  • Experience: 6 to 8 Years
  • Salary: Not Disclosed
  • Location: PAN INDIA Remote,Jaipur,Hyderabad,Pune

Programmers.IO is currently looking to hire PostgreSQL Database Administrator (DBA) on PostgreSQL, complex query , Amazon Web Services – Relational Database Service / Aurora PostgreSQL and Azure Database Technology. If you think you are a good fit and willing to work from PAN INDIA Remote,Jaipur,Hyderabad,Pune location.Please apply with you resume or share your resume at ayushi.khandelwal@programmers.ai

Experience Required: 6 to 8 Years

Role Overview

We are seeking a highly skilled PostgreSQL Database Administrator (DBA) to ensure the stability, performance, availability, and security of our core database platforms. This is a hands-on, operations-focused role, with PostgreSQL administration as the primary responsibility. The ideal candidate will bring strong production experience with PostgreSQL, exposure to at least one other enterprise database platform such as SQL Server and/or Oracle, and hands-on experience with cloud-native database services on AWS and Azure.

Key Responsibilities

PostgreSQL Administration & Operations

  • Own day-to-day administration of PostgreSQL databases across development, test, staging, and production environments
  • Install, configure, upgrade, and patch PostgreSQL databases in self-managed and managed service environments
  • Monitor and tune database performance including query optimization, indexing strategies, and resource utilization
  • Manage backup, restore, disaster recovery, and high availability configurations
  • Troubleshoot database issues related to performance, locking, replication, connectivity, and data integrity
  • Implement and enforce database security best practices including access controls, encryption, and auditing

Cloud-Native Database Services (AWS & Azure)

  • Hands-on administration of PostgreSQL on AWS RDS, Aurora PostgreSQL, and Azure Database for PostgreSQL
  • Configure and manage automated backups, read replicas, scaling, multi-AZ, and high availability features
  • Support database modernization and on-premises to cloud migration initiatives
  • Collaborate with cloud and application teams to design scalable, resilient, and cost-efficient database architectures
  • Support integration scenarios involving relational and selective non-relational data stores, with PostgreSQL as the primary system of record

Cross-Database & Platform Exposure

  • Provide operational support and working knowledge of SQL Server and/or Oracle Database as secondary platforms
  • Participate in database migration, consolidation, and coexistence initiatives
  • Assist application and architecture teams with database selection and optimization decisions

Operational Excellence & Collaboration

  • Create and maintain runbooks, SOPs, and operational documentation
  • Participate in on-call rotations, incident management, root cause analysis, and post-incident reviews
  • Work closely with application, DevOps, cloud, and security teams to ensure smooth operations
  • Support capacity planning, performance benchmarking, and proactive risk mitigation

Required Skills & Experience

  • 6–8 years of overall DBA experience with PostgreSQL as the primary database platform
  • Strong hands-on experience managing PostgreSQL in production environments
  • Deep understanding of PostgreSQL internals including MVCC, WAL, vacuuming, replication, and locking behavior
  • Experience with backup, recovery, high availability, disaster recovery, and performance tuning
  • Working knowledge of SQL Server and/or Oracle Database
  • Strong SQL skills with the ability to analyze and optimize complex queries

Cloud & Platform Experience

  • Hands-on experience with AWS RDS / Aurora PostgreSQL and Azure Database for PostgreSQL
  • Understanding of cloud constructs such as scaling, monitoring, security, and cost optimization
  • Experience supporting hybrid or multi-cloud database environments

Nice to Have (Value-Add Skills)

  • Linux administration experience for database hosting and troubleshooting
  • Exposure to Infrastructure as Code tools such as Terraform
  • Familiarity with monitoring tools such as CloudWatch, Azure Monitor, Prometheus, or equivalent
  • Experience working with DevOps or SRE teams

Skills and Knowledge:

  • PostgreSQL, complex query , Amazon Web Services – Relational Database Service / Aurora PostgreSQL and Azure Database