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:
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 we'll-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, eg 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