SQL Server Database Engineer

Macpower Digital Assets Edge LLC

Grand Rapids, MI

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Agile Programming Methodologies, Analysis Skills, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Data Management, Data Structures, Database Programming, Detail Oriented, DevOps, Identify Issues, Information Technology & Information Systems, Microsoft ADO (ActiveX Data Object), Microsoft Certifications, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Multitasking, Organizational Skills, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Procedure Development, Process Improvement, Product Development, Query Optimization, Reporting Skills, Root Cause Analysis, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Software Administration, Software Development, Stored Procedures, System Architecture, Team Player, Test Plan/Schedule, Testing, Transaction Processing/Management, Unit Test, Windows PowerShell, Writing Skills
LOCATION
Grand Rapids, MI
POSTED
30+ days ago
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.

About the Company

M

Macpower Digital Assets Edge LLC