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
Never miss an opportunity! Create an alert based on the job you applied for.
