PostgreSQL DBA

Required Skills

• 5–7 years of hands-on PostgreSQL database administration experience.
• Strong expertise in PostgreSQL installation, configuration, administration, monitoring, and troubleshooting.
• Practical experience managing PostgreSQL on AWS RDS.
• Proven experience with:
• High availability and replication
• Backup, restore, point-in-time recovery, and disaster recovery testing
• CDC and logical replication
• Database migrations and version upgrades
• Performance tuning and query optimization
• Database security and access controls
• Experience responding to production incidents and managing problems.
• Strong shell scripting skills.
• Experience using GitHub or GitLab for source control and collaboration.

Preferred Skills

• Experience with Amazon Aurora PostgreSQL.
• Knowledge of AWS Lambda and event-driven automation.
• Python programming for DBA automation and operational tooling.
• Experience with Jenkins and CI/CD pipeline integration; familiarity with GitHub Actions or GitLab CI/CD.
• Experience administering or supporting Oracle databases.
• Knowledge of AWS Database Migration Service, CloudWatch, IAM, Secrets Manager, and S3.
• Familiarity with infrastructure-as-code tools such as Terraform or CloudFormation.
• Relevant PostgreSQL, AWS, or database certifications.

Responsibilities

• Administer PostgreSQL databases across development, test, and production environments.
• Manage AWS RDS for PostgreSQL, including provisioning, configuration, patching, upgrades, scaling, monitoring, and maintenance.
• Design and support high-availability and disaster recovery solutions, including multi-AZ deployments, replication, failover, and read replicas.
• Manage backup, restore, point-in-time recovery, retention, and recovery validation processes.
• Support database migrations, upgrades, consolidation, and cross-environment refreshes.
• Develop and maintain change data capture (CDC) solutions using AWS DMS, Debezium, logical replication, or equivalent technologies.
• Tune database performance through query analysis, indexing, vacuuming, statistics management, connection optimization, and configuration changes.
• Monitor database health, capacity, availability, replication lag, storage, connections, and performance.
• Troubleshoot incidents involving outages, replication, locking, deadlocks, backup failures, and performance degradation.
• Implement security controls for access, roles, privileges, encryption, auditing, and credential rotation.
• Automate DBA activities using shell scripting, Python, AWS services, and CI/CD tools.
• Maintain operational documentation, runbooks, recovery procedures, and database standards.
• Collaborate with application, infrastructure, DevOps, security, and data engineering teams.
• Participate in on-call support, incident management, root-cause analysis, and continuous improvement.