Offer summary

Qualifications:

Proficiency in MS SQL Server, including creating and debugging stored procedures., Experience with MS SQL Reporting Services, Integration Services, and DBA tasks., Hands-on experience with Windows server applications, IIS configuration, and web application support., Strong troubleshooting skills and a technical background in supporting Windows-based web applications..

Key responsibilities:

Diagnose and resolve technical issues related to the web-based software application.

Utilize MS SQL Server for data analysis and troubleshooting.

Configure and troubleshoot related applications like IIS, SQL Reporting Services, and SFTP servers.

Support user acceptance testing and develop support documentation.

Job description

Banyan Software provides the best permanent home for successful enterprise software companies, their employees, and customers. We are on a mission to acquire, build and grow great enterprise software businesses all over the world that have dominant positions in niche vertical markets. In recent years, Banyan was named the #1 fastest-growing private software company in the US on the Inc. 5000 and amongst the top 10 fastest-growing companies by the Deloitte Technology Fast 500. Founded in 2016 with a permanent capital base setup to preserve the legacy of founders, Banyan focuses on a buy and hold for life strategy for growing software companies that serve specialized vertical markets.

About Lightspeed Data

Lightspeed Data is a leading provider of Trade and Data Management Systems purpose-built for broker-dealers and financial institutions. Our proprietary technology helps clients streamline back-office operations, automate post-trade workflows, and maintain regulatory compliance—all while driving operational efficiency at scale. Learn more at www.lightspeedtdms.com.

Location: Remote in the U.S.

As a Senior Application Support Analyst – Web & Database Systems with customer facing acumen, you will play a crucial role in ensuring the smooth operation of our web-based software application used by trade operations and settlement professionals. Leveraging your technical expertise, and communication skills, you will provide all tiers of technical support, troubleshoot issues, and enhance user experience.

Qualifications:

Experience with various AI tools, understanding and application of AI.
Deep proficiency in MS SQL Server for effective troubleshooting and software support.
Hands-on experience with creating, optimizing, and debugging MS SQL Stored Procedures.
Hands-on experience with MS SQL Reporting Services and Integration Services.
Hands-on experience with MS SQL DBA tasks, including database creation, backup, restoration, and query optimization.
Hands-on experience with MS IIS configuration and management.
Hands-on experience with installing and configuring applications on MS windows servers.
Exceptional troubleshooting abilities with a track record of timely issue resolution.
A solid technical background supporting Windows-based web applications.
Full Stack experience.
Familiarity with trade operations and settlement processes within financial services (a plus).

Responsibilities:

Diagnose and resolve technical issues reported by users, including software bugs, performance issues, and data discrepancies.
Utilize MS SQL Server for data analysis, troubleshooting, and supporting software functionality.
Help configure and troubleshoot issues in other applications that are required by our web-based application such as IIS, SQL Reporting Services, SQL Integration Services, SMTP Server, Batch files, and SFTP servers.
Collaborate with software developers and product managers to escalate and prioritize issues for resolution.
Serve as a technical support contact for our web-based software application used in trade operations and settlement.
Help develop and maintain support documentation, including FAQs and troubleshooting guides, to assist users in resolving common issues independently.
Help conduct user acceptance testing for software updates and enhancements to ensure functionality and usability meet business requirements.

Diversity, Equity, Inclusion & Equal Employment Opportunity at Banyan: Banyan affirms that inequality is detrimental to our Global Teams, associates, our Operating Companies, and the communities we serve. As a collective, our goal is to impact lasting change through our actions. Together, we unite for equality and equity. Banyan is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Required profile