USA Jobs, Careers and Recuitements
Job Target Job Search
[x]

Contact Information

Company: ACROSTAFF Jobs
Contact Name: DAVE
Website: http://www.acrostaff.com

Job Details: Data Modeling ---Rate:70\\hr on 1099 Date: Nov 04 2019

Job Reference: 10316
Job Category: IT Jobs [ View All IT Jobs Jobs ]
Company Type Employer
Employment type: Contract
Salary: 70 USD / Contract
Degree: Masters
Experience: 3 years
Location: Harrisburg, Pennsylvania, 17104
Job Skills: Data Modeling
Share Job with Others

Job Tools

Job Description

Rate:70\\hr on 1099

Position Type: Contract

Interview Type: WebCam/InPerson

Overall IT experience Required 10 Years

OLTP data modeling (logical and physical) experience. Required 5 Years

Lead Data Architect experience with the sole responsibility for large OLTP data models. Required 2 Years.

Experience using Erwin or similar data modeling tool(s) Required

Strong Structured Query Language (SQL) skills Required

Database development experience in DB/2, Oracle or SQL Server Required 3 Years

Highly developed oral and written communication skills Required

Experience working with Mainframe DB2 Desired
Experience working with Oracle 11g Desired
Experience with analytical (OLAP) data models in a data warehouse environment Desired
Experience using Erwin data modeling tool Desired
Experience working as an application developer in Java or .NET Desired


Senior Architect responsible for designing, developing, and implementing application infrastructure to provide highly-complex, reliable, and scalable applications and systems to meet the organization\'s objectives and requirements.

The position is for a senior data architect in the Data Administration Division of the Bureau of Business Solutions and Services. This position will be responsible for leading the logical and physical data modeling efforts to support transactional (OLTP) and analytical (OLAP) solutions on large enterprise projects.

Responsibilities will include logical and physical data modeling, design and creation of database objects (e.g., tables, views, stored procedures) and working closely with the business users, developers, and DBA�s.

� Serve as the lead in developing large, complex logical and physical data models for transactional and analytical solutions.
� Attend periodic project meetings with business and technical team members to gather requirements and to report on the status of data modeling efforts.
� Work closely with the business and application development team in building the logical and physical data models.
� Build these data models using All Fusion Erwin data modeling tool.
� Resolve any issues and answer any questions the development teams or DBA�s have regarding the physical data models.
� Create DDL for submission to DBAs for creation of databases in pre-production and production environments.
� Design and develop indexes, views, check constraints, triggers, and stored procedures for submission to DBA�s for creation in the databases in pre-production and production environments.
� Manage all change to the physical data model and facilitate a model-driven database development effort.
� Assist developers and DBA�s with query development and optimization and make any required changes to the physical data model to improve query performance and efficiency.

Experience:

� Required: 5+ years of OLTP data modeling (logical and physical)

� Required: 2+ years as a lead data architect with sole responsibility for large OLTP data models
� Required: 10+ years overall IT experience

� Required: Experience using Erwin or similar data modeling tool(s)

� Required: Strong Structured Query Language (SQL) skills

� Required: 3+ years of database development in a DB/2, Oracle or SQL Server

� Required: Highly developed oral and written communication skills

� Desired: Experience working with Mainframe DB2

� Desired: Experience working with Oracle 11g

� Desired: Experience with analytical (OLAP) data models in a data warehouse environment

� Desired: Experience using Erwin data modeling tool

� Desired: Experience working as an application developer in Java or .NET

Copyright © 2019 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.