Database Administrator - Albany, United States - Castletop Logistics LLC

Castletop Logistics LLC

Verified Company

Albany, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Job Summary:
The requirements listed below are from the "
State of New York," and requires applicants to start on-site on
Day 1

Database Administrator - Expert - HBITS

Agency Name:
Information Technology Services (ITS)

Location : 99 Washington Ave, Albany, NY, 12207

Duration : 24. 0 Months

Project/Program Name:
Grants & Scholarships

Short description of the Position:

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.

Duties:

Build and maintain a data architecture based on the requirements.
Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases.
Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data.
Performance tuning SQL to improve efficiency.
Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules.
Provide guidance and handson development for developing and maintaining queries in QMF for Workstation.

Skills:

84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures.
84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis.
84 months of Experience writing complex DML SQL against enterprise SQL Server and DB2 databases.
84 months of Experience working with the tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO.
84 months of experience using programming languages such as SQL, PL/SQL.
60 Months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases.
Résumé
Please submit a copy of resume which details relevant experience AND identifies a BS or MS Computer Science Degree and the School / Graduation Date obtained from.