Database Administrator

As a Database Administrator (DBA) you will be responsible for supporting a major database upgrade project—planning, executing, and validating the migration of our PostgreSQL and AWS RDS environments. You will ensure high availability, minimal downtime, and data integrity throughout the process, with a focus on database architecture, upgrade strategy, performance tuning, and RDS service management throughout the upgrade lifecycle.

What You'll Do

• Lead and execute major PostgreSQL and AWS RDS database version upgrades.

• Develop and maintain detailed upgrade plans, rollback procedures, and operational runbook.

• Perform pre- and post-upgrade database health checks, validation, and performance benchmark. • Monitor, tune, and optimize database performance during and after migration.

• Collaborate with application, infrastructure, and DevOps teams to coordinate upgrade activities.

• Schedule and execute critical tasks during designated low-traffic maintenance windows.

• Document all procedures, configurations, and changes in a clear, auditable manner.

What You'll Need

• 5+ years of hands-on DBA experience with PostgreSQL in production environments.

• Strong experience with AWS RDS (PostgreSQL engine) and related services (RDS Proxy, Parameter Groups, CloudWatch, Snapshots, Multi-AZ).

• Proven track record of managing major database version upgrades with minimal disruption.

• Proficiency in query optimization, indexing strategies, vacuum/analyze tuning, and connection management.

• Experience with database backup, recovery, and point-in-time restore procedures.

• Solid understanding of high availability and disaster recovery configurations.

• Strong communication skills and ability to work within a distributed remote team.

• Experience with AWS Aurora PostgreSQL.

• Familiarity with Terraform or CloudFormation for infrastructure provisioning.

• Experience with database monitoring tools (e.g., pgBadger, Datadog, CloudWatch Insights).

• Knowledge of p glogical, logical replication, or blue-green deployment strategies.

• AWS certifications (e.g., AWS Certified Database – Specialty).