iLink Digital is a Global Software Solution Provider and Systems Integrator, delivers next-generation technology solutions to help clients solve complex business challenges, improve organizational effectiveness, increase business productivity, realize sustainable enterprise value and transform your business inside-out. iLink integrates software systems and develops custom applications, components, and frameworks on the latest platforms for IT departments, commercial accounts, application services providers (ASP) and independent software vendors (ISV). iLink solutions are used in a broad range of industries and functions, including healthcare, telecom, government, oil and gas, education, and life sciences. iLinkexpertise includes Cloud Computing Application Modernization, Data Management Analytics, Enterprise Mobility, Portal, collaboration Social Employee Engagement, Embedded Systems and User Experience design etc.
What makes iLinks offerings unique is the fact that we use pre-created frameworks, designed to accelerate software development and implementation of business processes for our clients. iLink has over 60 frameworks (solution accelerators), both industry-specific and horizontal, that can be easily customized and enhanced to meet your current business challenges.
Requirements
Database Migration Engineer
We are seeking an experienced Database MigrationEngineer with deep expertise in SQL Server and database migration tools todesign and develop a robust migration solution.
Key Responsibilities:
Design, develop, and implement a database migration tool to seamlessly migrate databases from on-premises to Cloud primarily around SQL Server .
Analyze existing schema, stored procedures, indexes, and data models for compatibility with SQL.
Optimize data pipelines to ensure high-performance migration with minimal downtime.
Develop automated scripts and ETL workflows to handle data transfer efficiently.
Address schema transformation, data type compatibility, and performance tuning during the migration.
Conduct data validation, reconciliation, and consistency checks post-migration.
Implement logging, error handling, and rollback mechanisms for fail-safe migration.
Collaborate with cloud architects, data engineers, and DevOps teams to define best practices for migration.
Provide documentation, user guides, and training for internal teams on the migration process.
Required Skills Experience:
Strong expertise in SQL Server (on-prem and Azure SQL Server) , including schema design, indexing, partitioning, and query optimization.
Hands-on experience with database migration tools like Azure Data Migration Service (DMS), SQL Server Migration Assistant (SSMA), and custom migration scripts .
Proficiency in T-SQL, stored procedures, triggers, and database scripting .
Strong knowledge of ETL processes, data pipelines, and data transformation techniques .
Experience with Python, PowerShell, or other scripting languages for automation.
Familiarity with Azure services such as Data Factory .
Understanding of data security, encryption, and compliance in cloud-based data environments.
Experience in performance tuning, data partitioning, and workload optimization during migration.
Knowledge of CI/CD pipelines for database deployments is a plus.
Preferred Qualifications:
Experience with Fabric SQL .
Certifications such as Azure Database Administrator Associate (DP-300) or Azure Data Engineer Associate (DP-203) .
Q2.what's thread synchronization semaphores in threading what's critical section in threading One threading problem with 3 threads and how will... read more