Senior Database Administrator

Accountabilities:: Design, deploy, and maintain PostgreSQL clusters in AWS environments using Infrastructure as Code tools. Develop automation for database provisioning, configuration management, monitoring, and operational processes. Perform database maintenance activities including vacuuming, reindexing, and statistics analysis to maintain optimal performance. Analyze and optimize slow SQL queries, indexing strategies, and database workloads to improve efficiency and throughput. Design and maintain resilient, highly available PostgreSQL architectures that minimize downtime during upgrades, maintenance, and failovers. Implement and maintain robust backup, recovery, and disaster recovery strategies to protect data integrity and system availability. Monitor and support 24/7 production database systems, participating in incident response and root-cause analysis when required. Collaborate with SRE, DevOps, and engineering teams to improve database scalability, performance, reliability, and CI/CD integration. Contribute to improved observability, automation, and operational efficiency across database environments. Requirements: 4+ years of experience managing PostgreSQL databases in production environments. Strong expertise in SQL query optimization, indexing strategies, and PostgreSQL performance tuning. Proven experience designing and maintaining highly available and fault-tolerant database systems with minimal or zero downtime. Experience supporting mission-critical 24/7 production environments, including on-call responsibilities and incident response. Hands-on experience with AWS services such as EC2, RDS, EBS, S3, and IAM. Strong understanding of PostgreSQL replication, Point-in-Time Recovery (PITR), and high-availability solutions such as Repmgr, Patroni, ProxySQL, or similar technologies. Experience automating infrastructure and database operations using Terraform, Ansible, or comparable tools. Strong Linux systems administration skills and scripting experience with Bash, Python, Go, or similar languages. Familiarity with observability and alerting tools such as Prometheus, Loki, Grafana, or CloudWatch is a plus. Exposure to additional database technologies such as ClickHouse or Timescale Postgres is a plus. Experience developing internal automation or self-healing tools for query analysis and database management is desirable. Benefits: Competitive total compensation package. Opportunity to work with mission-critical PostgreSQL infrastructure in high-availability production environments. Hands-on exposure to AWS, Infrastructure as Code, database automation, observability, and modern reliability practices. Opportunity to collaborate with SRE, DevOps, and engineering professionals on large-scale infrastructure challenges. Various team-building programs and company events. Opportunities to contribute to automation, scalability, and continuous improvement initiatives. Additional company benefits and perks.