Developer III - Database

Cencora Limited - Conshohocken, PA

Full-time - Mid Level

Remote - Conshohocken, PA

About the position

The position at Cencora involves designing, developing, administering, optimizing, and managing database applications using SQL Server TSQL. The role requires collaboration with analysts and users to gather business requirements for financial and healthcare systems, including large data warehouses. The successful candidate will also be responsible for code reviews, performance analysis, and supporting code deployment and automation within the data analytics division.

Responsibilities

• Design, develop, administer, optimize, and manage database applications using SQL Server TSQL.
• Gather and interpret business requirements for financial and healthcare systems.
• Consult with the business to determine logical design for new business solutions.
• Perform code reviews and analyze execution plans.
• Re-factor inefficient code and ensure optimal performance settings.
• Configure, integrate, and support code deployment and automation.
• Participate in daily status calls and troubleshoot production-level issues.
• Monitor inbox and address automation requests or issues.

Requirements

• Bachelor's degree in Computer Science, Electronics Engineering, Telecommunications Systems Management, or related field.
• 4 years of experience utilizing TSQL for management and optimization of SQL Server data platforms.
• Experience with SQL Server Administration, including jobs, backup, security management, and performance settings.
• Experience configuring, supporting, and managing ETL automation with SQL Server Integration Services.
• 2 years of experience utilizing Powershell for automation or management of DevOps/Cloud platforms.

Nice-to-haves

• Experience with Reporting Services for configuration and management.
• Familiarity with Azure Data Factory and DevOps Pipeline.
• Knowledge of SAS and Dimensional Insights.

Benefits

• Medical, dental, and vision care.
• Backup dependent care support.
• Adoption assistance and infertility coverage.
• Family building support and behavioral health solutions.
• Paid parental leave and paid caregiver leave.
• Training programs and professional development resources.
• Opportunities for mentorship and volunteer activities.