Database Developer

$63,500 - $73,500/Yr

Kph Healthcare Services - East Syracuse, NY

Full-time - Mid Level

East Syracuse, NY

Health and Personal Care Retailers

About the position

The Database Developer position at KPH Healthcare Services is a hands-on role focused on the development and maintenance of ProAct database systems. The successful candidate will work within a dynamic SQL Development team, responsible for designing and developing database infrastructure and comprehensive ETL solutions to support core business processes, ensuring high levels of data accuracy and availability.

Responsibilities

• Develop and maintain SSIS packages to support data integration between different systems.
• Collaborate with business analysts and stakeholders to gather requirements and design data integration solutions.
• Design and develop ETL processes to extract, transform, and load data from various sources into the data warehouse.
• Troubleshoot and resolve technical issues related to SSA Jobs, SSIS packages, file integrations, and stored procedures.
• Provide early morning production support availability on a rotational basis (EST).
• Utilize Azure DevOps for Development and adhere to coding standards as outlined in Development Team SOPs.
• Perform code reviews to ensure the quality and consistency of code developed by the team.
• Communicate task/project progress and status changes utilizing Proact's CRM ticketing system.
• Develop and maintain documentation related to SSIS packages, processes, and procedures.
• Work with multiple teams to develop QA processes and alerting for core business functions.
• Stay up to date with the latest SSIS features and functionality and provide recommendations for process improvements.
• Work closely with other developers, database administrators, and business teams to ensure the smooth integration of SSIS packages and stored procedures into the overall technology stack.
• Support file-transfer process management/remediation processes, as needed.

Requirements

• Bachelor of Science in Computer Science or related field preferred.
• Minimum of 2-4 years of experience in Database Development for Level II position.
• Minimum of 4-6 years in Database Development and SQL Server DBA related task exposure for Level III position.
• Strong understanding of ETL processes and data warehousing concepts.
• Experience with performance tuning queries, procedures, and ETL processes.
• Experience working with a team of developers and business users.
• Strong SQL skills and knowledge of relational database concepts.
• Proficiency in Microsoft SQL Server Integration Services (SSIS) and related tools.
• Experience with source control systems.
• Excellent problem-solving skills and ability to troubleshoot technical issues.
• Excellent communication skills and ability to work effectively in a team environment.