SQL Server Database Engineer

2 weeks ago

Grand Rapids, MI, United States Macpower Digital Assets Edge Full time
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.

  • Senior Database Developer

    5 hours ago

    Grand Rapids, MI, United States Syms Strategic Group, LLC (SSG) Full time

    Syms Strategic Group (SSG)  is seeking a talented Senior Database Developer Location: Remote Department: Veterans Affairs Type:  Full Time Min. Experience:  Experienced Security Clearance Level:  Public Trust (MBI)  Military Veterans are highly encouraged to apply! Essential Duties and Responsibilities Establish database management systems,...

  • Lead .NET Software Engineer

    4 days ago

    Grand Rapids, MI, United States The Pivot Group Full time

    Job Description: Does the idea of leading change in technology strategy, architecture, and team mentorship within a critical business function excite you? We are seeking an accomplished and visionary Lead .NET Software Engineer to guide our development efforts for a leading manufacturer of horticultural labels. This strategic role involves setting technical...

  • Lead .NET Software Engineer

    2 weeks ago

    Grand Rapids, MI, United States The Pivot Group Full time

    Job Description: Does the idea of leading change in technology strategy, architecture, and team mentorship within a critical business function excite you? We are seeking an accomplished and visionary Lead .NET Software Engineer to guide our development efforts for a leading manufacturer of horticultural labels. This strategic role involves setting technical...

  • Lead .NET Software Engineer

    2 weeks ago

    Grand Rapids, MI, United States The Pivot Group Full time

    Job Description: Does the idea of leading change in technology strategy, architecture, and team mentorship within a critical business function excite you? We are seeking an accomplished and visionary Lead .NET Software Engineer to guide our development efforts for a leading manufacturer of horticultural labels. This strategic role involves setting technical...

  • Oracle Database Administrator

    7 days ago

    Grand Rapids, MI, United States TGW Logistics Group Full time

    SUMMARY The Database Administrator will contribute to a team effort in all aspects of database engineering including design, development, testing, deployment, analysis, and support. The role will be responsible for administration, performance tuning, optimization, and disaster recovery. In addition, support the teams with deploying new projects and...

  • Allied Electronics Developer

    1 hour ago

    Grand Rapids, MI, United States Kaav Inc. Full time

    We are seeking a Allied Electronics Developer with a strong passion for building great software to join our growing Engineering team. You will be working in an Agile SAFe environment so a commitment to collaborative teamwork is essential. Required Skills - Allied Electronics fuel controller point of sale Job Duties -RESPONSIBILITIES Integration of Allied...

  • Senior .Net Developer

    2 weeks ago

    Grand Rapids, MI, United States The Pivot Group Full time

    Job Description: Eager to make an impact in the world of web development, driving innovation and efficiency? We are searching for a talented and experienced Senior Web Developer (.NET) to join our team at a prominent manufacturer of horticultural labels. This role offers a unique opportunity to build and enhance mission-critical web applications that...

  • Senior .Net Developer

    2 weeks ago

    Grand Rapids, MI, United States The Pivot Group Full time

    Job Description: Eager to make an impact in the world of web development, driving innovation and efficiency? We are searching for a talented and experienced Senior Web Developer (.NET) to join our team at a prominent manufacturer of horticultural labels. This role offers a unique opportunity to build and enhance mission-critical web applications that...

  • Professional Software Engineer

    2 days ago

    Grand Rapids, MI, United States Dematic Full time

    What We Offer: Career Development Competitive Compensation and Benefits Pay Transparency Global Opportunities Learn More Here: https://www.dematic.com/en-us/about/careers/what-we-offer/ Dematic provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to...

  • Professional Software Engineer

    1 hour ago

    Grand Rapids, MI, United States Dematic Full time

    What We Offer: Career Development Competitive Compensation and Benefits Pay Transparency Global Opportunities Learn More Here: https://www.dematic.com/en-us/about/careers/what-we-offer/ Dematic provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to...