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

• Power Shell 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:
Comp TIA Server+
Information Technology Infrastructure Library (ITIL)
Microsoft Certified Solutions Expert
Oracle Linux System Administrator
Service Now 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, Script Med, and My Path Point
Indi Care™
Internet Protocols - DNS, DNS, HTTP, LDAP, SMTP, Active Directory, Active Directory federation services, DHCP
Programming and Development Languages - Java Script, HTML/CSS, Python, SQL
TARx GET™
Ansible, Puppet, and Power Shell
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.

Full time

Affiliated Companies

Affiliated Companies: Cencora Costa Rica Limitada

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