Job ID :
2672
Company :
State of Ohio
Location :
columbus, OH
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
6 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com

Short Description:

The Agency is seeking a Data Modeler/DBA3 to help us complete our PACTS Update Project that includes rewriting the current PACTS ASP Classic web application in .NET and enhancing

 

Complete Description:

Attention:   ODE is specifically looking for a resource that is strong in Erwin , data modeling , Business analyst skills (i.e. working with the customer to determine what requirements they need)  excellent interpersonal skills, ability to work independently or with supervision.,  DBA skills are 50 % of the necessary skill set.   

 

The Database Administrator is responsible for data analysis and database management. Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Database Administrators have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team.

 

:

•Highly skilled at database design, installations, conversions.

•Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.

•          Is involved in the gathering of requirements

•          Reviews the project documentation

•          Conducts reviews of the data model to support the application

•          Understands and identifies data that exists in other systems/data stores

•          Attends all status meetings during which data, data models, reports, Extraction Transformation Loads (ETLs), and data exchanges will be discussed

Experience designing and developing Oracle relational data models and generating related Database schemas.

 Experience as a  data analyst/modeler

Experience designing  relational data models including (but not limited to):

•          Interviewing business stakeholders and system users to identify important business data

•          Creating transactional data models to support on-line web application

•          Documenting data lineage (source-to-target mappings), dependencies, and calculations that can lead to an ETL design and implementation

•          Identifying and designing views and/or materialized views as necessary

 Experience with designing databases schemas on Oracle  11g

experience creating logical and physical data models using ERwin 7.3

Demonstrated prior experience in similar engagements.

 Experience writing complex SQL queries and performing data analysis.

 Experience with Oracle Version 11g

 Experience using Microsoft SharePoint.

Experience using SCRUM Agile development methodologies (or SCRUM Master certification as equivalent).

 Experience with Microsoft Team Foundation Server

Goals-oriented proactive team player with the ability to multi-task and prioritize technical tasks in a fast-paced, professional environment.

Bachelor’s degree or higher in Computer Science or related field. Partial credit will be awarded for BS degree or higher in any field.

Excellent verbal communication skills (to be rated at onsite interview) Please note – no “telephone interviews” will be considered for this engagement opportunity Only onsite, “in-person” interviews will be conducted at the ODE headquarters in downtown Columbus, Ohio for candidates who score highest in the initial evaluation.

 

Skills:

Skill

Required / Desired

Amount

of Experience

 

Experience designing and developing Oracle relational data models and generating related Database schemas

Required

5

Years

Experience with Logical and Physical Modeling within the last two years using ERwin 7.3

Required

5

Years

Experience with Modelmart Repository, Naming Standards File & Domain Class name applications

Required

5

Years

Experience designing relational data models

Required

5

Years

Experience with designing databases schemas on Oracle 11g

Required

1

Years

Experience using Microsoft Offce

Required

3

Years

2 years’ experience writing complex SQL queries and performing data analysis.

Highly desired

2

Years

At least 2 years’ experience with Oracle Version 11g

Highly desired

2

Years

1 year experience using Microsoft SharePoint.

Highly desired

1

Years

1 year experience using SCRUM Agile development methodologies

Highly desired

1

Years

1 year experience with Microsoft Team Foundation Server

Highly desired

1

Years

Excellent verbal communication skills (to be rated at onsite interview

Highly desired

 

 

Goals-oriented proactive team player with the ability to multi-task and prioritize technical tasks in a fast-paced, professional environment.

Highly desired

 

 

Bachelor’s degree or higher in Computer Science or related field

Highly desired