SQL Server Developer / SSRS Expert

Job Description:

Prism Visual Software, Inc. is looking for an experienced SQL Server Developer / SSRS Expert. As the SQL Server Developer / SSRS Expert , you will participate in the design, development, support, and maintenance of a Prism Software’s Route Accounting Technologies. Prism’s Android, Web, and back-office applications serve distribution and field service industries that integrate with many off the shelf accounting packages including Dynamics GP, Sage, SAP One, AccountMate, and QuickBooks. This position is especially suitable for developers with 3-10 years of experience who thrive on new challenges and have the ability to successfully apply past experience to master new technology. In addition to technical and creative savvy, candidates must be motivated, energetic, and success-driven. Our environment is fast-paced and dynamic, and the ideal candidate must possess the same attributes. You must demonstrate excellent communication skills, including the ability to work well with others.


  • Develop and modify our Microsoft SQL-based software applications 
  • Provide performance tuning and optimization of existing SQL code
  • Provide technical support for the database environment and database objects such as stored procedures, functions, triggers, tables, and views 
  • Work with developers, business analysts, other team members, and clients to review the business requirements and translate them into database objects 
  • Work with clients to design and implement data integration plans 
  • Collaborate with development and support teams to discuss projects, troubleshoot issues, and evaluate new technologies 
  • Design and implement SSRS reports

Desired Skills and Experience:

  • BS or MS in Computer Science or equivalent with 3+ plus years of experience 
  • Microsoft SQL Server experience with knowledge of Stored procedures, sophisticated query design, database structure design with 3+ plus years of experience 
  • 3+ years programming/analysis experience in SQL and .NET, preferred 
  • Windows Server administration and IIS installation and configuration - 3+ years 
  • MS Transact SQL – creating tables, views, stored procedure and functions, understanding indexes, and optimization 3+ years 
  • MS SQL debugging with MS SQL server tools(Ability to find a problem(error) in SQL scripts ) 3+ years 
  • Creating SSRS Reports 3+ years

A Big Plus:

  • Experience in Accounting ERP Systems (Microsoft Dynamics GP, Sage, or Visual AccountMate ) 
  • C#
  • HTML5, CSS3


Please e-mail your cover letter & resume to careers@prismvs.com. Indicate " SQL Server Developer / SSRS Expert “ in the subject line. Thank you.

This position is onsite in Prism's corporate office in Port Washington, NY. Prism Visual Software, Inc. is a growing software technology company based 40 minutes out of NYC on Long Island.

Prism Visual Software, Inc. provides excellent benefits and a competitive salary based on experience. This position will offer an excellent income and personal development opportunity.