Please fill these Skills:


Category

Name

Required

Level

Last Used

Experience

Candidate`s Last Used

Candidate`s Experience


Database Platforms

backup/recovery

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

Database Upgrades

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

Load (ETL) tools

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

MS SQL Server 2008 R2

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

MS SQL Server 2012

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

Performance Tuning

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

SQL Server Analysis Services ( SSAS)

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

SQL Server Integration Services (SSIS)

Yes

Advanced

Currently Using

4 - 6 Years






Database Platforms

SQL Server Reporting Services (SSRS)

Yes

Advanced

Currently Using

4 - 6 Years














Complete 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.



Scope of Project: 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 2008/2012/2014). 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:
•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.
•Write and modify scripts & stored procedures (e.g.: SQL, PHP) for database access or reporting.
•Ability to efficiently problem solve and analyze a variety of problems, assess risks and implement solutions while adhering to security standards.
•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.
•Work with cross-functional teams to support customer requests as appropriate.
•Other database duties as assigned.
•Report progress weekly to management and project manager.