Database Administrator Consultant

Not Interested
Bookmark
Report This Job

profile Job Location:

Blythewood, SC - USA

profile Monthly Salary: Not Disclosed
Posted on: 5 hours ago
Vacancies: 1 Vacancy

Job Summary

Why is this position open: New Position. The SCDMV is in the process of migrating 300 SQL Server Databases from SQL Server 2019 to SQL Server 2022 in addition to a need for Production Support in the current SQL DBA Team.
Will close to submissions on March 3rd 2026 5:00PM EST.

Interview Process: One Round - Virtual (Camera On Teams Meeting) or In Person highly preferred.
Duration of the Contract: 12 Months
Possibility for Extension: Yes

Work Location: Position is Hybrid however remote capability is very limited and the candidate should expect to be onsite five days a week. Remote days are based off of project needs and DMV discretion.
Candidate location: Resources must be local to South Carolina. The hiring manager is open to resources local to North Carolina if they will commute to Columbia SC 5 days/week.

Work Schedule: Weekend Hours and On Call Rotation is to be expected for project needs per the discretion of the DMV.

Daily Duties / Responsibilities:

  • SQL Server
    • Setup and maintain data replication and mirroring
  • Configure maintenance automation
  • Backup and Recovery
  • Troubleshoot SQL Server performance issues as they occur including after-hours and weekends
  • SQL Server monitoring
  • Install and configure new SQL Servers
  • Develop and support data warehouse and cubes through SQL Server Analysis Services
  • Migrate SQL Server databases to SQL Server 2022
  • Develop Reports using SSRS
  • Support SSIS packages
  • Develop database design development and management standards
  • Consult with developers regarding database design.
  • Implement and support 3rd party databases for vendor supplied applications
  • Oracle 19 familiarity: Desired
    • Analyze develop and support stored procedures and SQL.
  • Business Intelligence
    • Design develop and manage dashboards and reports through a BI solution
  • Data Modeling as assigned
    • Designing developing and maintaining logical and physical data models using ERwin Data Modeler
    • Ensuring database designs support scalability integrity and performance requirements.
    • Collaborating with data architects developers and business analysts to translate business requirements into data models.
    • Modeling activities are required in Oracle databases and may be required for MS SQL databases

Required Skills (rank in order of Importance):

  • 5 Years of Experience with SQL Server 2019 AND 2022
  • 5 Years of Experience with SQL Server Reporting Services
  • 5 Years of Experience with SQL Server Analysis Services
  • 5 Years of Experience with SQL Reports Designer
  • 5 Years of Experience with BI Tools and Design
  • 5 Years of Experience as an SQL Database Administrator
  • 2 Years of Experience working with

State government Agencies

Preferred Skills (rank in order of Importance):

  • Data Domain Boost (DD Boost) to support backup and restore operations for SQL Servers
  • Experience with Oracle 19 Database

Operations

  • Experience with Oracle Grid Control
  • Experience with erwin Data Modeler

Required Education:

BA in computer science data science or closely related field.

Required Certifications: NONE

INTERVIEW PROCESS (who will conduct i/v phone or in-person how many rounds of i/vs)

Anticipate one round of person interviews are stongly preferred. Video

SCHEDULE INTERVIEW: How soon can you schedule an interview (date / times)

Immediately

interviews using MS Teams is acceptable. Phone only interviews will not be considered.

Interviewers will be with Sr. DBA DBA Manager Application Development Director.

Why is this position open: New Position. The SCDMV is in the process of migrating 300 SQL Server Databases from SQL Server 2019 to SQL Server 2022 in addition to a need for Production Support in the current SQL DBA Team. Will close to submissions on March 3rd 2026 5:00PM EST. Interview Process: One...
View more view more

Key Skills

  • Children Activity
  • Cost Accounting
  • Feed
  • Corporate Strategy
  • ERP