Description
Oracle DBA required for a 12+ month contract based in Dublin City Centre.
Responsibilities:
- Act as the database (but not necessarily the database design) authority
- Implement updates and maintain revisions to logical and physical models in distributed development environments
- Liaise with Oracle customer service and technical support as necessary
- Design, development, tuning and maintenance of packages and procedures in both Oracle and Oracle Spatial
- Manage database security including access control and backup/restoration
- Administer corporate and sectoral databases across development, UAT, pre-live and live environments
- Ensure compliance with Oracle licence agreement
- Assist with the management of the Department's GIS resources, including database integration where required
- Provide expert technical advice and support to Java development teams and analysts interfacing to PL/SQL and Oracle
- Troubleshoot issues within a J2EE Development environment interfacing to GIS technologies and Oracle/Oracle Spatial
- Database monitoring and performance optimisation
- Tuning and Optimising Oracle and Oracle Spatial queries
- Data and Spatial Data loading
- Remote management of database services
Experience Required:
- Bachelor's Degree in Computer Science, Engineering, Information Technology, Mathematics or other relevant field.
- Oracle Certified Professional (OCP) in Oracle 10g or higher
- Minimum of 5 years work experience as an Oracle Database Administrator (DBA)
- Minimum of 3 years work experience with Oracle Application Server (AS)
- Experience in managing Oracle10g or higher on a Windows O/S platform
- Datamodelling and database design
- Experience in SQL tuning and database performance optimization
- Experience using ESRI's ArcSDE toolset
- Expertise in the implementation and utilisation of Oracle Spatial Locator
- Experience working in Virtualised Environments
- SQL and PL/SQL (including 10g & 11g enhancements)
- Experience working with Oracle Application Server
- Experience working in a Corporate Data Model environment