What are the responsibilities and job description for the Database Administrator II (61036734) position at State of South Carolina?
Job Responsibilities
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.
Minimum And Additional Requirements
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.
Additional Comments
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.
Benefits For State Employees
The state of South Carolina offers eligible employees generous benefits, including health and dental insurance; retirement and savings plan options; and paid vacation and sick leave. Plus, work-life balance programs such as telecommuting and flexible work schedules are available to employees of some state agencies.
Insurance Benefits
Eligible employees may enroll in health insurance, which includes prescription coverage and wellness benefits. Other available insurance benefits include dental, vision, term life insurance, long term disability and flexible spending accounts for health and child care expenses.
Retirement Benefits
State employees are also offered retirement plan options, including defined benefit and defined contribution plans. Additionally, eligible employees may elect to participate in the South Carolina Deferred Compensation Program, which is a voluntary, supplemental retirement savings plan offering 401(k) and 457 plan options.
Workplace Benefits
State employees may also be eligible for other benefits, including tuition assistance; holiday, annual and sick leave; and discounts on purchases, travel and more.
Note: The benefits above are available to most state employees, with the exception of those in temporary positions. Employees in temporary grant and time-limited positions may be eligible for all, some or none of these benefits as benefits are associated with each position type. For these positions, contact the hiring agency to determine what benefits may be available.
01
Are you a current SCDOT employee? Your work experience with SCDOT should be reflected on the application in the work history section. Failure to accurately reflect work history may result in non-selection.
Are you a former SCDOT employee? Your work experience with SCDOT should be reflected on the application in the work history section. Failure to accurately reflect work history may result in non-selection.
Please indicate the highest level of education you have attained. If you have not completed high school, please indicate the highest grade you completed.
04
What class driver's license do you possess?
How did you find out about this vacancy at the South Carolina Department of Transportation? Please check all that apply.
If you selected "other" please explain how you found out about the vacancy at the South Carolina Department of Transportation.
07
If you were referred by a current SCDOT employee, what is their name?
08
I understand that I must complete the state application to include current and previous work history and education. A resume cannot be submitted for completed work history and education sections of the employment application. Only information contained within this application will be used to determine my qualifications for this position or for any other employment consideration should I be the selected candidate. I have read and acknowledged this statement.
My failure to accurately and completely describe my work experience may prevent my application from being forwarded to the hiring manager. I understand and acknowledge this statement.
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.
Minimum And Additional Requirements
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.
Additional Comments
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.
Benefits For State Employees
The state of South Carolina offers eligible employees generous benefits, including health and dental insurance; retirement and savings plan options; and paid vacation and sick leave. Plus, work-life balance programs such as telecommuting and flexible work schedules are available to employees of some state agencies.
Insurance Benefits
Eligible employees may enroll in health insurance, which includes prescription coverage and wellness benefits. Other available insurance benefits include dental, vision, term life insurance, long term disability and flexible spending accounts for health and child care expenses.
Retirement Benefits
State employees are also offered retirement plan options, including defined benefit and defined contribution plans. Additionally, eligible employees may elect to participate in the South Carolina Deferred Compensation Program, which is a voluntary, supplemental retirement savings plan offering 401(k) and 457 plan options.
Workplace Benefits
State employees may also be eligible for other benefits, including tuition assistance; holiday, annual and sick leave; and discounts on purchases, travel and more.
Note: The benefits above are available to most state employees, with the exception of those in temporary positions. Employees in temporary grant and time-limited positions may be eligible for all, some or none of these benefits as benefits are associated with each position type. For these positions, contact the hiring agency to determine what benefits may be available.
01
Are you a current SCDOT employee? Your work experience with SCDOT should be reflected on the application in the work history section. Failure to accurately reflect work history may result in non-selection.
- Yes
- No
Are you a former SCDOT employee? Your work experience with SCDOT should be reflected on the application in the work history section. Failure to accurately reflect work history may result in non-selection.
- Yes
- No
Please indicate the highest level of education you have attained. If you have not completed high school, please indicate the highest grade you completed.
04
What class driver's license do you possess?
- Class A (CDL)
- Class B (CDL)
- SC Class C
- SC Class D
- Other State Driver's License
- None
How did you find out about this vacancy at the South Carolina Department of Transportation? Please check all that apply.
- Job/Career Fair
- Referred by current SCDOT employee
- SCDOT presentation
- Sign or billboard
- Bumper sticker/magnetic sign
- Facebook or Twitter post
- Internship
- Newspaper Ad
- Radio Ad
- Television Ad
- Trade Journal
- Referred from Vocational Rehab
- Referred from Department of Employment and Workforce
- Jobs.SC.Gov webpage
- Other
If you selected "other" please explain how you found out about the vacancy at the South Carolina Department of Transportation.
07
If you were referred by a current SCDOT employee, what is their name?
08
I understand that I must complete the state application to include current and previous work history and education. A resume cannot be submitted for completed work history and education sections of the employment application. Only information contained within this application will be used to determine my qualifications for this position or for any other employment consideration should I be the selected candidate. I have read and acknowledged this statement.
- Yes
- No
My failure to accurately and completely describe my work experience may prevent my application from being forwarded to the hiring manager. I understand and acknowledge this statement.
- Yes
- No
- Required Question