Senior DB Developer (SQL / PL SQL 2022)

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.