Job Description
MySQL DBA experience know DB architecture, DBA activities (monitoring, backup and recovery, excellent DBA), PHP, thread management, VERY strong SQL.
The ideal candidate for this role will have specific expertise in building, managing, and scaling MySQL database platforms for high volume online service businesses. This role will be responsible for ensuring the database platforms used across all infrastructures operate optimally to sustain or exceed our service level agreements and application response times. As the performance of the database is critical to the response time of the application, and the service is business critical to every single one of its customers, this role is critical to the success of the business itself. You will make a major difference in how the service scales and sustains data recovery capabilities. Your career will grow with the business which is growing.
The DBA should have significant background and expertise in system administration for Linux and open source environments, and be fluent in best practices in designing optimal system and storage architectures.
- Must have a strong background in design, development and implementation with Relational Database Management Systems experience.
- 7-10 years supporting database platforms for online service businesses
- Experience with PostgresSQL and MongoDB strongly preferred
- Experience with MS SQL Server 2005/2008 a plus
- Experience migrating existing application schema to MongoDB a plus
- Have experience in both OLTP and OLAP design methodologies
- Be able to determine when an RDBMS or a NoSQL solution is the right fit
- Drive best practices in monitoring MySQL databases with the ability to identify key performance indicators and put facilities in place to alarm on-call personnel for actionable events
- Expertise in various MySQL replication technologies including when to use one method over another, limitations, and alternatives
- Fluency in horizontally scaling database infrastructures and identifying the most appropriate factors from which to split against based on application design and supported use cases
Experience in designing and managing MySQL clustering is preferred
Additional InformationIf interested . please revert your feedback to Venkat at tekwissen dot com with an updated resume and Visa status in US.
Skills Required
- Strong background in design, development and implementation with Relational Database Management Systems
- 7-10 years supporting database platforms for online service businesses
- Very strong SQL skills
- MySQL architecture expertise including replication technologies and clustering
- System administration experience for Linux and open source environments
- DBA activities: monitoring, backup and recovery
- Experience with PHP and thread management
- Experience with PostgresSQL and MongoDB
- Experience with MS SQL Server 2005/2008
- Experience migrating existing application schema to MongoDB
- Experience in both OLTP and OLAP design methodologies
- Ability to determine when RDBMS or NoSQL is the right fit
- Experience designing and managing MySQL clustering
What We Do
STEM Xpert is a consulting engineering firm recognized in the engineering industry for its commitment to client service and passion for excellence. The firm provides specialized professional consulting services in the fields of science, technology, engineering, and mathematics (STEM).
