Lead Database Engineer
Job Location:
Monthly Salary:
Experience Required:
Posted:
Application Deadline:
Vacancies:
Job Summary
We are looking for a Lead Database Engineer with strong experience in database migration consolidation and data engineering. The role will lead the migration of multiple legacy databases into a unified target schema while ensuring data integrity reconciliation performance and production readiness.
- Lead end-to-end migration and consolidation of multiple legacy databases into a single target schema.
- Perform data profiling source-to-target mapping transformation and master data/entity resolution.
- Develop and execute full-load incremental delta and CDC-based migration processes.
- Design reconciliation processes covering row counts checksums control totals financial balancing and exception reporting.
- Develop migration runbooks rollback plans rehearsal strategies and production cutover plans.
- Execute migrations across DEV QA UAT and Production environments.
- Develop and optimize complex T-SQL stored procedures functions triggers indexes and queries.
- Work with SQL Server/MSSQL IBM DB2 PostgreSQL and Oracle databases.
- Utilize Azure SQL Azure Data Factory SSIS Azure Storage Azure Key Vault DMA and Azure Database Migration Service.
- Implement database CI/CD using SSDT/DACPAC Flyway/Liquibase Azure DevOps or GitHub Actions.
- Ensure database security data masking encryption RBAC and audit requirements.
- Assess the impact of schema changes on Power BI SSRS batch interfaces and downstream applications.
- Use Python/PowerShell and AI-assisted tools for migration automation reconciliation and engineering productivity.
- Provide technical leadership and communicate migration risks data issues and reconciliation results to stakeholders.
- 1012 years of database/data engineering experience with at least 4 end-to-end production data migrations.
- Expert knowledge of Azure SQL SQL Server 2016 T-SQL database internals performance tuning indexing execution plans statistics and partitioning.
- Mandatory experience consolidating multiple independent databases into a single target schema.
- Strong experience in ETL data migration data reconciliation master data management entity resolution and data quality.
- Hands-on experience with SQL Server/MSSQL IBM DB2 PostgreSQL and Oracle databases.
- Strong experience with Azure SQL Azure Data Factory SSIS Azure Storage and Azure Key Vault.
- Experience with DMA and Azure Database Migration Service is preferred.
- Experience with database DevOps CI/CD schema-as-code and version control.
- Strong scripting skills in Python and/or PowerShell.
- Good understanding of database security encryption data masking RBAC and data privacy.
- Strong communication documentation troubleshooting and stakeholder management skills.
- Practical experience using AI-assisted coding/data tools for SQL mappings migration scripts and documentation.
- Experience in Insurance F&I vehicle service contracts warranty claims billing or dealer remittance.
- Experience with multi-tenant data models and complex business rules.
- Exposure to Azure Synapse Databricks or Microsoft Fabric.
- Experience with Redgate ApexSQL dbForge or similar database comparison tools.
- Ability to understand Angular/.NET application code and trace data access paths.
- DP-300 or DP-203 certification mandatory.
Required Skills:
Who are we Fulcrum Digital is an agile and next-generation digital accelerating company providing digital transformation and technology services right from ideation to implementation. We specialise in delivering complex digital commerce ecosystems to large and small customers through a team-oriented and collaborative work environment. These services have applicability across a variety of industries including banking & financial services insurance retail higher education food health care and manufacturing. Job Summary Reports on a day-to-day basis to the Solution architect. The individual in this role will act as an integration developer and will have a broad understanding technology with a focus on technology stacks including those involving CRM solutions online content servers and online & mobile web applications. The developer will be involved in integrating and implementing solutions including legacy platform modernization through the project life cycle and ongoing support. This position will focus on translating applications from legacy solutions to web-based solutions using web framework and technology. Requirements Bachelors Degree from an accredited college or university with a major in Computer Science Information Systems Engineering Business or other related scientific or technical discipline. Masters Degree preferred. At least 4 years experience in developing and consuming RESTful APIs. At least 5 years experience in Service Oriented Architecture/Service integration with Web Services REST and security integration. Skills / Experience / Responsibilities Design develop and implement complex solutions based on Framework 4.5 using C# and . Will work with internal stakeholders to learn the business processes operating systems and application architectures in order to ensure that solutions fit the current or proposed architectural environment. Translate applications requirements into web-based solutions using the recommended frameworks and technology. Design and develop reusable components accelerators and frameworks. Assist in the system integration of components. Implement Test Driven Development frameworks (NUnit xUnit etc.). Implement Design Pattern (Singleton Factory and MVC). Implement Data Structures. Assist in translating customer service marketing & financial business function needs into digitization and automation of technical solutions aligned with organizational goals and strategies. Be a strong team player and effectively participate in projects and daily operational activities
