Job Title:
Senior Database Administrator
Location:
Dublin 1
Job Type:
Contract
Work Type:
4 days/week (initially 1 day/week in office for 2-3 weeks, then 1-2 times/month)
Role Type:
Senior (7+ years' experience)
Overview of Role
The client seeks a Senior Database Administrator to support the Business Intelligence, Data Analytics & Data Management Unit. The role focuses on administering and optimising the organisation's Oracle database, automating ETL routines and reporting, enhancing data quality, security, and integration, supporting open-source tools and platforms, developing APIs and BI dashboards, and contributing to the creation of a data warehouse/lake.
Role & Responsibilities:
* Administer and optimise Oracle database including replication, backup, security, tuning, and data cleansing
* Automate ETL routines and reporting processes
* Develop APIs and BI dashboards for data visualisation and integration
* Support open-source tools such as Metabase, QGIS, and platforms including AWS and Azure
* Perform database installation, configuration, upgrades, and patching (OPatch, DBUA)
* Implement backup and recovery strategies using RMAN and manage high availability via Oracle Data Guard
* Conduct performance tuning using EXPLAIN PLAN, SQL Trace, TKPROF, AWR/ASH, and use Oracle Enterprise Manager
* Manage security functions including user roles, auditing, encryption (TDE), and compliance with regulations like GDPR and HIPAA
* Automate routine tasks with shell scripting and PL/SQL, and support capacity planning and forecasting
* Integrate databases with applications through OCI, JDBC, ODBC, and support ETL tools like Oracle Data Integrator
* Manage cloud and hybrid environments including Oracle Cloud Infrastructure, Autonomous DBs, and Exadata Cloud Service
* Use version control and CI/CD tools (Git, Jenkins) for database code deployment pipelines
Skills, Qualifications & Experience
* Expert knowledge of Oracle RDBMS (versions 11g, 12c, 19c, 21c), including architecture, PL/SQL development, and data modelling
* Strong experience with backup/recovery, high availability solutions, and performance tuning methodologies
* Proficiency with cloud database environments and tools such as RMAN, OEM, Data Pump, APEX, and automation scripting (Bash, Python, PowerShell)
Experience:
* Minimum 7 years as a Senior Database Administrator working with Oracle databases in Linux/Unix/Windows environments
* Hands-on experience in database lifecycle management: installation, upgrades, patching, and performance optimisation
* Experience supporting BI tools and platforms including Metabase, Power BI, AWS, Azure, and open-source GIS tools
Education & Certifications:
* Relevant degree in Computer Science, Information Technology, or related field
* Oracle Database Administration certifications preferred (e.g., OCP)
Visa:
* Irish/EU Citizen or Stamp 4 Visa holder
About Us
As Ireland's largest IT Solutions Provider with a growing global footprint, ergo offers deep expertise across managed IT & hardware services, cloud, applications & software services, IT resourcing, and modern work solutions. Our recent technology awards reflect our commitment to delivering industry-leading IT solutions, highlighting our team's dedication and expertise.