SQL Enterprise Application Engineer

Clear Point Group; Paramus (NJ); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Power Automate

Boomi

Job summary

Clear Point Group is seeking a SQL Enterprise Application Engineer to enhance the firm’s critical application ecosystem. You will partner with business stakeholders to ensure stability, performance, and continuous improvement of enterprise systems.

The role focuses on SQL/query development, API integrations, and automation, with exposure to Azure enterprise applications, Windows Server administration, and modern workflow tools.

Qualifications

• Advanced knowledge of Microsoft SQL Server.
• Query development and optimization.
• Reporting (SSRS) and ETL processes (SSIS).
• API integrations and scripting (PowerShell, C#, or similar).
• Experience with Azure Enterprise Applications and Azure AD.

Responsibilities

• Administer, support, and optimize enterprise applications across finance, marketing, and practice management systems.
• Design, develop, and support SQL queries, scripts, SSIS/SSRS reporting, and integrations to enable business operations and reporting.
• Automate business and IT processes using Power Automate, Boomi and scripting tools.
• Build and maintain application integrations using APIs and scripting solutions.
• Support Azure-based enterprise applications, including Azure AD app registrations, authentication, and integrations.
• Administer Windows Servers, SQL Servers (queries, performance tuning, and reporting), and Azure Fabric.
• Troubleshoot complex application and data issues across integrated systems.
• Collaborate cross-functionally to implement improvements, manage vendors, and ensure system reliability.
• Participate in system upgrades, patching, and monthly maintenance in a rotation schedule (Windows, SQL, and application stack).

Skills

SQL Server

Query optimization

SSRS/SSIS

APIs & scripting

Power Automate

Windows Server admin

Azure Enterprise Apps

Azure AD

Problem solving

Communication

Education

Bachelor's degree or equivalent in CS or related field

Tools

PowerShell

C#

Elite 3E

Azure Fabric

Boomi

Job description

Must be a US citizen or green card holder!!!!!!!!!!!!!!!!!!!

No 3rd parties or C2C!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

We are seeking a SQL Enterprise Application Engineer to support and enhance the firm’s critical application ecosystem. This role partners closely with business stakeholders to ensure stability, performance, and continuous improvement of enterprise systems.

We are specifically targeting candidates with strong SQL/query development, API integration, and automation capabilities, along with some experience with Azure enterprise applications, Windows Server administration, and modern workflow tools.

Responsibilities

• Administer, support, and optimize enterprise applications across finance, marketing, and practice management systems
• Design, develop, and support SQL queries, scripts, SSIS/SSRS reporting, and integrations to enable business operations and reporting
• Automate business and IT processes using Power Automate, Boomi and scripting tools
• Build and maintain application integrations using APIs and scripting solutions
• Support Azure-based enterprise applications, including Azure AD app registrations, authentication, and integrations
• Administer Windows Servers, SQL Servers (queries, performance tuning, and reporting), and Azure Fabric
• Troubleshoot complex application and data issues across integrated systems
• Collaborate cross-functionally to implement improvements, manage vendors, and ensure system reliability
• Participate in system upgrades, patching, and monthly maintenance in a rotation schedule (Windows, SQL, and application stack)

Qualifications

• Advanced knowledge of Microsoft SQL Server:
• Query development and optimization
• Reporting (SSRS) and ETL processes (SSIS)
• Basic DBA-level experience (job creation, maintenance plans, performance tuning)
• Experience with API integrations and scripting (PowerShell, C#, or similar)
• Working knowledge of Azure Enterprise Applications, including:
• App registrations
• Authentication & identity integrations (Azure AD)
• Experience with Power Automate or similar workflow automation tools
• Familiarity with law firm application platforms (e.g., Elite 3E or similar systems), integrations, and system dependencies
• Strong hands-on experience with Windows Server administration
• Exposure to SSIS/SSRS report development and data workflows
• Strong analytical and problem-solving skills with the ability to troubleshoot complex systems
• Ability to work independently while supporting cross-functional teams
• Clear communication skills across technical and non-technical stakeholders
• Strong documentation and process discipline
• Aptitude to learn new tasks quickly and adapt to evolving technologies.
• Minimum 3+ years of experience supporting enterprise applications in a production environment
• Bachelor’s degree or equivalent experience in Computer Science or related field preferred
• Microsoft or related certifications are a plus