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 Dev Ops pipelines
- Understanding of system dependencies environment management and release coordination