Senior Database Systems Administrator
Senior Database Systems Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 endtoend 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 nonexhaustive 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 databasecentric 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 rearchitecture and refactoring 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 adhoc 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 reengineering 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.
Key Experience/Competencies/Skillsets: 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-arch
Education
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
Employment Type
Full Time
