Database Developer

KPH Healthcare Services • Full-time • East Syracuse, NY, US • 1w ago

Overview

Scope of Responsibilities: This is a hands-on position requiring the candidate to be able to work and assist with applicable technologies and assist in the development and maintenance of ProAct database systems while ensuring high levels of data accuracy and availability.

Job Summary:

We are seeking an experienced Database Developer to join our dynamic SQL Development team! As a member of the Development team, you will be responsible for designing and developing database infrastructure and comprehensive ETL solutions to support our core business processes.

Responsibilities

Job Duties:

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. Position requires 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

Qualifications

Education: Bachelor of Science in Computer Science or related field preferred

Experience:

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

Special Conditions of Employment:

Drug test
Initial and continuous exclusion and sanction/disciplinary monitoring
Any and all additional eligibility requirements based on the specific position

Compensation

$63,500-73,500.00 per year.

The final offer will be determined after careful consideration of multiple factors such as relevant skills, years of experience and education.

KPH Healthcare Services, Inc. is a multistate organization and abides by all local, state, and federal regulations as it pertains to minimum wage requirements.

Related Jobs

Programmer Analyst Remote Opportunity

KPH Healthcare Services • Full-time • East Syracuse, NY, US • 2m ago

Software Development

Overview Scope of Responsibilities: Responsible for analysis, design, development, testing, and maintenance of software applications in support of achieving business goals. This is a key role in our IT department a...

2m ago

Apply

Programmer Analyst Remote Opportunity

Kinney Drugs • Full-time • East Syracuse, NY, US • 2m ago

Software Development

2m ago

Apply

Store Clerk

KPH Healthcare Services • Part-time • Chittenango, NY, US • 6d ago

Retail Cashier

Overview Scope of Responsibilities: Works under direct supervision and follows standard procedures to accomplish assigned task Job Summary: Responsible for ringing out each customer’s purchases while ensuring...

6d ago

Apply

Delivery Driver- Pharmacy Kinney

KPH Healthcare Services • Part-time • Syracuse, NY, US • 1w ago

Transportation

Overview Job Summary: Responsible for accurate and timely delivery of customer’s purchases, while ensuring total customer satisfaction. Responsibilities Job Duties: Must comply with all State and Federal...

1w ago

Apply

Staff Pharmacist- 40 hours- Employee Owned Organization

KPH Healthcare Services • Full-time • North Syracuse, NY, US • 1w ago

Pharmacy

Overview For over 50 years, the HealthDirect team has been dedicated to the unique pharmacy needs of individuals residing in Long-Term Care (LTC) facilities such as nursing homes and assisted living facilities, as wel...

1w ago

Apply

Pharmacy Clerk/Tech 7AM-3:30PM

KPH Healthcare Services • Full-time • Liverpool, NY, US • 1w ago

Retail

Overview Job Summary: Assist pharmacy staff in the triaging of incoming prescriptions, the delivery of filled prescriptions to the patients, and all cashier duties. Works under direct supervision of a pharmacist an...

1w ago

Apply