Database Architect SQL queries stored procedures triggers scripts MS SQL Server Management

Profile

HBITS-03-11792

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 data integration activities for PBS E-Registration and for mobile field inspection project.

Database Architect:

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

84 months of experience in designing data architecture and data modelling (data dictionary and system documentation)

84 months of experience in SQL code tuning, consolidating views and tracking and improving database performance metrics

60 months of experience in designing reports using either Crystal Reports (version 2016 ) or Business Objects XI or SSRS

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.