ABOUT THIS POSITIONIn this role, the Specialist DBA will provide SQL Server administration, design, and development support in our diverse, fast-paced, & growing environment. The Specialist DBA will also analyze system performance, database performance, system health checks, and collaborate with Application Engineering teams to tune new and existing database access interfaces. This role provides plenty of opportunity for personal growth and development, while interacting with a positive, open team that is supportive of continued knowledge sharing and team advancement.WHAT YOU'LL DO
Performs system and application monitoring and alerting related to the SQL Server environment
Works with the Application Engineering teams in maintaining stored procedures, indexes, etc.
Automates Systems Management tasks
Conducts Performance Analysis and tuning, specifically in a .NET/MS SQL environment
Operationalizes new technologies introduced into the environment
Works with the Business Product Owners to identify priorities for Application Development and enhancements; acquires resources for projects to fit the current and future needs of the Business
Participates in an on-call response rotation (24x7 environment)
Additional duties as assigned
WHAT YOU'LL NEED
Ability to demonstrate creative thinking, advanced problem-solving, and troubleshooting
Experience administering MS SQL Server (versions 2012 through 2022)
Knowledge of High Availability solutions, such as Mirroring, Replication, Clustering, & Always On (Availability Groups)
Understanding of database security users and roles
Basic performance monitoring and analysis of SQL queries
Strong teamwork, interpersonal skills, integrity, and personal responsibility
Eager to learn new technologies & take personal responsibility/ownership for technical projects
Ability to review data scripts and communicate feedback to teams
Can effectively write performant SQL queries
Understanding of data recovery techniques from backup/restore
Can effectively monitor real-time transaction processing and identify issues
Experience with clustered database setup
Thorough understanding of database replication techniques, including Always On
Can effectively communicate and guide Application Engineering teams in SQL development
Bachelor’s degree in related field or equivalent work experience
Preferred Skills:
4+ years’ experience is preferred
3+ years’ experience in query optimization and performance tuning, using SQL Profiler and other troubleshooting tools, such as the SolarWinds Data Performance Analyzer
Permissions/User Management experience is highly preferred
Experience with Microsoft Azure, SSIS, SSAS, or PowerShell
ABOUT WAYSTARThrough a smart platform and better experience, Waystar helps providers simplify healthcare payments and yield powerful results throughout the complete revenue cycle.Waystar’s healthcare payments platform combines innovative, cloud-based technology, robust data, and unparalleled client support to streamline workflows and improve financials so providers can focus on what matters most: their patients and communities. Waystar is trusted by 1M+ providers, 1K+ hospitals and health systems, and is connected to over 5K commercial and Medicaid/Medicare payers. We are deeply committed to living out our organizational values: honesty; kindness; passion; curiosity; fanatical focus; best work, always; making it happen; and joyful, optimistic & fun.Waystar products have won multiple Best in KLAS® or Category Leader awards since 2010 and earned multiple #1 rankings from Black Book™ surveys since 2012. The Waystar platform supports more than 500,000 providers, 1,000 health systems and hospitals, and 5,000 payers and health plans. For more information, visit waystar.com or follow @Waystar (https://twitter.com/Waystar) on Twitter.WAYSTAR PERKS
Competitive total rewards (base salary + bonus, if applicable)
Customizable benefits package (3 medical plans with Health Saving Account company match)
Generous paid time off starting at 3 weeks + 13 paid holidays including 2 personal floating holidays
Paid parental leave (including maternity + paternity leave)
Education assistance opportunities and free LinkedIn Learning access
Free mental health and family planning programs, including adoption assistance and fertility support
401(K) program with company match
Pet insurance
Employee resource groups
Waystar is proud to be an equal opportunity workplace. We celebrate, value, and support diversity and inclusion. Qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, marital status, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.Job Category: Technology/EngineeringJob Type: Full timeReq ID: R2295