<p><b>Description </b></p> <p>Based on Governor's Office priorities, there are crucial initiatives that benefit New York State Higher Education Services (HESC) and are part of the ITS/HESC project portfolio. This position will supplement the GLP DB staff for governor initiatives resulting from the 2024 NYS Budget and that effect HESC's Grants and Scholarship programs.</p> <p><b>Duties </b></p> <ul> <li class="MsoNoSpacing">Build and maintain a data architecture based on the requirements. </li> <li class="MsoNoSpacing">Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases. </li> <li class="MsoNoSpacing">Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data. </li> <li class="MsoNoSpacing">Wo...