Perfect World Entertainment a subsidiary of Perfect World Co., Ltd. (NASDAQ: PWRD), publishes free-to-play, online games and provides online services in North America. The Company primarily publishes three-dimensional, or 3D, online games based on the Perfect World proprietary Angelica 3D game engine and game development platform. Perfect World Entertainments goal is to provide North American users with perfectly polished gameplay, exceptional localization, the highest quality customer service, and an unparalleled online community experience.
We are currently searching for a MySQL DBA! Please take a look at the job description and if interested apply to nahr@perfectworld.com
Responsibilities & Job Duties
Data mining from raw log files into relational database, maintenance and tuning of mission-critical MySQL databases
Solid knowledge of scalable schema design principals and provide assistance to development/design teams, and recommend best practices both in code and database design including creation of Stored Procedures and Indexing
Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements
Experience in updating MySQL instances in a high volume environment 100M+ rows
Extensive writing support of scripts in Perl/PHP/Python and/or Shell/Bash
Monitor, optimize and allocate physical data storage for database systems and work with development teams on data sizing based on efficient use of multi-core systems
Manage database backups and ensure disaster recovery and data retention protocols (backup, monitoring, security, installation)
Provide 24/7 support for critical production situations
Requirements
Bachelors Degree in Computer Science/Information Systems
3+ Years DBA experience in development or production capacity
3+ Years experience designing, developing, tuning, optimizing, deploying and updating MySQL instances in a high volume environment with critical 100% uptime requirements
Experience in Replication (Master Master, Master to Slaves
)
MySQL 5.x experience required (InnoDB and MyISAM, and other engines)
Scripting language knowledge of bash/perl/php
3+ years of deep experience with Linux System Administration
Strong analytical skills