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