SQL Server DBA

Job ID: SC-9798 (98890217)

Remote/Local SQL Server DBA with Database migration, T-SQL, TDE, PowerShell experience

Location: Columbia, SC (DES)
Duration: 12 Months
Candidate Location: Candidate MUST be a SC resident. No relocation allowed.

Must Have/Required Skills
Must have 5 years' experience as a Senior SQL Server DBA.
Must have 1 year of migrating application databases 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.

SC_E-RTR.docx

SCMSP_Candidate_Cover_Sheet_Updated.docx

innoSoul, Inc. is an Information Technology company and offers technology solutions in various platforms to different business domains. More specifically, business solutions for Application Development, System integration, network or software installation support, Custom Web Development, Hosting solutions. Our value-added solutions leverage technology to enhance business performance, increase productivity and secure data.