Database Administrator
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+26 more
Job description
If your goal is to build a career that makes a difference and you have a passion for making a difference in the lives of South Carolinaβs youth, consider joining the dedicated people of the South Carolina Department of Juvenile Justice (DJJ). MISSION: It is the mission of the South Carolina Department of Juvenile Justice (DJJ) to impact and transform young lives, strengthen families, and support safer communities through targeted prevention and rehabilitation., The Database Administrator is responsible for developing, administering, and optimizing the agencyβs enterprise data platform, including Snowflake or similar cloud technologies. Designs and maintains data pipelines, integrations, transformations, and automation supporting enterprise reporting and business operations. Provides database administration and technical support for existing agency-managed databases during modernization and ongoing support for any remaining systems. Provides technical expertise in database architecture, design, data integration, and governance. Collaborates with IT staff, vendors, and agency stakeholders to support application development, system modernization, and the effective management and exchange of agency data., Administers, maintains, and monitors agency database systems to ensure reliability, availability, security, and optimal performance.
Performs database upgrades, maintenance, troubleshooting, performance tuning, backup verification, and recovery operations.
Identifies and resolves database-related issues affecting agency applications.
Designs, develops, and maintains database structures supporting agency applications and business operations.
Establishes database standards, performs data modeling and normalization, develops schemas, and ensures data integrity.
Supports application modernization initiatives through database architecture improvements and technical recommendations.
Collaborates with application developers, vendors, and agency stakeholders to support data integration between agency systems.
Develops and maintains SQL queries, stored procedures, views, and other database objects.
Assists with data migration, system interfaces, troubleshooting, and implementation of new applications and technologies.
Implements and maintains database security controls, access permissions, auditing, and data protection measures.
Establishes and maintains data dictionaries, documentation, and data quality standards.
Ensures database practices comply with agency security policies, confidentiality requirements, and applicable regulations.
Supports and maintains business automation systems and agency applications, including bug fixes and updates based on process changes, etc.
Provides technical expertise and recommendations for database-related projects, technology investments, and long-term planning.
Develops and maintains technical documentation, operating procedures, and automated maintenance processes.
Works with IT staff and management to evaluate database technologies, improve operational efficiency, and support business continuity and disaster recovery planning.
Performs other related job duties as required or assigned. Minimum and Additional Requirements
Requirements
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 substitute for the bachelorβs degree on a year-for-year basis. ADDITIONAL REQUIREMENTS:
Requires knowledge of database administration, relational database design, data modeling, normalization, and data architecture.
Strong proficiency in Microsoft SQL Server, SQL development, stored procedures, performance tuning, database security, backup, and recovery procedures.
Knowledge of modern data platforms and technologies such as Microsoft Azure, Snowflake, data lakes, data warehouses, and cloud-based database solutions.
Understanding of conceptual, logical, and physical data modeling, including the development of entity relationships, data schemas, and enterprise data architectures.
Skills in data integration, ETL/ELT processes, data transformation, and the development of interfaces between enterprise applications.
Familiarity with data governance, data quality management, metadata management, data dictionaries, and master data management principles.
Knowledge, skills, and abilities are ultimately determined by verifiable work history, references, and interview.
Employee must be able to work in an environment with incarcerated youth.
This position performs job duties relating to the custody, control, transportation, or recapture of youth within the jurisdiction of the Department of Juvenile Justice and the employee may have direct and indirect contact with youth within the jurisdiction of the Department of Juvenile Justice. Training applicable to these duties will be provided. Preferred Qualifications PREFERRED AGENCY REQUIREMENTS: 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 substitute for the bachelorβs degree on a year-for-year basis. Experience with relational database management systems, preferably Microsoft SQL Server, including SQL development, database design, data modeling, normalization, performance optimization, and database security., You will be asked to provide a certified transcript if selected for a position requiring a degree. A background investigation will be conducted that may include but is not limited to, criminal records, driverβs license, and child abuse registry prior to an offer of employment. Additionally, a medical examination and drug testing may be required. Please provide an explanation for any gaps in employment. A resume may be attached to your application but not substituted for completing the work history section of the application.
Benefits & conditions
The South Carolina Department of Juvenile Justice offers an exceptional benefits package for FTE positions that includes:
- Public Service Loan Forgiveness Program
- Employee Assistance Program (EAP)
- Health, dental, and life insurance
- 15 days annual (vacation) leave per year
- 15 days of sick leave per year
- 13 paid holidays
- State retirement plans and deferred compensation programs
- Discount Programs such as TicketatWork and WeSave, 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
I understand that the South Carolina Department of Juvenile Justice is an equal opportunity employer. DJJ does not discriminate in hiring, promotions, discharge, pay, fringe benefits, job training, classification, referral, or other employment aspects based on race, color, religion, sex, disability, or national origin. Any acts you feel are in violation, please get in touch with the Office of Human Resources, 220 Executive Center Drive, Columbia, SC .
- Yes
- No
02
I understand that the South Carolina Department of Juvenile Justiceβs School District also does not discriminate in any programs or activities based on race, color, national origin, sex, disability, or age. The following offices have been designated to handle inquiries regarding the school districtβs nondiscrimination policies: Title IX - Inspector Generalβs Office - 220 Executive Center Drive, Columbia, SC 29210-5427 - Ph: ; Special Education Office, 220 Executive Center Drive, Columbia, SC I have read and fully understand DJJβs position concerning the law.
- Yes
- No
03
I understand that SCDJJ will not hire or promote anyone who may have contact with residents and shall not enlist the services of any contractor who may have contact with residents who have engaged in sexual abuse in a prison, jail, lockup, community confinement facility juvenile facility, or other institution (as defined in 42 U.S.C. 1997); has been convicted of engaging in sexual activity in the community facilitated by force, overt or implied threats of force, or coercion, or if the victim did not consent or was unable to consent or refuse; or has been civilly or administratively adjudicated to have engaged in the activity described above.
- Yes
- No
04
I understand that my fingerprint record received from the FBI and SLED must indicate no felony convictions as a condition of employment.
- Yes
- No
05
I certify that I have not been convicted of any criminal offenses that carries a sentence of 1 year or more or any criminal offenses that involves moral turpitude (an act contrary to the accepted rule of right and duty to man and society). Forfeiture of bond, a guilty plea, or plea of nolo contendere is considered the equivalent of a conviction.
- Yes
- No
06
Have you or any members of your family ever been a victim of a crime committed by a juvenile who is currently under the supervision of SCDJJ? If yes, type in βYesβ and give your last name of the juvenile, date, and location of trial. If no, please type βNoβ. 07
Do you currently or have you ever worked in or have been professionally associated with a prison, jail, lock, community confinement facility, juvenile facility or other institution as defined in 42 U.S.C. 1997?
- Yes
- No
08
If you answered βYesβ to the previous question, please list the institution(s) and your date(s) of employment. 09
Do you have a valid driverβs license?
- Yes
- No
10
Are you at least 21 years of age?
- Yes
- No
11
Will you now or in the future require sponsorship to work in the U.S.?
- Yes
- No
12
Are you currently employed or have you previously been employed with SCDJJ?
- Yes
- No
13
Are you able to perform the essential job functions with or without a reasonable accommodation?
- Yes
- No
14
How did you hear about this position?
- Government Website (careers.sc.gov)
- Career Fair
- Indeed.com
- SC Works
- DJJ Employee
- Other
15
If you answered βDJJ Employeeβ to the previous question please list employeeβs name. 16
If you answered βOtherβ to the previous question, please tell us how you learned of this position. 17
Do you have 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?
- Yes
- No
18
I understand that any misrepresentation, omission of facts, or otherwise falsification on this application and attachments will result in disapproval of this application or termination of employment.
- Yes
- No
19
Please provide us with two (2) references. One (1) professional reference and one (1) personal reference (non-family member). Please list name(s), phone number(s), and email address(es). Required Question
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦