IT - DES - Database Administrator - Advanced

Job Title: IT - DES - Database Administrator - Advanced

Location with zip code: Columbia, SC,29201(Remote)

Duration: 12 Months

Interview Process: 1 round, Virtual/Online

Possibility for Extension: Yes

Work Location: Fully Remote

Pay Rate: $65-70/hr Only W2 candidates required
Candidate MUST: Be a SC resident. No relocation allowed.
Job Description:

• Act 60of 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.

Required Skills:

• Must have 3 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 Skills:

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

Required Education & certification:

• 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.
• 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.

Role & 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.

About our Company: -

22nd Century Technologies, Inc., is one of the fastest growing IT Service Integrator and Workforce Solution companies in the United States. Founded in 1997, 22nd Century Technologies is a Certified National Minority Business Enterprise with 6,000+ people including 600+ Cyber SMEs nationwide supporting our customers in all 50 states, Canada, and Mexico. With HQs in Somerset, NJ and Mclean, VA, 22nd Century has 14 offices throughout the United States. As part of our unrelenting focus on quality and compliance, 22nd Century Technologies delivery is based on Certified Matured Processes including CMMI L3 Dev & SVC, ISO 20000, ISO 27001, and ISO 9001 quality processes. With a strong focus on the public sector, 22nd Century currently holds government contracts with 14 out of 15 Federal Executive agencies including DoD, 37 other Federal agencies, 50 States, 115+ Local agencies, and 37 School Districts. In the last three years, we have expanded our services to Fortune 500 and other commercial clients and currently support 80+ commercial clients.

Recognized among Best Company to Work For by Forbes, 22nd Century Technologies, Inc., consistently exceeds our clients expectations by focusing on their absolute satisfaction with jobs while keeping our employees motivated. 22nd Century Technologies is an Equal Opportunity Employer" and s & all other parties authorized to work in the US are encouraged to apply."

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.