Database administrator Job in Galway, Dublin Ireland

Our client is a rapidly growing multinational which develops high quality console, PC and online games.

 

They urgently require a Database Administrator to work in their newly established Centre of Excellence in Galway, Ireland.

Role

The Database Administrator will develop and maintain database infrastructure components for online games. This job requires a high level of expertise in administration, development, backup, recovery, and tuning of database components. The Database Administrator requires both operational and development DBA capabilities.

The successful candidate must be able to plan, implement, and maintain DB operational services as well as develop database architectural and script based components. Oracle DBA, PL/SQL development, Unix administration scripting as it pertains to a DBA, and perl scripting are the primary skill sets of this job, but other database experience in open source databases such as Postgres, MySQL, EnterpriseDB are required as well. Oracle experience in a production environment and warehousing experience is required.

 

The Database Administrator will contribute to the development of all technologies related to database systems in a collaborative environment populated by domain experts.

Responsibilities
 

·    The DBA administers and maintains relational databases and assists in the development and implementation of policies and procedures for ensuring the security and integrity of company databases.

·    Partners with developers on data modelling, logical and physical schema design and SQL query tuning.

·    Performs database performance tuning, capacity planning, replication, and other distributed data issues.

·    Develops scripts to automate routine maintenance tasks as appropriate.

·    Maintains and develops database backup/recovery process using RMAN for hot backups and disaster recovery.

·    Automates database monitoring solutions.

·    Creates custom warehouse solution for automated metrics and reporting for both game and business systems.

Requirements

 

Essential
 

·    Minimum of 4 years experience in Relational Database Administration in a production environment

·    Significant knowledge of Oracle internals

·    Expert with SQL level tuning, instance level tuning, storage tuning and replication based solutions

·    Knowledge of PL/SQL optimization techniques

·    Able to perform partitioning schemes pruning

·    Data warehouse experience; custom ETL solutions, dimensional modelling star schemas, data cubes, custom reporting solutions

·    Expert with backup and recovery solutions including planning, implementing and periodic evaluation of backup/recovery (offline/online) strategies, RMAN, recovery catalogue, fast recovery strategies, and interfacing with third party products and hardware

·    Replication experience; Custom solutions, Snapshot based, Streams based, Multi-master

·    Experience with clustering technologies (shared shared nothing) and data modelling with either Oracle or MySQL

·    Solid understanding of capacity planning and traffic modelling

·    Shell Scripting in both bash perl

·    Linux monitoring and tuning techniques as they pertain to a DBA
 

Beneficial
 

·    Significant experience with MySQL

·    Previous experience with conversions of Oracle to and from open source offerings such as MySQL, Postgres, EnterpriseDB

·    Unix system administration knowledge

·    Perl programming expertise

·    Java and/or C++

·    Web experience

 

Compensation

 

Our client offers a highly competitive base salary and benefits package including but not exclusive to; bonus, shares, pension, life assurance, long term disability, out of country relocation and games.

 

IMPORTANT
 

·         This position is based in Ireland and candidates should be eligible to work in Ireland.