Remote BRMS SQL Developer

Job Description

We are seeking an experienced BRMS SQL Developer to support the ongoing development, enhancement, and maintenance of enterprise business rules applications. This role will be heavily focused on SQL Server development, including writing and troubleshooting complex SQL queries, working with multiple-table joins, CTEs/Common Table Expressions, aggregate functions, GROUP BY and ORDER BY logic, and leveraging UNION and UNION ALL to support application and data-processing requirements. The developer will also work with stored procedures, data validation logic, backend data integrations, and database-driven troubleshooting to ensure accurate and efficient rule execution.

The consultant will work within the InRule Business Rules Management System (BRMS) to develop and maintain business rules, decision tables, and rule-driven workflows, with SQL serving as a key component of the underlying data processing and integration. Responsibilities will also include production support, troubleshooting SQL and application issues, performing root cause analysis, resolving break/fix incidents, supporting deployments, and identifying opportunities to improve query performance and system reliability. The ideal candidate will have strong hands-on SQL fundamentals and be comfortable working across both database and application layers while partnering with business analysts, QA teams, developers, and operational stakeholders.

Skills and Requirements

Strong hands-on SQL Server development experience, with the ability to independently write, modify, troubleshoot, and optimize SQL queries. Strong understanding of SQL joins, including INNER JOIN, LEFT JOIN, and working with data across multiple related tables. Solid understanding of core SQL concepts including CHAR vs. VARCHAR, DELETE vs. TRUNCATE, UNION vs. UNION ALL, GROUP BY, ORDER BY, aggregate functions, and filtering data. Hands-on experience creating and utilizing CTEs/Common Table Expressions, subqueries, and other techniques for organizing more complex SQL logic. Experience working with or supporting stored procedures, including modifying existing procedures and troubleshooting database logic. Experience with InRule BRMS or a similar business rules/decision management platform, including business rules, decision tables, or rule-driven application logic. Experience troubleshooting data-related production issues, performing root cause analysis, and supporting applications across development, QA/test, and production environments.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.