HIKINEX logo
HIKINEX

Design Your Dream Team

Database Migration Consultant – Staff

RecruitmentRecruitmentContractRemoteLeadTeam 201-500H1B No SponsorCompany SiteLinkedIn

Location

Maryland

Posted

4 days ago

Salary

0

Seniority

Lead

Bachelor Degree3 yrs expEnglishAWSETLMS SQL ServerPostgreSQLSQLSSIS

Job Description

Database Migration Consultant – Staff

HIKINEX

• Develop, maintain, and optimize database objects using Microsoft SQL Server, T-SQL, and PostgreSQL. • Convert and remediate SQL Server database code for PostgreSQL compatibility. • Develop and maintain stored procedures, functions, triggers, and views. • Perform functional, integration, and performance testing of migrated database objects. • Analyze and remediate T-SQL to PostgreSQL syntax differences and compatibility issues. • Review and address findings from AWS Schema Conversion Tool (SCT) assessment reports. • Validate migrated data and support database migration testing activities. • Collaborate with development and project teams to support database modernization and migration initiatives.

Job Requirements

  • 3+ years of SQL development experience.
  • Strong hands-on experience with: Microsoft SQL Server and T-SQL Stored Procedures, Functions, Triggers, and Views PostgreSQL and PL/pgSQL SQL Server to PostgreSQL code conversion and remediation Functional and performance testing of database objects Familiarity with: T-SQL to PostgreSQL dialect conversion (e.g., TOP/LIMIT, ISNULL/COALESCE, GETDATE()/NOW(), temp tables, identity vs. sequences ) AWS Schema Conversion Tool (SCT) assessment reports and remediation Data validation and migration testing Experience supporting database modernization or migration projects.
  • Preferred Qualifications Experience with AWS Database Migration Service (AWS DMS).
  • Experience with SSIS/SSRS remediation or migration.
  • Experience with AWS services and SQL Server to PostgreSQL migration projects.
  • Familiarity with AWS Glue and modern ETL migration concepts.

Related Categories

Related Job Pages

More Recruitment Jobs

ContractRemoteTeam 201-500H1B No Sponsor

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

Maryland
ContractRemoteTeam 201-500H1B No Sponsor

• Develop and maintain enterprise applications using C# and .NET technologies. • Refactor embedded and inline SQL within application code to support PostgreSQL compatibility. • Modernize data access layers using ADO.NET, Entity Framework, and Dapper. • Migrate SQL Server-based applications and database integrations to PostgreSQL. • Convert T-SQL queries and database logic to PostgreSQL-compatible syntax. • Update connection strings, credentials, and database access configurations. • Perform application testing, debugging, and performance optimization throughout migration efforts. • Collaborate with cross-functional teams to deliver scalable, secure, and high-quality application modernization solutions.

Maryland
RenoFi logo

Mortgage Sales Recruiter

RenoFi

1 mission - make renovations possible. NMLS #1802847

Recruitment4 days ago
Full TimeRemoteTeam 51-200H1B No Sponsor

• Own the end-to-end recruiting process for Senior Loan Officer candidates - you’ll be their trusted contact and guide them from initial outreach and screening, to coordination of interviews with the team, and through the offer and reference check stages • Engage with Sales leadership team to understand priorities for each market and corresponding resourcing needs • Build trusted relationships with hiring managers and key stakeholders and coach them on hiring best practices • Own the job posting process for various roles, including the drafting of job specs and posting to relevant sites including LinkedIn • Manage and maintain the talent pipeline and leverage the data to inform hiring projections • Maintain the ATS and provide timely and thoughtful feedback to all candidates to maintain data integrity • Leverage all RenoFi recruiting platforms to actively engage and source candidates • Validate potential candidate’s mortgage production using data sources such as MMI • Provide weekly updates to key stakeholders on activities and pipeline • Champion RenoFi’s culture & vision

United States
$60K - $90K / year
CHA Consulting, Inc. logo

Campus Recruiter

CHA Consulting, Inc.

CHA is an innovative, full-service engineering, design, consulting, and program/construction management firm.

Recruitment4 days ago
Full TimeRemoteTeam 1,001-5,000Since 1952H1B No Sponsor

• Partner with hiring managers, HR Leadership, and recruiters to understand hiring needs and develop campus recruiting strategies that support early careers growth • Manage full-cycle recruiting activities for intern, co-op, entry-level, and experienced professional positions • Build and maintain talent pipelines through proactive sourcing, networking, and relationship-building efforts • Represent CHA at career fairs, university events, networking opportunities, and other recruiting initiatives • Develop strong relationships with colleges, universities, and student organizations to strengthen CHA's campus recruitment presence • Track recruiting activity and market trends to help inform talent acquisition strategies and workforce planning efforts • Serve as a brand ambassador for CHA, promoting our culture, values, and career opportunities to prospective candidates

Florida + 1 moreAll locations: Florida | New York
$70K - $80K / year