SQL Database Developer

SQL Database Developer - State of South carolina-Department of transporatation-SCDOT

Only W2(Green Card/ US Citizen)

Hourly rate $60/hr W2

Job Description

SCOPE OF THE PROJECT

RE-DEVELOPMENT AND INTEGRATION OF MULTIPLE DATABASE SYSTEMS SERVING INTERFACING BETWEEN THE AGENCY PERSONNEL INFORMATION SYSTEM, CLOUD HOSTED ENTERPRISE ASSET MANAGEMENT SYSTEM, AND VARIOUS INTERNAL SYSTEMS AND APPLICATIONS. PRIMARY FOCUS WILL BE TO DEVELOP QUERIES, PROCEDURES, AND FUNCTIONS WITHIN IN THE DATABASE INTERFACING WITH THE STATE ERP SYSTEM AND SCDOT SYSTEMS AND APPLICATIONS. SECONDARY FOCUS WILL BE ESTABLISHING THE FOUNDATION FOR A DATA WAREHOUSE. POSITION IS ONSITE.

DAILY DUTIES / RESPONSIBILITIES

DESIGN STABLE, RELIABLE AND EFFECTIVE DATABASES. MODIFY DATABASES ACCORDING TO REQUESTS, FOLLOW INDUSTRY STANDARDS, BEST PRACTICES AND USE COMMON PRACTICES AND TECHNIQUES. CREATE AND MAINTAIN ACCURATE DOCUMENTATION AND DESIGN DIAGRAMS, ENSURE DATABASE PROGRAMS MEET AGENCY AND PERFORMANCE REQUIREMENTS, RESEARCH AND PROVIDE RECOMMENDATIONS FOR DATABASE DESIGN AND FEATURE IMPLEMENTATION.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE)

PROVEN SKILLS AS A DATABASE DEVELOPER

KNOWLEDGE OF SOFTWARE DEVELOPMENT

HANDS ON EXPERIENCE WITH MSSQL

DOCUMENTATION DEVELOPMENT

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE)

IN-DEPTH UNDERSTANDING OF DATA MANAGEMENT, DATABASE DESIGN, INTEGRATION, AND DATA WAREHOUSE DESIGN

KNOWLEDGE OF INDUSTRY BEST PRACTICE AND TECHNIQUES

ABILITY TO UNDERSTAND REQUIREMENTS AND A PROBLEM-SOLVING ATTITUDE

REQUIRED EDUCATION/CERTIFICATIONS

BS DEGREE IN COMPUTER SCIENCE OR RELEVANT WORK EXPERIENCE IN FIELD

PREFERRED EDUCATION/CERTIFICATIONS

MICROSOFT CERTIFIED SOLUTIONS ASSOCIATE (MCSA)

MICROSOFT CERTIFIED SOLUTIONS EXPERT (MCSE)

Share resume to sam@miraclezit(dot)com

All your information will be kept confidential according to EEO guidelines.