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:
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.
Seniority level
* Mid-Senior level
Employment type
* Contract
Job function
* Information Technology
* Industries: Technology, Information and Internet
About this role: Referrals increase your chances of interviewing at Ergo IT Recruitment Services.
#J-18808-Ljbffr