SQL Server Admin

  • Raleigh, NC
  • Posted 12 hours ago | Updated 12 hours ago

Overview

On Site
Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required
Able to Provide Sponsorship

Skills

DB2/SQL Server Admin/DBA with DBMS
test cases
data conversion and ERDs
DMV
Data Analysis
Data Conversion
Data Governance
Data Integrity
Data Profiling
Data Structure
Database Administration
Database Design
IBM DB2
Management
Microsoft SQL Server
Database
Performance Tuning
Streaming
Data Cleansing

Job Details

Job ID: NC-0721)

Hybrid/Local DB2/SQL Server Admin/DBA with DBMS, test cases, data conversion and ERDs experience

Location: Raleigh, NC (NCDOT)
Duration: 12 Months
Interview Type: Either Webcam or In Person Interview

Skills:
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

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.
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

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.