Senior Oracle Database Administrator - Kilkenny

at  SL Controls Ltd

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

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 databases including both Decision Support
Systems and Online Transactional Processing.
You will provide and ensure data availability, integrity, and security and perform routine database administration functions including installation, configuration, and upgrading of databases and software on various platforms, database capacity planning, pro-active performance monitoring and tuning, security procedure execution, backup and recovery.

Core Tasks:

• Define requirements and associated designs for relational database systems.
• Work closely with application development team to ensure successful deployment and performance of database applications.
• Resolve issues and recommend the most cost effective 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 the overall 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 with regulatory 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 capacity standards 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 to assignments.
• 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 significant impact on database operations.
• Use best practices to ensure success of work assignments and/or projects.
• Perform difficult assignments that are multidimensional or cross-disciplinary in nature, developing solutions to a variety of complex problems which require originality and/or ingenuity.
• Apply initiative and judgment in accomplishing resolution of unusual situations.

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.