Job Description

Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today!

Job Details

===============

Cencora is looking for a Mid-Level SQL Server Database Developer to join our Data Warehouse Team in our 3rd Party Logistics Division. Working closely with the Data Warehouse, Business Intelligence, EDI and Account Management teams; lessons learned from this activity will provide a foundation for growth for your career goals and exciting opportunities to take our operations farther with exciting technologies and methods. If you love a fast-paced and challenging work environment with many future world-wide support opportunities, you may be our ideal candidate.


Shift : 02:00 PM to 11:00 PM IST


PRIMARY DUTIES AND RESPONSIBILITIES:

Build out new code management, release, and control procedures Troubleshoot SSIS package & SQL job failures Setup new inbound and outbound file processing requests Possess strong data analysis skills and an investigative mindset to troubleshoot and resolve issues by analyzing data and examining code in depth Be highly skilled in debugging and understanding existing code bases in T-SQL to connect the dots and resolve complex issues Develop centralized performance and security monitoring methods Design and implement High Availability and Disaster Recovery Solutions Hands-on experience in Microsoft SQL Server installation, configuration, performance tuning, maintenance, and Database Administration on Production Servers Maintain backup & recovery plans Participate in on-call rotation schedule Perform multiple Windows Server and SQL upgrades/migrations Work with supporting vendors, database owners, infrastructure teams Work with Windows environment for better SQL server compliance Contribute to new cloud platform choices Be well-organized and focused with good communication skills

REQUIREMENTS:

6+ years - SQL Server - T-SQL

4+ years - SSIS Development and support

4+ years - SQL Server Administration

4+ years - Windows Server Administration

4+ years - Data Warehouse Environment


One of the following

PowerShell 3+ Years C# 3+ Years
Nice To Have:

3rd Party Logistics Experience is a Major Plus

PowerShell

AS400, RPG Knowledge

Windows Server Administration

Azure


.


Experience & Educational Requirements:

Bachelor's Degree in Computer Science, Information Technology or any other related discipline or equivalent related experience. 2+ years of directly-related or relevant experience, preferably in software designing and development.



Preferred Certifications:

Android Development Certification

Microsoft Asp.Net Certification

Microsoft Certified Engineer

Application/Infrastructure/Enterprise Architect Training and Certification, e.g. TOGAF

Certified Scrum Master

SAFe Agile Certification

DevOps Certifications like AWS Certified DevOps Engineer



Skills & Knowledge:

Behavioral Skills:

Critical Thinking

Detail Oriented

Interpersonal Communication

Learning Agility

Problem Solving

Time Management



Technical Skills:

API Design

Cloud Computing Methodologies

Integration Testing & Validation

Programming/Coding

Database Management

Software Development Life Cycle (SDLC)

Technical Documentation

Web Application Infrastructure

Web Development Frameworks



Tools Knowledge:

Cloud Computing Tools like AWS, Azure, Google cloud

Container Management and Orchestration Tools

Big Data Frameworks like Hadoop

Java Frameworks like JDBC, Spring, ORM Solutions, JPA, JEE, JMS, Gradle, Object Oriented Design

Microsoft Office Suite

NoSQL Database Platforms like MongoDB, BigTable, Redis, RavenDB Cassandra, HBase, Neo4j, and CouchDB

Programming Languages like JavaScript, HTML/CSS, Python, SQL

Operating Systems & Servers like Windows, Linux, Citrix, IBM, Oracle, SQL

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 BUSINESS SERVICES INDIA PRIVATE LIMITED

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