What are the responsibilities and job description for the SQL Server Database Engineer position at MDA Edge?
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.
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.
Database Specialist
Degage Ministries - Hiring Heros Like YOU! -
Grand Rapids, MI
Server
Red Lobster -
Kentwood, MI
Server
PF Changs -
Grand Rapids, MI
