Database Administrator

Scope of Project This project involves supporting approximately 300+ SQL Server databases, which are in the process of being migrated from SQL Server 2012 to SQL Server 2019. Additionally, high availability solutions are being implemented on a number of systems supported by these databases. There is also an increased use of Reporting Services and Analysis Services implemented in various support systems such as SharePoint, MS System Center, Team Foundation Server, and others. The project also addresses increasing security concerns around these assets. This position will supplement the current SQL DBA team with production support activities such as OS updates, security updates, etc., and will require activities beyond normal hours. This is expected to be a long-term, ongoing assignment. On-site presence is required; therefore, regional candidates (SC, GA, NC) will be given preferred priority. The candidate will be working in a team environment consisting of 5 database engineers and administrators and will work directly with application developers and the server support team. Excellent oral and written communication skills are required. 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 2019 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: Desired Analyze, develop, and support stored procedures and SQL Business Intelligence Design, develop, and manage dashboards and reports through a BI solution Develop and present end-user training for BI solution Develop and present developer training for BI solution Required Skills (Rank In Order Of Importance) SQL Server 2012, 2014, 2016, 2019 SQL Server Reporting Services SQL Server Analysis Services Reports Designer Business Intelligence Tools and Design 8 - 10 years SQL DBA experience Preferred Skills (Rank In Order Of Importance) SQL Server 2012, 2014, 2016, 2019 DD Boost to support backup and restore operations for SQL Server Oracle 19 Business Intelligence Microsoft Office Microsoft Visio Seniority level Mid-Senior level Employment type Full-time Job function Other Industries IT Services and IT Consulting #J-18808-Ljbffr