Database Administrator

Summary

Join our team as a Database Engineer with 5+ years of PostgreSQL experience, including advanced query optimization and performance tuning. You will manage AWS RDS for PostgreSQL, utilize AWS DMS for data migration, and possess proficiency in SQL, PL/pgSQL, and scripting languages. Experience with database backup, restore, and disaster recovery is crucial. Troubleshooting and optimizing database performance are key responsibilities. A TSA Clearance (or the ability to obtain one) is required. This role offers opportunities to work with AWS data services and NoSQL databases.

Requirements

• Have 5+ years of experience with PostgreSQL, including advanced query optimization and performance tuning
• Possess strong knowledge of indexing strategies, query execution plans, and database internals
• Have experience managing AWS RDS for PostgreSQL in production environments
• Have hands-on experience with AWS DMS for data migration and replication
• Be proficient in SQL, PL/pgSQL, and scripting (Python, Bash, etc.) for automation
• Have strong experience with database backup, restore, and disaster recovery strategies
• Be able to troubleshoot and optimize database performance under real-world constraints
• Have an active TSA Clearance or the ability to obtain one

Preferred Qualifications

• Have experience with AWS data services (Kinesis, EventBridge, Athena, Glue, Firehose)
• Be familiar with NoSQL databases (DynamoDB, Redis, etc.) in AWS environments
• Have an understanding of data warehousing concepts and ETL pipelines
• Have experience with Infrastructure-as-Code (Terraform, CloudFormation)
• Have exposure to CI/CD pipelines and DevOps best practices for database deployments