Sql Server DBA - should be from SC, NC or GA

Title : Sql Server DBA

Location : Columbia, SC - Onsite

Duration : 12 + Months

Job Type : C

Description

THIS IS EXPECTEDTO 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

AND ADMINISTRATORS 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

o Setup and maintain data replication andmirroring

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 SQLServer Analysis Services o Migrate SQL Serverdatabases to SQL Server 2022 o Develop Reportsusing SSRS o Support SSIS packages o Develop databasedesign, development, and management standards o Consult withdevelopers regarding database design. o Implement andsupport 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 Ensuringdatabase designs support scalability, integrity, and performance requirements.

o Collaborating with data architects, developers, andbusiness analysts to translate business requirements into data models.

• Modeling activities are required in Oracle databases andmay be required for MS SQL databases

Skills

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