PL-SQL Technical Lead - Transformation , Mumbai

Job Description:

Job Title: Manager

Department: IT

Reports to: Senior Manager/ Assistant Vice President – IT

Experience: 10 Years and above

Required Qualification: BE/ B Tech/ MCA/ MBA

Preferred Qualification: BE/ B Tech/ MCA/ MBA

Skill, Knowledge & Trainings:

 Incumbent should possess hands on knowledge of the database design and should be able to devise data migration strategies from scratch.
 Ability to design the database E-R modelling vis-à-vis legacy system database models by understanding the legacy packages and procedures.
 The Incumbent would function as Technical lead for Database Migration in the transformation project and would be responsible for initiating , leading , planning and ensuring the successful migration of legacy data to the transformation
 Ability to analyse, assess and evaluate trending technologies in DB related tools
 Ability to understand & troubleshoot data related issues and suggest mitigation solutions.
 Significant prior experience in designing, building and supporting enterprise class Database systems in the capital markets / fixed income / foreign exchange / derivatives domain.
 Implement and govern the database migration strategies.
 Experience with agile development methodologies and supporting tools
 Thorough understanding of SDLC processes including testing methodologies; exposure to automated testing would be an added advantage
 Good Communication and Presentation skills
 Understand the legacy data model and data and provide strategic database direction to the teams.
 Be responsible for maintaining staging Databases

Core Competencies (Must have):

 Database design/ Development in Capital Markets / Fixed Income / Foreign Exchange / Derivatives /Treasury domain/ Information technology/ Fintech
 DB Security and Governance
 DB Performance Tuning
 IT Team Management & Delivery
 Oracle Certification (DBA Track) on Oracle 10g/11g/19c

 Hands on experience with PL-SQL complex queries, procedure, packages and DB administration.

Additional Competencies (Nice to have):

 Appreciation of Enterprise Functional Database Architecture in Capital Markets
 Cloud Native design, Agile Methodologies
 AWS Certification

Job Purpose:

The successful candidate would join the IT Department in the Transformation Programme for Clearing and Settlement systems. The transformation programme is focused on transforming the existing applications for the clearing and settlement systems as per the new technical architecture and design. The successful candidate would be responsible for leading an database team or teams through all stages of the development life cycle while also working closely with all other project stakeholders.

Area of Operations Key Responsibility

1. PL SQL / Database Strategic Development Management
2. ER Modelling, Project Estimation and Delivery Tracking, DB Design, DB recon, DB Migration, DB Support (UAT and Production)
3. Recruitment and Team Building Developing assessment criteria, conducting interviews, guiding the development team, problem solving, setting clear goals and delivering through teams

Any Other Requirement:

 Leadership skills with ability to build consensus across multiple stakeholders
 Would be required to work with multiple projects / teams concurrently
 Team building and Team working