Bioware Seeks Database Administrator
BioWare Austin seeks candidates for a Database Administrator role in our new Austin, Texas studio for BioWare's first Massively Multiplayer Online game.
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. This position 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. Past experience as an Oracle DBA in a production environment and warehousing experience is required. This position must have the ability to operate independently with little direction and contribute new expertise and knowledge to an environment already populated by experts.
Our Jobs at Bioware page has information on how to apply and several other helpful resources.
BioWare|Pandemic is fueled by the new partnership of RPG leader BioWare Corp., and action/adventure powerhouse, Pandemic Studios. One of the world's largest and best-funded independent game developers, BioWare|Pandemic aims to attract the top industry talent by combining experienced management with a record of innovative, award-winning releases for original and licensed content.
BioWare Corp. is the developer of the award winning Star Wars: Knights of the Old Republic, Neverwinter Nights, Baldur's Gate 1 & 2, Shadows of Amn, Tales of the Sword Coast, MDK2, Shattered Steel, and the recently released Jade Empire, as well as the current developer of the upcoming sci-fi action RPG, Mass Effect, and the much anticipated Dragon Age. Here is a chance to get in at the ground level on Triple A titles with a stable and successful developer.
Duties and Responsibilities
- Maintain database infrastructure components for online games including such things as game persistence systems, login servers, in game systems (help, rewards, metrics), reporting systems, billing, registration, etc. This may eventually require on call periods with a pager. This includes backup and recovery, ongoing tuning and maintenance, traffic/capacity planning, database security, and high availability services.
- Develop and maintain a robust backup and recovery system
- Develop new database infrastructure components for online games
- Develop & maintain automated database monitoring solutions
- Develop & maintain warehouse based BI solutions
- Develop & maintain automated metrics and reporting solutions for both game and business systems
- Contribute to standards, process, and procedures and set new innovative precedents
- Work with game developers to interface game components with databases through packages and procedures
- Help teach developers best practices when developing to database
Experience and Qualifications
- Bachelor’s degree in Computer Science or related field
DBA requirements:
- Oracle (7+ years experience)
- Production DBA experience as an operations DBA
- 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
- Expert with SQL level tuning
- Expert with instance level tuning
- Expert in storage tuning
- Expert with replication based solutions
- Significant knowledge of Oracle internals
- Capacity planning and traffic modeling
- Conversion of Oracle to and from open source offerings such as MySQL, Postgres, EnterpriseDB
- Experience with clustering technologies (shared & shared nothing)
- Data modeling
- Replication experience
- Custom solutions
- Snapshot based
- Streams based
- Multi-master
- Data ware house experience
- Custom ETL solutions
- Dimensional modeling & star schemas
- Partitioning schemes & pruning
- Data cubes
- Custom reporting solutions
Database Programming:
- Internal to Database
- PL/SQL & T-SQL program units
- PL/SQL optimization techniques
- ADT & OO database object experience
- Multi-phase transaction processing
- Schema optimization techniques
- Oracle memory management techniques
UNIX:
- Shell Scripting in both bash & perl
- Linux monitoring and tuning techniques as they pertain to a DBA
Plusses:
- Unix system administration knowledge
- Perl programming expertise
- Java
- Web experience
How to apply
Please quote the following competition number in the subject line of your electronic application, or include in the cover letter of your mailed application:
06-Prog-DBA-BWA12
To apply by email, send your resume and online portfolio to:
ArtistJobsAustin -AT- bioware.com
Along with your submission, you MUST include a signed product submission agreement. You can fax it to: 780-439-6374
Resources to help you apply:
- FAQ on Hiring Artists
- Helpful Art Portfolio Submission Guidelines
- Product Submission Agreement (PSA)
Due to the volume of applications we receive for our job postings, we are unable to respond personally to telephone inquiries regarding the status of an application. Only candidates being considered for interview will be contacted at this time.
Posted by MarkRichards on May 29, 2007 04:08 PM
