- 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
- Ability to demonstrate creative thinking, advanced problem-solving, and troubleshooting
- Experience 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 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
- 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