HBITS: HBITS-07-14857
Senior, Database Administrator
24 month contract
Interview: Virtual Interview
Work model: 50% telecommuting, 50% Office per week
--- Project Description ---
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.
--- Day-to-Day Tasks ---
1. Build and maintain data architecture based on the
requirements.
2. Design and develop Logical and Physical Data Model using
ER Studio Data Architect. Create DDL scripts to establish and
maintain necessary databases.
3. Write complex SQL queries against SQL Server and DB2
databases. Create DML scripts to manipulate data.
4. Work with project managers, solution architects, business
analysts, application development teams and QA to ensure the
quality of DDL and DML scripts.
5. Performance tuning SQL to improve efficiency.
6. Working with NYS Agency representatives to develop gap
analysis specifications and understand Agency business rules.
7. Provide guidance and hands-on development for developing
and maintaining queries in QMF for Workstation.
8. Create clear and accurate documentation on data models, and
description of data usage in the application process flow.
--- Required Qualifications ---
60 months of Experience designing and developing logical and
physical data models, and creating DDL scripts for tables, views,
indexes, triggers, stored procedures.
60 months of Experience designing and developing Data
Conversion Strategy Plan, Data Mapping Documents, Gap
Analysis.
60 months of Experience writing complex DML SQL against
enterprise SQL Server and DB2 databases.
60 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.
60 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.
18 months of experience working with projects or programs
relating to higher education services
MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10109907
- Position Id: 8c2ad4cca9242c1a07a91ca90fc3ea50
- Posted 15 hours ago
Never miss an opportunity! Create an alert based on the job you applied for.
