Database Application Developer/Report Designer

City of New York • New York, NY

10d

About The Position

The HIV/AIDS Services Administration (HASA) is recruiting a Computer Associate (Software) II to develop, design, enhance, implement, and support program-specific software and information structures. Under the general supervision of the Applications Development Manager, the role operates with considerable latitude for independent initiative and judgment in resolving Information Technology issues. Applicants must be permanent in the Computer Associate Software civil service title.

The position develops and maintains database applications, creates and enhances reports, coordinates electronic-form design, and supports users and vendors of HASAWeb. It works with operational staff, programming and web development teams, HASA staff, HRA-ITS, and program units. The role also coordinates the Single Room Occupancy (SRO) billing process. The stated schedule is 9:00 a.m. to 5:00 p.m.

Requirements

• Applicants must be permanent in the Computer Associate Software civil service title.
• Meet one of the stated qualification pathways: a bachelor's degree including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full-time computer software experience; a high school diploma or equivalent and five years of such experience; or equivalent education and/or experience.
• The qualifying computer software experience may include computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, or web development and design.
• All candidates must have at least a four-year high school diploma or equivalent and at least one year of satisfactory full-time computer software experience as described in the qualifications.
• College education may substitute for up to two years of the experience requirement under the stated credit equivalencies; qualifying computer science or related-field credits or an eligible computer programming certificate may also substitute for one year of experience under the stated conditions.

Responsibilities

• Design and deploy Microsoft SQL Server Reporting Services reports for case management, eligibility operations, finance, personnel, housing, and contracts units, connecting to Oracle and Microsoft SQL Server database applications.
• Coordinate the design, development, and implementation of HASA database applications and maintain existing applications.
• Design, develop, and implement programs using SQL Server 2016 and above, including tables, views, stored procedures, and SSIS packages.
• Analyze and enhance existing quality assurance and other statistical and periodic reports, and create new reports based on analysis and recommendations using Oracle, the Electronic Data Warehouse (EDW), in-house SQL Server applications, and flat files received by SFTP.
• Coordinate the design and planning of electronic forms with the Policy and Procedures unit, and maintain and update web-based E-forms.
• Communicate with operational staff to understand requirements and feedback, convey them to programming and web development teams, and recommend changes to web application and database design.
• Provide technical support to users and program vendors for the HASAWeb web application, including resolving issues, maintaining its security module, adding or removing users, codes, and roles, and coordinating with HASA staff and/or HRA-ITS.
• Create ad-hoc reports for management using available data sources, including Oracle, SQL Server 2016 databases, and flat text files.
• Coordinate the SRO billing process as the single point source by creating contract exception reports, creating and transferring files to and from HRA FTP servers, and requesting updates to the central database application.

What This Job Offers

• Job Type: Full-time