Database Administrator

South Carolina Department of Juvenile Justice

Columbia (SC)

On-site

USD 90,000 - 130,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

South Carolina Department of Juvenile Justice seeks a Database Administrator to develop, administer, and optimize the agency's enterprise data platform using Snowflake or similar cloud tech. You will design data pipelines, support modernization, and provide governance across systems.

Collaboration with IT staff and vendors is essential. You will manage database security, performance, and reliability, while developing schemas, ETL processes, and documentation for enterprise reporting and

Qualifications

  • Bachelor's degree or equivalent; year-for-year substitution allowed.
  • Knowledge of database administration and data architecture.
  • Strong SQL Server expertise, SQL development, and backups/recovery.
  • Experience with Azure, Snowflake, data lakes/warehouses.
  • Data modeling, normalization, and ER design.
  • Data integration and ETL/ELT development.
  • Data governance, metadata management, and data dictionaries.

Responsibilities

  • Administers, maintains, and monitors agency database systems for reliability and security.
  • Performs upgrades, maintenance, troubleshooting, tuning, backups, and recovery.
  • Identifies and resolves database issues affecting applications.
  • Designs and maintains database structures supporting apps and operations.
  • Establishes standards, models data, creates schemas, and ensures integrity.
  • Supports modernization through architectural improvements and recommendations.
  • Collaborates with developers, vendors, and stakeholders for data integration.
  • Develops SQL queries, stored procedures, views, and objects.
  • Assists with data migration, interfaces, and new tech implementations.
  • Implements and maintains security controls and data protection.
  • Maintains data dictionaries, documentation, and data quality standards.
  • Ensures practices comply with security policies and regulations.

Skills

Database administration
SQL Server
Data modeling
ETL/ELT
Data governance
Data integration
Cloud data platforms
Data security

Education

Bachelor's degree in CS/IS or related field

Tools

Azure
Snowflake

Job description

Job Responsibilities

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.

Job Responsibilities

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.

Job Purpose

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.

Job Responsibilities
  • 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.
Minimum And Additional Requirements

Performs other related job duties as required or assigned.

State Minimum 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.

Additional Comments
  • 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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator
Database Administrator

Doc PersonalBeratung GmbH • Columbia (SC)

On-site
USD 80,000 - 110,000
Public Service Loan Forgiveness
Health, dental, life insurance
Database Administrator
Database Administrator

Doc PersonalBeratung GmbH • South Carolina

On-site
USD 90,000 - 120,000
Public Service Loan Forgiveness
EAP
Health, dental, and life insurance
+4
IT Help Desk Specialist
IT Help Desk Specialist

South Carolina Department of Juvenile Justice • Columbia (SC)

On-site
USD 45,000 - 60,000
Public Service Loan Forgiveness (PSLF)
Employee Assistance Program (EAP)
Health, dental, life insurance
+5
IT Help Desk Specialist
IT Help Desk Specialist

Doc PersonalBeratung GmbH • South Carolina

On-site
USD 42,000 - 70,000
Public Service Loan Forgiveness
Employee Assistance Program (EAP)
Health, dental, and life insurance
+4
IT Help Desk Specialist
IT Help Desk Specialist

State-of-South-Carolina • South Carolina

On-site
USD 40,000 - 65,000
Public Service Loan Forgiveness
Employee Assistance Program (EAP)
Health, dental, and life insurance
+5
Sergeant - MEDC
Sergeant - MEDC

South Carolina Department of Juvenile Justice • Columbia (SC)

On-site
USD 42,000 - 54,000
Health insurance
Dental insurance
Life insurance
+2
Desktop & Network Support Manager
Desktop & Network Support Manager

State-of-South-Carolina • South Carolina

On-site
USD 70,000 - 100,000
Public Service Loan ForgivenessProgram
Employee Assistance Program (EAP)
Health, dental, and life insurance
+4
Community Services Supervisor - Lexington County
Community Services Supervisor - Lexington County

Doc PersonalBeratung GmbH • West Columbia (SC)

On-site
USD 48,000 - 72,000
Public Service Loan ForgivenessProgram
Employee Assistance Program (EAP)
Health, dental, and life insurance
+4
Lieutenant - MEDC
Lieutenant - MEDC

Doc PersonalBeratung GmbH • South Carolina

On-site
USD 65,000 - 80,000
Youth Engagement Coordinator - JDC
Youth Engagement Coordinator - JDC

South Carolina Department of Juvenile Justice • Columbia (SC)

On-site
USD 38,000 - 52,000
Public Service Loan Forgiveness
Employee Assistance Program (EAP)
Health, dental, and life insurance
+4