MySQL DBA

Job title: MySQL DBA

Reports to: Manager, Database Administration

Department: Cloud Platforms

Location: Alpharetta, GA or (US Remote)

Grade: 17

Our Company: Priority Technology Holdings, Inc. is a leading financial technology company that specializes in providing integrated payments and banking solutions. Our innovative native platform empowers businesses to effortlessly collect, store, and send money in a scalable manner. We are committed to revolutionizing the way companies handle their financial transactions by offering cutting-edge technology and exceptional customer service.

Job Summary: As a Database Administrator, your primary role involves delivering technical assistance for the database environment, encompassing tasks such as aiding in database development, as well as implementing emerging technologies. Ensuring the utmost reliability and performance of online processing database systems is of paramount importance to our organization. The Database Administrator reports to the Manager, Database Administration.

This position is full-time and remote (Only for candidates in the Alpharetta, GA area: We offer hybrid work arrangements, combining both remote and on-site work).

RESPONSIBILITIES:

Collaborate with a multidisciplinary team, including developers, system administrators, DevOps engineers, and security specialists, to design, implement, and maintain the company’s database infrastructure.

Ensure data quality, accuracy and consistency across data platforms.

Reviews service-related reports

(e.g: database backups, maintenance, monitoring) on a daily basis to ensure service-

related issues are identified and resolved within established SLAs.

Respond to database related alerts and escalations and work with database engineering

to come up with strategic solutions to recurring problems.

Works with database engineering to develop ongoing assessments of database

performance and identify problem areas.

Should be comfortable to work as L1, L2, L3 as and when required.

Responsible for deploying database objects like tables, indexes, packages and views

across multiple environments.

Participate in the company's on-call rotation.

MINIMUM REQUIREMENTS:

5-10 years on IT operation with strong understanding of database structures, theories, principles, and practices.

5+ years of hands-on experience with MySQL Server (5.7, 8.0.X), Percona Server, and/or MariaDB.

3+ years of experience managing databases on AWS RDS and/or Aurora for MySQL.

Knowledge on Database Architecture and common Storage Engines used in MySQL.

Should be proficient in SQL Query Tuning and Slow Query Optimizations on MySQL based systems.

Should be proficient in Understanding and Analyzing Database and Server Logs.

Experience with MySQL replication on complex multi source/replica topologies.

Ability to write, optimize and troubleshoot Stored Procedures, Triggers, Views, etc.

Knowledge of Indexes and Index Management. Ability to use Performance Monitoring tools to gather metrics to define baselines.

Understanding of, and experience with, server-client computing and relational database environments.

Good understanding of the organization’s goals and objectives.

Good interpersonal, written, and oral communication skills.

Technical documentation skills.

Ability to present ideas in user-friendly language.

Strong root cause analysis.

Self-motivated and directed, with keen attention to detail.

Able to prioritize and execute tasks in a high-pressure environment.

Experience working in a team-oriented, collaborative environment.

Willingness to learn in new technologies.

PREFERRED REQUIREMENTS:

Experience working with InnoDB cluster and MySQL router.

Experience with MSSQL Server.

Knowledge of monitoring tools (DataDog, PMM, CloudWatch, Elastic).

Experience working with VLDB > 1TB.

Familiarity with NoSQL.

Experience with Atlassian tools (Jira, Confluence).

Certification is a plus.

Compensation and Benefits:

Compensation range: $73k - $110k

End of Year Discretionary Bonus

Unlimited PTO after year 1 (3 weeks to start)

Medical, Dental & Vision

401k Match

Education Expense Reimbursement

Gym Membership Reimbursement

HSA and FSA for U.S.-based employee

Employee assistance program (EAP)

Traditional Physical Requirements

Requires prolonged sitting, standing, bending, stooping and stretching.

Requires the ability to lift 10 pounds.

Requires eye-hand coordination, manual dexterity and a normal range of hearing and vision (with or without correction).

Join our team at Priority Technology Holdings, Inc. and be part of a dynamic and innovative company that is transforming the financial technology landscape. Together, we can shape the future of payments and banking solutions while providing unmatched value to our clients.