This a Full Remote job, the offer is available from: Michigan (USA)
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.
This offer from "MDA Edge" has been enriched by Jobgether.com and got a 75% flex score.