Job Title: Senior Database Systems Administrator
Location: Dublin 1 or Co Mayo (3 days onsite/week)
Contract / Permanent: 12 Months with further extension
Role:
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.
Responsibilities:
1. Supporting and customising data architecture associated with existing legacy solutions and websites (Access, SQL Server, DBASE, Oracle, MySQL etc.)
2. Reverse engineering and documenting existing legacy systems to gain an understanding of data stores, data flows and data architecture
3. Assisting in the migration of legacy databases and solutions to the cloud (Dataverse, Azure SQL Server, AWS etc.)
4. Gaining an understanding of the various (legacy and third party) data sources in the Department and their underlying data and technologies
5. Working with project teams to build data architecture and models to support end-to-end business solutions
6. Contributing to discussions concerning the website database architecture.
Qualifications:
1. Strong theoretical base in Database development and management across multiple database platforms.
2. Extensive experience migrating legacy on premise solutions to the cloud.
3. Experience modelling data and the relationships between data using relevant tools.
4. Acts as the senior responsible person with respect to database development on major client engagements.
5. Experience in leading and developing robust database architecture.
Experience Level Required:
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 Deliverables:
1. Design databases ensuring their stability, reliability and establishing best practices.
2. Provide expertise in the full development lifecycle, from concept and design to testing.
3. Develop new database-centric functionality on existing software products.
4. Create technical and architectural documentation and create technical instructions throughout Programme development.
5. Troubleshoot changes/errors/modifications.
6. Responsible for the performance, integrity and security of a re-architecture and re-factoring of legacy systems.
7. Ensure data consistency across the database and provision for data security and recovery control.
8. Design schemes, tables, and servers and set permissions for users to access them.
9. Ensure timely backups of all key database systems.
10. Prepare and execute for D/R test plans as required.
11. Installation support of Enterprise Manager.
12. Cloning of Oracle test and train environment servers as required.
13. Yearly reboots planned for after current financial year end.
14. Oracle service requests updates and patches as needed.
15. General troubleshooting issues on R12 Oracle applications and 19C database.
16. Monthly data fixes as needed for application and database issues.
17. Develop scripts to automate part of monthly user reporting.
18. Ongoing liaison with ICT and OGCIO on technical issues.
19. Daily monitoring of all systems.
20. Yearly patch cycle for Oracle R12 application and database.
21. Work with 3rd party support to implement monthly fixes for issues identified with bespoke software.
Requirements:
1. Experience supporting databases on multiple platforms and customising legacy Microsoft Access solutions.
2. Experience re-engineering and migrating legacy on premise solutions to the cloud.
3. Experience in the full development lifecycle, from concept and design to testing using best practices.
4. Experience reverse engineering and documenting legacy systems.
5. Experience working in a similar technical environment with Business Analysts, CRM Developers, Web Developers, Project Managers, etc.
#J-18808-Ljbffr