Production Database Administrator Marketo Inc.
THIS JOB HAS EXPIRED
We are changing the Way Marketing and Sales Collaborate at Every Stage of a Revenue Cycle. Marketo is the fastest growing provider of marketing automation and revenue-building best practices. Marketo provides uncompromising software solutions that help marketing and sales teams to collaborate at every stage of a revenue cycle from the earliest stages of demand generation and lead management to the pursuit of revenue and customer loyalty.
Primary 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.
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.
Requirements
- 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.
Skills/Experience
- 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.
| Location: |
901 Mariners Island Blvd.
Suite 200
San Mateo, CA 94404
United States
|