Overview
On Site
$Open
Full Time
Part Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 1 year
100% Travel
Skills
Database Administration
Performance Tuning
Data Profiling
Data Analysis
Database Design
Data Conversion
Data Governance
DMV
Data Structure
Data Integrity
IBM DB2
Microsoft SQL Server
Database
Test Cases
Data Cleansing
Management
Streaming
Outsourcing
Technical Direction
Job Details
NEED DATA BASE ADMINISTRATOR OR ENGINEER WHO NEED TO BE LOCAL CANDIDATE AND CAN DO INPERSON INTERVIEW AT CLIENT LOCATION
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 State's DMV data.
Typical Experience: 84+ months
Role Types: Database Analyst, Database Programmer
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.
Description (including, but not limited to):
1. Data analysis and database management
2. Designing of data dictionaries, physical and logical database models, and performance tuning
3. Creation of requirements for database, database schema, data maps, ERDs, application objects (i.e., tables, indexes, views, etc.)
4. Creation of data rules to identify areas for data cleansing
5. Conducting data profiling, data analysis, data cleansing, database design, database implementation, data conversion, and data governance for the State's DMV data
Required/Desired Skills Typical Experience: 84+ months
Role Types: Database Analyst, Database Programmer
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.
Description (including, but not limited to):
1. Data analysis and database management
2. Designing of data dictionaries, physical and logical database models, and performance tuning
3. Creation of requirements for database, database schema, data maps, ERDs, application objects (i.e., tables, indexes, views, etc.)
4. Creation of data rules to identify areas for data cleansing
5. Conducting data profiling, data analysis, data cleansing, database design, database implementation, data conversion, and data governance for the State's DMV data
| Skill | Required /Desired | Amount | of Experience |
|---|---|---|---|
| Understand data structures and schemas, and implementing appropriate indexes | Required | 3 | Years |
| 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 | Highly desired | 3 | Years |
| No. | Question |
|---|---|
| Question1 | All work must be completed on-site. Do you agree to this requirement? |
| Question2 | Your candidate must be able to attend an in-person interview. Do you agree to this requirement? |
| Question3 | What is your candidate's email address? |
| Question4 | Vendors must disclose to the agency if the candidate will be subcontracted at the time of submission. Is your candidate an employee of your company or a subcontractor? Please be sure to notify a CAI Account Manager if your candidate's employee status changes. |
| Question5 | Vendors must notify the agency if any portion of the requirements listed in this task order will be outsourced to other countries. Do you anticipate outsourcing any work being done for this assignment to another country? |
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.