DBA at PestRoutes.com

PestRoutes.com; McKinney (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Field Service Holdings, LLC is seeking an experienced MySQL database administrator to ensure performance, availability, and security of clusters of MySQL instances. You will provision instances, monitor resources, and collaborate with the team on migrations, backups, and data integrity.

Responsibilities include documenting specifications, upgrading MySQL versions, and optimizing SQL. Experience with Redis/Elasticsearch and Flyway is preferred.

Qualifications

• Strong proficiency in MySQL database management.
• Decent experience with recent versions of MySQL.
• Understanding of MySQL storage engines (InnoDB, MyISAM).
• Experience with replication configuration in MySQL.
• Knowledge of best practices in MySQL.
• Proficient in writing and optimizing SQL statements.
• Knowledge of MySQL features like event scheduler.
• Ability to plan resource requirements from high level specs.
• Knowledge of limitations and workarounds vs. other relational databases.
• Proficient with Git/Mercurial/SVN.
• Experience with Redis and Elasticsearch is preferred.
• Experience with Flyway for DB versioning.
• Experience in upgrading MySQL versions.

Responsibilities

• Provision MySQL instances, clustered and non-clustered configurations.
• Ensure performance, security, and availability of databases.
• Prepare documentation and specifications.
• Handle upgrades, backups, recoveries, migrations.
• Profile server resource usage and optimize.
• Collaborate with team members and stakeholders.
• Identify or create tools to detect data integrity issues.

Skills

MySQL administration

MySQL replication

InnoDB / MyISAM

SQL optimization

Git / Mercurial / SVN

Redis

Elasticsearch

Flyway

MySQL upgrades

Tools

Flyway

Job description

Company 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.

Job Description

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.

• 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

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

Additional Information

Disclaimer: This Job Description indicates the general nature and level of work expected of the incumbent(s). It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent(s) may be asked to perform other duties in addition to those described above.

Field Service Holdings, LLC,is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of any status or condition protected by applicable federal, state, or local municipal law.