Database Developer

$63,500 - $73,500/Yr

Proact International Ltd - East Syracuse, NY

Full-time - Mid Level

East Syracuse, NY

Merchant Wholesalers, Nondurable Goods

About the position

The Database Developer position at ProAct involves hands-on development and maintenance of database systems, ensuring high levels of data accuracy and availability. The role requires collaboration with various teams to design and implement ETL solutions that support core business processes, utilizing Microsoft SQL Server and SSIS.

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.

Benefits

• Competitive salary ranging from $63,500 to $73,500 per year.