Previous Job
Previous
Database Administrator
Ref No.: 17-01682
Location: COLUMBIA, South Carolina
Client: Education Department
Work Location: COLUMBIA, SC
Duration: 12 Months


Job Description:
Mandatory Qualifications:
his posting should be for 12 months, vice 6.
 
Scope of the Project: The SC Department of Education has several projects currently running and ongoing operational work that have an immediate need for a Database Administrator with a background in SQL Server technologies (SQL Server 2008/2012/2014/2016) and SSIS and MS SQL. This position is responsible for working with SCDE's Data Management team to review and assess the quality of data, and to work with data warehouses. Prepare large and small data sets for research and evaluations.
 
Daily Duties / Responsibilities:
1.            Development and maintenance of database procedures, reports, and automated jobs. Enhancement of existing database functions based on new/changing business requirements.
2.            Report, research, correct, and test defects in reports, stored procedures, and other database related functions. Accurately translate business requirements into functional implementations.
3.            Evaluate data quality in databases and across the data warehouse as well as against the extract, transfer, and load (ETL) workflow. Identify, analyze, and interpret trends or patterns in complex data sets. Design, document, maintain, execute system tests and requirements around data and data quality.
4.            Identify and leverage opportunities to improve data management processes, systems, and standards.
5.            Other duties as assigned.
6.            Report progress weekly to management and project manager.
 
Required Skills (Rank in order of importance):
  • SQL server experience
  • Backup / recovery operation
  • Database planning and design
  • Database monitoring / performance tuning
  • Load balancing
  • Database upgrading
  • REDGATE toolsets
 
Preferred Skills (rank in order of importance):
  • Familiarization with SQL tool sets
  • SharePoint server knowledge
  • SQL reporting service
 
Preferred Education/Certifications:
  • MCA, MCSA, MCSE
 
Skill Set
Category Name Required Importance Level Last Used Experience Candidate Experience Candidate Last Used
Database Platforms backup/recovery Yes 1 Intermediate Currently Using 2 - 4 Years    
Database Platforms Load Balancing Yes 2 Intermediate Currently Using      
Database Platforms MS SQL Server 2008 R2 Yes 2 Intermediate Currently Using 2 - 4 Years    
Database Platforms MS SQL Server 2012 Yes 1 Intermediate Currently Using 2 - 4 Years    
Database Platforms Performance Tuning Yes 2 Intermediate Currently Using 2 - 4 Years    
Database Platforms RedGate Toolset Yes 3 Intermediate Within 6 Months 1 - 2 Years    
Database Platforms SQL Server Yes 1 Intermediate Currently Using 2 - 4 Years    
Database Platforms SQL Tuning Yes 3 Intermediate Within 6 Months 2 - 4 Years    
Database Platforms SharePoint Server 2013 No 8 Entry Within 1 Year < 1 Year    
Database Platforms SQL Server Reporting Services (SSRS) No 6 Intermediate Within 6 Months 1 - 2 Years    
Database Platforms SQL Server tools: SSCM No 8 Entry Within 1 Year 1 - 2 Years    
Database Platforms SQL Server tools: SSMS No 7 Entry Within 1 Year < 1 Year    
Development Tools SQL Yes 1 Intermediate Currently Using 2 - 4 Years    
Programming Languages SQL Databases Yes 1 Intermediate Currently Using 2 - 4 Years