Database Migration Consultant (Senior / Pod Lead) | Remote Contract Opportunity | Fastwater Staffing
📍 Location: Fully Remote (Maryland, U.S.) 📄 Employment Type: Contract 🚀 Start Date: Immediate 💰 Compensation: TBD -- based on skills and experience Important Screening Requirements Due to client security requirements, candidates must be U.S. Citizens or U.S. Permanent Residents (Green Card holders) authorized to work in the United States without current or future visa sponsorship. Must be willing to support and work with a government client. Must be willing to undergo fingerprinting as part of the onboarding process. Must successfully complete a government background investigation (CJIS-type clearance).
About the Role
We are seeking an experienced Database Migration Consultant (Senior / Pod Lead) to lead large-scale database modernization and migration initiatives. In this role, you will oversee database migration efforts, guide technical teams, and drive the successful migration of Microsoft SQL Server environments to PostgreSQL and Amazon Aurora PostgreSQL. The ideal candidate has deep expertise in database architecture, AWS migration tools, and performance optimization, along with proven experience leading enterprise-scale database migration projects.
Key Responsibilities
Lead database modernization and migration initiatives from SQL Server to PostgreSQL and Amazon Aurora PostgreSQL. Design, develop, and optimize database objects, including stored procedures, functions, triggers, views, and SSIS/SSRS components. Perform schema conversion and code remediation using AWS Schema Conversion Tool (SCT). Plan and execute database migrations using AWS Database Migration Service (DMS), including full-load and Change Data Capture (CDC) migration strategies. Optimize database performance through indexing, query tuning, and architectural improvements. Review technical deliverables and provide guidance to database migration team members. Collaborate with cross-functional teams to ensure successful delivery of database modernization initiatives. Support database validation, testing, troubleshooting, and post-migration optimization. Required Qualifications 8+ years of experience in database engineering, database migration, or database architecture. Expert-level experience with: Microsoft SQL Server and T-SQL Stored Procedures, Functions, Triggers, Views, and SSIS/SSRS PostgreSQL and Amazon Aurora PostgreSQL PL/pgSQL development and performance tuning SQL Server to PostgreSQL migration projects Strong hands-on experience with: AWS Schema Conversion Tool (SCT) AWS Database Migration Service (DMS) Schema conversion and code-object remediation Full-load and Change Data Capture (CDC) migration strategies Database performance tuning, indexing, and optimization Large-scale database modernization initiatives Experience leading database migration teams and reviewing technical deliverables.
Preferred Qualifications
AWS Certified Database – Specialty certification. Production experience with Amazon Aurora PostgreSQL. Experience leading enterprise-scale SQL Server to PostgreSQL migration programs.