Job Description

Project description
We are looking for a highly skilled Lead 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

• - 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.

Skills Required