SENIOR ORACLE DATABSE PL/SQL DEVELOPER

OVERALL EXPERIENCE 12YRS +

Position Responsibilities/Duties

Support reporting of business applications using Oracle databases for North America and EMEA.
Design and develop solutions to meet complex business requirements.
Develop and manage PL/SQL database objects, SQL scripts and Interfaces using data management toolsets (TOAD), source version control systems (Perforce) and application deployment tool (Urban code).
Develop, implement and support Business Event and Workflow processes.
Design, develop and implement new and enhanced interfaces with other internal and external systems.
Produce detailed system requirements specifications, complex data flow diagrams, test plans, swim lane and process diagrams using standardized documentation methods.
Ensure that proposed solutions comply with the company’s technology direction.
Ensure compliance with company’s change and security policies.
Interface with Developers, Analysts and Business Stakeholders to understand and propose technology solutions to meet complex business and technical objectives.

Some budget accountability may be expected as projects are presented and approved by Sr. Management.
Key Responsibilities:

Experience/Knowledge Requirements

Ability to absorb & present complex ideas quickly & accurately.
Ability to provide solutions on a tight deadline.
Good prioritizing and time management.
Have a positive approach to work and to fellow team members.
Experience in creating complex Stored Procedures, Tables, Views, Materialized Query tables, Indexes and SQL.
Excellent oral and written communication skills.
Some Experience in IT Strategy and Architecture planning a plus.
3+ years' experience as an Oracle PL/SQL Technical Developer.
TOAD experience is a must.
Strong PL/SQL programming skills.
Excellent SQL tuning experience.
Ability to understand Lending, Trade finance, Deposits, Treasury, Money Transfer and payment applications and analyze any new applications introduced in the bank.
Preferred Working knowledge of Loan IQ and familiarity with LOAN IQ data model.
Experience and knowledge of Oracle Finance EBS (GL, AP) and reconciliation with external source applications .
Some knowledge of Accounting Principles a plus.
Preferred experience working on complex system integration projects within a heavy technical environment
Prior Banking and IT Compliance project experience.
Oracle 11g or 12c experience is a must.
Should have strong English communication and writing skills.
Ability to manage multiple priorities effectively is a necessity.