Job Description

Position Summary

The Cloud Data Engineer will migrate databases to AWS cloud infrastructure, optimize database performance, design backup and recovery strategies, and maintain data integrity and security throughout migration and ongoing operations.

Key Responsibilities

·         Migrate on-premises databases to AWS cloud infrastructure.

·         Optimize database performance through query tuning, indexing, and resource management.

·         Design and implement comprehensive database backup and recovery strategies.

·         Ensure data integrity throughout migration processes using validation and reconciliation.

·         Configure database security controls to protect sensitive information.

·         Administer and support Microsoft SQL Server and PostgreSQL environments.

·         Develop and support ETL pipelines and data-integrity processes.

·         Use Terraform for infrastructure-as-code database provisioning and configuration.

Required Skills & Experience

·         Strong experience with cloud-based and on-premises database management.

·         Hands-on expertise with AWS RDS and AWS Database Migration Service (DMS).

·         Proficiency with Microsoft SQL Server and PostgreSQL administration.

·         Strong database performance optimization skills, including query optimization and indexing.

·         Experience developing ETL pipelines and ensuring data integrity.

·         Hands-on Terraform experience for database provisioning.

·         Experience with data validation, reconciliation, backup/recovery, and database security.

Mandatory Eligibility Requirements

· ·         Must have existing/current FRB clearance. Candidates who are not already FRB cleared will not meet the immediate requirement.