SQL Database Administrator

Remote
Full Time
Experienced

Position Details: 
Candidate MUST be a SC resident. No relocation allowed.

Act 60 of 2023 required the restructure and transfer of programs, services, duties, and authority of the Department of Health and Environmental Control (DHEC) into the Department of Public Health (DPH) or the Department of Environmental Services (SCDES). As such, SCDES’s Office of Technology is migrating all systems out of the DHEC environment (now maintained by DPH) and into the SCDES environment. SCDES has 1200+ employees using 100+ applications. These applications are intended to be maintained and supported by 50+ Office of Technology staff and numerous vendors. 

SCDES servers need to be established and prepared to host applications at the Department of Administration’s Division of Technology Operations (DTO) state data center and in the commercial cloud. These applications have many dependencies on other systems, some of these dependencies will migrate however some will remain in the DHEC environment. The Senior Database Administrator position will support the application migration and modernization as well as day to day support of existing systems.

Must Have/Required Skills 

  • Must have 5 years’ experience as a Senior SQL Server DBA. 
  • Must have 1 year of migrating application database between versions and platforms. 
  • 5 years Backup/Restore experience. 
  • SQL Server Integration Services experience. 
  • Managing roles, permissions, and encryption. 
  • T-SQL proficiency  

Preferred/Nice to Have Skills

  • Implementing Transparent Data Encryption (TDE) 
  • Database Design and Normalization  
  • PowerShell 

Required Education and/or Certifications

A bachelor's degree in computer science or a related area and experience in computer system development and modification. Relevant experience may substitute for the bachelor’s degree on a year-for-year basis.

Senior Database Administrator Position Summary/Job Purpose:

The Senior Database Administrator works as a key member of the infrastructure team supporting the applications migration efforts. The Database Administrator is responsible for planning, coordinating, and executing the migration of application databases within the SC Department of Environmental Services, Office of Technology. This position ensures seamless transition from legacy systems to modern platforms while maintaining data integrity, security, and compliance with state IT standards. The role supports critical environmental data systems and contributes to the department’s technology modernization initiatives.

Key Responsibilities/Job Functions:

Migration Planning & Execution

  • Assess existing databases for migration readiness.
  • Develop and implement migration strategies for on-premises and cloud environments.
  • Coordinate with application teams to ensure compatibility and minimize downtime.
  • Monitor migration processes and resolve issues promptly.
  • Provide technical guidance and training to stakeholders.
  • Work closely with application developers, infrastructure team, and business units

Database Administration and Security & Compliance

  • Configure, and maintain SQL Server and other database platforms.
  • Perform schema conversions, data transformations, and integrity checks.
  • Optimize database performance during and after migration.
  • Implement encryption, access controls, and auditing during migration.
  • Ensure compliance with state and federal data regulations and security standards.
Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Human Check*