Database Solutions Engineer (Database Administrator I)

Job Description

The role of Database Administrator I includes the responsibilities to design, develop, configure, maintain, monitor, and support database management systems (DBMS) in the Department of Education.
The Database Administrator (DBA) will work with the Department of Education's SQL Server environment and other DBMS systems as needed to perform these operations, as well as others as assigned:
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;
This position is located in the Office of Information Technology. A high school diploma and work experience in systems development and maintenance, technical support, or the support of database management systems. A bachelor's degree in a related field may substitute for the required experience.
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.
Proficiency with Microsoft SQL Server is required; 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.).
Strong understanding of relational database design, normalization, and schema modeling. Experience developing SQL queries, views, joins, stored procedures, triggers, and transactions.
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.
ONLY THOSE APPLICANTS CHOSEN FOR AN INTERVIEW WILL BE NOTIFIED BY LETTER THAT THE POSITION HAS BEEN FILLED.
http://www.ed.sc.gov/jobs/human-resources/title-ix-nondiscrimination/