Database Administrator II (61036734)

State-of-South-Carolina; South Carolina; On-site; USD 70,000 - 100,000; Full time

Job summary

The South Carolina Department of Transportation seeks a dedicated SQL Database Administrator to lead the design, deployment, and ongoing support of SQL servers and related applications. You will oversee backup/restore, security, and data integrity across production, test, and development environments.

Responsibilities include managing SQL Reporting Services, IIS servers, and vendor applications, plus providing technical support to developers.

Qualifications

• Bachelor's degree in computer science, information systems or a related field and three (3) years of experience in systems development and maintenance, technical support or the support of complex database management systems, or an approved acceptable equivalence in accordance with State Human Resources Regulations.

Responsibilities

• Administers SCDOT's SQL database and server environments, including design, development and support of SQL servers and applications.
• Administers SQL Reporting Services Server: design, deployment and support.
• Manages SQL data backup/restoration and ensures data integrity and security.

Skills

SQL Server administration

Backup & restore

IIS administration

VMware

Technical support

Education

Bachelor's degree in computer science or information systems

Tools

VMware

SQL development tools

Job description

Acts as primary administrator for SCDOT's SQL database and server environment. This includes the design, development and support of all SQL servers and applications. Installs and configures SQL databases and ensures database integrity and security.

Acts as primary administrator for SQL Reporting Services Server. This includes the design, deployment and support of SQL Reporting Services Server.

Acts as primary administrator for SCDOT's SQL data backup/restoration environment. This includes using SQL utilities to manage backup data and logs to ensure data integrity, backup and restoration.

Acts as primary administrator to provide SQL development environment and support for SCDOT's applications development staff. This includes deploying and maintaining a test/dev/production server environment and deploying client developer tools on clients PC in a VMware environment.

Acts as an administrator of SCDOT's Internet Information Server environment. This includes the design, deployment and support of all IIS servers. Installs and configures IIS and ensure database integrity, security and backup. Ensures that all available security patches are applied to all servers.

Acts as an administrator of SCDOT's 3rd party vendor server applications. This includes the design, deployment and support of vendor servers and applications. Ensures that all available security patches are applied to all servers.

Provides technical support to SCDOT and third-party applications developers. This includes assistance with problem diagnosis and resolution of SQL databases and applications. This includes the installation and support of SQL development tools including client software.

Performs other related duties as assigned.

A bachelor's degree in computer science, information systems or a related field and three (3) years of experience in systems development and maintenance, technical support or the support of complex database management systems, or an approved acceptable equivalence in accordance with State Human Resources Regulations. A valid motor vehicle operator's license is required.

The physical demands for the essential functions includes sitting or standing at a desk for an extended periods and working on a computer. May be required to lift up to 30 lbs. May be required to work outside normal business hours.

The South Carolina Department of Transportation is committed to a diverse workforce and does not discriminate on the basis of race, color, religion, sex (including pregnancy), national origin, age (40 or older), disability or genetic information.