What are the responsibilities and job description for the SQL Server DBA position at Excelraise, LLC?
Job Detail
- Job Code 11613 1
-
Tax Term W2 Hourly
-
Career Level Mid Level
-
Experience 8 Years
-
US Work Status US Citizen
-
Job Duration 12 Months
-
Qualifications Bachelor's Degree
Job Description
Excelraise, LLC is a leading provider of full-service IT solutions and a talent management company headquartered in Denver, CO. At Excelraise, we specialize in IT staffing solutions tailored for government and federal clients across the USA.
Excelraise, LLC values your referrals! Refer qualified candidates for our open Job Postings and earn a generous REFERRAL BONUS for successful placements. Submit referrals here: Excelraise Referral Program.
Excelraise, LLC is seeking an SQL Server DBA for our client in Blythewood, SC.
***This is Onsite Position***MUST BE ONSITE TO TRAIN/WORK ***
***This person will be providing production support and may be asked to work some overtime***
***References – Two Needed at submission***
***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***
Scope 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.
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:
- 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
- SharePoint 2010, 2013
- MS System Center
- DDBoost
- Unstructured Data Management
- Visio, MS Project
- Design of complex web intelligence reports and dashboards
Preferred skills:
- 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