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 :
8+ years of hands-on experience with PostgreSQL administrationStrong knowledge of PostgreSQL performance tuning, replication, and backup / restore mechanismsExperience with database sharding, partitioning, and horizontal scalingSolid understanding of AWS services such as EC2, EKS, RDS, Aurora, S3, CloudWatchaProficient 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 pgBadgerExperience integrating with CI / CD pipelines and DevOps practicesStrong understanding of database security, auditing, and access controlDesirable 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 architecturesKnowledge of cloud cost optimization for database infrastructureExperience working in an Agile development environmentRequired Skills :
Strong problem-solving skills and proactive mindsetAbility to communicate technical concepts clearly with cross-functional teamsComfortable in client-facing roles, especially during incidents and design discussionsWillingness to mentor junior DBAs and support team knowledge sharingShow more
Show less
Skills Required
Auditing, Access Control, Bash, Database Security, Sql, Partitioning, Replication, Python