Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Albany, NY
View more jobs in New York

Job Details

Database Architect MS SQL Server SSRS SSMS SSIS ETL GIS ArcGIS Pro Google Maps

Company name
Mvp Consulting Plus, Inc.

Location
Albany, NY, United States

Employment Type
Contract

Industry
It, Gis

Posted on
Apr 26, 2022

Apply for this job






Profile

HBITS-03-12026

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:

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)

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.

EmploymentCrossing was helpful in getting me a job. Interview calls started flowing in from day one and I got my dream offer soon after.
Jeremy E - Greenville, NC
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
GISCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
GISCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2024 GISCrossing - All rights reserved. 169 192