Senior Oracle Database Administrator

The Role:

• Senior Oracle Database Administrator
• Kilkenny
• Onsite role this role requires a full onsite presence and remote working is not being offered
• Permanent or contractor opportunity

Role Brief:

In this role working with a major SL Controls client your primary role will be the maintenance of rational databasesincluding both Decision Support
Systems and Online Transactional Processing.

You willprovide and ensure data availability integrity and security and perform routinedatabase administrationfunctions including installation configuration and upgrading of databases and software on variousplatforms database capacity planning proactive performance monitoring and tuning security procedureexecution backup and recovery.

Core Tasks:

• Define requirements and associated designs for relational database systems.
• Work closely with application development team to ensure successful deployment andperformance of database applications.
• Resolve issues and recommend the most costeffective solutions.
• Lead or participate on the design and implementation of large complex database solutions.
• Consult with developers and clients to determine the impact of new and revised processes on theoverall architecture of systems.
• Facilitate monitor and implement solutions around data replication for multiple databases.
• Implement advanced monitoring and alerting solutions for database systems.
• Maintain appropriate level system documentation.
• Maintain and ensure database consistency integrity security and auditing in accordance withregulatory and compliance requirements.
• Performs database patching and supports OS patching at regularly scheduled intervals.
• Manage development testing and implementation of database systems to meet database capacitystandards and sizing objectives.

Supervisory Tasks:

• Mentor and oversee the technical duties of less experienced staff members.
• Work with a distributed DBA team.
• Exercise considerable judgment and latitude in determining objectives and approaches toassignments.
• Use your latitude for discretionary action or decision with work reviewed as required
• Responsible for the successful completion of moderate risk assignments that have a significantimpact on database operations.
• Use best practices to ensure success of work assignments and/or projects.
• Perform difficult assignments that are multidimensional or crossdisciplinary in nature developingsolutions to a variety of complex problems which require originality and/or ingenuity.
• Apply initiative and judgment in accomplishing resolution of unusual situations.

Skills Brief:

Required:

• Experience in large enterprise database environments as well as solution delivery methodologies gained through a combination of formal training and progressive work experience.
• Experience working in a regulated environment.
• Experience working with company operating procedures policies tasks and processes.
• Experience with transactional and/or data warehouse practices.
• Experience in Database Security.
• Excellent communication and customer service skills.
• Fluent in Linux/Unix shell scripting SQL and PL/SQL.
• Experience working with Oracle on Linux/Unix.
• Strong experience with Backup/Recovery using Oracle RMAN and DataPump.
• Strong experience with High Availability using Oracle RAC and Data Guard.
• Ability to meet deadlines on multiple projects and handle multiple assignments.
• Ability to perform in a diverse cross functional team environment.

Preferred:

• Experience with GoldenGate
• Experience with Oracle advanced security
• Ability to architect the database based on user requirements

Person Brief:

You must at a minimum have a Bachelors Degree in Computer Science or an equivalent degree with a strong focus on database concepts and technology. A minimum of 7 years of experience in Oracle database administration is essential.

Some experience in the Pharma Life Sciences or Medical Devices manufacturing setting would be preferred but is not essential.

You should have proven experience at Senior or Lead level in a database administration role and the ability to develop and mentor less experienced individuals while also managing senior level stakeholders in other teams and functions. Exceptional communication skills and attention to detail are essential qualities for this role.

The role will be based onsite in Kilkenny so you should be living within a reasonable commute of the site of willing and able to relocate with 1 to 2 months.

You should have a valid work permit allowing you to work in Ireland or be an EU or UK citizen.

Opportunity Brief:

This is an excellent opportunity to work with clients who are global leaders in their field helping to develop and improve upon industry leading technology solutions. SL Controls offers a supportive environment committed to employee development and wellness along with a competitive and rounded compensation package which rewards high performers.

Company Brief:

SL Controls are experts in the area of Equipment System Integration and System Support. We specialise in assisting our customers including many of the worlds top multinational companies in the medical device and pharmaceutical sectors achieve their Six Sigma and OEE targets.

Over the past 20 years we have grown our business from a Sligo based enterprise into an international business with additional offices in Galway Limerick Leinster and Florida USA.

We pride ourselves on our expertise in industrial IT integration and regulatory compliance in support of global end users OEMs and Technology providers.

Find out more about working at SL Controls our Sustainable Development Goals and our Diversity Equity and Inclusion policy.