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
| | or email at
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//Visa and Passport if applicable)
Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.) Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
Never miss an opportunity! Create an alert based on the job you applied for.
