Apply on Employer Site

State of South Carolina · 2 weeks ago

Database Solutions Engineer (Database Administrator I) - 61079663

Lexington County, SC

Full-time

Hybrid

New Grad, Entry Level

State of South Carolina is looking for a Database Solutions Engineer to support the Department of Education's database management systems. The role involves designing, developing, and maintaining database systems, as well as assisting in data collection processes and ensuring data integrity.

Government

Responsibilities

Maintain and upgrade existing database systems

Assist the team of DBA’s in ongoing and project tasks

Develop, test, implement and maintain data collection processes and data transfer processes (e.g., ETL, data exports and imports, etc.)

Perform data validation, integrity checking, encryption, decryption, and reformatting of data during import/export operations

Support personnel and applications in accessing data within security and needs-based standards

Monitor and troubleshoot database-based applications, services and jobs

Develop and enforce security operations

Assist with data validation and reporting processes

Perform backups, archival and restoration tasks as needed

Develop SQL tables, queries, views, joins, indexes, triggers, stored procedures, and other database operations as needed by application developers, reporting developers, and data consumers

Develop and maintain database and systems documentation, metadata, data dictionary, and technical specifications

Prepare data for reporting through consolidation, aggregation, cleansing, transformation and other processes

Qualification

Microsoft SQL ServerSQL queriesETL processesCloud database platformsRelational database designScripting languagesCommitment to learningDesire to innovateProblem-solving skillsCommunication skillsCollaboration skills

Required

A high school diploma and work experience in systems development and maintenance, technical support, or the support of database management systems

Proficiency with Microsoft SQL Server is required

Strong understanding of relational database design, normalization, and schema modeling

Experience developing SQL queries, views, joins, stored procedures, triggers, and transactions

Preferred

A Bachelor's degree in a quantitative or related field (such as Computer Science, Information Technology, Data Science, etc.) or commensurate training and/or experience in database administration, programming, or IT-related fields

Experience with cloud-based database platforms such as DataVerse, Azure SQL, or AWS RDS is preferred

Other modern database management systems would be a plus (e.g., Postgres, MySQL, Oracle, etc.)

Familiarity with ETL tools, scripting languages (e.g., PowerShell, Python), and database automation techniques

Exposure to DevOps, CI/CD, or infrastructure-as-code principles related to data systems preferred

Excellent problem-solving and communication skills, with the ability to work both independently and collaboratively across a wide range of colleagues

Commitment to continually building on existing knowledge and skills to be up to date on the latest technology and analysis innovations

Desire to innovate and create cutting edge solutions which make a significant impact in an empowering work environment

Company

State of South Carolina

Glassdoor3.2

South Carolina is a southeastern U.S. state.

Founded in 2005

Columbia, South Carolina, USA

10001+ employees

https://sc.gov/

Funding

Current Stage

Late Stage

Leadership Team

David Sella-Villa

Chief Privacy Officer

Mark Rhoden

Chief Financial Officer, Office of Regulatory Staff

Recent News

UPSTATE BUSINESS JOURNAL

Greenville downtown entertainment district gets initial OK: City Council notes

2025-11-26

The Herald

Impact of US election for Scottish firms in spotlight

2024-11-02

Company data provided by crunchbase