Senior PostgreSQL Database Administrator (Azure)
">
We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) to manage, optimize, and secure PostgreSQL databases hosted on Microsoft Azure.
">
About the Role:
">
* Database Administration:
Key Responsibilities:
">
1. Install, configure, and maintain PostgreSQL databases on Azure(Azure Database for PostgreSQL – Flexible Server).
2. Perform routine database maintenance tasks including backups, restores, patching, and upgrades.
3. Monitor database performance and proactively tune queries, indexes, and configurations to ensure optimal performance.
4. Implement and manage high availability (HA) and disaster recovery (DR) strategies using Azure-native tools and PostgreSQL replication.
Security & Compliance:
">
* Manage role-based access control (RBAC) and integration with Azure Active Directory (AAD).
Automation & Scripting:
">
* Develop and maintain automation scripts using tools like PowerShell, Bash, or Python for routine DBA tasks.
* Leverage Infrastructure as Code (IaC) tools such as Terraform or ARM templates for provisioning and managing database resources.
Monitoring & Troubleshooting:
">
* Use Azure Monitor, Log Analytics, and third-party tools (e.g., pgAdmin, Datadog, New Relic) to monitor database health and performance.
* Troubleshoot and resolve database-related issues including deadlocks, slow queries, and connection problems.
Required Qualifications:
">
* 5+ years of experience as a PostgreSQL DBA, with at least 2 years on Azure.
* Strong understanding of PostgreSQL internals, performance tuning, and replication.
* Hands-on experience with Azure Database for PostgreSQL and related services.
* Proficiency in SQL, PL/pgSQL, and scripting languages (e.g., Bash, Python).
* Familiarity with CI/CD pipelines and DevOps practices.
* Excellent problem-solving and communication skills.
* Participate in on-call rotations and provide 24/7 support for critical production systems.
Preferred Qualifications:
">
* Azure certifications (e.g., Azure Database Administrator Associate, Azure Solutions Architect).
* Experience with containerized PostgreSQL deployments (e.g., Kubernetes, Docker).
* Knowledge of other database systems (e.g., Oracle, MySQL, SQL Server) is a plus.