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.ResponsibilitiesAdminister and maintain PostgreSQL, AWS RDS PostgreSQL, and Aurora PostgreSQL across multiple environmentsTroubleshoot database performance issues, connectivity problems, replication failures, and production incidentsSupport AWS DMS migrations, including task failures, CDC lag, table errors, and cutover activitiesManage PostgreSQL replication, replication slots, WAL, schemas, roles, users, and privilegesMonitor database health using Amazon CloudWatch, dashboards, metrics, logs, and alarmsDeploy and manage database infrastructure using AWS CloudFormationPerform PostgreSQL query and performance tuning using execution plans, auto_explain, parameter optimization, and session managementSupport Linux-based DBA operations, including log analysis, Shell/Python automation,



and CLI-based administrationPerform PostgreSQL/Aurora version upgrades, including pre-upgrade assessments, backups, validation, and post-upgrade monitoringManage incidents and change requests through formal ITSM/CAB processesMaintain database documentation, operational procedures, and troubleshooting runbooksRequirementsExperience with AWS DMS and database migrationsStrong understanding of PostgreSQL architecture, including WAL, MVCC, autovacuum, replication, replication slots, and partitioningExperience with AWS CloudFormationExperience with Amazon CloudWatchStrong PostgreSQL security knowledge — roles, schemas, privileges, and access controlLinux/Unix administration and Shell scriptingStrong SQL and PL/pgSQL skillsExperience with production incident management and change processesGood to HaveIf you're an experienced PostgreSQL DBA with strong AWS expertise and enjoy solving complex production database challenges, we'd love to hear from you!
#J-*****-Ljbffr

📌 Database Administrator (Jalisco)
🏢 Pyramid Consulting
📍 Jalisco