Job ID :
6420
Company :
State of Ohio
Location :
COLUMBUS, OH
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
09 Feb 2015
Job Seekers, Please send resumes to resumes@hireitpeople.com

 

Complete Description:

DOT has a need for a resource with data analyst skills for this position.   The position will be 75% data analysis and 25% DBA.  The successful candidate will have solid experience in the data analysis side working with Business requirements, leading discovery for functional and non functional requirements, utilizing word , visio , powerpoint and excel as tools.       The resource will be working with the business users to determine what data they have, how is it formated , where do they obtain the data.  The resource will also analyze the current data in the enterprise, determine any similarities, links or if the data is the same.       They will be writing SQL statements and scripts, schemas, data diagrams.    The successful candidate will know how to write requirements, entity relationship diagrams, data normalization, They use Word and Visio for documentation.  DOT databases: Oracle, Sybase, MS SQL.   They use PowerDesigner.   

The

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.

 

Years of Relevant Experience:

7 plus years

Preferred Education:

4 year college degree or equivalent technical study

Role Description:

•Participates in Database Management System selection and maintains database performance.

•Knowledge of various Database Management System products.

•Provide status of work to Project Team Lead.

•Engage in ongoing process improvement.

 

Skills:

Skill

Required / Desired

Amount

of Experience

Experience working with Business users determining data/requirements needs and documentation

Required

7

Years

Logical and Technical experience , able to "see the big picture", data archtecture experience

Highly desired

7

Years

Experience in various data modeling tools

Highly desired

7

Years

Experience building complex queries and ETL processes

Highly desired

7

Years

Excellent documentation skills in Word,Visio

Required

7

Years

Experience with analysis of complex database structures and releated interfaces

Required

4

Years

Experience with enterprise databases

Required

5

Years

Excellent interpersonal skills

Required

 

 

Experience with Oracle, Sybase and MS SQL

Required

5

Years

Experience in leading discovery sessions to gather requirements

Required

7

Years

Experience in writing functional and non functional requirements

Required

7

Years

Excellent communication both oral and written

Required

7

Years