Database Architect SQL queries

Profile

Database Architect Expert

HBITS-03-12117

Day to day tasks to be performed by the Selected Candidate:

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.

Build complex SQL queries, stored procedures, functions, views, and reports.

Understand the business needs and 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 planning and transformation of UIS to new platform.

Participate in data integration activities for PBS E-Registration and for mobile field inspection project.

Database Architect:

UIS Enhancements project

Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

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

84 months experience in design and development of advanced SQL queries, stored procedures, triggers, scripts, cursors, and views

84 months experience in MS SQL Server Management Studio (MS SQL Server version 2012 , and upgrade to MS SQL 2019) and proficient use of standard business and database software (including SSRS, SSMS, SSIS), and strong understanding of ETL concepts (Extract, Transform and Load)

84 months of experience in designing data architecture and data modelling (data dictionary and system documentation), including the ongoing maintenance of an existing data model

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

60 months of experience with geocoding processes (importing GIS data to database, data modeling) and experience with Geographic Information Systems (i.e. ArcGIS Pro, Google Maps)

Requested Documentation: Please submit copy of resu

me, certificate, degree.

Toll Free:

855-818-5109

Local:

518-218-1700

Map

& visit our office

Corporate - Albany NY

435 New Karner Rd, Ste 202

Albany NY 12205

Chicago

63E Lake Street, Ste 201

Chicago, IL 60601

Florida

17258 SE 121st Ave

Summerfield, FL 34491

© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Mvp Consulting Plus, Inc.