Project description We are looking for a highly skilled Lead Developer with solid 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 - Experienced in working with major banking technology platforms using SQL Server 2022 and NET Framework including schema conversion data migration and stored procedure refactoring - Review and update existing NET applications to ensure compatibility with the upgrade - Preparing Architectural diagrams walk-through sessions with Senior IT Business stakeholders - Coordinating with multiple products interfaces internally and externally - Supporting E2E project life cycle managing timelines - 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 - 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 - Troubleshoot database connection performance or application errors during and after migration SKILLS Must have - Experienced in working on and managing medium or large scale net SQL Server applications in Banking domain - Expert-level proficiency in SQL Server including complex stored procedures query tuning indexing and performance optimization - Strong experience in Microsoft NET Framework NET Core C and SQL Server 2022 - Deep knowledge of SQL stored procedures triggers and database optimization - Proficiency in Perl Shell scripting and Windows Batch scripting - Experience in Ctrl-M job setup and scheduling - 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