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 focussed 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
PL SQL / Database Strategic Development
Management

ER Modelling, Project Estimation and Delivery
Tracking, DB Design, DB recon, DB Migration, DB
Support (UAT and Production)

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