What are the responsibilities and job description for the Senior Database Administrator position at State of South Carolina?
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
Supplemental questions are considered part of the official application. Any misrepresentation of yourself may be grounds for disqualification.
Conditional selection based on candidate education, training, experience, oral interviews and clearance of background investigation.
Salary : $79,600 - $111,500