[3559MSCRMCV] SQL DBA

Monday, 4 March 2013

[3559MSCRMCV] SQL DBA

Direct Client - Phone Hire

Location: Columbia, SC

Duration: 6+ months

Rate: DOE

Description

Manages and maintains all production and non-production SQL Server databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Will handle off hour migration of database objects from test environment to production environment.

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.

Skills Needed
• Backup and restore methodologies.
• Experience with failover clusters and load balancing and other high availability strategies.
• Experience troubleshooting bottle necks in SQL Server.
• Experienced with SQL Server Reporting Services (SSRS. SSAS, SSIS).
• Skills in Microsoft Office Suite.