Title : Database Administrator - 9985
Location : Columbia, SC/ Hybrid
Duration : 12 + Months
Interview Process: One Round - Virtual (Camera On Teams Meeting) or In Person. 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.
SCOPE OFTHE PROJECT:
SCDMV supports in the neighborhood of 300 plus SQL server databases and are in the process of migrating those databases from SQL server 2019to 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 CONSISTINGOF 6 DATABASE ENGINEERS
ANDADMINISTRATORS AND WORKING DIRECTLY WITH APPLICATION ARCHITECT AND DEVELOPERS,BUSINESS ANALYSTS AND SERVER SUPPORT TEAM. EXCELLENT ORAL AND WRITTEN COMMUNICATIONS
SKILLS ARE REQUIRED.
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 to Migrate SQL Server databases to SQL Server 2022 to Develop Reports using SSRS
Support SSIS packages to Develop database design, development, and management standards to Consult with developers regarding database design.
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 ANDRESTORE
OPERATIONS FOR SQL SERVERS
EXPERIENCE WITH ORACLE 19 DATABASE OPERATIONS
EXPERIENCE WITH ORACLE GRID CONTROL
EXPERIENCE WITH ERWIN DATA MODELER
Never miss an opportunity! Create an alert based on the job you applied for.
