FEXCO :: Database Administrator (DBA)
Contract : 2 year fixed term contract – fulltime
Location : Killorglin, Co.Kerry
Main Duties and Responsibilities:
� Responsible for effective implementation, configuration, testing, backup and recovery strategies for all relevant programmes, products and software for high availability solutions
� Ensure and carry out regular backups of the database using relevant programmes i.e. RMAN scripting
� Responsible for the administration of existing enterprise databases and the analysis, design, and creation of new databases
� Monitor systems and databases for optimum performance and capacity constraints while analysing and integrity of the data stored in the database
� Understand and implement schemas, possessing the ability to interpret and write complex SQL queries
� Administer database security i.e. adding and removing users, administering quotas, auditing, and checking for security problems
� Identify and suggest recommendations relating to performance and efficiency of data storage e.g. more effective use of indexes or other database specific features
� Review Developer proposed database designs ensuring identification and elimination of any potential problems due to poor design e.g. WRT performance considerations
� Work closely and coach relevant IT staff, managers, developers and support engineers in tasks such as: SQL scripting, database development improvements and schema reviews
� Follow correct processes for documentation, database outage/failures, system configuration and database troubleshooting
� Maintaining data standards, including adherence to the Data Protection Act
Minimum Requirements:
� Proven relevant experience in a high availability environment possessing 4+ years within the Oracle database administration function
� Demonstrate Linux experience
� Possess full SQL programming experience
� Display knowledge and practice of Shell Scripting
� Possess third level degree within relevant IT or business related function (operational experience in the areas stated above will be considered)
� Experience of all or some of the following desirable but not essential: PLSQL, Middleware Experience- Tomcat, Apache, Java and Python and Oracle Financials
� Be flexible in relation to hours ensuring availability for out of hours support to the business
Apply to: msweeney@fexco.com
Closing date for applications: 27.11.2009