Job Summary
Add dedicated execution capacity for Navision-based data migrations, SQL database operations, data quality and reporting support. The role will take on operational and delivery activities currently handled by the Data Architect, enabling her to focus on data architecture, governance and strategic design decisions.
Key Responsibilities
Area
Expected contribution
Data migrations and transformation
Execute migrations for acquisitions, mergers and clinic closures, profile, cleanse, transform, load and reconcile data, support rehearsals, cutover and post-load validation.
Database operations and performance
Maintain and troubleshoot SQL Server and Azure SQL environments, monitor health and performance, tune queries, support patching, vulnerability remediation and access management.
Data quality
Identify and resolve completeness, integrity, duplication and consistency issues across master and transactional data, in partnership with business teams.
Reporting and data delivery
Develop and maintain T-SQL queries, data extracts and Azure data flows for internal and external recipients, with appropriate checks for accuracy and sensitive information.
Engineering practices and support
Use Git/source control and Azure DevOps practices, document solutions, investigate incidents, automate repeatable tasks and improve migration runbooks and controls.
Execute reliable, repeatable and well-controlled data migration and database activities across the RBS landscape, working closely with the Data Architect and business stakeholders.
Skill Requirements
Essential
- Solid relational database understanding
- Intermediate-to-advanced T-SQL
- Extensive SQL Server and Azure SQL experience
- Query and database performance tuning
- Azure Data Factory and/or Synapse, familiarity with the wider Azure data suite
- Hands-on data migration, cleansing, transformation and reconciliation experience
- Microsoft Excel for analysis and validation
- Git/source control and disciplined database development practices
- Clear communication and confidence working with business and technical stakeholders
Desirable
- PowerShell
- Power BI and/or Microsoft Fabric
- Azure DevOps pipelines
- Source-controlled database projects
- Dynamics NAV 2016
- Dynamics 365 Business Central
- ERP or CRM migration experience
- Experience supporting acquisitions, mergers or business closures
Must Have Skill
Azure Data Factory (ADF),Azure SQL DB,Microsoft SQL Server
Good to Have Skill
Other Requirements
Experience and success measures
- Typically 5+ years of relevant SQL Server/database engineering experience, including delivery of complex data migrations in enterprise environments.
- Able to independently execute assigned migration workstreams, including validation and reconciliation, with architectural direction provided by the Data Architect.
- Able to take ownership of day-to-day SQL/Azure SQL support, performance troubleshooting, data-quality analysis and recurring data-delivery activities.
- Demonstrates strong documentation, control awareness, attention to detail and proactive stakeholder communication.
The role is execution-focused. Ownership of enterprise data architecture, governance frameworks, architecture standards and strategic solution design remains with the Data Architect. The successful candidate is expected to implement within those standards and raise design decisions or exceptions for architectural review.
📌 Senior Support Lead (India)
🏢 HCLTech
📍 India