The role of an Oracle PL/SQL Developer iscrucial to our organization as it involves developing testingimplementing and maintaining PL/SQL code to support business needs.The developer will work closely with crossfunctional teams toensure optimal database performance and seamless dataintegration.
KeyResponsibilities:
* Make enhancementsto the PL/SQL framework for data ingestion for banks regulatoryreporting needs
* Work within a project team tohelp deliver IT change within the regulatory accountingspace
* Work closely with the project team andFinance on change and developmenttasks.
* Develop new functionality orenhancements using Oracle database technologies includingPL/SQLbased packaged procedures functions VPD views materialisedviews common database APIs SQL*Loader routines etc
* Ensure database development is in line withmodern Oracle database development practices and databaseoptimisation throughput scale and efficiency have been factored inthe design of the build
* Have a willingness andskills to analyse financial data run queries and provide summarisedextracts to business analysts
* Documentingdevelopment through technical design documents installationdocuments unit test cases etc.
* Provide timelyupdates to stakeholders in terms of progress and status ofissues
* Work with Oracle support raising SRs ifrequired and providing diagnostic information whenrequired
* Ensure all development is compliantwith MUSI change control and information riskpolicies
* Communicate with wider technologyteams to ensure fixes or enhancements are executed in a controlledand coordinated manner
RequiredQualifications:
* Extensively workedwith database management systems such as Oracle and be consideredan expert in this field
* A strong understandingof database languages including SQL*Plus & PL/SQL
* Ideally have experience with working onFinancial accounting systems
* Strong experienceworking with interfaces and have a good appreciation of ETLtechniques ideally Informatica
* Have beeninvolved with project implementations with a solid understanding ofthe project life cycle and different implementationtechniques
* Pay great attention to detail and beclientdriven with a focus on delivery andmilestones
* Have exceptional communicationskills being able to converse with a wide variety of stakeholdersincluding department heads
* Have exposureworking with scheduling software such as ControlM Autosys Tivolietc
pl/sql,databasedevelopment,oracle,ibm tivoli,finance,informatica,performancetuning,etl,communication,schedulingsoftware,database,sql*plus,oracle database,bmc control-m,sql,changecontrol,autosys,data analysis,data modeling,databasemanagement