PostgreSQL DBA

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

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

Depends on Experience