Collaborate with stakeholders from across the organization to set priorities and drive toward implementation
Ensure database systems meet all requirements of performance, availability, scalability, quality, and security to produce world class products
Delivering high-quality work-products; champion quality standards, performance, and scalability
Research innovative technologies and stay ahead of the industry
Design and implement resilient and performant database processes and solutions
Develop custom stored procedures, views, or user-defined functions
Collaborate with cross-functional teams
Debug and tune/optimize SQL code either directly or indirectly from the application
Support Tier2 development team with database requests as needed (including bug fixes, production data manipulation and feature testing)
On-call duty may be required, responding to critical DB alerts, and escalating if needed

Requirements

Minimum of 7+ years of experience in administering MySQL, MariaDB, and PostgreSQL
Support and encourage data engineering practices supporting a multi-source data ecosystem
Extensive knowledge of Pgpool-II for query load balancing, failover management, and connection routing between primary and standby nodes
Automate database deployment and maintenance tasks using shell scripts and infrastructure automation tools
Develop operational runbooks for replication setup, failover recovery and pooler troubleshooting
Intrinsic self-starter and problem solver
Experience with performance tuning and a broad knowledge base of indexing strategies, In-Memory OLTP technologies, and best practice SQL standards
Hands on experience with replication, performance tuning and maintenance plans
Hands on experience building processes for OLTP and OLAP processing
Ability to collaborate with SQL developers and solve problems
Experience working in a microservice architecture with separate data sources per microservice
Familiarity with one or more industry standard source control solutions (Git preferred - experience with DACPAC a plus)
Agile experience
Excellent communication skills
Desire to work in a fast paced, evolving, growing, and dynamic environment
Bachelors in computer science, Engineering, Information Technology, other relevant degree, or comparable work experience

Benefits

Flexible paid time off, giving you the opportunity to rest, relax and recharge away from work
14 Paid Company Holidays, includes 2 floating holidays (you choose!)
A comprehensive benefits plan including medical, dental, life, vision, disability, and life insurance covered up to 100% by Payscale
Unlimited infertility coverage benefits through our medical plans
Additional supplemental health benefits offered to you and your family
401(k) retirement program with a fully vested immediate company match
16 weeks of paid parental leave for birthing and non-birthing parents
Health Savings Account (HSA) options and company contributions each pay period
Flexible Spending Account (FSA) options for pre-tax employee allocations
Annual remote work stipend to be used on wellness or home office equipment

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

MySQLMariaDBPostgreSQLPgpool-IISQLshell scriptingOLTPOLAPperformance tuningindexing strategies

Soft Skills

collaborationproblem solvingself-startercommunicationadaptabilityquality standardsinnovationteam supportprioritizationchampioning

Certifications

Bachelor's in Computer ScienceBachelor's in EngineeringBachelor's in Information Technology