Senior Database Administrator
New
J
JobgetherInformation Technology
Based in IndiaFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 4+ years
- Required Skills
- AWSPostgreSQLPythonSQLBashGoLinuxTerraformAnsible
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.
- Experience supporting mission-critical 24/7 production environments, including on-call 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 (e.g., Repmgr, Patroni, ProxySQL).
- Experience automating infrastructure and database operations using Terraform, Ansible, or comparable tools.
- Strong Linux systems administration skills and scripting experience with Bash, Python, or Go.
Responsibilities
- 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.
- Implement and maintain robust backup, recovery, and disaster recovery strategies.
- Monitor and support 24/7 production database systems, participating in incident response and root-cause analysis.
- Collaborate with SRE, DevOps, and engineering teams to improve database scalability, performance, reliability, and CI/CD integration.
View Full Description & ApplyYou'll be redirected to the employer's site