Note: The job is a remote job and is open to candidates in USA. HIKINEX is seeking an experienced Database Migration Consultant (Senior / Pod Lead) to lead large-scale database modernization and migration initiatives. The role involves overseeing database migration efforts, guiding technical teams, and ensuring successful migration of Microsoft SQL Server environments to PostgreSQL and Amazon Aurora PostgreSQL.
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
Skills
- 8+ years of experience in database engineering, database migration, or database architecture
- Expert-level experience with Microsoft SQL Server and T-SQL
- Expert-level experience with Stored Procedures, Functions, Triggers, Views, and SSIS/SSRS
- Expert-level experience with PostgreSQL and Amazon Aurora PostgreSQL
- Expert-level experience with PL/pgSQL development and performance tuning
- Expert-level experience with SQL Server to PostgreSQL migration projects
- Strong hands-on experience with AWS Schema Conversion Tool (SCT)
- Strong hands-on experience with AWS Database Migration Service (DMS)
- Strong hands-on experience with schema conversion and code-object remediation
- Strong hands-on experience with full-load and Change Data Capture (CDC) migration strategies
- Strong hands-on experience with database performance tuning, indexing, and optimization
- Strong hands-on experience with large-scale database modernization initiatives
- Experience leading database migration teams and reviewing technical deliverables
- AWS Certified Database – Specialty certification
- Production experience with Amazon Aurora PostgreSQL
- Experience leading enterprise-scale SQL Server to PostgreSQL migration programs
Company Overview