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