HBITS Software Architect - Expert
Listed on 2026-03-10
-
IT/Tech
Database Administrator
Location: City of Albany
Job Description
The consultant hired from this procurement is expected to provide the architectural and technical expertise to support the system infrastructure of the Settlement/Ceiling System, and the reporting for the Shelter Management system. The candidate will also be responsible for the maintenance activities to support the Social Statistics Reporting System, Recommended Appointment System (REAPS) and various other web application and reports. In addition to support and maintenance efforts, the position will be responsible for all activities associated with the project’s system development life cycle – system planning, design, development, quality assurance and maintenance.
This position also assists in SQL Server Report and SQL Integration Services development and maintenance.
Tasks include all phases of web application analysis, design, construction and developer testing. The use of Microsoft Visual Studio, specifically coding in and development of stored procedures using PL/SQL and interacting with an Oracle database for the Settlement/Ceiling System. The consultant will maintain the existing .NET code and support the changes involved in maintaining the OTDA claiming and settlement/ceiling process. Additionally, the consultant will be required to support database changes, perform quality assurance reviews, implement changes, etc.
The consultant will work and communicate closely with OTDA Budget and Finance staff to define requirements and design enhancements. The consultant will work within the NYS Statewide Financial System (SFS) project to ensure the information supplied from the Settlement application conforms to the file layouts established by SFS.
Tasks include development of reports that can be utilized within Microsoft CRM for the Shelter Management system.
SQL Server SupportTasks include development and maintenance of various SQL Server Reports and SQL Server Integration Service Packages and being the DBA Backup.
Mandatory Qualification Software ArchitectMakes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system.
Expert84+ Months:
Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
- 84 months experience designing application architecture, developing & deploying n-tier asp.
Net Web apps using web services and Windows Communication Foundation - 84 months experience analyzing business processes and workflows; and working with non-technical staff to develop system specifications and resolve issues.
- 72 months experience using Oracle and PL/SQL packages including SQL programming,
- 36 months experience as a Web GUI designed including accessibility compliance.
- 48 months experience with developing applications related to government financial systems including file transfers.
- 36 months experience using object-oriented concepts to design complex business objects, for example voucher processing, settlement program rules.
- 48 months experience using SQL Reporting
- 36 months experience using Microsoft CRM with SQL Server Reporting Services Integration
- 48 months experience using Microsoft SQL Server Integration Services
- Bachelor's degree
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).