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.
S
Syntricate Technologies Inc