Overview
Skills
Job Details
Thank you for your possible interest. Please apply for further information.
Term: Salary: Around $95,000 per year neg.
Location: Grand Rapids, MI- Can work remote, but will need to come to Grand Rapids 1-2 times per quarter
Role: MS Database Engineer
Vertical: Education
This person will be a Database Engineer on one of three product teams supporting the platform. Ability to work remote, however, it is preferred that they are located in West Michigan. The team comes together at the Service Center for planning meetings every 10 weeks so candidates must be willing to come on-site during that time.
The Database Engineer will be a part of the Data Services Team within the Technology Services department. This position will report directly to the Manager of Data Services and be part of team of IT Data professionals responsible for development and maintenance of a custom Student Information System.
In this role, you will be working on an agile software development team and developing software products. The Database Engineer is a detail-oriented problem solver as well as a visionary focused on finding ways to improve system architecture and build a solid backbone to the data systems. The mission of the Database Engineer is to work closely with a team of application developers and technical teams to address high-impact problems using thoughtful and informed analysis. This role requires someone with a penchant for improving existing systems and processes where possible. Success in this role is also dependent on being organized and conducting regular communication with cross functional produce team and to deliver great software products.
DUTIES AND RESPONSIBILITIES:
Develop, maintain, and update SQL Server stored procedures, views, SSIS packages, and SSRS reports.
Identify opportunities to make improvements in T-SQL code and implement them.
Design, build, and implement databases to support new software development.
Complete SSRS Report writing, which includes an understanding of the underlying data, data structure and business terminology.
Optimize the reports and underlying stored procedures that take longer to run.
Troubleshooting data issues, validating result sets, performing unit testing.
Help write and optimize in-application SQL statements.
Collaborate with other team members and stakeholders.
QUALIFICATIONS:
3+ years of experience in Microsoft SQL Server environment with primary focus on development.
Very Strong skills in T-SQL development, including query optimization, building and modifying stored procedures, functions, and creating tables and views.
Advanced knowledge of T-SQL, including transactions, (begin..try, merge, common table expressions, ROW_NUMBER/OVER, bulk insert, filtering and covering indexes, computed columns, etc..)
Experience in DevOps area including CI/CD pipelines, powershell, Azure DevOps (ADO), etc... -
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Strong experience in providing ownership, management, design, development and support to OLTP systems.
Ability to navigate and understand large complex database structures for sourcing data.
Experience in Agile development environment.
Strong verbal and written communication skills, with an ability to express complex technical concepts in business terms and complex business concepts in technical terms.
Excellent problem solving and root cause analysis skills.
Excellent written and verbal communication
Flexible, team player, get-it-done personality
Ability to multi-task and context-switch effectively between different activities and teams
Microsoft certifications are a plus
What are the 3-4 non-negotiable requirements of this position?
Minimum of 3 years of experience in Microsoft SQL Server environment
Very strong skills in T-SQL development.
Experience in DevOps area including CI/CD pipelines, PowerShell, Azure DevOps (ADO).
What are the nice-to-have skills?
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Strong experience in providing ownership, management, design, development and support to OLTP systems. Ability to navigate and understand large complex database structures for sourcing data. Experience in Agile development environment.