Job Title: Senior Cloud DBA PostgreSQL - Python Automation - Azure
Location: Hyderabad(Hybrid)
Job Type: Full-time
Job Summary:
We are seeking a Senior Cloud Database Administrator (DBA) with 47 years of hands-on experience specializing in PostgreSQL in AWS and Azure environments. The ideal candidate will be proficient in managing cloud-native database deployments automation performance optimization and support. Familiarity with other RDBMS and NoSQL platforms (e.g. SQL Server MySQL MongoDB) and DevOps integration is a plus.
Key Responsibilities:
- Cloud Database Administration:
- Install configure and manage PostgreSQL instances in AWS RDS EC2 and Azure Database for PostgreSQL.
- Handle database provisioning upgrades patching and lifecycle management in the cloud.
- Performance & Optimization:
- Analyse slow queries and improve performance using indexes configuration tuning and schema optimization.
- Monitor resource utilization and optimize database parameters for better throughput and latency.
- Backup Recovery & HA:
- Design and implement backup strategies Point-in-Time Recovery (PITR) replication and disaster recovery solutions.
- Maintain high availability using read replicas failover clusters or native cloud HA solutions.
- Scripting & Automation:
- Automate database tasks using Python Bash or PowerShell.
- Contribute to Infrastructure-as-Code (Terraform CloudFormation ARM Templates) for database provisioning.
- Monitoring & Troubleshooting:
- Set up alerts and dashboards using Observability tools like NewRelic Datadog etc
- Handle incidents perform root cause analysis and contribute to ongoing operational improvements.
- Security & Compliance Support:
- Enforce access controls encryption and secure connections.
- Contribute to audits and compliance efforts (e.g. SOC2 ISO 27001 and FedRAMP if applicable).
- On-call Support:
- Participate in on-call rotations for 24x7 coverage (follow-the-sun model) for incident response issue triage and problem resolution
Required Qualifications:
- 47 years of hands-on experience as a PostgreSQL DBA.
- Expertise in PostgreSQL administration on AWS and/or Azure platforms.
- Strong skills in performance tuning indexing and query optimization.
- Experience with backup and recovery HA/DR setups.
- Proficiency in scripting languages (Python Shell PowerShell) for automation.
- Familiarity with monitoring and observability tools for database health and performance.
- Understanding of cloud IAM networking and security principles.
Preferred Qualifications:
- Exposure to SQL Server MongoDB MySQL or Redis.
- Experience with Kubernetes containers or serverless environments.
- Familiarity with DevOps practices CI/CD tools and IaC.
- Awareness of security frameworks like NIST FedRAMP or GDPR.
Roadmap to Success
First 90 Days: Getting Oriented
- Understand Current Systems:
- Onboard with the DBA DevOps and SRE teams.
- Review existing PostgreSQL architectures in AWS and Azure.
- Review and Assess:
- Evaluate current performance bottlenecks automation scripts and security configurations.
- Familiarize yourself with cloud cost management HA/DR plans and monitoring setups.
- Quick Wins:
- Triage and resolve outstanding performance issues.
- Implement minor automation and alerting improvements.
First 6 Months: Adding Value
- Optimization & Stability:
- Improve query performance and database efficiency through configuration tuning and indexing strategies.
- Harden backup and recovery strategies and begin enhancing high availability.
- Automation & Cost Control:
- Contribute automation scripts for maintenance scaling and backups.
- Assist with cost analysis and optimization recommendations.
- Cross-Functional Collaboration:
- Work closely with developers SREs and DevOps on deployments and DB integration.
First 12 Months: Driving Impact
- Reliability & Security Enhancements:
- Implement proactive security measures (e.g. audit logging secure access).
- Support compliance and security initiatives documentation and audit readiness.
- Innovation & Leadership:
- Propose modernization initiatives (e.g. containerized DBs serverless options).
- Mentor junior team members or contribute to internal knowledge-sharing sessions.
- Operational Excellence:
- Help build a fully monitored automated and resilient PostgreSQL environment.
- Establish yourself as the go-to expert for PostgreSQL in the cloud.
What We Offer:
- Competitive salary and performance incentives
- Remote-friendly flexible work culture
- Cloud training programs and technical certifications
- Exposure to large-scale cloud architecture and DevOps best practices
- Collaborative fast-paced engineering environment
Required Experience:
Senior IC