Sign upLog in

Database Administrator

Syntricate Technologies Inc

BLYTHEWOOD, SC

Apply
JOB DETAILS
SALARY
SKILLS
Analysis Skills, Automation, Business Analysis, Business Intelligence, Business Intelligence Software, Computer Science, Consulting, Data Modeling, Data Recovery, Data Science, Data Warehousing, Database Administration, Database Design, Database Programming, Database Replication, High Availability, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft SharePoint, OLAP Cubes, Oracle, Oracle Database, Project Estimates, Reporting Dashboards, Reporting Skills, Requirements Management, SQL (Structured Query Language), SQL Databases, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), State Government, Stored Procedures, System Migration, Systems Administration/Management, Team Foundation Server (TFS), Visual Studio Application Lifecycle Management (ALM) (fka Visual Studio Team System / VSTS ), erwin Data Modeler
LOCATION
BLYTHEWOOD, SC
POSTED
30+ days ago
Database Administrator
10311 BLYTHEWOOD RD BLYTHEWOOD, SC 29016 (Onsite)
12+ Months
Web Cam Interview

$75/Hr on W2

SCOPE OF THE PROJECT:
  • 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.

About the Company

S

Syntricate Technologies Inc