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

⭐ SDE/ArcGIS geodatabase experience

⭐ Logical replication experience

⭐ CyberArk Vault experience

⭐ Python automation

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!

#Hiring #PostgreSQL #Postgres #DBA #DatabaseAdministrator #AWS #RDS #Aurora #AWSDMS #CloudFormation #CloudWatch #DatabaseJobs #TechJobs #DevOps #Linux

📌 Database Administrator (Guadalajara)
🏢 Pyramid Consulting
📍 Guadalajara