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.