Job Title: Database Administrator - Senior Task ID: HBITS-07-14857 Position Duration: 24 Months Client: State of NY Agency: Information Technology Services (ITS) Please call
(703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at
[email protected] Description - 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.
Mandatory Qualifications 1 60 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures. 2 60 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis. 3 60 months of Experience writing complex DML SQL against enterprise SQL Server and DB2 databases. 4 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. 5 60 months of experience using programming languages such as SQL, PL/SQL. 6 60 Months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases. 7 18 months of experience working with projects or programs relating to higher education services
Required Documentation • Resume
• Copy of Candidate Identification
(i.e., Driver's License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.) 
