SQL Server Database Engineer - Macpower Digital Assets Edge Private Limited
Grand Rapids, MI
About the Job
Job Summary:
- 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 a 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 our 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 product teams 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 Please click here to learn more about our core values.
Must Have Skills:
- 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).
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.
Source : Macpower Digital Assets Edge Private Limited