Full-Time Production Database (MySQL) Administrator
NOTE: This job listing has expired and may no longer be relevant!
Job Description
Responsibilities:
The ideal candidate will be capable of database performance analysis, system level analysis and query performance optimization. Understand database performance characteristic based on workload from the front-end application servers. Identify and remediate bottlenecks in database performance.
Candidates will have worked in a SaaS Operations environment where site stability, uptime, health monitoring and diagnostics are paramount to success. In this role you will configure, manage and maintain multiple MySQL servers and databases using InnoDB & MyISAM storage engines. Focus on performance optimization at schema level, service level, OS level, hardware level.
Candidates must have experience in database design, data modeling, and data architect in OLTP and data warehousing, preferably in a SaaS model/environment. The role will be responsible for the development, test, rollout, and support of our database system. You will work as an integral part of our database team to not only streamline and optimize current infrastructure but help design future iterations with emphasis on optimization, scalability, security and redundancy.
Candidate must also ensure the appropriate best practices are followed for monitoring, back-up, restoration and upgrades of database servers. Create processes to ensure the data quality of the information by identifying potential data errors.
Work with the development team to analyzes requirements and produces optimal database schema. Understands complex replication setup and manages data partitioning across multiple clusters/data centers. Works with application development team to successfully implement new or modify existing features.
Creation of scripts and tools used to monitor overall database health. Development of ad hoc and customized reports.
Additional Responsibilities:
Work with the architecture team and engineering team to oversee the design of critical areas of the application data model throughout the entire SDLC lifecycle. Provide support and mentorship to engineers in all aspects of logical database design, creating and tuning queries, etc. Work with Network Operations, the architecture team, the application performance team, and the engineering team to identify and correct performance and scalability problems in development, staging, and production databases. Perform database infrastructure design, refactoring, data validation, application updates, and troubleshooting as required. Review and recommend and enforce database best practices and standards for engineering team. Lead and participate in database design reviews. Review and recommend emerging database and web technologies. Assist in the mentoring and coaching of less senior level database team members. Actively gather statistics from production databases to increase efficiency, improve reliability, and minimize operating expenses.
Understands scale, efficiency, and stability of data constraints in the manipulation of large amounts of data. Focus on scaling horizontally rather than vertically with a thorough understanding of the various ways to use MySQL in a constant uptime/high availability environment. Production experience with clustered, shared, or replicated database configurations required. This experience must include replication to geographically distributed datacenters (CO-Locations, etc) along with failover planning.
Required Skills/ Experience:
- BS Computer Science or equivalent
- 7+ years of extensive MySQL database experience – with large data (1TB+) and MySQL performance tuning
- 5+ years experience with UNIX/Linux
- Excellent verbal/written communication skills.
- Excellent analytical/organizational skills in concert with superb decision making skills.
- Hands-on experience with Apache/Tomcat
- Experience with PHP applications is a bonus
- Experience in developing SaaS based systems
- Hands-on experience with source control & release management systems such as CVS or Subversion
- Experience with OLAP, ETL, BI Reporting, MDX and Report tuning applications
- Ability to apply mathematic skills for analysis of data, programming logic and implement mathematic functions as needed.
- Expert knowledge of at least one other database platform such as Oracle is a must and strong working knowledge of Red Hat Linux.
About Marketo
Marketo is the global leader in Revenue Performance Management. Marketo’s powerful yet easy-to-use marketing automation and sales effectiveness solutions transform how marketing and sales teams of all sizes work — and work together — to drive dramatically increased revenue performance and fuel business growth. The company’s proven technology, comprehensive services, and expert guidance are helping corporations around the world to turn marketing from a cost center to a business-building revenue driver.
Marketo is an Equal Opportunity Employer
How to Apply
SELECT you new job online now and we'll contact you as soon as possible.
94 total views, 1 today