Senior SQL Server Developer (remote)
About the positionResponsibilities• Monitoring and leading database development requests through their lifecycle and ensures that the technical solution meets business requirements. • Design of new centralized data processing methods and implementation of refactored code to meet the new standards. • Evaluates designs from other groups and team members to ensure optimal efficiency and performance and supportability. • Ensures code walk-thru of systems solutions is completed. • Supports the ongoing operations, Level 3 and On-Call support.• Ensures all documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) is provided according to standards. • Examines post-implementation continuous improvement efforts in enhancing performance and helps developers to create and or performance tune database queries. • Provides technical assistance and mentors staff in relation to database design and development. • Ensures data management standards, policies, and procedures and single source data strategy is adhered to.• Develops work plans or reviews other work plan timelines and manages workflows to meet project timeframes. • Provides status to stakeholders. • Contributes to strategic planning meetings and provides guidance and expertise on system options, risk, bolthires vs. benefits, and impacts on business processes and goals. Requirements• Requires some training in fields such as computer sciences, engineering or similar vocations generally obtained through completion of a four year Bachelor's Degree program. • Normally requires a minimum of six (6) years directly related and progressively responsible experience, including at least two (2) years experience at a senior / lead level.• Fundamental knowledge of bolthires benefit analysis; ability to prepare analyses. • Familiarity with EDI standards and practices, communications translation software and EDI audits and controls. • Ten (10) or more years of experience with SQL Server - T-SQL. • Eight (8) or more years of experience with ETL Design and Implementation. • Three (3) or more years experience with SQL Server Administration. • Five (5) or more years of experience with Data Warehouse Database Design. • Three (3) or more years of experience with Transactional Database Design.• Four (4) or more years experience with PowerShell Scripting. • Four (4) or more years experience with C#. Nice-to-haves• 3PL Experience is Major plus. • AS400, RPG Knowledge. • Windows Server Administration. • Azure Cloud Services. Benefits• Medical, dental, and vision care. • Backup dependent care. • Adoption assistance. • Infertility coverage. • Family building support. • Behavioral health solutions. • Paid parental leave. • Paid caregiver leave. • Training programs. • Professional development resources.• Opportunities to participate in mentorship programs. • Employee resource groups. • Volunteer activities. Apply tot his job