Senior SQL Server Developer (remote)
About the position Responsibilities • 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 Apply tot his job