Database Administrator- Expert

Job description
Job Title: Database Administrator Expert

Location: Raleigh NC 27610 (Hybrid/Onsite)

Duration: 12 months contract

Summary:
Under the direction of a data architect this position will conduct data profiling data analysis data cleansing database design database implementation data conversion and data governance for the States DMV data.

Expected Skills:
• Able to work in a team environment as well as without assistance
• Can provide input and feedback to others
• Able to manage highly complex work efforts
• May have advanced education
• May have extensive industry experience

Job Description (including but not limited to):
• Data analysis and database management
• Designing of data dictionaries physical and logical database models and performance tuning
• Creation of requirements for database database schema data maps ERDs application objects (i.e. tables indexes views etc.)
• Creation of data rules to identify areas for data cleansing
• Conducting data profiling data analysis data cleansing database design database implementation data conversion and data governance for the States DMV data
• Understand data structures and schemas and implementing appropriate indexes

Skills and Experience Requirements:

Skill / Requirement

Required /Desired

Years of Experience

Able to create logical and physical models of data to represent relationships and ensure data integrity

Required

5 Years

Working knowledge of DB2 and SQL Server database management systems (DBMS)

Required

3 Years

Understanding of the process of extracting data from various sources transforming it and loading it into a database

Required

5 Years

Use of at least one data cleansing tool

Required

2 Years

Able to create and execute test cases

Required

5 Years

Able to identify and resolve issues within the data cleansing process

Highly desired

3 Years

Able to clearly communicate technical information to both technical and non-technical audiences

Highly desired

3 Years

Must meet deadlines and manage multiple streams of work

Required

5 Years

Able to dissect complex problems and derive insights from large datasets

Required

5 Years