Job Description :
Role: SQL Database Administrator
Location: Grand Rapids, MI
Duration: Full Time
Interview Mode: In Person
Job description
In this role you will work out of our corporate headquarters (Service Center) located in Grand Rapids, Michigan. The NHA Service Center is where all the behind-the-scenes magic happens. Our 400 brilliant team members are brag-worthy. With a diverse group of departments like admissions, talent acquisition, facilities, legal services, and many more working together to provide top level back-office support. The Service Center is a place of bright colors, smiling faces, and opportunity. We like to gather for events such as the fall crocktoberfest cook-off, the sparkling holiday party full of fun and unexplainable excitement, and our annual 5K Service Center fun run.

Your Role
Manage SQL Server database servers through multiple product lifecycle environments, from development to mission-critical production systems
Install, configure, maintain and upgrade database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, backups, security, etc
Troubleshoot SQL Server service outages as they occur, including after-hours and weekend (rare)
Perform scheduled maintenance and support release deployment activities after hours
Monitor SQL Server Alerts, configuration via monitoring tools such as Solarwinds DPA (Database Performance Analyzer), Red Gate SQL Monitor, etc, and act in consultation with the team
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
Develop and maintain automation solutions using Powershell and contribute to process documentation

Requirements
BS degree in Computer Science or related fields, or equivalent years of relevant work experience required
Minimum 5 years of SQL server database administration experience including troubleshooting and performance tuning required
Minimum 3 years in a production support role required
Extensive understanding of administering a Microsoft SQL Server is required
Good understanding of Transact-SQL (T-SQL) is required
Experience with AlwaysOn Availability Groups and Powershell is required
Basic SSRS/SSIS/SSAS administration knowledge is required
Experience with backups, restores and recovery models
Excellent written and verbal communication skills, as well as a flexible and "get-it-done" personality
Must be available for off-hour and on-call work in the event of outages, problems and off-hour required changes
Ability to multi-task and context-switch effectively between different activities and teams
Strong customer service skills and ability to organize and plan work independently
Advanced troubleshooting and problem-solving capabilities


What are the 3-4 non-negotiable requirements on this position?
1. Minimum 5 years of SQL server database administration experience including troubleshooting and performance tuning required 2. Extensive understanding of administering a Microsoft SQL Server is required 3. Experience with AlwaysOn Availability Groups and Powershell is required 4. Experience with backups, restores and recovery models 5. Must be available for off-hour and on-call work in the event of outages, problems and off-hour required changes

What are the nice-to-have skills?
1. Good understanding of Transact-SQL (T-SQL) 2. Basic SSRS/SSIS/SSAS administration knowledge 3. Excellent written and verbal communication skills, as well as a flexible and "get-it-done" personality 4. Ability to multi-task and context-switch effectively between different activities and teams 5. Strong customer service skills and ability to organize and plan work independently 6. Advanced troubleshooting and problem-solving capabilities Please include notes on whether the candidate is legally authorized to work in the United States

What is exciting about this opportunity?
You will work closely with several different teams within the IT department, which gives a good blend of infrastructure, development and operations! There may also be opportunity for remote days once you are up to speed and comfortable in the role. Our IT department is always using the latest and greatest technologies.