SQL DBA - Harrisburg PA

ROLE:  MS SQL Server DBA

Location: Harrisburg PA

Duration: 12 months contract

SQL DBA for 12 months contract in.

Rate is $60 per hour C2C

 

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.