DBA - MySQL Database Administrator

With PestRoutes in McKinney TX US

More jobs from PestRoutes

Posted on May 19, 2020

About this job

Job type: Full-time
Experience level: Mid-Level
Role: Database Administrator, System Administrator
Industry: Business Process Optmization, Cloud-Based Solutions, SaaS
Company size: 51–200 people
Company type: Private

Technologies

mysql, database, git, innodb, sysadmin

Job description

Field Service Holdings, which includes PestRoutes software and Lobster Marketing, is employee and customer obsessed. Forbes recognized us as one of America's Best Startup Employers 2020. In fact, we ranked number four in the greater Dallas area. Together, we defend one another’s time by maintaining an entrepreneurial spirit. That means we squash the unimportant to make way for the work that brings value to the business. At Field Service Holdings you are well trained, respected, properly compensated and not overworked. The results are our proof. We have capital from world-class investors and can tout a stellar employee Net Promoter Score of 59. That’s a fancy way of saying people come here for a great job and stay because of our great culture. 

We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentation and specifications as required.

Responsibilities

Provision MySQL instances, both in clustered and non-clustered configurations

Ensure performance, security, and availability of databases

Prepare documentation and specifications

Handle common database procedures, such as upgrade, backup, recovery, migration, etc.

Profile server resource usage, optimize and tweak as necessary

Collaborate with other team members and stakeholders

Identify or create tools to detect and remedy data integrity/corruption issues 

Skills and Qualifications

Strong proficiency in MySQL database management

Decent experience with recent versions of MySQL

Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM

Experience with replication configuration in MySQL

Knowledge of de-facto standards and best practices in MySQL

Proficient in writing and optimizing SQL statements

Knowledge of MySQL features, such as its event scheduler

Ability to plan resource requirements from high level specifications

Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

Proficient understanding of code versioning tools such as {{Git / Mercurial / SVN}}

Experience with Redis and Elasticsearch preferred

Experience with database versioning tools such as Flyway

Experience in upgrading MySQL versions

Apply here