Senior SQL Server Database Administrator

Job Description:

DPP is seeking a Senior Database Administrator for an opportunity in Columbia, SC.

Location: Fully remote, but must reside in South Carolina.
Duration: 12 months, with possibility of extension.
Term: W2 position

Position summary:

Due to the separation of two departments, all systems must be migrated from one environment to another. Servers will need to be established and prepared to host applications in a state data center and in the commercial cloud.
The Senior Database Administrator will support the application migration and modernization as well as day-to-day support of the existing systems.
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 department’s 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:
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.

Required knowledge, skills, and abilities:

A Bachelor&39;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.
5+ years’ experience as a Senior SQL Server DBA.
1+ year of migrating application database between versions and platforms.
5+ years Backup/Restore experience.
SQL Server Integration Services experience.
Experience managing roles, permissions, and encryption.
T-SQL proficiency.

Preferred knowledge, skills, and abilities:

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

Interested? Learn more:
Click the apply button or contact our recruiter Harrison at Harrison.Donahuedppit.com to learn more about this position (26-00116).

Authorized US Worker - US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time. EOE/AA/V/D

DPP offers a range of compensation and benefits packages to our employees and their eligible dependents. Call today to learn more about working with DPP.

Job Ident #: 26-00116

Company Details

DP Professionals

3741 Landmark Drive
Suite 200
Columbia, South Carolina 29204 USA
www.dppit.com/

DPP® specializes in placing highly qualified information technology professionals in both contingent and direct hire opportunities in private industries such as healthcare, insurance, banking, utilities, energy, manufacturing, federal and state government...

(Job and company information not to be copied, shared, scraped, or otherwise disseminated/distributed without explicit consent of JSfirm, LLC)

Job Info

Location

Columbia, South Carolina, United States

Type

Permanent

Company Details

DP Professionals

3741 Landmark Drive
Suite 200
Columbia, South Carolina 29204 USA
www.dppit.com/