Senior Software Engineer - DBA
Posted Updated
Description
The Azure Database Administrator is responsible for administering, monitoring and optimizing Azure Database for PostgreSQL environments across development, testing and production. The role focuses on database performance tuning, query optimization, backup and recovery, high availability, security and operational reliability, ensuring that database platforms hosted on Microsoft Azure remain reliable, secure and scalable. The position collaborates with application development, cloud and DevOps teams to support database deployments and continuous performance improvements.
Key Responsibilities:
- Administer, monitor and maintain Azure Database for PostgreSQL across development, testing and production environments.
- Perform database performance tuning, query optimisation and indexing to improve application responsiveness and database efficiency.
- Monitor database health, storage utilisation and performance metrics, and proactively resolve issues.
- Configure and manage backup, restore and recovery processes to support data protection and business continuity.
- Support high-availability configurations and assist with disaster recovery planning and testing.
- Manage and optimise connection pooling solutions such as PgBouncer to improve database connectivity and resource utilisation.
- Implement and maintain database security controls, including user access management, encryption, role-based access control and auditing.
- Troubleshoot performance bottlenecks, deadlocks, connectivity issues and database failures.
- Collaborate with application development, cloud and DevOps teams to support database deployments and performance improvements.
- Assist with database migrations, upgrades, patching and environment maintenance.
- Create and maintain database documentation, operational procedures and support runbooks.
Mandatory Skills:
- Strong hands-on experience with Azure Database for PostgreSQL.
- PostgreSQL administration, configuration, maintenance and troubleshooting.
- SQL query optimisation, execution plans and database indexing strategies.
- Database performance tuning, monitoring and capacity planning.
- Backup, restore, point-in-time recovery and disaster recovery concepts.
- High availability and failover configurations.
- Connection pooling technologies such as PgBouncer.
- Database security, authentication, authorisation, encryption and auditing.
- Familiarity with Azure Monitor, Log Analytics and database performance monitoring tools.
- Azure networking concepts, Private Endpoints and firewall configurations.
Preferred Skills:
- Exposure to Azure DevOps and CI/CD processes.
- Basic scripting using PowerShell, Bash or Python for automation.
- Knowledge of Infrastructure as Code tools and concepts, including ARM, Bicep or Terraform.
- Understanding of Agile/Scrum methodologies.
- Azure or PostgreSQL-related certifications are an added advantage.
Requirements
Qualification & Experience:
- Bachelor’s degree in Computer Science, Information Technology or a related field.
- 2–5 years of experience in database administration, including at least 2 years of hands-on experience with Azure PostgreSQL. Experience supporting database environments and operational activities is required.
Professional Certifications:
- Azure or PostgreSQL-related certifications are an added advantage.
Job Specific Skills:
- Azure Database for PostgreSQL administration and PostgreSQL troubleshooting.
- SQL query optimisation, execution plans, indexing, performance tuning and capacity planning.
- Backup, restore, point-in-time recovery, high availability, failover and disaster recovery.
- PgBouncer or similar connection pooling technologies.
- Database security, authentication, authorisation, encryption, RBAC and auditing.
- Azure Monitor, Log Analytics and performance monitoring tools.
- Azure networking, Private Endpoints and firewall configurations.
- Exposure to Azure DevOps, CI/CD, PowerShell/Bash/Python scripting and Infrastructure as Code (ARM, Bicep or Terraform) is preferred.
Skills
Sign in to read and join the discussion.