Database Administrator II - Columbia

State of South Carolina; Columbia (SC); On-site; USD 70,000 - 90,000; Full time

Job summary

South Carolina Department of Employment and Workforce (DEW) in Columbia is seeking a Database Administrator II to manage and optimize our SQL Server, PostgreSQL, and Oracle databases across cloud and on‑prem environments. You will ensure data integrity, security, and performance while coordinating with technical staff and customers.

The ideal candidate possesses a bachelor’s degree in IT or database administration, experience with database systems design, and the ability to deploy reliable

Qualifications

• A bachelor's degree in information technology systems, database administration, or a related field. Relevant experience may substitute on a year-for-year basis.
• Familiarity with Microsoft SQL Server and PostgreSQL in cloud environments is highly desirable.

Responsibilities

• Installation, configuration, upgrade, and migration of database software.
• Backup and recovery of databases.
• Administration and maintenance of database security policies and procedures.
• Capacity planning and monitoring of database systems.
• Management of database change management, including separate test and production environments.
• Deployment of system solutions into production.

Skills

Database administration

SQL Server

PostgreSQL

Cloud environments

Data security

Performance monitoring

Backup and recovery

Auditing

Education

Bachelor's degree in IT / Database Administration

Tools

SQL Server

PostgreSQL

Oracle Database

Job description

About Us

Business is booming in South Carolina! Are you ready to be a part of developing and connecting the next generation of workers in this state? Year after year, experts pick our state as one of the best in the country for doing business. Just last year, South Carolina announced more than 8,000 new jobs and $9.12 billion in capital investment. Entrepreneurs are flocking to cities like Greenville, Charleston, Columbia, and Rock Hill to start and grow their businesses. And our hospitality industry is primed to take off as travelers from around the world continue to discover the beauty and accessibility of South Carolina’s mountains and coast.

Here at the South Carolina Department of Employment and Workforce (DEW), we are laser-focused on connecting every jobseeker who comes through our doors with their next great career opportunity! Are you looking for a meaningful position at an agency brimming with optimism and camaraderie that also offers job security, affordable health insurance, great retirement benefits, and work-life balance? If so, continue reading to discover your chance to make a difference at DEW!

Job Description

Are you experienced at managing database software and planning? Would you like to make an impact? Join our team at DEW!

Our Database Administrator II serves within the IT Enterprise Applications office in Columbia.

This role is directly responsible for administering the support of database products related to the agency's SQL Server database, Postgres Database management systems, and the Oracle Databases and their supporting environments. Responsibilities include version updating, service pack installations, data integrity, security, recovery, and performance issues relating to the database systems.

An ideal candidate will possess expertise in database management systems, concepts, design methodologies, database structures, operating systems, data security, integrity, monitoring, auditing activities, and the ability to present technical and non-technical reports effectively, fostering positive relationships with technical staff and customers.

Key Responsibilities

• Installation, configuration, upgrade, and migration of database software.


• Backup and recovery of databases.


• Administration and maintenance of database security policies and procedures.


• Capacity planning and monitoring of database systems.


• Management of database change management, including separate test and production environments.


• Deployment of system solutions into production.

Education and Experience

A bachelor's degree in information technology systems, database administration, or a related field, and experience in information technology systems or a related area. Relevant experience may be substituted for a bachelor's degree on a year for year basis.

Familiarity with Microsoft SQL Server and PostgresSQL in cloud environments is highly desirable.