OnSite/local SQL Server DBA/Developer (MCSA/MCSE) with Data Warehouse, Tuning, SSIS, SSMS, data modeling experience

Job ID: BL-10853-1 (98790612)

OnSite/local SQL Server DBA/Developer (MCSA/MCSE) with Data Warehouse, Tuning, SSIS, SSMS, data modeling experience

Location: Columbia, SC
Duration: 12+ Months Hrs/Wk: 40.00
Remote Work Availability: 0%

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)

Database Platforms MS SQL No 1 Advanced Within 6 Months 2 – 4 Years
Database Platforms Performance Tuning No 4 Advanced Within 6 Months 2 – 4 Years
Database Platforms Relational Database Experience No 1 Advanced Within 6 Months 2 – 4 Years
Database Platforms Report and Dashboard development No 1 Advanced Within 6 Months 2 – 4 Years
Database Platforms SQL Server No 1 Advanced Within 6 Months 2 – 4 Years
Database Platforms SQL Server tools: SSMS No 1 Advanced Within 6 Months 2 – 4 Years
Database Platforms SQL Tuning No 1 Advanced Within 6 Months 2 – 4 Years
Miscellaneous Interpret business process and business data models No 1 Advanced Within 6 Months 2 – 4 Years
Specialties Data Warehousing No 1 Intermediate Within 6 Months 2 – 4 Years

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.

Leave a Reply

Search

Categories

Archives

Tags

There’s no content to show here yet.

Discover more from innoSoul:

Subscribe now to keep reading and get access to the full archive.

Continue reading