RICEFW Technologies
MS SQL Database Developer - Fully Onsite in Columbia, SC
RICEFW Technologies, Columbia, South Carolina, us, 29228
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 DEVELOPERKNOWLEDGE OF SOFTWARE DEVELOPMENTHANDS ON EXPERIENCE WITH MSSQLDOCUMENTATION DEVELOPMENT
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):IN-DEPTH UNDERSTANDING OF DATA MANAGEMENT, DATABASE DESIGN, INTEGRATION, AND DATA WAREHOUSE DESIGNKNOWLEDGE OF INDUSTRY BEST PRACTICE AND TECHNIQUESABILITY 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)Additional Sills: Ability to understand requirements; has a problem solving attitude Skills:Category
Name
Required
Importance
Level
Last Used
ExperienceDatabase Platforms MS SQL Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms Performance Tuning Yes 4 Advanced Within 6 Months 2 - 4 Years Database Platforms Relational Database Experience Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms Report and Dashboard development Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms SQL Server Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms SQL Server tools: SSMS Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms SQL Tuning Yes 1 Advanced Within 6 Months 2 - 4 Years Miscellaneous Interpret business process and business data models Yes 1 Advanced Within 6 Months 2 - 4 Years Specialties Data Warehousing Yes 1 Intermediate Within 6 Months 2 - 4 Years
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 DEVELOPERKNOWLEDGE OF SOFTWARE DEVELOPMENTHANDS ON EXPERIENCE WITH MSSQLDOCUMENTATION DEVELOPMENT
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):IN-DEPTH UNDERSTANDING OF DATA MANAGEMENT, DATABASE DESIGN, INTEGRATION, AND DATA WAREHOUSE DESIGNKNOWLEDGE OF INDUSTRY BEST PRACTICE AND TECHNIQUESABILITY 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)Additional Sills: Ability to understand requirements; has a problem solving attitude Skills:Category
Name
Required
Importance
Level
Last Used
ExperienceDatabase Platforms MS SQL Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms Performance Tuning Yes 4 Advanced Within 6 Months 2 - 4 Years Database Platforms Relational Database Experience Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms Report and Dashboard development Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms SQL Server Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms SQL Server tools: SSMS Yes 1 Advanced Within 6 Months 2 - 4 Years Database Platforms SQL Tuning Yes 1 Advanced Within 6 Months 2 - 4 Years Miscellaneous Interpret business process and business data models Yes 1 Advanced Within 6 Months 2 - 4 Years Specialties Data Warehousing Yes 1 Intermediate Within 6 Months 2 - 4 Years