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.