CL - Database AdministratorScope Of Project: SCDMV supports in the neighborhood of 300 plus SQL Server databases and are in the process of migrating those databases from SQL Server 2012 to SQL Server 2019. 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. SCDMV is also facing increasing security concerns around these assets.
In addition, this position will supplement our current SQL DBA force with production support activities such as OS updates, security updates, etc. and will require beyond normal hours activities. 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. Candidate will be working in a team environment consisting of 5 database engineers and administrators and working directly with application developers and server support team. Excellent oral and written communications skills are required.Daily duties / responsibilities:SQL ServerSetup and maintain data replication and mirroringConfigure maintenance automationBackup and RecoveryTroubleshoot SQL Server performance issues as they occur, including after-hours and weekendsSQL Server monitoringInstall and configure new SQL ServersDevelop and support data warehouse and cubes through SQL Server Analysis ServicesMigrate SQL Server databases to SQL Server 2019Develop Reports using SSRSSupport SSIS packagesDevelop database design, development, and management standardsConsult with developers regarding database designImplement and support 3rd party databases for vendor supplied applicationsOracle 19: DesiredAnalyze, develop, and support stored procedures and SQL.Business IntelligenceDesign, develop, and manage dashboards and reports through a BI solutionDevelop and present end user training for BI solutionDevelop and present developer training for BI solutionRequired 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 experiencePreferred 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