Database Administrator (PostgreSQL AWS RDS and DMS)

About the position

We are seeking a highly skilled Database Administrator with extensive experience in PostgreSQL and AWS environments. The ideal candidate will have a strong background in database performance tuning, query optimization, and management of AWS RDS for PostgreSQL. This role requires hands-on experience with data migration and replication using AWS DMS, as well as proficiency in SQL and scripting for automation tasks. The candidate must also be capable of implementing robust backup, restore, and disaster recovery strategies while troubleshooting and optimizing database performance in real-world scenarios.

Requirements

• 5+ years of experience with PostgreSQL, including advanced query optimization and performance tuning.
• Strong knowledge of indexing strategies, query execution plans, and database internals.
• Experience managing AWS RDS for PostgreSQL in production environments.
• Hands-on experience with AWS DMS for data migration and replication.
• Proficiency in SQL, PL/pgSQL, and scripting (Python, Bash, etc.) for automation.
• Strong experience with database backup, restore, and disaster recovery strategies.
• Ability to troubleshoot and optimize database performance under real-world constraints.
• Active or ability to obtain a TSA Clearance is required.

Nice-to-haves

• Experience with AWS data services (Kinesis, EventBridge, Athena, Glue, Firehose).
• Familiarity with NoSQL databases (DynamoDB, Redis, etc.) in AWS environments.
• Understanding of data warehousing concepts and ETL pipelines.
• Experience with Infrastructure-as-Code (Terraform, CloudFormation).
• Exposure to CI/CD pipelines and DevOps best practices for database deployments.