Lead Db Developer (sql / Pl Sql 2022)

Year    Kolkata, West Bengal, India

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.

Skills Required

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD5163607
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Kolkata, West Bengal, India
  • Education
    Not mentioned
  • Experience
    Year