Title : Sqlserver DBA
Location : Columbia, SC – Remote- Need to be local to SC
Duration : 12 + Months
Job Type : C
Description :
Senior Database Administrator Position Summary/JobPurpose:
The Senior Database Administrator works as a key member of theinfrastructure team supporting the applications migration efforts. The DatabaseAdministrator is responsible for planning, coordinating, and executing themigration of application databases within the SC Department of EnvironmentalServices, Office of Technology. This position ensures seamless transition fromlegacy systems to modern platforms while maintaining data integrity, security,and compliance with state IT standards. The role supports criticalenvironmental data systems and contributes to the department’s technologymodernization initiatives.
Key Responsibilities/Job Functions:
MigrationPlanning & 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.
Skills :
Must Have/Required Skills
· Must have5 years’ experience as a Senior SQL Server DBA.
· Musthave 1year of migrating application database betweenversions and platforms.
· 5 yearsBackup/Restore experience.
· SQLServer Integration Services experience.
· Managing roles,permissions, and encryption.
· T-SQL proficiency
Preferred/Nice to Have Skills
· ImplementingTransparent Data Encryption (TDE)
· DatabaseDesign and Normalization
· PowerShell
Required Education and/or Certifications
A bachelor's degree in computer science or a related area and experiencein computer system development and modification. Relevant experience maysubstitute for the bachelor’s degree on a year-for-year basis.