ITPROUSPSSC-1 Database Administrator - Consultant
ITPROUSPSSC-1 Database Administrator - Consultant
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
5years
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
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.
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. ONSITE 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 Server
o Setup and maintain data replication and mirroring
o Configure maintenance automation
o Backup and Recovery
o Troubleshoot SQL Server performance issues as they occur including afterhours and weekends
o SQL Server monitoring
o Install and configure new SQL Servers
o Develop and support data warehouse and cubes through SQL Server Analysis Services
o Migrate SQL Server databases to SQL Server 2019
o Develop Reports using SSRS
o Support SSIS packages
o Develop database design development and management standards
o Consult with developers regarding database design.
o Implement and support 3rd party databases for vendor supplied applications
Oracle 19: Desired
o Analyze develop and support stored procedures and SQL.
Business Intelligence
o Design develop and manage dashboards and reports through a BI solution
o Develop and present end user training for BI solution
o Develop and present developer training for BI solution
Requirements
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
SQL SERVER
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
DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR SQL SERVER
ORACLE 19
BUSINESS INTELLIGENCE
MICROSOFT OFFICE
MICROSOFT VISIO
Benefits
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
Education
REQUIRED EDUCATION/CERTIFICATIONS: 1. ISC(2, ISACA, SANS GIAC and/or other Information Security Certification is required. PREFERRED EDUCATION/CERTIFICATIONS: 1. Bachelor's in a related area or 10+ years of experience in the field or in a related area.
Employment Type
Full Time
