Senior Database Migration Consultant – Pod Lead

Job not on LinkedIn

🔥 3 minutes ago

🦀 Maryland, Virginia – Remote

🦀 Maryland – Remote ⚔️ Virginia – Remote

⏳ Contract/Temporary

🟠 Senior

🎯 Recruiter

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

HIKINEX

WebsiteLinkedInAll Job Openings

201 - 500 employees

🤝 B2B

🎯 Recruiter

B2B • Recruitment

HIKINEX is a multi-channel integrated service provider that delivers outsourced sales, recruitment, virtual assistant, and marketing support to help companies scale quickly and reduce operating costs. The company offers sales-as-a-service (appointment setting, outbound sales, sales training), end-to-end recruiting and talent acquisition (sourcing, screening, ATS management, executive recruiting), virtual administrative support, and marketing/brand ambassador services. HIKINEX operates remotely out of San Francisco and emphasizes flexible, scalable staffing and operations solutions for B2B clients.

📋 Description

• 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

🎯 Requirements

• 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: 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

🏖️ Benefits

• 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)