Job Title : DBA – AWS Aurora PostgreSQL
Experience : 6+ Years
Work Mode : Remote
Laptop Pickup : One-time pickup from Noida, Bengaluru, Pune, Hyderabad, or Chennai
Contract Duration : 6 Months
Job Summary :
We are seeking an experienced AWS Aurora PostgreSQL DBA to manage, optimize, and support enterprise database environments hosted on AWS.
The ideal candidate should have strong expertise in PostgreSQL, AWS RDS/Aurora PostgreSQL, database performance tuning, high availability, disaster recovery, security, and production support.
Key Skills Required :
AWS Aurora PostgreSQL, PostgreSQL DBA, AWS RDS, SQL Performance Tuning, Query Optimization, Indexing, Execution Plan Analysis, High Availability (HA), Disaster Recovery (DR), Multi-AZ, Read Replicas, CloudWatch, Aurora Performance Insights, Backup & Recovery, Database Security, IAM, Audit Logging, Production Support, RCA, Python/Shell/PowerShell Scripting, Terraform/CloudFormation, AWS DMS, CI/CD, Git.
Mandatory Skills :
- 4 to 5+ years of experience in PostgreSQL Database Administration.
- 3 to 5+ years of hands-on experience with AWS RDS and Aurora PostgreSQL.
- Strong SQL expertise, including query optimization, indexing, and execution plan analysis.
- Experience with Aurora clustering, Multi-AZ deployments, read replicas, failover management, backup, and recovery.
- Hands-on experience with AWS CloudWatch and Aurora Performance Insights.
- Strong understanding of database security, encryption, IAM controls, audit logging, and compliance practices.
- Experience in production support, incident management, troubleshooting, and root cause analysis (RCA).
- Scripting/automation experience using Python, Shell Script, or PowerShell.
- Experience with Infrastructure as Code (Terraform or CloudFormation).
- Knowledge of AWS DMS, DevOps practices, CI/CD pipelines, and Git.
Preferred Skills :
- Experience supporting Master Data Governance (MDG) or enterprise data platforms.
- Experience working in healthcare or other highly regulated environments.
- Exposure to AWS services such as Redshift, DynamoDB, and S3.
- AWS Certified Database Specialty or AWS Solutions Architect certification is preferred.
Key Responsibilities :
- Manage and support AWS Aurora PostgreSQL environments, including provisioning, configuration, monitoring, scaling, and maintenance.
- Optimize database performance through query tuning, indexing, and proactive monitoring.
- Implement and maintain high availability, backup, recovery, and disaster recovery solutions.
- Troubleshoot production issues, perform root cause analysis, and ensure database reliability and availability.
- Collaborate with application, cloud, and data engineering teams to support deployments and production releases.
- Automate routine DBA activities and improve operational efficiency using scripting and AWS-native tools.
Qualifications :
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Strong analytical, troubleshooting, and communication skills.
- Ability to work independently and manage multiple priorities in a fast-paced environment.