Database Developer

KPH Healthcare Services • Full-time • East Syracuse, NY, US • 4w 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 • 3m 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...

3m ago

Apply

Programmer Analyst Remote Opportunity

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

Software Development

3m ago

Apply

Store clerk Camillus part time mornings

KPH Healthcare Services • Part-time • Syracuse, NY, US • 2d ago

Retail

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

2d ago

Apply

Director of Account Management

KPH Healthcare Services • Full-time • Remote (East Syracuse, NY) • 5d ago

Sales

Overview Scope of Responsibilities : Responsible for the growth, retention, client satisfaction as well as strategic planning of existing ProAct accounts. Responsible for the coaching and development of the ProAct ac...

5d ago

Apply

Billing Associate - Long Term Care

KPH Healthcare Services • Full-time • E Syracuse, NY, US • 5d ago

Overview Assist in centralized billing of all claims Responsibilities Job Duties: Responsible for accurate data entry of resident insurance information. Review of resident face sheets and make correcti...

5d ago

Apply

Pharmacy Clerk

KPH Healthcare Services • Part-time • E. Syracuse, NY, US • 6d 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...

6d ago

Apply

Pharmacy Tech 7am-3:30pm Mon-Fri

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

Pharmacy

1w ago

Apply

Pharmacy Clerk/Tech - 2nd shift - No weekends

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

Retail

1w ago

Apply

Shift Supervisor

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

Management Supervisor

Overview Responsible for providing supervisory leadership in the absence of store management. Typically authority is assigned on an individual shift basis. Responsibilities Job Duties: Ability to fulfill all...

1w ago

Apply

Cashier: Brewerton Rd

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

Retail

1w ago

Apply