What are the responsibilities and job description for the Senior Database Administrator position at State of South Carolina?
Job Responsibilities
About SLED
The South Carolina Law Enforcement Division (SLED) is a premier statewide law enforcement agency dedicated to serving and protecting the citizens of South Carolina. With a proud history rooted in integrity, professionalism, and public service, SLED is committed to providing high-quality investigative, intelligence, and forensic services to support law enforcement agencies across the state.
At SLED, we value dedication, ethical conduct, accountability, and a strong commitment to justice. Our agency plays a vital role in maintaining public safety and supporting criminal justice efforts at the local, state, and federal levels. From advanced forensic science to homeland security, criminal investigations, and criminal justice information systems, SLED's diverse responsibilities make it one of the most dynamic law enforcement agencies in the state.
We foster a professional work environment where teamwork, respect, and continuous improvement are fundamental. Our employees are held to the highest standards and are given opportunities to grow within a mission-driven organization that makes a meaningful difference in South Carolina communities.
Learn more about why you should join our team at www.sled.sc.gov.
General Responsibility
Administer the database management system for statewide client server information system. Advise the manager of application development on defining goals and objectives for the information system. Develop and maintain data standards, documentation, and security and authorization procedures.
Specific Duties
South Carolina Law Enforcement Division (SLED) is committed to providing equal employment opportunities to all applicants and does not discriminate on the basis of race, color, religion, sex (including pregnancy, childbirth, or related medical conditions, including, but not limited, to lactation), national origin, age (40 or older), disability or genetic information.
SLED offers an exceptional benefits package for FTE positions that includes:
Conditional selection based on candidate education, training, experience, oral interviews and clearance of background investigation.
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
Do you have a bachelor's degree? If yes, what is your area of study?
02
Do you have experience in systems development and maintenance, technical support, or the support of complex database management systems? If yes, please describe your experience.
03
I understand that this position may require non-standard work hours and overnight travel.
If offered the position, are you willing to accept a salary offer between $79,600 and $111,500?
As part of the application process, are you willing to submit to a background investigation to include: a criminal history check, driving record, history of drug use, employer and personal reference checks?
Have you ever used/experimented with any illegal drugs? If yes, provide name of drug and last date used.
07
Have you ever purchased or sold any illegal drugs? If yes, provide name of drug and date of action.
08
As a condition of employment, I understand that all sworn and non-sworn employees, including contract and temporary employees will be subject to random drug testing.
I understand that these supplemental questions are an official part of this application. Any attempt to misrepresent myself may be grounds for disqualification.
I have read each question carefully and affirm or attest that all questions answered are true and correct?
Will you need reasonable accommodations to participate in the selection procedures (e.g., interview, written tests, or job demonstrations)? If yes, contact the human resources office of the S.C. Law Enforcement Division.
How did you learn about this career opportunity? (Careers.SC.Gov; LinkedIn; Employee Referral; Career Fair; Direct E-Mail; Etc.) Please specify below.
About SLED
The South Carolina Law Enforcement Division (SLED) is a premier statewide law enforcement agency dedicated to serving and protecting the citizens of South Carolina. With a proud history rooted in integrity, professionalism, and public service, SLED is committed to providing high-quality investigative, intelligence, and forensic services to support law enforcement agencies across the state.
At SLED, we value dedication, ethical conduct, accountability, and a strong commitment to justice. Our agency plays a vital role in maintaining public safety and supporting criminal justice efforts at the local, state, and federal levels. From advanced forensic science to homeland security, criminal investigations, and criminal justice information systems, SLED's diverse responsibilities make it one of the most dynamic law enforcement agencies in the state.
We foster a professional work environment where teamwork, respect, and continuous improvement are fundamental. Our employees are held to the highest standards and are given opportunities to grow within a mission-driven organization that makes a meaningful difference in South Carolina communities.
Learn more about why you should join our team at www.sled.sc.gov.
General Responsibility
Administer the database management system for statewide client server information system. Advise the manager of application development on defining goals and objectives for the information system. Develop and maintain data standards, documentation, and security and authorization procedures.
Specific Duties
- Act as the database administrator. Maintain tables to ensure data integrity. Design and maintain physical data model for optimum use of resources, performance, and availability. Manage backups, data integrity, and ensure performance of indexes. Prepare and implement updates as well as test and implement new software to aid in the operation, performance and debugging of the database system.
- Provide ad hoc queries and modify data. Provide answers to infrequent or one time queries through SQL. Synchronize data records to maintain data integrity and to enforce new or modified business rules. Modify records through interactive SQL which cannot be fixed otherwise due to their complex nature and or inaccessibility through current applications.
- Design and maintain data server schemas. Work with the assistant database administrator, senior system analyst, and programmers to ensure database design supports application requirements and business rules.
- Train and supervise programming staff in utilizing database stored procedures. Install and maintain database management systems software.
- Maintain detailed documentation in implementing all responsibilities. Develop and maintain plans to implement use of emergency server, including transfer of data to and from tape backups.
- Perform other duties as required.
- A bachelor's degree in computer science, information systems or a related field and experience in systems development and maintenance, technical support, or the support of complex database management systems. Related experience may be substituted for the bachelor's degree on a year-for-year basis.
- A minimum of ten (10) years of experience in systems development and maintenance, technical support, or support of complex database management systems.
- Must have expert knowledge of database management systems, concepts and design methodologies.
- Must have knowledge of database structures, operating systems, data security, systems integrity and monitoring and auditing activities.
- Must be able to prepare and present technical and nontechnical reports in a clear and concise manner.
- Must be able to manager subordinate technical staff in the design and support of database management systems.
- This position may require non-standard work hours to support system outage or upgrades.
- This position may require overnight travel.
South Carolina Law Enforcement Division (SLED) is committed to providing equal employment opportunities to all applicants and does not discriminate on the basis of race, color, religion, sex (including pregnancy, childbirth, or related medical conditions, including, but not limited, to lactation), national origin, age (40 or older), disability or genetic information.
SLED offers an exceptional benefits package for FTE positions that includes:
- Health, Dental, Vision, Long Term Disability, and Life Insurance for Employee, Spouse, and Children
- 15 days annual (vacation) leave per year
- 15 days sick leave per year
- 13 paid holidays
- Paid Parental Leave
- State Retirement Plan and Deferred Compensation Programs
Conditional selection based on candidate education, training, experience, oral interviews and clearance of background investigation.
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
Do you have a bachelor's degree? If yes, what is your area of study?
02
Do you have experience in systems development and maintenance, technical support, or the support of complex database management systems? If yes, please describe your experience.
03
I understand that this position may require non-standard work hours and overnight travel.
- Yes
- No
If offered the position, are you willing to accept a salary offer between $79,600 and $111,500?
- Yes
- No
As part of the application process, are you willing to submit to a background investigation to include: a criminal history check, driving record, history of drug use, employer and personal reference checks?
- Yes
- No
Have you ever used/experimented with any illegal drugs? If yes, provide name of drug and last date used.
07
Have you ever purchased or sold any illegal drugs? If yes, provide name of drug and date of action.
08
As a condition of employment, I understand that all sworn and non-sworn employees, including contract and temporary employees will be subject to random drug testing.
- Yes
- No
I understand that these supplemental questions are an official part of this application. Any attempt to misrepresent myself may be grounds for disqualification.
- Yes
- No
I have read each question carefully and affirm or attest that all questions answered are true and correct?
- Yes
- No
Will you need reasonable accommodations to participate in the selection procedures (e.g., interview, written tests, or job demonstrations)? If yes, contact the human resources office of the S.C. Law Enforcement Division.
- Yes
- No
How did you learn about this career opportunity? (Careers.SC.Gov; LinkedIn; Employee Referral; Career Fair; Direct E-Mail; Etc.) Please specify below.
- Required Question
Salary : $79,600 - $111,500