Back to search.BioWare Ireland, a division of EA Games - Database Administrator
| Employment Type: | Contract |
| Location: | Galway - West, Ireland, Galway |
| Salary: | Competitive Salary Offered |
| Languages: | English |
| Required Languages: | 1 |
Advertiser Details
- Name:BioWare Ireland, a division of EA Games
- Posted:12-04-2012
- Code:52631
BioWare Ireland seeks candidates for the position of Database Administrator. 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.
Company Overview:
BioWare, a division of Fortune 500 company Electronic Arts (ERTS), specializes in delivering the best story-driven games in the world. With a history of excellence, BioWare has created some of the world's best-selling titles including the award-winning Baldur's Gate, the Neverwinter Nights series, and Star Wars: Knights of the Old Republic. Original BioWare-created IPs include: Jade Empire, DragonAge : Origins, the critically acclaimed Mass Effect, Mass Effect 2, and Sonic Chronicles: The Dark Brotherhood for the Nintendo DS. BioWare is currently developing Star Wars: The Old Republic, a massively multiplayer online role-playing game being developed at BioWares studios in Austin, Texas. Recently announced, BioWares customer support for the upcoming game will be centralized in Galway, Ireland.
Key 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 modeling, 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.
Experience and Qualifications
Bachelor's degree in Computer Science or related field
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 modeling & 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 catalog, 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 modeling with either Oracle or MySQL
Solid understanding of capacity planning and traffic modeling
Shell Scripting in both bash & perl
Linux monitoring and tuning techniques as they pertain to a DBA
Pluses:
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
Person Specification:
Compensation:
BioWare Ireland offer 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.
Please Note:
Applicants must be eligible to work in Ireland without company sponsorship
IMPORTANT NOTICE:
You are now going to be redirected to EA Games Careers Portal where you will need to register your details & apply for this position for your application to be received by BioWare Ireland, A Division of EA Games.
If you are an active TLJ user you will be redirected immediately. If you are new to TLJ you will have to register with us first.
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.
Company Overview:
BioWare, a division of Fortune 500 company Electronic Arts (ERTS), specializes in delivering the best story-driven games in the world. With a history of excellence, BioWare has created some of the world's best-selling titles including the award-winning Baldur's Gate, the Neverwinter Nights series, and Star Wars: Knights of the Old Republic. Original BioWare-created IPs include: Jade Empire, DragonAge : Origins, the critically acclaimed Mass Effect, Mass Effect 2, and Sonic Chronicles: The Dark Brotherhood for the Nintendo DS. BioWare is currently developing Star Wars: The Old Republic, a massively multiplayer online role-playing game being developed at BioWares studios in Austin, Texas. Recently announced, BioWares customer support for the upcoming game will be centralized in Galway, Ireland.
Key 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 modeling, 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.
Experience and Qualifications
Bachelor's degree in Computer Science or related field
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 modeling & 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 catalog, 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 modeling with either Oracle or MySQL
Solid understanding of capacity planning and traffic modeling
Shell Scripting in both bash & perl
Linux monitoring and tuning techniques as they pertain to a DBA
Pluses:
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
Person Specification:
Compensation:
BioWare Ireland offer 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.
Please Note:
Applicants must be eligible to work in Ireland without company sponsorship
IMPORTANT NOTICE:
You are now going to be redirected to EA Games Careers Portal where you will need to register your details & apply for this position for your application to be received by BioWare Ireland, A Division of EA Games.
If you are an active TLJ user you will be redirected immediately. If you are new to TLJ you will have to register with us first.
You cannot apply for this job as it is no longer active.
