DBA

Posted 14 Hours Ago
Be an Early Applicant
McKinney, TX, USA
In-Office
Entry level
Information Technology • Mobile • Software
The Role
Administer MySQL database instances and clusters, ensuring performance, availability, security, replication, and data integrity. Provision databases, manage upgrades, backups, recovery, and migrations, optimize resource usage and SQL queries, and develop tools to detect corruption. Collaborate with technical teams and stakeholders while preparing documentation and specifications.
Summary Generated by Built In
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. 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.

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

Skills Required

  • Strong proficiency in MySQL database management
  • Experience with recent versions of MySQL
  • Understanding of MySQL storage engines, including InnoDB and MyISAM
  • Experience configuring MySQL replication
  • Knowledge of MySQL standards and best practices
  • Proficiency writing and optimizing SQL statements
  • Knowledge of MySQL features, including the event scheduler
  • Ability to plan resource requirements from high-level specifications
  • Knowledge of MySQL limitations and workarounds compared with other relational databases
  • Proficiency with code versioning tools such as Git, Mercurial, or SVN
  • Experience with Redis and Elasticsearch
  • Experience with database versioning tools such as Flyway
  • Experience upgrading MySQL versions
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
186 Employees
Year Founded: 2012

What We Do

PestRoutes is a McKinney, Texas-based software company serving pest-control businesses and service providers. Its technology supports field-service operations through business operations tools, marketing automation, and fleet-management capabilities intended to help companies grow while making teams safer and more productive. Launched in 2012, PestRoutes expanded its leadership team and workforce into a rapidly growing organization with more than 100 employees overall.

Similar Jobs

In-Office or Remote
2 Locations
5173 Employees

Byrd's House Detective DBA BHD Home and Mold Inspections Logo Byrd's House Detective DBA BHD Home and Mold Inspections

Help Desk Specialist

Agency • Logistics • Real Estate • Virtual Reality • Consulting • Hospitality • Data Privacy
Remote or Hybrid
United States
100 Employees
35-45 Annually

Apex Fintech Solutions Logo Apex Fintech Solutions

Senior Database Administrator

Fintech • Software • Financial Services
Hybrid
Austin, TX, USA
1000 Employees

Radarchaos Logo Radarchaos

Database Administrator

3D Printing • Aerospace • Agency • Angel or VC Firm • Analytics • Agriculture • 3PL: Third Party Logistics
Remote or Hybrid
United States
11 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account