?
Hiring: PostgreSQL Database Administrator | AWS

Location: Guadalajara, Mexico city, Monterrey, Queretaro (Hybrid 3-2 days onsite per week)

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

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

? Key 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

? Required Skills

✅ Strong
PostgreSQL DBA
experience

✅ Hands-on
AWS RDS / Aurora PostgreSQL
experience

✅ 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 Postgr

📌 Database Administrator (Guadalajara)
🏢 Pyramid Consulting
📍 Guadalajara