Law

Dear Partners/Job Seekers

One of our JobPencil's client has opening for Lead SQL Server DBA requirement, if you have matching candidates please submit their profiles, contact JobPencil service team for more details.

Job Title: Lead SQL Server DBA
Location: Columbia, SC
Duration: 1 Year
Direct Client Position

SCOPE OF THE PROJECT:
THIS IS AN ONGOING PROJECT TO ENABLE DSS TO BETTER SECURE, MANAGE, IMPEMENT AND MAINTAIN SQL SERVER ENVIRONMENT. THIS POSITION IMPACTS AGENCY'S ABILITY TO MEET FEDERAL GUIDELINES AND PROGRAM INITIATIVES.
access.
Recommends tools and resources to monitor SQL Server activity and provide key statistics and performance measures.
Researches and evaluates new technologies to improve SQL Server functionality.
Analyzes and troubleshoots problems related to SQL Server Environment.
Knowledge and experience with managing, securing, troubleshooting and administrating SQL Server 2005 or above.
Knowledge and experience with SQL Server connection protocols including Kerberos and NLTM.
Create, Write, Trouble-shoot and Deploy SSIS packages.
Creates triggers, stored procedures, and query optimization plans.
Creates normalized database objects.
Creates SQL Server maintenance plans for DR planning and business continuity.
Installs SQL Server as per best practices.
Practical knowledge of SQL DBMS objects such as system databases and recovery models.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
Backup and restore methodologies.
Experience architecting, setting up, configuring and administrating failover clusters, mirroring, replication and other high availability strategies.
Experience troubleshooting bottle necks in SQL Server.
Experience creating, deploying and managing SQL Server Auxiliary features such as SSRS. SSAS, SSIS.
Skills in Microsoft Office Suite.
CANDIDATE MUST BE ABLE TO COMMUNICATE CLEARLY WITH THE DEVELOPMENT TEAM, PROJECT STAFF, AND THE USER COMMUNITY.

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
STRONG PROJECT SKILLS
SELF STARTER
TIME MANAGMENT
ANALYTICAL THINKING
MINIMAL MANAGEMENT REQUIRED
backup/recovery  Yes  1  Expert  Currently Using  
failover clusters  Yes  1  Expert  Currently Using  
Load Balancing  Yes  1  Expert  Currently Using  
MS SQL Server 2000  Yes  1  Expert  Currently Using  
MS SQL Server 2005  Yes  1  Expert  Currently Using  
MS SQL Server 2008 enterprise server  Yes  1  Expert  Currently Using  
MS SQL Server 2008 R2  Yes  1  Expert  Currently Using  
MS SQL Server 2012  Yes  1  Expert  Currently Using  
SQL Server  Yes  1  Expert  Currently Using  
SQL Server Analysis Services ( SSAS)  Yes  1  Expert  Currently Using  
SQL Server Dynamic Management Views (DMV)  Yes  1  Expert  Currently Using  
SQL Server Integration Services (SSIS)  Yes  1  Expert  Currently Using  
SQL Server Reporting Services (SSRS)  Yes  1  Expert  Currently Using  
Active Directory  No  1  Advanced  Currently Using  
Kerberos  Yes  1  Expert  Currently Using  
NLTM  Yes  1  Expert  Currently Using  
 
Additional Skills: Advanced skill set for building and administering high availability environments with load balancing.
Ability to train Jr. DBAs.
Must be organized, focused, and ability to communicate well to superiors, peers and customers.
Must be a conceptual and analytical thinker with ability to logically process steps and communicate action plan.

"Recruiting is made easier with JobPencil.com"

JobPencil.com – is the leading technology job portal which connects the Employers looking to hire highly talented professionals and the candidates looking for right opportunities and employers.

Please join our trail month program and take advantages of our unique services are especially tailored for you:

Manage Job Posting - Manage up to 25 active jobs.

•        Manage Consultants - Manage all of your consultants who are currently looking for jobs.

•        Question Bank - You can create question papers from question bank offered by JobPencil.com

•        Resume Alerts - Create your resume alert criteria and keep receiving matching candidates!

•        Resume Search - Contact our Admin team for more information!

•        Featured/Premium Employer Listing - Contact our Admin team for more information!

•        Video Interview/Conferencing - Will be available very soon!

To provide you with our valuable service, we will work to get you matching candidate for your requirement.

We are looking forward to serving you. Please contact us for your questions and suggestions!

Regards,

JobPencil Service Team

Web: www.JobPencil.com                                                  

Phone:  614-583-8755

Fax:  614-388-5556

Email: admin@jobpencil.com