Database Administrator

Pyramid Consulting, Inc; Región Centro; Presencial; MXN 350.000 - 700.000; Jornada completa

Descripción de la vacante

Pyramid Consulting, Inc. is seeking an experienced PostgreSQL Database Administrator to support enterprise PostgreSQL infrastructure hosted on AWS.

This hands-on role focuses on production support, troubleshooting, performance tuning, migrations, and collaborating with application teams. The ideal candidate will administer PostgreSQL, AWS RDS PostgreSQL, and Aurora PostgreSQL across environments, monitor health with CloudWatch, and lead upgrades and change management, while maintaining solid

Formación

• Experience with AWS DMS and migrations.
• Strong understanding of PostgreSQL architecture: WAL, MVCC, autovacuum, replication, partitions.
• Linux/Unix administration and Shell scripting.
• Solid SQL and PL/pgSQL expertise.
• Experience with production incident management and change processes.

Responsabilidades

• Administer PostgreSQL, AWS RDS PostgreSQL, and Aurora PostgreSQL across multiple environments.
• Troubleshoot database performance issues, connectivity problems, replication failures, and production incidents.
• Support AWS DMS migrations, including task failures, CDC lag, table errors, and cutover activities.
• Manage PostgreSQL replication, replication slots, WAL, schemas, roles, users, and privileges.
• Monitor database health using CloudWatch, dashboards, metrics, logs, and alarms.
• Deploy and manage database infrastructure using AWS CloudFormation.
• Perform PostgreSQL query and performance tuning using execution plans and parameter optimization.
• Support Linux-based DBA operations, including log analysis and shell scripting.
• Perform PostgreSQL/Aurora version upgrades, including pre-upgrade assessments, backups, validation, and post-upgrade monitoring.
• Manage incidents and change requests through ITSM/CAB processes.
• Maintain database documentation, operational procedures, and troubleshooting runbooks.

Conocimientos

PostgreSQL

AWS

Troubleshooting

Performance Tuning

Linux/Unix

Herramientas

AWS RDS

Aurora PostgreSQL

AWS CloudFormation

Amazon CloudWatch

AWS DMS

Descripción del empleo

We are looking for an experienced PostgreSQL Database Administrator to join our team and support enterprise database infrastructure hosted on AWS.

This role is ideal for a hands‑on DBA who enjoys production support, troubleshooting, performance tuning, database migrations, and working closely with application teams.

Responsibilities

• Administer and maintain PostgreSQL, AWS RDS PostgreSQL, and Aurora PostgreSQL across multiple environments
• Troubleshoot database performance issues, connectivity problems, replication failures, and production incidents
• Support AWS DMS migrations, including task failures, CDC lag, table errors, and cutover activities
• Manage PostgreSQL replication, replication slots, WAL, schemas, roles, users, and privileges
• Monitor database health using Amazon CloudWatch, dashboards, metrics, logs, and alarms
• Deploy and manage database infrastructure using AWS CloudFormation
• Perform PostgreSQL query and performance tuning using execution plans, auto_explain, parameter optimization, and session management
• Support Linux-based DBA operations, including log analysis, Shell/Python automation, and CLI-based administration
• Perform PostgreSQL/Aurora version upgrades, including pre-upgrade assessments, backups, validation, and post-upgrade monitoring
• Manage incidents and change requests through formal ITSM/CAB processes
• Maintain database documentation, operational procedures, and troubleshooting runbooks

Requirements

• Experience with AWS DMS and database migrations
• Strong understanding of PostgreSQL architecture, including WAL, MVCC, autovacuum, replication, replication slots, and partitioning
• Experience with AWS CloudFormation
• Experience with Amazon CloudWatch
• Strong PostgreSQL security knowledge — roles, schemas, privileges, and access control
• Linux/Unix administration and Shell scripting
• Strong SQL and PL/pgSQL skills
• Experience with production incident management and change processes

Good to Have

If you're an experienced PostgreSQL DBA with strong AWS expertise and enjoy solving complex production database challenges, we'd love to hear from you!