SQL Enterprise Application Engineer

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

Job summary

Clear Point Group is seeking a SQL Enterprise Application Engineer to support and enhance our enterprise application ecosystem. You will collaborate with business stakeholders to ensure stability, performance, and continuous improvement across finance, marketing, and practice management platforms.

You will develop SQL queries and SSIS/SSRS reports, integrate APIs, and automate processes using Power Automate, Boomi, and scripting.

Qualifications

• Bachelor's degree in Computer Science or related field preferred.
• 3+ years of experience supporting enterprise applications in production.
• Experience with API integrations and scripting (PowerShell, C# or similar).
• Experience with Azure Enterprise Applications, including App registrations and Azure AD authentication.
• Strong Windows Server administration experience and SQL Server performance tuning.

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.
• 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 and auth integrations.
• Administer Windows Servers, SQL Servers, and Azure Fabric.
• Troubleshoot complex application and data issues across integrated systems.
• Collaborate with cross-functional teams to implement improvements and manage vendors.
• Participate in system upgrades, patching, and monthly maintenance in a rotation schedule.

Skills

SQL Server

Query development

SSIS/SSRS

PowerShell

C#

Azure AD

API integrations

Windows Server

Automation scripting

Performance tuning

Education

Bachelor's degree in CS/related

Equivalent experience

Tools

Elite 3E

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