Job Title: Senior Database Systems Administrator Location: Dublin 1 or Co Mayo (3 days onsite/week) Contract / Permanent : 12 Months with further extension Start date: Feb 2025.
Role: Nature of the Services Required – comprehensive description of the Client's requirements The Clients PMO Unit requires a Senior Database Systems Administrator to join their team.
The Database Systems Administrator will work with the wider PMO team to support existing legacy systems and where necessary work towards modernising existing systems.
The Database Systems Administrator will be instrumental in assisting the PMO team with respect to the following: · Supporting and customising data architecture associated with existing legacy solutions and websites (Access, SQL Server, DBASE, Oracle, MySQL etc.)
· Reverse engineering and documenting existing legacy systems to gain an understanding of data stores, data flows and data architecture · Assisting in the migration of legacy databases and solutions to the cloud (Dataverse, Azure SQL Server, AWS etc.)
· Gaining an understanding of the various (legacy and third party) data sources in the Department and their underlying data and technologies · Working with project teams to build data architecture and models to support end-to-end business solutions · Contributes to discussions concerning the website database architecture if/when they arise.
Note: Most websites are built using MySQL The Database Systems Administrator should: · Have a strong theoretical base in Database development and management across multiple database platforms to include knowledge of best practices · Have extensive experience migrating legacy on premise solutions (Access, SQL 2000/2008, etc.)
to the cloud · Have experience modelling data and the relationships between data using relevant tools · Acts as the senior responsible person with respect to database development on major client engagements.
· Have experience in leading and developing robust database architecture Take responsibility for leading on the database administrator function within the Business Solutions unit, including the ability to coordinate contributions of other specialists to complete a joint project.
Experience Level Required: It is a mandatory requirement that the Resource proposed has the equivalent of · It is a mandatory requirement that the Resource proposed has the equivalent of 7+ years of extensive professional experience in their specialized field (Database Systems Administrator).
· It is a mandatory requirement that the Resource proposed hold the following qualifications or equivalents: * Professional Certification in SQL Server Key Deliverable: The following non-exhaustive list of Key Deliverables, are applicable to this Role .
· Responsible for designing databases and ensuring their stability, reliability and establishing best practices.
· Provide expertise in the full development lifecycle, from concept and design to testing.
· Develops new database-centric functionality on existing software products (Access, SQL, SSRS, etc.)
· Create technical and architectural documentation and create technical instructions throughout Programme development.
· Troubleshoot changes/errors/modifications.
· Responsible for the performance, integrity and security of a re-architecture and re-factoring of legacy systems.
· Ensures that data remains consistent across the database, is clearly defined, users access data concurrently, in a form that suits their needs and that there is provision for data security and recovery control (all data is retrievable in an emergency).
· Design schemes, tables, and servers and set permissions for users to access them.
· Ensure timely backups of all key database systems.
· Prepare and execute for D/R test plans as required.
· Installation support of Enterprise Manager.
· Cloning of Oracle test and train environment servers as required.
· Yearly reboots - planned for after current financial year end.
· SSL certificate updates.
· Oracle service requests updates and patches as needed.
· Hubble 2024 reporting tool knowledge and expertise – additional Hubble upgrades as required when bugs are identified not fixed in the current version.
· General troubleshooting issues on R12 Oracle applications and 19C database as raised by the Financial Services Unit, ad-hoc work as required.
· Monthly data fixes as needed for application and database issues.
· Develop script to automate part of monthly user reporting, new scripts as recurring tasks are identified.
· Ongoing liaison with ICT and OGCIO (Office of Government Chief Information Office) on technical issues.
· Daily monitoring of all systems.
· Yearly patch cycle for Oracle R12 application and database.
· Work with 3rd party support to implement monthly fixes for issues identified with bespoke software.
Requirements Key Experience/Competencies/Skillsets : The following Experience/Competencies/Skillsets are applicable to this Role.
1.
Has experience supporting databases on multiple platforms (Access, Dbase, SQL Server 2000/2008/../2019, Oracle, etc.)
and has experience customising legacy Microsoft Access solutions.
2.
Has experience re-engineering and migrating legacy on premise solutions to the cloud and hybrid cloud models.
3.
Has experience full development lifecycle, from concept and design to testing using best practices and has extensive experience preparing technical and architectural documentation.
4.
Has experience reverse engineering and documenting legacy systems.
5.
Has experience working in a similar technical environment with Business Analysts, CRM Developers, Web Developers, Project Managers, etc .