Previous Job
Previous
CL - Database Developer (SQL) - Consultant
Ref No.: 18-29595
Location: Columbia, South Carolina
Start Date: 04/30/2018
 Remote Work Availability: 25%
 
Below mentioned VMS requirement:
Status New
Position # 8013-1
Position CL - Database Developer (SQL) - Consultant
Region  Name State of South Carolina- Department of Administration
Worksite Address Columbia, SC
Tenure End date will be fiscal year end of 6-30-2018.
This position will be extended into the next fiscal year
No. of Openings: 1 (INTERVIEW TYPE: Any Phone , Webcam & In-person)
Candidate Submission Limit Per Supplier: 2










 
Interview Process (phone, video or in-person, how many rounds of i/v's, etc)?
  • Hiring manager will conduct interviews via phone or in-person.
Interview Availability:  How soon can you schedule an interview (date / times)?
  • ONCE QUALIFIED CANDIDATES/RESUMES HAVE BEEN RECEIVED.
 
PUBLIC SECTOR/GOV'T EXPERIENCE REQUIRED?
  • YES

SKILL MATRIX
Category Skill Required Level Experience Candidate Experience Last Used
Administrative DBA Yes Lead 6 + Years    
Database Platforms MS SQL Yes Lead 6 + Years    
Database Platforms SQL Server Integration Services (SSIS) Yes Lead 6 + Years    
Development Tools SQL Yes Lead 6 + Years    
Miscellaneous Database Administration Yes Lead 6 + Years    
Packaged Applications MS Office (Word, Excel, PowerPoint, Visio) Yes Lead 6 + Years    
Programming Languages SQL Databases Yes Lead 6 + Years    
Programming Languages TRANSACT-SQL Yes Lead 6 + Years    
 
JOB DESCRIPTION: SCOPE OF THE PROJECT:SOUTH CAROLINA DEPARTMENT OF ADMINISTRATION'S (ADMIN) EXECUTIVE BUDGET OFFICE (EBO) PLANS TO HAVE ITS FISCAL YEAR BUDGET PLANNING, EXECUTION AUTOMATED USING INFORMATION TECHNOLOGY. CURRENTLY THE BUDGET PROCESS/WORKFLOW IS MORE MANUAL USING EXCEL SPREADSHEETS AND WORD DOCUMENTS. THERE ARE VARIOUS AGENCIES AND GOVERNMENT BODIES INVOLVED IN THE CREATION OF THE STATE BUDGET AND DATA COLLECTION, ADMINISTRATION, PROCESSING IS A TEDIOUS PROCESS. THIS PROJECT AIMS TO PROVIDE AUTOMATION TO THE BUDGETING PROCESS USING INFORMATION TECHNOLOGY.
 
DAILY DUTIES / RESPONSIBILITIES:
  • Identify the requirements for the following aspects of database support and management: applications, data security, data backup and retention, data archive and purge, and data recovery time objectives.
  • Create the database/database instance and tablespaces.
  • Provide first level Application DBA support for vendor supported applications running on database management servers.
  • Provide analysis and report on database performance trends and exceptions.
  • Recommend corrective action to resolve database performance and capacity problems.
  • requirements gathering
  • database architecture which includes the implementation of conceptual, logical and physical database models with experience in the creation of ER diagrams
  • schema design and development
  • t-SQL and stored procedure development and deployment with experience in database normalization
  • complex SSIS development and deployment
  • database code and system optimization
  • application troubleshooting
  • implementation of best security practices
  • bug tracking and resolution
 
REQUIRED SKILLS:
  • 5-8 years' experience as a SQL Server Application/Architect DBA
  • Advanced knowledge of database administration, Software Development Life Cycle (SDLC), and systems analysis procedures.
  • Must have the ability to work effectively with management, application developers and customers as necessary.
  • Must have excellent communication skills, a self-starter, and be able to work effectively with all audiences.
  • Must have experience working on Enterprise Applications, reporting to project managers, building code on time and according to specific technical requirements.
  • Must be able to give adequate time-tables for work scope.
  • Will need to work in conjunction with other Enterprise level DBA's to ensure standards are being followed for the purposes of architecture, security and best practices as well.
 
PREFERRED SKILLS:
  • Microsoft Certified Database Administrator (MCDBA)
  • .NET CODING
  • STRONG UNDERSTANDING OF DATA IMPORT, EXPORT, EDITING
  • REPORTING SERVICES; TO INCLUDE, MICROSOFT REPORTING SERVICES, BUSINESS OBJECTS, ETC.
  • MICROSOFT EXCEL ADVANCED USAGE
 
REQUIRED EDUCATION: Bachelor's Degree in a relevant field of work or equivalent work experience.