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 / FintechDB Security and GovernanceDB Performance TuningIT Team Management & DeliveryOracle Certification (DBA Track) on Oracle 10g / 11g / 19cHands 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 MarketsCloud Native design, Agile MethodologiesAWS CertificationJob 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 :
PL SQL / Database Strategic Development ManagementER 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 teamsAny Other Requirement :
Leadership skills with ability to build consensus across multiple stakeholdersWould be required to work with multiple projects / teams concurrentlyTeam building and Team working(ref : hirist.tech)