Job Title: SQL Database Administrator - Advanced
Duration: 12 months+
Request id: 6884-1
Location: Blythewood, SC (Prefer local or nearby)
Visa copy required
| Manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures data
SCOPE OF THE PROJECT: SCDMV SUPPORTS IN THE NEIGHBORHOOD OF 100 PLUS SQL SERVER DATABASES AND ARE IN THE PROCESS OF MIGRATING THOSE DATABASES FROM SQL SERVER 2008 TO SQL SERVER 2012. 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. SCDMV IS ALSO INVESTIGATING BUSINESS INTELLIGENCE SOLUTIONS FOR ALL OF ITS DATA ASSETS INCLUDING ORACLE AND SQL SERVER DATA. THIS ENGINEER WILL BE EXPECTED TO PROVIDE SUPPORT FOR THIS INITIATIVE. 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 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 after-hours 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 database to SQL Server 2012, 2014 o Develop Reports using SSRS o Develop database design, development, and management standards o Consult with developers regarding database design. o Implement 3rd party databases for vendor supplied applications • Business Intelligence o Support development of a business intelligence solution for SCDMV • Oracle 11/12: Desired o Develop Dashboard and reports using through BI solution o Develop and present end user training for BI solution
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE): SQL SERVER 2008,2012 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 2014,2016 DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR SQL SERVER ORACLE 11/12 BUSINESS INTELLIGENCE MICROSOFT OFFICE MICROSOFT PROJECT MICROSOFT VISIO |
| Category | Name | Required | Importance | Level | Last Used | Experience |
| Database Platforms | MS SQL Server 2008 enterprise server | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | MS SQL Server 2008 R2 | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | MS SQL Server 2012 | Yes | 1 | Advanced | Within 6 Months | 2 - 4 Years |
| Database Platforms | Schema design including the appropriate implementation of database access security protocols into reporting program code. | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | SQL Server Analysis Services ( SSAS) | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | SQL Server Integration Services (SSIS) | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | SQL Server Reporting Services (SSRS) | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | SQL Server tools: PerfMon | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | Strong background in database planning, scaling, and capacity planning activities | Yes | 1 | Advanced | Within 6 Months | 6 + Years |
| Database Platforms | MS SQL Server 2014 | No | 1 | Advanced | Within 6 Months | 2 - 4 Years |
| Database Platforms | Oracle 11G | No | 2 | Entry | Within 2 Years | 1 - 2 Years |
| Database Platforms | Oracle 12 | No | 2 | Entry | Within 1 Year | 1 - 2 Years |
| Miscellaneous | Business Intelligence (BI) | Yes | 2 | Intermediate | Within 2 Years | 1 - 2 Years |
Feel free to contact me if you require further information or assistance.
Unfeigned regards,
Ankur Bhatia
Lead Technical Recruiter | ASK IT Consulting Inc.
Women Owned Minority Certified Enterprise
33 Peachtree Court Holtsville, NY 11742
Phone: +1 631-649-1313 X 4381| Fax: +1 631 803 4488
E: ankur.bhatia@askitc.com|www.askitc.com
Ask IT Consulting is an equal opportunity employer. All qualified applicants, who are eligible for employment are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.
You received this message because you are subscribed to the Google Groups "CVMSCRM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cvmscrm+unsubscribe@googlegroups.com.
To post to this group, send email to cvmscrm@googlegroups.com.
Visit this group at https://groups.google.com/group/cvmscrm.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment