Design Your Dream Team
Senior Database Migration Consultant – Pod Lead
Location
Maryland
Posted
4 days ago
Salary
0
Seniority
Senior
Job Description
Senior Database Migration Consultant – Pod Lead
HIKINEX
• 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.
Job Requirements
- 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.
Benefits
- 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).
Related Guides
Related Categories
Related Job Pages
More Recruitment Jobs
• 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.
• 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
Campus Recruiter
CHA Consulting, Inc.CHA is an innovative, full-service engineering, design, consulting, and program/construction management firm.
• 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
• Own full-cycle recruiting for a portfolio of Wellbeing Go-to-Market positions, including Sales, Client Success, Customer Success, Marketing, Revenue Operations, Implementation, and other customer-facing roles. • Partner closely with hiring managers to develop recruiting strategies, understand business priorities, and align hiring plans with organizational goals. • Build proactive talent pipelines through sourcing, networking, referrals, and market research to ensure a strong slate of qualified candidates. • Leverage LinkedIn Recruiter and other sourcing tools to identify and engage passive talent. • Manage multiple searches simultaneously while delivering an exceptional candidate and hiring manager experience. • Serve as a trusted advisor throughout the hiring process, providing market insights, interview guidance, and recommendations that support quality hiring decisions. • Drive structured interview processes that promote consistency, efficiency, and an inclusive candidate experience. • Maintain accurate recruiting activity, candidate data, and pipeline reporting within Workable (or similar ATS). • Communicate proactively with hiring managers and business leaders on pipeline health, hiring progress, and recruiting risks. • Partner with cross-functional teams, including HR Business Partners, Compensation, and Hiring Leaders, to facilitate successful offers and onboarding. • Contribute to ongoing improvements in recruiting processes, tools, interview practices, and talent acquisition programs as we continue to scale.



