PostgreSQL Database Administrator (DBA)

1. 1. About the job

We are seeking an experienced Azure PostgreSQL Database Administrator (DBA) to lead and support our strategic upgrade initiative from PostgreSQL 14 to PostgreSQL 17 on Azure Database for PostgreSQL Flexible Server. The ideal candidate will possess deep expertise in PostgreSQL internals, Azure cloud services, and database migration strategies, with a strong focus on performance, reliability, and automation.

1. 1. 1. Key Responsibilities

• Design, develop and maintain Java-based applications
• Plan and execute the upgrade from PostgreSQL 14 to 17 with minimal downtime.
• Perform pre-upgrade assessments, compatibility checks, and risk analysis.
• Develop rollback and contingency plans to ensure business continuity.
• Use tools such as Azure DMS, pg_dump/pg_restore, and logical replication for seamless migration.
• Manage PostgreSQL instances on Azure Flexible Server.
• Configure and tune PostgreSQL parameters for optimal performance post-upgrade.
• Conduct performance benchmarking, regression testing, and query optimization.
• Implement indexing strategies, partitioning, and advanced tuning techniques.
• Monitor system health using Azure Monitor, Log Analytics, and custom dashboards.
• Troubleshoot issues related to replication, query performance, and resource utilization.
• Implement proactive alerting, logging enhancements, and automated recovery mechanisms.
• Review and update security configurations post-upgrade.
• Ensure audit logging, access controls, and data privacy compliance.
• Monitor and ensure data integrity, security, and privacy in accordance with industry standards.
• Collaborate with development, DevOps, and operations teams to ensure seamless integration.
• Liaise with Microsoft support for issue resolution and best practices.
• Provide technical guidance and mentorship to junior DBAs and engineers.
• Maintain detailed documentation of upgrade procedures, configurations, and lessons learned.
• Conduct thorough testing and validation of database systems to ensure reliability.
• Analyze performance data and share insights with relevant teams to support development.
  1. 1. Requirements
• Bachelor’s degree (or its equivalent) in Computer Science/Information Technology
• Minimum 5 years of experience as a PostgreSQL DBA.
• Proven hands-on expertise with Azure Database for PostgreSQL Flexible Server.
• Strong understanding of PostgreSQL upgrade paths, version differences, and migration strategies.
• Proficiency in SQL, PL/pgSQL, and performance tuning.
• Experience with NoSQL concepts and hybrid data architectures.
• Strong understanding of database architecture, design, and infrastructure administration.
• Familiarity with CI/CD pipelines, automation tools, and cloud-native observability platforms.
• Solid written and verbal communication skills in English.
• Ability to work under pressure and meet deadlines in enterprise-level environments.
• Positive attitude, professional demeanor, and collaborative mindset.

Preferred Certifications:

• Microsoft Certified: Azure Database Administrator Associate

PostgreSQL Certified Professional