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.
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

📌 Database Administrator (Centro)
🏢 Pyramid Consulting
📍 Centro