As discussed // SQL DBA Developer
Krish @ Compusoft
Hi Associates,
|
Direct Client : Deloitte |
|
|
Country |
City |
State |
|
United States |
Nashville |
TN |
|
Location: |
Nashville, TN |
|
Start Date: |
14-Jan-13 |
|
# of positions: |
3 |
|
Est Duration: |
1 year |
|
Rate |
55/hr on CTC |
|
Skill Requirements |
|
Skill Type : - Required |
Skill Type : - Preferred |
|
Microsoft - SQL Server, years of Experience |
|
Project Role |
|
DBA |
|
Technical Environment | |
|
Filenet P8, Datacap 8.0, .NET, SQL Server, Windows, Ilog etc | |
|
Responsibilities |
|
|
ROLE: MS SQL Server DBA
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 • 4+ 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. |
|
Standard Conditions |
|
45 hours a week |
Thanks & Regards,
Krish (Kishan Choudary Tella)
Compusoft Integrated Solutions Inc.
Direct: 847-752-5445 ||Fax : 248-538-8435
E-mail: kr...@compusoft-is.com
Yahoo IM: krishrecruiter || Gtalk: Kishanat21