Database Architect

Job Title: Database Architect - Expert Task ID: HBITS-06-13759 Position Duration: 30 Months Client: State of NY Agency: Department of Environmental Conservation

Please call

(703) 466-0951 | (571) 351-1868 | (703) 348-3018

or ema il at nysreqs@ilinksolutions.com

Description

The database architect will be responsible for designing and maintaining MS SQL databases, reviewing database performance, and optimizing existing processes. This individual will perform analytical and technical tasks to develop advanced complex SQL based solutions. This individual will also provide ad-hoc production support for the existing database needs. Maintain Database mobile field inspection module V7 already integrate into UIS. Build complex SQL queries, stored procedures, functions, views, and reports. Work with developers to design modern and effective database architectures. Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages. Review performance logs to track and analyze production issues, identify and eliminate obsolete DB objects, and optimize stored procedures and jobs to improve database responsiveness. Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset. Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members. Participate in data integration activities for PBS E-Registration , mobile field inspection system and Spill Hotline-Response Notification project.

Mandatory Qualifications

1. 84 months experience in design and development of advanced SQL queries, stored procedures, triggers, scripts, cursors, and views 2. 84 months experience in MS SQL Server Management Studio (MS SQL Server version 2012+, and upgrade to MS SQL 2019) including experience on database software (including SSRS, SSMS, SSIS), and understanding ETL concepts (Extract, Transform and Load data). 3. 84 months of experience in designing data architecture and data modeling (data dictionary and system documentation), including the ongoing maintenance of an existing data model 4. 84 months of experience supporting day-to-day database operations, including: monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization, tuning, consolidating views and tracking and improving database performance metrics 5. 60 months of experience with extracting and inserting data to/from business systems using scripting along with GIS API's( ESRI ArcGIS, Survey 123, Workspace, Google Maps)

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.)

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