DB Developer - SQL Migration

We are looking for a highly skilled Developer with strong technical expertise across Microsoft .NET, SQL, scripting languages (Perl, Shell, Batch), Control-M, and Linux/Windows environments to support a major database upgrade from SQL Server 2000 to SQL Server 2012. The role involves assessing applications within risk technology, performing data migration and validation, and Implementation. Responsibilities include leading SQL Server database upgrades, analyzing structures, performing testing, coordinating with teams, updating .NET applications and scripts, and troubleshooting.

Must Have

• Strong experience in Microsoft .NET Framework / .NET Core, C#, and SQL Server (2000, 2005, 2012).
• Deep knowledge of SQL, stored procedures, triggers, and database optimization.
• Proficiency in Perl, Shell scripting, and Windows Batch scripting.
• Experience working with Control-M job scheduling for batch and ETL jobs.
• Comfortable working in Linux and Windows environments.
• Exposure to Java components or integration with database back-ends.

Good to Have

• Experience in large-scale migration or upgrade programs in Core banking, capital markets, and Risk technology.
• Well-versed with data validation frameworks, versioning tools (Git, SVN), and DevOps pipelines.
• Understanding of system dependencies, environment management, and release coordination.

##### Project description

We are looking for a highly skilled Developer with strong technical expertise across Microsoft .NET, SQL, scripting languages (Perl, Shell, Batch), Control-M, and Linux/Windows environments to support a major database upgrade from SQL Server 2000 to SQL Server 2012. The role involves assessing applications within risk technology, performing data migration and validation, and Implementation.

##### Responsibilities

• Lead and support the upgrade of SQL Server databases from 2000 to 2012, including schema conversion, data migration, and stored procedure refactoring.
• Analyze current database structures, compatibility issues, and deprecated features; propose technical solutions and mitigation steps.
• Perform unit testing, support QA team in data validation, reconciliation, and regression testing post-migration.
• Coordinate with DBAs and infrastructure teams for migration planning, backup, and rollback.
• Review and update existing .NET applications to ensure compatibility with the upgrade.
• Modify existing Perl, Shell, and Batch scripts interacting with the database to make sure no issues post migration.
• Analyze and update Java components or middleware modules that integrate with the upgraded SQL layer.
• Validate and reconfigure Control-M job schedules for batch processes where needed.
• Develop or enhance automation scripts for migration, validation, and job monitoring using Perl, Shell, and Batch scripting.
• Create monitoring scripts for system health, job failures, and post-migration data integrity.
• Work on Linux and Windows environments for cross-system integrations.
• Participate in system integration testing (SIT) and user acceptance testing (UAT) for upgraded applications and data flows.
• Troubleshoot database connection, performance, or application errors during and after migration.
• Provide post-implementation support and root cause analysis for any defects or data issues.

##### Skills

Must have

• Strong experience in Microsoft .NET Framework / .NET Core, C#, and SQL Server (2000, 2005, 2012).
• Deep knowledge of SQL, stored procedures, triggers, and database optimization.
• Proficiency in Perl, Shell scripting, and Windows Batch scripting.
• Experience working with Control-M job scheduling for batch and ETL jobs.
• Comfortable working in Linux and Windows environments.
• Exposure to Java components or integration with database back-ends.

Nice to have

• Experience in large-scale migration or upgrade programs in Core banking, capital markets, and Risk technology.
• Well-versed with data validation frameworks, versioning tools (Git, SVN), and DevOps pipelines.
• Understanding of system dependencies, environment management, and release coordination.

##### Other

Languages

English: C1 Advanced

Seniority

Senior