Previous Job
Previous
Database Administrator
Ref No.: 16-00396
Location: Columbia, South Carolina
Client: Education Department
Location: Columbia,SC
Duration: 2 Months


Job Description:
Job Description: Manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.

The SC Department of Education has several projects currently running and ongoing operational work that have an immediate need for a Database Administrator (DBA) with a background in SQL Server technologies (SQL Server 2005/2008/2012). This position is responsible for working in test and production environments, building, upgrading, and configuring databases. Create, configure and maintain SQL jobs, troubleshoot the interaction of web-based and Windows applications and reports. Execute ad-hoc queries and generate reports for users in a timely manner. Collaborate with team members to create and modify stored procedures associated with applications and reports.

DAILY DUTIES / RESPONSIBILITIES:

1. Design, build, implement, secure and maintain databases for development, test and production environments. Work with SCDE team to identify and analyze performance bottlenecks and recommend solutions.
2. Write and modify scripts & stored procedures (e.g.: SQL, PHP) for database access or reporting.
3. Ability to efficiently problem solve and analyze a variety of problems, assess risks and implement solutions while adhering to security standards.
4. Participate in cross-training activities to achieve a comfort level supporting SCDE data collection servers, as well as cross-train other team members on DBA responsibilities.
5. Work with cross-functional teams to support customer requests as appropriate.
6. Other database duties as assigned.
7. Report progress weekly to management and project manager.
Skills  
Skills:
Category
Name
Required
Importance
Level
Last Used
Experience
Database Platforms backup/recovery Yes 1 Advanced Currently Using 4 - 6 Years  
Database Platforms Database Upgrades Yes 2 Intermediate Currently Using 2 - 4 Years  
Database Platforms Load (ETL) tools Yes 1 Advanced Currently Using 4 - 6 Years  
Database Platforms Load Balancing Yes 1 Advanced Currently Using 4 - 6 Years  
Database Platforms MS SQL Server 2008 R2 Yes 1 Advanced Currently Using 4 - 6 Years  
Database Platforms MS SQL Server 2012 Yes 1 Advanced Currently Using 4 - 6 Years  
Database Platforms SQL Server Analysis Services ( SSAS) Yes 2 Intermediate Currently Using 2 - 4 Years  
Database Platforms SQL Server Integration Services (SSIS) Yes 1 Advanced Currently Using 4 - 6 Years  
Database Platforms SQL Server Reporting Services (SSRS) Yes 2 Intermediate Currently Using 2 - 4 Years  
Database Platforms SQL Tuning Yes 1 Advanced Currently Using 4 - 6 Years  
Database Platforms Understanding of database scalability and operations Yes 1 Advanced Currently Using 4 - 6 Years  
Additional Skills: