Remote Database Administrator (PostgreSQL AWS RDS and DMS)

Description:

• The position is for a Database Administrator specializing in PostgreSQL, AWS RDS, and DMS.
• The candidate must have over 5 years of experience with PostgreSQL, focusing on advanced query optimization and performance tuning.
• A strong knowledge of indexing strategies, query execution plans, and database internals is required.
• The role involves managing AWS RDS for PostgreSQL in production environments.
• Hands-on experience with AWS DMS for data migration and replication is necessary.
• Proficiency in SQL, PL/pgSQL, and scripting languages such as Python and Bash for automation is expected.
• The candidate should have strong experience with database backup, restore, and disaster recovery strategies.
• The ability to troubleshoot and optimize database performance under real-world constraints is essential.
• An active TSA Clearance or the ability to obtain one is required.

Requirements:

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

Benefits:

• The job offers the opportunity to work with advanced database technologies and cloud services.
• Candidates will gain experience in managing production environments and data migration processes.
• The role provides exposure to various AWS data services and NoSQL databases.
• There is potential for professional growth in understanding data warehousing concepts and ETL pipelines.
• The position may include opportunities to work with Infrastructure-as-Code tools and CI/CD pipelines.