Sr. Specialist SQL DBA

Company: Waystar
Location: Louisville
Posted on: May 27, 2023

Job Description:

In 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 be doing:Performs system and application monitoring and alerting related to the SQL Server environmentWorks with the Application Engineering teams in maintaining stored procedures, indexes, etc.Automates Systems Management tasksConducts Performance Analysis and tuning, specifically in a .NET/MS SQL environmentOperationalizes new technologies introduced into the environmentWorks 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 BusinessParticipates in an on-call response rotation (24x7 environment)Additional duties as assignedWhat we''re looking for:Ability to demonstrate creative thinking, advanced problem-solving, and troubleshootingExperience administering MS SQL Server (versions 2008, 2012, 2014, & 2016)Knowledge of High Availability solutions, such as Mirroring, Replication, Clustering, & Always On (Availability Groups)Understanding of database security users and rolesBasic performance monitoring and analysis of SQL queriesStrong teamwork, interpersonal skills, integrity, and personal responsibilityEager to learn new technologies & take personal responsibility/ownership for technical projectsAbility to review data scripts and communicate feedback to teamsCan effectively write performant SQL queriesUnderstanding of data recovery techniques from backup/restoreCan effectively monitor real-time transaction processing and identify issuesExperience with clustered database setupThorough understanding of database replication techniques, including Always OnCan effectively communicate and guide Application Engineering teams in SQL developmentBachelor''s degree in related field or equivalent work experiencePreferred Skills: 4+ years'' experience is preferred3+ years'' experience in query optimization and performance tuning, using SQL Profiler and other troubleshooting tools, such as the SolarWinds Data Performance AnalyzerPermissions/User Management experience is highly preferredExperience with Microsoft Azure, SSIS, SSAS, or PowerShellWaystar provides cloud-based technology that simplifies and unifies healthcare payments. Together, our technology, data and client support streamline workflows and improve financials for our clients, so that they can focus on their patients. 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 and fun. Waystar products have won Best in KLAS or Category Leader every year 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 or follow @Waystar on Twitter.

Keywords: Waystar, Louisville , Sr. Specialist SQL DBA, IT / Software / Systems , Louisville, Kentucky