Cencora is looking for a passionate, innovative and experienced SQL Server Database Developer V to join our Data Warehouse Team. Support our exciting transformation of data delivery operations to carry ICS into the coming decades of growth. This key role is responsible designing new and efficient data processing methods and refactoring current operations to match new standards. This role will collaborate closely with Business Intelligence, EDI, Account Management many other groups. As a 60/40 split between new development and operational production support, lessons learned from support will provide the insight needed to improve our platform and overall efficiency. If you love a fast-paced and challenging work environment with many future world-wide support opportunities, you may be our ideal candidate.

PRIMARY DUTIES AND 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, cost vs. benefits, and impacts on business processes and goals.

REQUIREMENTS:

SQL Server – T-SQL                                          10+ Years

ETL Design and Implementation                8+ Years

SQL Server Administration                           3+ Years

Data Warehouse Database Design            5+ Years

Transactional Database Design                   3+ Years

One of the following

• PowerShell         4+ Years
• C#                           4+ Years

Nice To Have

3PL Experience is a Major Plus

AS400, RPG Knowledge

Windows Server Administration                4+ Years

Azure

.

Experience & Educational Requirements:

Bachelor’s Degree in Computer Science, Information Technology or any other related discipline or equivalent related experience. 6+ years of directly-related or relevant experience, preferably in application support or system/application/database administration.

Preferred Certifications:

CompTIA Server+

Information Technology Infrastructure Library (ITIL)

Microsoft Certified Solutions Expert

Oracle Linux System Administrator

ServiceNow Certified Systems Administrator

Salesforce Certified Administrator

Microsoft Certified Systems Administrator (MCSA)

Skills & Knowledge:

Behavioral Skills:

Conflict Resolution

Creativity & Innovation

Coaching & Mentoring

Decision Making

Planning

Presentation Skills

Risk-taking

Technical Skills:

Operating Systems

Database Administration

Enterprise Level Information Systems

Incident Management

Internet Protocols

Data Modelling and Data Flow

Network Architecture and Management

Service Level Maintenance

Tools Knowledge:

Microsoft Office Suite

HRIS systems (Time Keeping, Workday, HRMS, & Talent Management)

Enterprise Resource Planning Systems such as SAP

Salesforce, ScriptMed, and MyPathPoint

IndiCare™

Internet Protocols - DNS, DNS, HTTP, LDAP, SMTP, Active Directory, Active Directory federation services, DHCP

Programming and Development Languages - JavaScript, HTML/CSS, Python, SQL

TARxGET™

Ansible, Puppet, and PowerShell

AS/400 Query or Showcase, Visual Basic

SCALE

What Cencora offers

​Benefit offerings outside the US may vary by country and will be aligned to local market practice. The eligibility and effective date may differ for some benefits and for team members covered under collective bargaining agreements.

Affiliated Companies

Equal Employment Opportunity

Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.

The company’s continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory.

Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email hrsc@cencora.com. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned