Job description

Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education. Responsibilities & Skills: • Engineers will be required to support database setups in an active-active configuration and optimize database performance. • Extensive knowledge of Stored Procedures. Ability to split SPs into two and migrating the changes from SQL MI to Azure SQL • Minimum of five years of experience in SQL Server performance tuning and optimization • Hands-on familiarity working through complex stored procedures and make necessary changes • At least five years of experience in logical and physical database modeling, designing database schema, stored procedures, triggers, and other database-related objects • Minimum of five years of progressive experience in developing, unit testing, and troubleshooting SQL Server, including SSRS, SSIS, and SSAS (desirable) • Advanced knowledge of T-SQL/Stored Procedure/Function programming and design • Experience with Azure SQL MI and Azure SQL – migration from SQL MI to Azure SQL • Minimum of two years of hands-on experience in Azure Data Factory • Make necessary changes to SSIS packages • Provide alternative options for cross-database calls Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law. Candidate Privacy Policy Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains: • What information we collect during our application and recruitment process and why we collect it; • How we handle that information; and • How to access and update that information. Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.

Requirements