Developer Transaction Database

Job Description

The jobholder is responsible for developing and enhancing the TDB application.This includes perform technical assessment of requirements received, effort estimation, solution design, build/test the approved design and implementation into production environment in accordance with SDLC best practices.The role also demands to provide analysis and solution when production issues/job failures are escalated to build the bank.What will you be doing Analysis:Actively engaged external business and IT partners in the requirements analysis for system enhancements and changes.Writing functional specifications if required.Design:Interpret and understand functional specificationsWriting technical design documents adhering to predefined standardsCode:Hands on development of quality (i.e. readable, performing and supportable) PL/SQL code on an Oracle database, delivering the functionality detailed in the technical specificationsHands on development of Autosys, Unix, and Perl scripts, delivering the functionality detailed in the technical specificationsEnsuring code written meets the predefined company and department standardsPerformance Tuning:Tuning existing code to ensure acceptable application performanceReview users queries to understand data access patterns and suggest enhancements to data model and/or indexing strategyQuality Assurance:Conducting reviews at various quality check points and providing constructive feedbackMentoring junior members of the teamTesting:Preparation of detailed unit test casesExecution of unit test cases and documentation of resultsProviding support during QA and UAT test phasesDiagnosis and resolution of defects found during QA and UAT test phasesSupport regression testing - investigate output differences.Implementation:Packaging up codes for release into productionOn implementation of releases, provide training to support team membersPost-Implementation:Point of contact for support team, investigating and resolving issues found in productionProduction Escalation:The role demands to provide analysis and solution when production issues/job failures are escalated to build the bank (Production Escalation to BTB) in a timely manner. Individuals will be required to provide Production escalations on rotation basis.Communication ResponsibilitiesCommunicate directly with business analysts and project managers, understanding detailed business requirements at all stages of the development lifecycleCommunicate effectively with business users to gain an in-depth understanding of new requirements and minor system changesCommunicate effectively with the other external IT development teams and the local development manager.Work closely with global development team members in Singapore, London and New York participating in and contributing to technical discussions. Participate and contribute in technical discussionsWhat we re looking for:Extensive experience Oracle 11G and 12G , PL/SQL Development , Database design, SQL performance tuningExperience with Unix (preferably Linux)Good understanding of Data Warehouse and Data Mart concepts with proven experience in bothAbility to design and implement logical and physical data modelsHands on experience with GIT or similar version source code control tools.Ability to perform effort estimation for a given piece of work.Familiar with scheduling management technologies e.g. Autosys, Control MExperience working with large Oracle databasesSkills that will help you in the role:Good understanding of investment banking, and the industry sectorGood understanding of front to back finance and operational process flowsUnderstanding of Cloud Technology and AWS in particularUnderstanding of Agile SDLC concepts; Understanding of Scrum/Kanban Agile SDLC methodologyA bachelor degree in Computer Science, Software Engineering or related.Good experience years of hands-on Oracle database development experience.Experience of working in a fast-paced and agile environment.IB experience advantages.,

Keyskills :
Databasedesign racle11G 12G PLSQLDevelopment SQLperformancetuning Oracledatabases