Database Migration Consultant — Senior / Pod Lead | Remote Contract Opportunity [ FastWater Staffing ]
About this role
📍 Location: Fully Remote (Maryland, U.S.)
📄 Type: Contract
🚀 Start: Immediate
💲 Compensation: TBD — based on skills and experience
Screening Requirements
- Due to client and clearance requirements, candidates must be U.S. Citizens or U.S. Permanent Residents (Green Card holders) and able to work in the United States without current or future visa sponsorship.
- Undergo fingerprinting as part of the onboarding process.
- Complete a government background check (CJIS-type)
About the Role
We are seeking a Senior Database Migration Consultant / Pod Lead to lead a large-scale database migration from SQL Server to Amazon Aurora PostgreSQL. This role will serve as the technical lead for the database workstream, providing hands-on expertise while mentoring other consultants and driving migration strategy.
Key Responsibilities
- Lead the SQL Server to Aurora PostgreSQL migration effort
- Define and oversee schema conversion using AWS Schema Conversion Tool (AWS SCT)
- Resolve complex database objects that cannot be automatically converted
- Convert and optimize stored procedures, functions, triggers, and views
- Design and oversee AWS DMS migration processes, including full-load and CDC replication
- Review and validate work completed by team members
- Optimize PostgreSQL performance and database design
- Provide technical guidance and mentorship to the database migration team
Required Qualifications
- Strong experience with SQL Server and T-SQL development
- Expertise with:
- Stored Procedures
- Functions
- Triggers
- Views
- SQL Agent Jobs
- Hands-on experience with Amazon Aurora PostgreSQL and PL/pgSQL
- Experience migrating databases from SQL Server to PostgreSQL
- Strong understanding of data type mapping, query conversion, and performance tuning
- Experience with AWS Schema Conversion Tool (AWS SCT)
- Experience with AWS Database Migration Service (AWS DMS)
- Familiarity with SSIS and SSRS environments
Preferred Qualifications
- AWS Database Specialty Certification
- Production experience with Aurora PostgreSQL
- Experience leading large-scale SQL Server to PostgreSQL migrations
- Experience with AWS migration and modernization projects
Ideal Candidate
A hands-on database migration expert who can lead complex SQL Server to PostgreSQL migrations, solve challenging conversion issues, and guide a team through successful database modernization projects.
Company at a glance
Hikinex is a company that provides scalable business support.
We specialize in supporting growing businesses. Our HIKINEX agents are sourced, trained, and promoted to seamlessly integrate into businesses of all sizes across a wide range of industries. We are passionate about our clients and strive to deliver an unparalleled experience.
As a result, our employees are highly trained, our services are fully scalable, and our monthly plans are commitment-free. We invest heavily in our clients, and our processes are designed to demonstrate our commitment to their success.
Your team at HIKINEX is committed to helping you succeed.
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?