What are the responsibilities and job description for the SQL Developer position at Robert Half?
About the Role:
We are seeking a highly motivated and skilled Junior .NET/SQL Developer to join our team. This role focuses on the maintenance and enhancement of our internally developed legacy systems, specifically the intricate web of interfaces that connect them. This is not a software development role from scratch. You will be working with existing code and integrations to ensure the smooth operation of critical systems. A strong understanding of SQL and experience with XML and API integrations are crucial for success in this position.
Responsibilities:
- Maintain and enhance existing legacy systems, ensuring their continued functionality and stability.
- Manage and troubleshoot integrations between our in-house software and various third-party systems, including connections with other municipalities and internal software. This involves working with XML, APIs, and PowerShell scripts.
- Focus on integrating systems via our iPass integration platform (an on-prem middleware solution connecting our legacy SQL database with SaaS connectors). This includes preparing the SQL database for iPass integration through manual processes.
- Work with XML data exchange, SQL queries, and potentially REST APIs (as we are moving towards this technology) to facilitate seamless data flow between systems.
- Support the integration of various systems, such as our jail management system and evidence system, each with unique API connections. This often involves processing XML outputs and ensuring data is correctly transferred.
- Collaborate with the team to identify and implement improvements to existing integrations and workflows.
- Provide support for our on-prem ERP system, which is integrated using iPass.
- While PowerBI experience is a plus, it is not a primary focus of this role.
Required Skills:
- Proficiency in SQL, including writing and executing complex queries.
- Strong understanding of .NET and C# programming. While you won't be building applications from scratch, coding skills are necessary for maintaining and modifying existing code.
- Experience working with XML and API integrations. Understanding of REST APIs is a plus.
- Familiarity with PowerShell scripting for automation tasks.
- Experience with integration platforms (iPaaS) is highly desirable.
- Strong analytical and problem-solving skills.
- Ability to work effectively in a team environment.
- Excellent communication skills. 1
Salary : $60,000 - $80,000
