Database Administrator (Executive Officer)

The Database Administrator is responsible for supporting the maintenance and operation of the organisation’s databases. Key responsibilities include ensuring optimal database performance and security, troubleshooting and resolving database issues, and assisting with database development and administration tasks.

Role Responsibilities The role of Database Administrator includes, but is not limited to, the following duties: • Collaborating with the database team to design, install, test, and maintain databases; • Creating regular database backups and restorations, and managing routine maintenance activities such as storage management and performance optimisation; • Assisting in configuring user permissions, managing access, and implementing security measures to protect sensitive information; • Working with the team to troubleshoot issues, diagnose errors, and ensure the smooth operation of databases; • Analysing slow queries and resolving connectivity issues as required; • Monitoring data quality, identifying and correcting inconsistencies, and applying appropriate data validation techniques; • Using Structured Query Language (SQL) to generate reports, extract data, and perform basic data manipulation; • Ensuring data security, preventing unauthorised access, and maintaining consistency across applications; • Optimising database queries and overall application performance to improve user experience; • Writing and refining SQL queries to efficiently retrieve, manipulate, and store data; • Utilising cloud-based database solutions, including cloud backups and hosted instances; • Responding to helpdesk queries assigned to the Database Team and liaising with application vendors as needed; • Maintaining clear and up-to-date documentation of databases and their configurations; • Managing Oracle Exadata Cloud at Customer (ExaCC) database hardware environments; • Administrating Oracle Cloud Infrastructure (OCI) environments; • Evaluating existing systems and processes and providing recommendations for adopting new practices aligned to TÉ’s strategy and goals.

Note: This job description is subject to re-definition as part of ongoing reforms within the Public Service and change management initiatives within TÉ. Person Specification On the closing date of Monday 30th June 2025 at 5pm candidates must satisfy all the following requirements:

Essential Criteria: • Hold a relevant academic qualification at a minimum Level 8 on the National Framework of Qualifications in a related discipline (e.g. Computer Science, Data Science, Data Analytics, Mathematics, Statistics, GIS); and • A record of achievement in their career to date working with and administrating Databases, or as part of a University qualification; and • Experience writing and optimising SQL queries to retrieve, manipulate, and store data efficiently; and • The capacity to demonstrate to a high level the key competencies that have been devised for posts at this level under the following headings (see Appendix A for further details): 1. People Management; 2. Analysis & Decision Making; 3. Delivery of Results; 4. Interpersonal & Communication Skills; 5. Specialist Knowledge, Expertise and Self Development; 6. Drive & Commitment to Public Service Values.

Desirable Criteria: • Knowledge of Database Administration, particularly with Oracle (preferred), PostgreSQL, Microsoft SQL Server or NoSQL databases such as MongoDB; • Ability to establish and maintain a single, authoritative source of critical data, ensuring consistency and quality across the organisation; • Experience in implementing data security measures to protect against unauthorised access and data breaches;

• Proven ability to manage and maintain databases, ensuring data integrity, performance, and availability; • Experience in leveraging AI-driven automation to optimise processes and support data-driven decision-making. General The appointment is on a probationary basis to a permanent post in the Civil Service and is subject to the Civil Service Regulations Acts 1956 to 2005, the Public Service Management (Recruitment and Appointments) Act 2004 and any other Act for the time being in force relating to the Civil Service. Salary: €37,544 - €60,610 per year Personal Pension Contribution (PPC) The PPC pay rate applies when the individual is required to pay a Personal Pension Contribution (otherwise known as a main scheme contribution) in accordance with the rules of their main/personal superannuation scheme. This is different to a contribution in respect of membership of a Spouses’ and Children’s scheme, or the Additional Superannuation Contributions (ASC). A different rate will apply where the appointee is not required to make a

Personal Pension Contribution. Long service increments may be payable after 3 (LSI1) and 6 (LSI2) years satisfactory service at the maximum of the scale.

Important Note Entry will be at the minimum of the scale and the rate of remuneration will not be subject to negotiation and may be adjusted from time to time in line with Government pay policy. Different terms and conditions may apply if you are a currently serving civil or public servant. Subject to satisfactory performance, increments may be payable in line will current Government Policy. Payment will be made fortnightly in arrears by Electronic Fund Transfer (EFT) into a bank account of your choice. Payment cannot be made until a bank account number and bank sort code has been supplied on appointment and statutory deductions from salary will be made as appropriate. You will agree that any overpayment of salary, allowances, or expenses will be repaid by you in accordance with Circular 07/2018: Recovery of Salary, Allowances, and Expenses Overpayments made to Staff Members / Former Staff Members/Pensioners.

Tenure and Probation The appointment is to a permanent position on a probationary contract in the Civil Service. The probationary contract will be for a period of one year from the date specified on the contract. During the period of your probationary contract, your performance will be subject to review by your manager(s) to determine whether you: (i) Have performed in a satisfactory manner; (ii) Have been satisfactory in general conduct; (iii) Are suitable from the point of view of health with particular regard to sick leave. Prior to the completion of the probationary contract a decision will be made as to whether or not you will be retained pursuant to Section 5A (2) Civil Service Regulation Acts 1956–2005. This decision will be based on your performance assessed against the criteria set out in (i) to (iii) above. The detail of the probationary process will be explained to you by HR, and you will be given a copy of the Department of Public Expenditure and Reform’s guidelines on probation. All appointees will serve a one-year probationary period. If an appointee who fails to satisfy the conditions of probation has been a serving civil servant immediately prior to their appointment from this competition, the issue of reversion will normally arise. In the event of reversion, an officer will return to a vacancy at their former grade in their former Department.

In the following circumstances your contract may be extended and your probation period suspended. • The probationary period stands suspended when an employee is absent due to Maternity or Adoptive Leave; • In relation to an employee absent on Parental Leave or Carers Leave, the employer may require probation to be suspended if the absence is not considered to be consistent with the continuation of the probation; and • Any other statutory provision providing that probation shall - (i) stand suspended during an employee’s absence from work, and (ii) be completed by the employee on the employees return from work after such absence. Where probation is suspended the employer should notify the employee of the circumstances relating to the suspension. The terms of the Organisation of Working Time Act 1997 will apply, where appropriate, to this employment.

Headquarters Headquarters will be such as may be designated from time to time by the CEO. When required to travel on official duty the appointee will be paid appropriate travelling expenses and subsistence allowances, subject to normal civil service regulations.

Duties The employee will be required to perform any duties appropriate to the position which may be assigned from time to time. The officer may not engage in private practice or be connected with any outside business which would interfere with the performance of official duties or conflict with his/her role.

Hours of attendance Hours of attendance will be fixed from time to time but will amount to not less than 41 hours 15 minutes gross per week or 35 hours net per week. No additional payment will be made for extra attendance (over and above 41 hours and 15 minutes gross or 35 hours net per week) as the rate of remuneration payable covers any exceptional extra attendance liability that may arise from time to time. TÉ offers flexible working, with a commitment to work-life balance and a family-friendly workplace. Annual Leave The annual leave allowance for this position is 23 days, rising to 24 days after 5 years’ service, to 25 days after 10 years’ service, to 26 days after 12 years’ service and to 27 days after 14 years’ service. This allowance is subject to the usual conditions regarding the granting of annual leave in the civil service, is based on a five-day week and is exclusive of the usual public holidays.