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 4–7 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:
- 4–7 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
Read Full Description