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!
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.
PRIMARY DUTIES AND RESPONSIBILITIES:
• Minimum 4+ year of experience required.
• 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. 4+ 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
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.
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