Innovations technological

Title: SQL Server DBA 
Location : Columbia, SC
Duration: 6 Months(Telephonic)

DAILY DUTIES / RESPONSIBILITIES:

* Develops security measures and policies for SQL Server to prevent unauthorized 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 SQL Server 2005 or above.
* Knowledge and experience with SQL Server connection protocols including Kerberos and NLTM.
* 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 with failover clusters and load balancing and other high availability strategies.
• Experience troubleshooting bottle necks in SQL Server.
• Knowledgeable/ experienced with SQL Server Reporting Services (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.