Senior PostgreSQL Database Administrator

Company:

Description:

Sr PostgreSQL Database Administrator

We are seeking a Sr PostgreSQL Database Administrator to join our Applications Development team at MMC. This role will be based in Mexico City. This is a hybrid role that has a requirement of working at least three days a week in the office.

We will count on you to:

• Manage, optimize, and ensure the high availability of PostgreSQL databases hosted on Linux and Azure’s cloud platform.
• Lead complex database projects, including database migrations, performance tuning, and high-availability configurations.
• Implement advanced PostgreSQL features (e.g., partitioning, indexing strategies, advanced query tuning, and replication) to optimize database performance at scale.
• Oversee the configuration and management of Azure-specific PostgreSQL offerings such as Azure Database for PostgreSQL - Flexible Server and Azure Database for PostgreSQL - Single Server.
• Configure and maintain high-availability solutions for PostgreSQL (e.g., Azure Availability Zones, synchronous replication, failover strategies) using the Azure Resource Manager templates and CI/CD pipelines.
• Strong knowledge of PostgreSQL extensions (e.g., PostGIS, pg_partman, pg_stat_statements), their deployment in a cloud environment using the CI/CD pipelines and how to leverage them in production environments.

What you need to have:

• Experienced Senior PostgreSQL Database Engineer with extensive expertise in PostgreSQL and Azure or AWS
• 2+ years of database experience with Postgres in Cloud
• Bachelor's degree preferred or equivalent work experience
• Sound knowledge of Relational DBMS (Database Management Systems)
• Talented in Database and cloud computing design, architectures, and data lakes
• Excellent written and verbal communication skills in English

What makes you stand out:

• Advanced experience with PostgreSQL internals and performance tuning, including query execution plans, auto vacuum settings, and complex transaction management.

Why join our team:

• We help you be your best through professional development opportunities, interesting work and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.