SQL DBA - Harrisburg PA

Hi,

 

ROLE:  MS SQL Server DBA

Location: Harrisburg PA

Duration: 12 months contract

 

Required Skills/Experience/Duties:

·         In depth SQL Server Database Administration

·         Experience in database/application tuning

·         Experience in troubleshooting and resolving database integrity issues,

·         performance issues, blocking and deadlocking issues, replication issues, log

·         shipping issues, connectivity issues, security issues, etc.

·         Ability to detect and troubleshoot SQL Server related CPU, memory, I/O,

·         disk space, and other resource contention issues

·         Experience with Microsoft SQL Server 2005/2008, SQL Server Profiler, SQL

·         Reporting Services

·         Resolve application T-SQL related issues

·         Create periodic Disaster Recovery testing plan and enable the capability

·         for all SQL Server environments

·         Create process and procedure for periodic restore and recovery for all

·         databases in multiple environments

·         Install Microsoft SQL Server 2005/2008 Enterprise software

·         Apply Microsoft SQL Server 2005/2008 patches

·         Install and configure third party products/tools required for SQL Server

·         2005/2008

·         Perform database administration and database maintenance tasks

·         Plan, coordinate, and execute data conversion activities such as data

·         mapping and data conversion programming to support data migrations between

·         systems

·         Conduct data mapping: defines data elements, entity relationships, input

·         and output sources, and how data will be transmitted through a proposed

·         system; estimates the type of information to be entered, computed, updated

·         or otherwise used in the system; estimates data volumes

·         Create, or support creation of, required reports and queries in response

·         to business user needs

·         Experience with SSIS, SSAS, and SSRS

·         Experience with Data analysis, data modeling, data warehouse

·         7+ years of experience working in teams and in a team environment that is

·         process-oriented and deadline-driven

·         3-4 years IT operations experience with strong understanding of database

·         structures, theories, principles, and practices

·         Able to provide a working model of transaction processing environment for

·         capacity assessment and planning

·         Able to prioritize and execute tasks in a high-pressure environment

·         Good interpersonal, written, and oral communication skills

 

Education:

Bachelor of Science in Computer Science, Engineering, or MIS

 

Responsibilities:

Database installations, upgrades, configuration, performance monitoring, and

tuning of Microsoft SQL Server software and related products; Backup and

recovery policies and procedures; Database design and implementation;

Database security implementation and maintenance (creating and maintaining

users, roles, and privileges); T-SQL, MDX, DMX Scripting, Stored Procedures,

Functions, Triggers, Views, SSIS Packages.

 

---

Bala

Accounts Manager

SSAI Technologies LLC | Board: 908 450 9465| Fax: 908 842 0244 | www.ssaitech.com | Email: bala@ssaitech.com |  bala.ssaitech@gmail.com

WBE/MBE certified for the State of NJ

Note: We respect your online privacy. TBill s.1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line. I am sorry for the inconvenience caused to you

Iphone class room training in NJ - call for details.