NAGASANDEEP KANCHERLA[pic]

abhsz0@r.postjobfree.com

512-***-****

SQL Server DBA

Note: Available Immediately *** ONLY FOR A

CONTRACT POSITION ***

Professional Summary:

o 6+ years of SQL Server Database Administration/Development experience

in IT,

Department of Defense, Financial services, Banking and Health Care

domains.

o Extensive knowledge in MS SQL Server 2008/ 2005 and MS SQL server

2000, 7.0 in production, Test and Development environment.

o Microsoft Certified Technology Specialist (MCTS) - Microsoft SQL

Server Implementation and Maintenance (70-431)-(MCP ID: 6619883).

o Microsoft Certified IT Professional (MCITP) - Designing a Database

Server Infrastructure by Using Microsoft SQL Server 2005(70-443) and

Optimizing and Maintaining a Database Administrative Solution by

Using SQL Server 2005(70-444).

o Access my MCP Transcript

(https://mcp.microsoft.com/authenticate/validatemcp.aspx) by providing

Transcript ID (849557) and the Access Code (sandeep9).

o Very good experience in Installation, Configuration and Maintenance of

SQL server.

o Good experience in Installation and Upgrades of/to SQL server

2000/2005 and its service packs, database migrations, backup, recovery

and maintenance of SQL server 2000/2005 databases in Cluster

environment.

o Expertise in Disaster Recovery with Backup and Restore strategies

using SQL server native tools and scheduling those backups.

o Experience in Data Modeling, Logical Modeling and Physical Modeling

using Erwin Tool. Generating scripts and forward and Reverse

Engineering databases.

o Hands on experience in migrating SQL server 7.0 to SQL Server 2000 and

SQL server 2000 to SQL server 2005.

o Involved in writing T-SQL Queries, Stored Procedures, Triggers,

Scripts, views, Functions and cursors.

o Monitoring SQL server performance using SQL Profiler, Query Analyzer,

Index Tuning Wizard, Windows Performance Monitor and DBCC commands.

o Strong experience in implementing Log Shipping for fail over support.

o High level proficiency with Replication-Transactional, Snapshot.

o Experience in Database mirroring, Database snapshot and Isolation

levels.

o Excellent T-SQL skills. Experience in Query Optimization, Database

tuning, Performance tuning.

o Proficient in creating Jobs, Alerts, SQL Mail Agent, scheduled DTS

packages and restoring databases using full, differential and

transaction log backups.

o Used BCP extensively for flat file import and export operation

from/to SQL server.

o Experience in migrating DTS packages to SSIS.

o Experience in ETL (Extract, Transformation and loading) Development

using Data Transformation Services (DTS) and SQL Server Integration

services (SSIS) for Data Migration between legacy systems to SQL

Server 2000/2005.

o Experience working in a clustered OLTP environment with Very Large

Databases (VLDB) and having change control (Visual SourceSafe).

o Hands on experience in generating reports using SQL Server Reporting

Services (SSRS).

o Excellent communication skills and ability to work in a team and

individually.

Technical Skills:

Databases Microsoft SQL Server2008/2005/2000, MS Access 2000

Database Tools SSMS, Configuration Manager, Enterprise Manager,

Query Analyzer, SQL Profiler, DTS, SSIS,SSRS,

Database Tuning Advisor, Business Intelligence

Development Studio

Languages T-SQL, SQL CMD, MS_DOS, ADO.NET, VB Script, C#.NET

Operating Windows 2008/2003/2000 Server, Windows XP, Vista.

Systems

Web Servers IIS 6.0/7.0.

Architecture Relational DBMS, Client-Server Architecture,

Clustering, Replication, OLAP, OLTP, VLDB.

Other Tools Erwin 4.0, MS Visual SourceSafe, Remedy, MS Office

suite, MS Visio,

MS Project, Windows System Monitor, Microsoft Visual

Studio 2003/2005.

Education:

. Bachelor of Technology in Computer Science and Information Technology,

JNTU, Hyderabad, INDIA.

Professional Certifications:

> 070-431 TS: Microsoft SQL Server 2005 - Implementation and

Maintenance

> 070-443 PRO: Designing a Database Server Infrastructure by Using

Microsoft SQL Server 2005.

> 070-444 PRO: Microsoft SQL Server 2005 - Optimizing and Maintaining a

Database Administration.

Professional Experience:

Contact this candidate