Database Administrator

Database Administrator

Onsite at 10311 BLYTHEWOOD RD BLYTHEWOOD, SC 29016. Duration: 12+ Months. Web Cam Interview. Pay: $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:

• 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.