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

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.

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