in5000-1
SQL Server DBA with SSIS, SSRS, SSAS, high availability (clustering/load balancing/failover), MS Office and DMV experience
Location: COLUMBIA, SC
Duration: 6 Months
Job 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. Responsible for off-hour migration of database objects from test to production environments. Design and implement system data collection and monitoring process for SQL instances using SSIS and SSRS.
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.
Knoweldgeble of DMVs, usage and best practice parameters.
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.
Background Checks:
No comments:
Post a Comment