For more details, please connect with Praveen H at praveenh@vgroupinc.com or call at 609-766-2733.
End Client: New York State - Information Technology Services (ITS)
Job Title: Senior Database Administrator
Duration: 24 Months
Location: Albany, NY 12255
Hours Per Week: 40 Hours
Interview Type: Webcasting
Job Code: HBITS-07-14857
Ceipal ID: SNY_SQL857_PH
Scope of Project:
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.
Responsibilities:
Build and maintain 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.
Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts.
Performance tuning SQL to improve efficiency.
Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules.
Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation.
Create clear and accurate documentation on data models, and description of data usage in the application process flow.
Required/Preferred Skills:
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.
V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/ contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.
If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
LinkedIn:
Facebook:
Twitter:
...with teammates and accepting coaching from management team. - Having a clean and tidy appearance and work habits. - Communicating with customers, teammates and managers in a positive manner. xhmxlyz Remote working/work at home options are available for this role.
Massage TherapistSenior Level to Entry LevelPart-timeSandCille Spa is the best spa in the Erie area for both the client and the employee... ...ourselves in being focused on both cleanliness, the guest experience & the employee experience. We strive to provide the highest...
...responsible for a variety of specialized duties related to the receipt, interpretation, and follow-through of patient diet orders in hospital and long-term care settings. Acts as a liaison between the patient, the Food and Nutrition Services Department, and Nursing...
...Position: Caregiver / PCALocation: Dallas, GA 30157Schedule: Part-Time | Monday-Thursday | 9:00 AM - 1:00 PM (16 hours per week)Pay:... ...Benefits:* Competitive pay $14-16/hr* Flexible scheduling based on client needs* Paid training* Supportive...
..., you'll receive some of the highest compensation rates in the industry, free access to Grand Teton and Yellowstone National Parks, FREE... ...Eligibility Summary Job Summary: Provide guided fly fishing excursions on the Snake River within Grand Teton National Park...