Database Administrator

MVP Consulting

Albany, NY

Apply

JOB DETAILS

SKILLS

Analysis Skills, Budgeting, Capacity Management, Consulting, Data Description Language (DDL), Data Modeling, Data Recovery, Database Administration, Database Design, Higher Education, Microsoft SQL Server, People Management, Performance Analysis, Performance Tuning/Optimization, Programming Languages, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Schedule Development, Scholarship, Scripting (Scripting Languages), Security Monitoring, Software Testing, Testing

LOCATION

Albany, NY

POSTED

5 days ago

HBITS: HBITS-08-14863

NYS ITS - Expert, 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 a 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.

Database Administrator
Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security and troubleshooting, as well as backup and data recovery.
Expert 84+ 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.

--- Required Qualifications ---
• 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 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.

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.

About the Company

MVP Consulting

Resume Resources

Free Resume Templates Free Resume Builder