SQL DBA

SUPPORTS IN THE NEIGHBORHOOD OF 300 PLUS SQL SERVER DATABASES AND ARE IN THE

PROCESS OF MIGRATING THOSE DATABASES FROM SQL SERVER 2019 TO SQL SERVER 2022. IN

ADDITION, DMV IS IMPLEMENTING HIGH AVAILABILITY SOLUTIONS ON A NUMBER OF THE SYSTEMS

SUPPORTED BY THESE DATABASES AND INCREASING OUR USE OF REPORTING SERVICES AND ANALYSIS

SERVICES IMPLEMENTED IN A NUMBER OF SUPPORT SYSTEMS SUCH AS SHAREPOINT, MS SYSTEM

CENTER, TEAM FOUNDATION SERVER, AND OTHERS. SCDMV IS ALSO FACING INCREASING SECURITY

CONCERNS AROUND THESE ASSETS.

IN ADDITION, THIS POSITION WILL SUPPLEMENT OUR CURRENT SQL DBA FORCE WITH PRODUCTION

SUPPORT ACTIVITIES SUCH AS OS UPDATES, SECURITY UPDATES, ETC. AND WILL REQUIRE BEYOND

NORMAL BUSINESS HOURS ACTIVITIES. THIS POSITION WILL BE REQUIRED TO SUPPORT THE ORACLE

DBA TEAM AS NEEDED, CREATE REPORTS IN SSRS AND POWER BI, AND UTILIZE ERWIN IN MANAGING

LOGICAL AND PHYSICAL DATA MODELS, DATA DICTIONARIES AND MODEL DOCUMENTATION.

THIS IS EXPECTED TO BE A LONG TERM, ONGOING ASSIGNMENT. ON-SITE PRESENCE IS REQUIRED

THEREFORE REGIONAL CANDIDATES (SC, GA, NC) WILL BE GIVEN PREFERRED PRIORITY.

CANDIDATE WILL BE WORKING IN A TEAM ENVIRONMENT CONSISTING OF 6 DATABASE ENGINEERS

AND ADMINISTRATORS AND WORKING DIRECTLY WITH APPLICATION ARCHITECT AND DEVELOPERS,

BUSINESS ANALYSTS AND SERVER SUPPORT TEAM. EXCELLENT ORAL AND WRITTEN

COMMUNICATIONS SKILLS ARE REQUIRED.

POSITION: Database Administrator - Consultant OPEN TO VISA TRANSFER? □ YES X NO

START DATE:

MARCH 2026

DURATION:

12+ MOS

POSSIBILITY OF EXTENSION?

YES

Bill Rate: Up to: $95.00 Public Sector/Gov’t Experience

Required?

YES

Remote work possibility Yes or

No?

Yes, DMV management

discretion.

PRE-EMPLOYMENT CHECKS (drug, credit, criminal, motor vehicle)?

Drug, Criminal, Credit, e-Verify, NDA

DAILY DUTIES / RESPONSIBILITIES:

• SQL Server

o Setup and maintain data replication and mirroring

o Configure maintenance automation

o Backup and Recovery

o Troubleshoot SQL Server performance issues as they occur, including after-hours and

weekends

o SQL Server monitoring

o Install and configure new SQL Servers

o Develop and support data warehouse and cubes through SQL Server Analysis Services

o Migrate SQL Server databases to SQL Server 2022

o Develop Reports using SSRS

o Support SSIS packages

o Develop database design, development, and management standards

o Consult with developers regarding database design.

o Implement and support 3rd party databases for vendor supplied applications

• Oracle 19 familiarity: Desired

o Analyze, develop, and support stored procedures and SQL.

• Business Intelligence

o Design, develop, and manage dashboards and reports through a BI solution

• Data Modeling – as assigned

o Designing, developing, and maintaining logical and physical data models using ERwin

Data Modeler

o Ensuring database designs support scalability, integrity, and performance

requirements.

o Collaborating with data architects, developers, and business analysts to translate

business requirements into data models.

o 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/v’s)?

Anticipate one round of interviews. In 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.