PostgreSQL DBA

Position: PostgreSQL DBA

Location: Remote

Shift Time: 2pm to 11pm

Experience: 8+ Years

Job Overview:

We are looking for a highly experienced Senior PostgreSQL DBA to join our growing team. The ideal candidate will play a critical role in managing, optimizing, and scaling PostgreSQL databases in a Kubernetes-based environment that utilizes sharding and pods for high availability and distributed workloads. The role requires deep technical expertise, an ownership mindset, and hands-on experience working with mission-critical, high-throughput database systems.

Key Responsibilities:

·      Design, implement, and maintain highly available PostgreSQL clusters

·      Manage sharded database architecture and performance across multiple pods in Kubernetes

·      Optimize database performance, indexing, query tuning, and vacuuming strategies

·      Monitor, troubleshoot, and resolve database issues including replication, failover, and storage

·      Automate backups, recovery plans, and database provisioning

·      Ensure database security, access control, and compliance with client policies

·      Collaborate with DevOps and application teams to ensure smooth database operations and integrations

·      Participate in incident management and on-call support for database-related production issues

·      Perform database capacity planning, data partitioning, and archiving strategies

Technical Skills & Experience Required:

· years of hands-on experience with PostgreSQL administration

·      Strong knowledge of PostgreSQL performance tuning, replication, and backup/restore mechanisms

·      Experience with database sharding, partitioning, and horizontal scaling

·      Solid understanding of AWS services such as EC2, EKS, RDS, Aurora, S3, CloudWatcha

·      Proficient in writing SQL, PL/pgSQL, and automation scripts (Bash, Python, etc.)

·      Hands-on experience with monitoring and logging tools such as Datadog, Splunk, Prometheus, or pgBadger

·      Experience integrating with CI/CD pipelines and DevOps practices

·      Strong understanding of database security, auditing, and access control

Desirable Skills:

·      Exposure to cloud-native PostgreSQL services (e.g., Amazon RDS/Aurora, GCP Cloud SQL, Azure PostgreSQL)

·      Familiarity with PostgreSQL extensions like PostGIS, TimescaleDB, etc.

·      Knowledge of high availability tools (Patroni, Pgpool-II, Stolon, etc.)

·      Exposure to multi-tenant or microservices-based architectures

·      Knowledge of cloud cost optimization for database infrastructure

·      Experience working in an Agile development environment

Required Skills:

·      Strong problem-solving skills and proactive mindset

·      Ability to communicate technical concepts clearly with cross-functional teams

·      Comfortable in client-facing roles, especially during incidents and design discussions

·      Willingness to mentor junior DBAs and support team knowledge sharing