PROFESSIONAL SUMMARY

• High proficiency with 5+ years of technical experience in Database Administration, Development, Security and Support of MS SQL Server 2000/2005/2008/2008R2 in Production, Testing and Development.
• Experience with less than 1+ year in Database Administration, Development, Security and Support of Oracle 10g in Production, Testing and Development.
• Experience in developing Stored Procedures, Views, Triggers, cursors and Complex Queries in T-SQL and PL/SQL.
• Experience in Installation, Upgrade and Configuration of MS SQL Server and databases in clustered and Non-clustered environments.
• Experience in Installation, Upgrade and Configuration of Oracle 10g on UNIX, Linux and Windows.
• Experience in Backup/Recovery in MS SQL Server.
• Experience in Performance Tuning and SQL Tuning in MS SQL Server.
• Experienced in New High availability concepts Database Mirroring and Replication, Log Shipping.
• Experienced in implementing different types of Replication Models like Snapshot and Transactional.
• Experience in upgrading of SQL Server from version 2000 to 2008R2 & 2005 to 2008.
• Handful experience in SSIS & SSRS.
• Created and Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules for system errors, insufficient resources, fatal database errors, hardware errors, security.
• Provided 24x7 on-call supports, Supported systems beyond regular hours/ weekends/ holidays.

EDUCATION:
M.S. in Electrical Engineering
B. E. in Electronics and Communication Engineering

CERTIFICATION: Microsoft Certified Technology Specialist (MCTS)-SQL Server 2005.

TECHNICAL SKILLS
Environments: Windows NT/2000/2003/2008 Servers, Red Hat Linux.
Languages: C, T-SQL, PL/SQL, HTML, Perl.
Relational Databases: SQL Server 2000/2005/2008/2008R2 (32 & 64 Bit) and Oracle 9i/10g.
MS SQL tools: MS SQL Server Management Studio, BIDS, MS SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, DTS, SSIS, SSAS, SSRS, DTA, DTSXchange.
Oracle Tools: SQLPLUS, SQL developer, Toad, RMAN, SQL Dump, OEM.
Peformance Monitoring Tools: Confio Ignite, Idera.
Hardware: IBM, Dell, HP, Compaq servers
Web Servers: IIS & Apache.

PROFESSIONAL WORK EXPERIENCE

Confidential,Pennsylvania (MAR’2009 – Current)
SQL Server DBA - Confidential,is an American Retailer Chain operating over 5,000 stores in 31 states.
As SQL SERVER DBA/Developer, I am involved in the Administration and development of Store Management and Pharmacy databases and applications (Such as Pharmacy, Portal, POS, etc)
Responsibilities:

• Database Administration, Security & Maintenance in all the 5000 SQL servers of the company and 20+ corporate Servers.
• Database Administration, Security & Maintenance in 4 Oracle servers.
• Managing database Backup and Recovery of all the 5000 MSSQL Servers.
• Develop DB packages for the new version of the Application, Which includes writing scripts and Release Management.
• Responsible for Building, Automating, Scripting and Implementing changes into production environment (Build Management).
• Developed SQL Stored Procedures, Functions, Triggers, Packages, etc.
• Migrated SQL Server 2005 & 2008 databases to SQL server 2008R2 using Backup-Restore, Detach-Attach, and Copy Database Wizard.
• Designed and implemented Disaster Recovery Procedures like Database mirroring between production and DR servers.
• Involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Reviewed third party tools so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Created the SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Provided 24/7 support to developers in implementing the applications on production server.

ENVIRONMENT: MS SQL Server 2000/2005/2008/2008R2, Oracle 9i/10g, T-SQL, PL/SQL, Perl, Windows NT/2003/2008, UNIX, Linux, SQL Plus, OEM, SSMS,SSIS, SSRS, SQL Profiler, IIS 6.0, Performance Monitor.

Confidential,NJ (APR’2008 to JAN’2009)
SQL Server DBA / Developer - Confidential,is an American, multinational, Fortune100 telecommunications company based in Schaumburg, Illinois.
Responsibilities:

• Administration of MS-SQL Server 2005 & 2008.
• Creation and implementation of Database backup and Recovery plans.
• Implemented Transactional replication between 3 servers on a 100 GB databases.
• Worked on SQL Server Clustering, Log shipping, Mirroring, Snapshot and Replication.
• Developed, implemented, maintained and exercising Disaster Recovery processes like all kinds of Backup and Recovery models.
• Creation and Execution of DTS and BCP utilities in SQL Server 2005.
• Bulk Insert and loading the data files which comes from various legacy systems.
• Created, Deployed and managed Reports through SQL Server Reporting Services (SSRS).
• Migrated SQL Server 2000 DTS packages into SSIS (SQL Server 2005) by using Upgrade Advisor.
• Designed Logical and Physical database for projects on basis of user requirements using Erwin.
• Expertise in Monitoring and Troubleshooting and resolving the SQL Server Performance issues.
• Effectively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Expertise in managing internal databases like Development server, Testing Server and Production Servers from planning through implementation and support.

Confidential,Bangalore, India (Jul’2006 – Jun’2007)
Jr SQL Server DBA/Developer - Worked as Jr.SQL DBA\\Developer, additionally completed academic project in this company.
Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Installation and configuration of SQL Server 2000 on Window NT OS.
• Implementing Backups and Restoring when necessary.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Extensively Developed SQL scripts for maintaining administration tasks.

Academic Projects:
- Vehicle Security System Using CAN Protocol (Micro-Core Solutions, Bangalore, India)
- Wireless Time Server (NJIT, NJ, USA)

Key Courses in Academics:
Data Management System Design, Network Architecture and Protocols, Broadband Packet Switches, Internet Engineering, Wireless Networks, Wireless and Personal Communication Systems, Random Signal Analysis, Linear Systems, Data Communication and Advanced Microprocessors.