Lead DB Developer (SQL / PL SQL 2022)

10 years

Calcutta

Posted:8 months ago

Apply

Job Description

Project description

We are looking for a highly skilled Lead SQL 2022 Developer with strong technical expertise across Microsoft .NET, SQL, scripting languages (Perl, Shell, Batch), Control-M, and Linux/Windows environments to support multiple applications within the banking domain. The role involves assessing applications within banking technology, performing data migration and validation, and Implementation.

Responsibilities

Leading and managing major banking technology platforms using SQL Server 2025 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

  • 10+ years of experience in SQL / PL SQL engineering, with at least 5 years in a lead role within Banking technology (Core / Capital Markets)

Proven leadership in major database migration, upgrade, or modernization programs.

Experience leading teams of developers and database engineers in a large-scale database migration project in Agile or hybrid delivery environments across multiple locations.

Expert-level proficiency in SQL Server, including complex stored procedures, query tuning, indexing, and performance optimization.

Experienced in collaborating with Solution Architects and DBAs across the organisation to follow and define standard practices.

Evaluate existing architecture and design, modernized solutions aligned with migration goals.

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

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

Lead


Kolkata, India

Req. VR-119543

SQL (PL/SQL - Oracle)

BCM Industry

21/01/2026

Req. VR-119543

Skills Required

developer sql .net scripting perl linux support technology data migration server refactoring analyze database testing reconciliation regression planning backup rollback java middleware automation monitoring integrity engineering leadership agile query tuning indexing optimization architecture design scheduling etl integration versioning git svn devops management coordination oracle

Work Mode

On-site

Job Type

Part Time

Mock Interview

Practice Video Interview with JobPe AI

Start Java Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now
coding practice

Enhance Your Java Skills

Practice Java coding challenges to boost your skills

Start Practicing Java Now
Luxoft logo
Luxoft

IT Services and IT Consulting

Zug New York

RecommendedJobs for You