MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious
1

Data Modeler (Contractor)

Location New York, United States
Posted 29-May-2020
Description

Must Pass Government Background Check

TASKS AND DUTIES:

Creates conceptual, logical and physical data models for transactional systems in Erwin.
Leads business discovery sessions with the end users.
Plans, implements and manages systems initiatives with IT and customer teams.
Establishes and maintains data technical standards as described in data dictionaries and source to target mapping documents.
Conducts database performance monitoring, capacity planning, trend Forecasting.
Documents and improves upon processes, procedures, and best practices to align with industry standards and customer needs.
Adheres to disaster recovery requirements to ensure business resumption requirements are met.
Provides high-level of customer satisfaction to internal and external customers, applying necessary sense of urgency and creativity in problem identification and prompt incident resolution.
Provides advanced database systems administration.
Analyzes system performance and suggest/implement tuning as needed.
Administers MS SQL server database.

Project Specific Technical Requirements: 

7+ years of experience in the following: 

Data Modeling/Architecture (conceptual, logical, physical, understanding of the data)
Database Management performing installation, configuration, customization, implementation and support of SQL Server Database
Creating Data Dictionaries and Data Mappings documents.
Experience and expertise in monitoring and troubleshooting ETL, DTS, SSIS and Data warehouse queries.
Hands-on experience in SQL Server Performance Tuning, Query Optimization and Production support.
Hands-on experience writing complex Stored Procedure/ Functions in PL/T-SQL and MS SQL.  Writing complex Shell Scripts to support SQL and other functions

 

ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans

Recommended skills
Performance Tuning
Extract Transform Load (Etl)
Query Optimization
Data Modeling
Distributed Temperature Sensing (Dts)
Databases

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url