Database Administrator II (61036734)

State of South Carolina; Columbia (SC); Presencial; USD 75.000 - 110.000; Jornada completa

Descripción de la vacante

The State of South Carolina is seeking a SQL Database Administrator to manage the department's SQL database and server environment, including the design, development and security of SQL servers and applications. You will administer SQL Reporting Services, IIS, backup/restoration processes, and provide VMware-based development and test environments for applications.

A bachelor’s degree and 3 years of relevant experience are required.

Formación

• Bachelor's degree in computer science, information systems or a related field with 3 years of experience in systems development or database management.
• Experience administering SQL databases and ensuring integrity and security.
• Experience with SQL Server Reporting Services and IIS.
• Ability to deploy client developer tools in VMware environments.

Responsabilidades

• Design, deploy, and support SQL databases and applications.
• Manage SQL Reporting Services Server design and deployment.
• Maintain backup/restoration processes for data integrity.
• Provide development environment support and VMware server deployments.
• Administer IIS servers and apply security patches.
• Support third-party vendor server applications.

Conocimientos

SQL Database Administration

SQL Server

Server management

VMware

IIS

Security and backups

Educación

Bachelor's degree in computer science or related field

Herramientas

SQL Server

SQL Reporting Services

IIS

VMware

Descripción del empleo

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