Database Administrator

Job title: Database Administrator (MySql)

Reports to: Manager, Database Administration

Department: Cloud Platforms

Location: Remote or Alpharetta, GA (Hybrid)

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 and organization, 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 of Database Administration. This position is full-time and offers a hybrid work option.

Responsibilities:

• Reviews service-related reports: (e.g: backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within 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.
• Works with database engineering to develop and enforce a security scheme for the database environment.
• Responsible for deploying database objects like tables, indexes, packages and views across multiple environments.
• Should be proficient in Understanding and Analyzing Database Logs.
• Should be able to work on OnCall (24*7 support) rotation.
• Should be comfortable to work as L1, L2, L3 as and when required.

MINIMUM REQUIREMENTS:

• BE or BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field.
• Preferred 5-10 years as Database Administrator with MySQL related systems and strong understanding of database structures, theories, principles, and practices.
• Knowledge on MySQL Database Architecture and Storage Engines.
• Should be proficient in SQL Query Tuning and Slow Query Optimizations.
• Ability to write, optimize and troubleshoot Stored Procedures, Triggers, Views, Indexed Views, etc.
• Knowledge of Indexes and Index Management Ability to use Performance Monitor to gather Metrics to define baselines ‘
• Understanding of, and experience with, server-client computing and relational database environments.
• Experience with AWS - DBA experience on AWS hosted databases such RDS and/or Aurora for MySQL.
• Experience with AWS services like Cloudwatch and other supported services to optimize RDS/Aurora databases.
• MySQL open source tool kit and Percona tool kit experience.
• Experience deploying, configuring, and managing Innodb Cluster - Group Replication.
• Database migration experience (Cloud migration projects).
• Experience with data management and data processing flowcharting techniques.
• Knowledge of reporting and query tools and practices.
• Able to prioritize and execute tasks in a high-pressure environment.
• Experience working in a team-oriented, collaborative environment.
• Ability to work towards proactive solutions.
• Willingness to learn in new technologies.
• Strong root cause analysis.
• Technical documentation skills.
• Good understanding of the organization’s goals and objectives.
• Good interpersonal, written, and oral communication skills.

*Technical interviews may include demonstration of technical skills.

PREFERRED REQUIREMENTS:

• Experience with Datadog, Splunk, Elastic including APM is a huge plus.
• Experience with other monitoring tools: Idera, MonYog, Red-Gate, Elastic, etc.
• Certification is a plus; MCTS, MCITP, MVP, Oracle (MySQL), Percona, AWS, GCP, Azure Data.
• Experience working with VLDB > 1TB Familiarity with NoSQL.

Experience with Microsoft SQL Server experience (2016 - 2019):

• Experience with High Availability (Always On/Log Shipping)
• Experience using SQL Profiler
• Examining Execution Plans
• SSRS Administration and Configuration
• SSIS

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.