Offer summary

Qualifications:

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., Proficiency in SQL, PL/pgSQL, and scripting for automation..

Key responsabilities:

Manage and optimize PostgreSQL databases in AWS RDS environments.

Perform data migration and replication using AWS DMS.

Implement backup, restore, and disaster recovery strategies for databases.

Troubleshoot and enhance database performance under real-world constraints.

Job description

Required Qualifications

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

Preferred Qualifications (Nice to Have)

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

Required profile