Hi Folks,
Hope you are doing great there..!
I am wondering if you have consultant available for the below position, if so please respond me with their most updated resume and the best contact number to reach them to discuss about the below role ASAP. Please respond back to Avisheak.s@shstinc.com or call me on (412) 450 1316 Ext 203.
Note : Must Be Local Or Nearby, Who Can Do F2F Inetrview.........!!!!!
Job Title : Data Architect
Location: Richmond VA
Duration : 6+ Months Contract
Location: Richmond VA
Duration : 6+ Months Contract
Position Description :
The position is for a senior data architect in the Data Administration Division of the Bureau of Business Solutions and Services at PennDOT. 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 from PennDOT's IT portfolio. 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.
The position is for a senior data architect in the Data Administration Division of the Bureau of Business Solutions and Services at PennDOT. 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 from PennDOT's IT portfolio. 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.
Specific Duties:
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 AllFusion 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.
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 AllFusion 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.
Skills and 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
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
Avisheak Singh
(412) 450 1316 Ext : 203
--
All Job Openings : http://groups.google.com/group/jobjunction/topics?hl=en
You received this message because you are subscribed to the Google
Groups "Job Junction" group.
Send us your resume to jobjunction.global@gmail.com, we will post you updated openings.
To post to this group, send email to jobjunction.global@gmail.com
To unsubscribe from this group, send email to jobjunction+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jobjunction?hl=en
---
You received this message because you are subscribed to the Google Groups "Job Junction" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobjunction+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment