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.
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.
Numbers & Facts
Location
BLYTHEWOOD, SC
Skills
Analysis Skillsunmatched
Automationunmatched
Business Analysisunmatched
Business Intelligenceunmatched
Business Intelligence Softwareunmatched
Computer Scienceunmatched
Consultingunmatched
Data Modelingunmatched
Data Recoveryunmatched
Data Scienceunmatched
Data Warehousingunmatched
Database Administrationunmatched
Database Designunmatched
Database Programmingunmatched
Database Replicationunmatched
High Availabilityunmatched
Microsoft SQL Serverunmatched
Microsoft SQL Server DBA (Database Administration)unmatched
Microsoft SharePointunmatched
OLAP Cubesunmatched
Oracleunmatched
Oracle Databaseunmatched
Project Estimatesunmatched
Reporting Dashboardsunmatched
Reporting Skillsunmatched
Requirements Managementunmatched
SQL (Structured Query Language)unmatched
SQL Databasesunmatched
SQL Server Analysis Services (SSAS)unmatched
SQL Server Integration Services (SSIS)unmatched
SQL Server Reporting Services (SSRS)unmatched
State Governmentunmatched
Stored Proceduresunmatched
System Migrationunmatched
Systems Administration/Managementunmatched
Team Foundation Server (TFS)unmatched
Visual Studio Application Lifecycle Management (ALM) (fka Visual Studio Team System / VSTS )unmatched
erwin Data Modelerunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.