Overview
Administer, monitor and optimise Azure Database for PostgreSQL environments across development, testing and production, keeping database platforms on Microsoft Azure reliable, secure and scalable.
What you'll do
- 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.
What you'll need
- 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.
- 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.
Nice to have
- 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.
Details
- Location: Bangalore, Karnataka, India.
Read the full description and apply on the company’s own careers page.