Verified Job
IT / Software / Data Analyst
Database Administrator- Expert
IT / Software / Data Analyst
#629875
Remote / WFH
Job Description
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
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
