Job Title: SQL DBA (Only W2)

Location: Columbia, SC

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)

Skill Matrix:

• MS SQL Advanced 2 - 4 Years
• Performance Tuning Advanced 2 - 4 Years
• Relational Database Experience Advanced 2 - 4 Years
• Report and Dashboard development Advanced 2 - 4 Years
• SQL Server Advanced 2 - 4 Years
• SQL Server Integration Services (SSIS) Advanced 2 - 4 Years
• SQL Server tools: SSMS Advanced 2 - 4 Years
• SQL Tuning Advanced 2 - 4 Years
• Interpret business process and business data models Advanced 2 - 4 Years
• Data Warehousing Intermediate 2 - 4 Years

Additional Skills: Ability to understand requirements and a problem-solving attitude.

Job Types: Full-time, Contract

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Experience:

• MS SQL: 4 years (Preferred)
• Performance Tuning: 4 years (Preferred)
• Relational Database: 4 years (Preferred)
• SQL Server tools: SSMS: 4 years (Preferred)
• Report and Dashboard development: 4 years (Preferred)

Work Location: On the road

Please Note :
blog.nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, blog.nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.