Description
Primary Responsibilities
- Develop consistent, reliable, maintainable, performance focused Oracle code
- Model conceptual, logical and physical database designs
- Take ownership for the design and development of database elements of the system and facilitate necessary review sessions
- Contribute to and drive the adoption of Data Engineering processes and practices
- Liaise with senior database engineering colleagues in multiple locations (US/Ireland/India)
- Proactively communicate with DBA, QA, developers and business analysts
- Collaborate with engineering colleagues working in the following technologies - middle tier (Java) and UI (client web interfaces)
- Travel outside Ireland on occasion, if required.
Education and Experience
Required
- Degree or equivalent in Computer Science, Engineering or related discipline
- Minimum of 5 years of experience in Oracle SQL & PL/SQL
- Expertise in data analysis
- Experience in SQL performance tuning
- Experience in designing data access layer for Real Time and batch applications
- Familiar with multiple database concepts, ie RDBMS, OODB, ODS, Warehouse
- Experience in developing using formal development methodologies (Agile experience a plus)
Desired
- Familiarity with logical data modelling and relational database design experience using the CASE tool PowerDesigner
- Experience in using utPLSQL
- Data movement and ETL experience (preferably Informatica)
- Experience in working with Job scheduling tools (preferably Autosys)
- Oracle Certification would be highly desirable
- Experience working in UNIX environment
- Experience in Shell Scripting preferably C-Shell/K-Shell
- Proficiency with one or more source control systems
- Experience working with project teams located in multiple geographic locations.
Skills and Knowledge
- Exceptional analytical and problem solving skills
- Strong oral and written communication skills
- Strong interpersonal skills
- Strong client focus and results orientation
- Ability to take initative
- Understanding of Continuous Integration methodologies is an advantage
- Financial systems knowledge is desirable