PostgreSQL Azure Database Administrator

Area(s) of responsibility

Job Description – PostgreSQL Azure Database Administrator (5–7 Years)
Role Overview
We are seeking an experienced PostgreSQL Azure DBA (5–7 years) responsible for managing, optimizing, and securing PostgreSQL databases hosted on Azure cloud. The role involves ensuring high availability, performance tuning, backup & recovery, and cloud database operations while supporting business-critical applications.
Key Responsibilities
Database Administration (PostgreSQL on Azure)
•    Install, configure, and maintain PostgreSQL databases on Azure (Flexible Server / PaaS) 
•    Manage database objects, schemas, and configurations
•    Ensure data integrity, availability, and reliability of database systems 
•    Perform database upgrades, patching, and migrations

Performance Tuning & Optimization
•    Monitor database performance and optimize queries, indexes, and execution plans 
•    Identify performance bottlenecks and implement tuning strategies
•    Ensure optimal utilization of CPU, memory, and storage resources
•    Implement capacity planning and workload optimization 

Backup, Recovery & High Availability
•    Implement and manage backup and disaster recovery strategies 
•    Ensure high availability (HA) and replication configurations
•    Perform restore and recovery testing to validate DR readiness
•    Configure failover, replication, and DR solutions in Azure
Monitoring & Troubleshooting
•    Monitor database systems using Azure tools (Azure Monitor, logs, metrics) 
•    Diagnose and resolve database issues, outages, and incidents
•    Perform root cause analysis (RCA) and implement corrective actions
•    Ensure optimal uptime and system availability

Security & Compliance
•    Implement database security, encryption, and access controls 
•    Manage roles, permissions, and authentication mechanisms
•    Ensure compliance with data protection and organizational policies
•    Conduct regular audits and vulnerability assessments

Cloud & DevOps Integration
•    Manage Azure services related to PostgreSQL (Backup, Monitoring, Networking) 
•    Support CI/CD pipelines for database deployments (Azure DevOps) 
•    Automate database operations using scripting and tools
•    Collaborate with DevOps and development teams for deployments

Collaboration & Support
•    Work closely with application teams to optimize database usage
•    Provide L2/L3 support for production systems
•    Maintain documentation, runbooks, and standard operating procedures
•    Support data migration and cloud modernization initiatives

Required Skills & Experience
•    5–7 years of experience as a Database Administrator
•    Strong proficiency in PostgreSQL database administration 
•    Hands-on experience with Azure Database for PostgreSQL 
•    Expertise in SQL (queries, functions, stored procedures) 
•    Experience in performance tuning, indexing, and query optimization 
•    Knowledge of backup, recovery, and HA/DR strategies 
•    Familiarity with Azure tools (Azure Monitor, Azure Backup, networking) 
Preferred Skills
•    Experience with replication, clustering, and scaling PostgreSQL
•    Knowledge of DevOps tools (Azure DevOps, CI/CD pipelines) 
•    Familiarity with scripting (Shell / Python / PowerShell)
•    Experience with database migrations and cloud transformations
_Soft Skills
•    Strong analytical and problem-solving skills
•    Good communication and stakeholder management
•    Ability to work in a fast-paced production environment