Database Administrator II - Columbia

State-of-South-Carolina; South Carolina; On-site; USD 80,000 - 110,000; Full time

Job summary

The South Carolina Department of Employment and Workforce (DEW) in Columbia is seeking a Database Administrator II to manage and support the agency's SQL Server, PostgreSQL, and Oracle databases across environments. You will handle updates, security, recovery, and performance.

A strong background in database design, data security, and reporting is essential. Ideal candidates will have a bachelor’s degree in IT systems or database administration and experience with cloud deployments of SQL Server

Qualifications

• Bachelor's degree in IT systems, database administration, or a related field.
• Experience in information technology systems or a related area.
• Familiarity with Microsoft SQL Server and PostgresSQL 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 management systems

Data security

Monitoring and auditing

Report writing (technical)

Operating systems

Education

Bachelor's degree in IT systems or database administration

Tools

SQL Server

PostgreSQL

Oracle DB

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.

If you’re ready to take on this challenge and help support South Carolina’s workforce system, please apply. We look forward to hearing from you!

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.

Supplemental questions are considered part of your official application. Please complete the State application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position.