Requirement of MySQL DBA at MA

Hi Partners,

Please find the requirement below: and send me your consultant's updated resume ASAP.

 

@ krishna.bhatt@idctechnologies.com

 

Position : MySQL DBA

Location : Boston, MA

Duration : 8+ months

 

Descriptions:

Initial assessment of all of client's database infrastructure for configuration, capacity, and best practices. This includes Gamesville (MySQL & Postgres), Registration (MySQL), and WebPub (MySQL).

Updating client's database infrastructure to best practices, configuring monitoring and replication. Conducting a "fire drill" to verify that we have procedures to fail-over in the case of an emergency.

Task list:

·         Upgrade MySQL 5.0 instances to 5.1+ (currently supported by Centos/RedHat)

·         Propose improvements to MySQL replication to reduce downtime during failures and ensure accuracy of data.

·         Implement PostgreSQL replication (or similar)

·         Audit and test database backups, develop an ongoing process.

·         Build and test an emergency failover process.

·         Evaluate use of MyISAM and InnoDB usage and propose usage per property.

·         Check databases for corruption and develop a process to do so on an ongoing basis.

·         Verify that database schemas match between dev, QA, and live environments; split separate QA instances if none present

 

 

 

Thanks & Regards,

Krishna
IDC Technologies Inc.
408-457-9399 * 2002
krishna.bhatt@idctechnologies.com

YM: bhatt_krishna11
IDC Technologies, Inc.,1851 McCarthy Boulevard, Suite 116, Mil pitas, CA , USA, 95035
 "Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail can not be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list."