Senior SQL (Integration) Developer

About the Role:

We are upgrading our ERP and must update/rebuild multiple system integrations (APIs, middleware, ETL, batch jobs, etc.). Current staff are committed to production support; adding two Integration Developers will:

• Enable parallel development and testing
• Provide required middleware/API development skills
• Speed up issue resolution during implementation, minimizing business disruption

The mission of the Senior SQL (Integration) Developer is to design, develop, and optimize SQL queries, stored procedures, and database solutions to support integration projects between various applications and systems. This role ensures efficient data exchange via APIs and web services, maintains data quality, and supports seamless system interoperability.

Responsibilities:

• Design, write, and optimize SQL queries, stored procedures, and functions to support data retrieval and integration.
• Ensure database performance tuning and query optimization for high efficiency.
• Develop and maintain integrations between systems using APIs, web services, and ETL processes.
• Build and manage data exchange workflows to ensure timely and accurate transfer of information.
• Set up and maintain monitoring systems for integration jobs and API calls.
• Identify, investigate, and resolve integration failures or performance issues.
• Implement and consume REST/SOAP APIs for data exchange.
• Ensure API endpoints are securely and efficiently integrated with SQL-based systems.
• Develop Python scripts/services for integrations, ETL, automation, and error handling.
• Work closely with ERP, BI, and development teams to gather requirements and deliver integration solutions.
• Support internal stakeholders by troubleshooting data-related and integration issues.
• Document SQL scripts, integration workflows, and system configurations.
• Maintain clear technical documentation for future maintenance and team onboarding.

Requirements:

• Advanced SQL development (T-SQL, PL/SQL, or similar).
• Strong skills in database performance tuning and optimization.
• Proficient in API (REST/SOAP) integration and management.
• Proficient in ETL processes and integration tools.
• Understanding of database security and access control.
• Familiarity with monitoring tools and automation scripts.
• Python development experience is preferred.