*NOTE: REMOTE | OPEN 2ND JOB | 2-Month Contract
We are looking for an experienced Azure PostgreSQL DBA to join a strategic database modernization project, focusing on upgrading Azure Database for PostgreSQL Flexible Server from PostgreSQL 14 to PostgreSQL 17.
Key Responsibilities
- Lead and execute PostgreSQL version upgrades with minimal downtime.
- Assess migration risks, compatibility, and performance impacts.
- Design migration strategies using tools such as Azure DMS, logical replication, and pg_dump/pg_restore.
- Administer and optimize Azure Database for PostgreSQL Flexible Server environments.
- Perform database performance tuning, query optimization, indexing, and partitioning.
- Monitor database health, availability, and performance using Azure Monitor and Log Analytics.
- Troubleshoot replication, performance, and infrastructure-related issues.
- Implement security best practices, access controls, audit logging, and compliance measures.
- Collaborate with Development, DevOps, and Infrastructure teams throughout the upgrade lifecycle.
- Create technical documentation and provide guidance to junior engineers.
Requirements
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 5+ years of hands-on experience as a PostgreSQL DBA.
- Strong experience with Azure Database for PostgreSQL Flexible Server.
- Solid knowledge of PostgreSQL upgrades, migrations, backup/recovery, and replication.
- Strong SQL and PL/pgSQL skills with proven database performance tuning experience.
- Understanding of database architecture, cloud infrastructure, and automation practices.
- Experience working with CI/CD pipelines and monitoring/observability tools.
- Good communication skills in English.
Nice to Have
- Experience with NoSQL databases or hybrid data architectures.
- Microsoft Certified: Azure Database Administrator Associate.
- PostgreSQL-related certifications.
- Experience supporting enterprise-scale database environments.