Address
SalaryJob title: Sr Database Administrator (MySQL)
Reports to: Manager, Database Administration
Department: Cloud Platforms
Location: Remote
Grade: 19
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, Database Administration.
RESPONSIBILITIES:
- 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.
- Works with database engineering to develop and enforce a security scheme for the database environment.
- Should be proficient in Understanding and Analyzing Database Logs.
- Should be able to work on the OnCall (24*7 support) mechanism.
- 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.
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 IT operation with strong understanding of database structures, theories, principles, and practices.
- Minimum 6 years Microsoft SQL Server or MySQL experience as DBA or Developer.
- Knowledge on Database Architecture and able to understand the need to redesign as per best practices.
- Should be proficient in SQL Query Tuning and Slow Query Optimizations with rewrite in an optimized way.
- Propose and build automated solutions with automation expertise.
- Experience with High Availability (Always On/Log Shipping).
- Experience in Linux and able to manage an on-prim MySQL database environment.
- Expertise in InnoDB cluster and Group Replication in MySQL.
- Experience with data management and data processing flowcharting techniques.
- Deep knowledge and understanding of DB architecture for workload specific configurations.
- Good understanding of the organization’s goals and objectives.
- Good interpersonal, written, and oral communication skills.
- AWS CLI expertise to extract environment & configuration reports and fix anomalies.
- Ability to present ideas in user-friendly language.
- Strong root cause analysis.
- Self-motivated and directed, with keen attention to detail.
- TSQL, Power-shell, CLI and coding expertise.
- Able to prioritize and execute tasks in a high-pressure environment.
- Experience working in a team-oriented, collaborative environment.
- Ability to write, optimize and troubleshoot Stored Procedures, Triggers, Views, Indexed Views, etc.
- Ability to work towards proactive solutions.
- Knowledge of Indexes and Index Management Ability to use Performance Monitor to gather Metrics to define baselines.
- Experience using SQL Profiler and examining Execution Plans SSRS Administration and Configuration.
- Required Technologies SQL Server 2012-2016 / MySQL 5.7 and above and above Database Administration, Tuning, Management, Security SQL Server Integration Services.Willingness to learn at all times.
- Willingness to learn in new technologies.
PREFERRED REQUIREMENTS:
- Involvement with the MSSQL Server Community; MySQL DBA/Developer certification.
- Certification is a plus; MCTS, MCITP, MVP Familiarization with Idera, git, CICD tools.
- Must be ok to work on call 24-7 rotation and Deployment Database Assemblies and CLR Knowledge.
- Experience working with VLDB > 1TB Familiarity with NoSQL.
- Experience with MySQL and/or SingleStore (formerly MemSQL).
- Exposure to AWS – DBA experience on AWS hosted databases would be a plus.
- Understanding of AWS Cloud watch Alerts for RDS Technical interview may include demonstration of technical skills.
Compensation & Benefits:
- Compensation range: $92,000 - $150,000
- Unlimited PTO after year 1 (3 weeks to start)
- Medical, Dental & Vision
- 401k Match
- Education Expense Reimbursement
- Gym Membership Reimbursement
- HSA and FSA
- 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.
