Title: SQL Server DBA (ONLY W2)
Duration: 12 Months
Location: 100% REMOTE within State of South Carolina
Job ID: 9798
No. of Hours/Week: 40
Candidate MUST be a resident of the hiring state. No relocation allowed.
Position Summary / Job Purpose
The Senior Database Administrator works as a key member of the infrastructure team supporting application migration efforts. This role is responsible for planning, coordinating, and executing the migration of application databases within the Office of Technology.
The position ensures seamless transition from legacy systems to modern platforms while maintaining data integrity, security, and compliance with IT standards. The role supports critical data systems and contributes to broader 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 teams, and business units
Database Administration, 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 data regulations and security standards
Required Skills
- Bachelor's degree in Computer Science or related field 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 databases between versions and platforms
- 5+ years Backup/Restore experience
- SQL Server Integration Services (SSIS) experience
- Experience managing roles, permissions, and encryption
- Strong T-SQL proficiency
Preferred Skills (Not Mandatory)
- Implementing Transparent Data Encryption (TDE)
- Database Design and Normalization
- PowerShell