Overview
Skills
Job Details
Title: Database Administrator Expert - Hybrid
Mandatory skills:
Data analysis, database management,
data dictionaries, physical database models, logical database models, performance tuning,
database, database schema, data maps, ERDs, application objects, tables, indexes, views,
data cleansing, data rules, data cleansing tool, data cleansing process,
data profiling, data analysis, data cleansing, database design, database implementation, data conversion, data governance,
data structures, data schemas, data integrity, datasets,
DB2, SQL Server database management systems, DBMS,
extracting data, sources, transforming it, loading it, test cases
Description:
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 client 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):
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 client 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
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.
Contact Details :
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008