SUMMARY:

• Over 8+ years of strong professional experience in SQL Server 2008/2005/2000 as Database Administrator and Developer.
• Highly experienced in installing, configuring and administering SQL Server 2008/2005/2000.
• Upgraded and migrated several servers and databases from SQL Server 2000 to SQL Server2008/2005.
• 24/7 On Call Support for Production servers.
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non-Clustered environments.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring.
• Good Knowledge in implementing in different Replication Models (Snapshot, Merge and Transactional) with different topologies.
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
• Extensive experience with backup and Restore methodologies using Native and third party tools (LITE SPEED, NetBackup, and Red Gate).
• Highly experienced with Business Intelligence in MS SQL Server 2005/2008 in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expertise in migrating servers using in place and side by side upgrade.
• Experience in capacity planning, performance tuning, and disaster recovery and troubleshoot performance issues.
• Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment.
• Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Extensive knowledge in design of logical and physical data modeling using Erwin data modeling tool.
• Experienced in Extraction, Transformation and Loading (ETL) process using DTS, SSIS and Informatica.
• Created Linked Servers for OLEDB Data Source and Native Data Sources.
• Experience in developing management reports using SSRS and Crystal Reports.
• Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Very good knowledge of PCI/SOX regulations and documenting audit procedures.
• Developed Dash Board Reports on COGNOS 8.4 report studio
• Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008.
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCCcommands and Dynamic Management Views.
• Strong in monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Good working knowledge in .Net Frameswork2.0/3.0/3.5, C++, VB.Net, C#, ASP.Net, ADO.Net, XML and WebServices.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent strong team player with an ability to take new roles.
• Microsoft Certified IT Professional: Database Administrator.

EDUCATION:
Bachelor of Technology in Computer Science Engineering

TECHNICAL SKILLS:

Platforms: Windows XP/NT/2000 server/2003 server/Vista/2008 Server/Windows 7
Databases: SQL SERVER 2000/2005/2008, Oracle 9i, MS-Access
Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C, C++, C#
Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script
Security Tools: Microsoft Baseline Security Analyzer (MBSA), NGSSQuirreL for SQL
Server, Scuba by Imperva
Tools: SQL Server Management Studio / Enterprise Manager, SQL Navigator,
SSRS, SSAS, SSIS, Enterprise Manager, SSMS, Toad, Visual Studio
2005/2008, VERITAS, Quest LiteSpeed, Informatica Powercenter 8.5/9.1,
Cognos 8.4, Excel Macro 2007/2003, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, New York Nov 11 - Sep 12
Role: SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005, SQL Server 2008 on WINDOWS 2003/2008 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Configured Merge and TransactionReplication from Production to DR Servers and Reporting Server with Multiple subscribers.
• Supported production servers in Fail over cluster environment.
• Implemented several new features of SQL Server 2008 including Resource Governor, native SQL Server encryption, Data Compression.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated reporting tables, views and stored procedures.
• Worked extensively on data maintenance like re-indexing, integritychecking, and database shrinking.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XMLfiles etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages, Informatica.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query ExecutionPlans, Used SQL Profiler for optimizing the store procedure.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Environment: Windows Server 2003, Windows Server2008, SQL Server 2008/2005/2000, SSRS, SSIS, Internet Information Server 6, JavaScript, CSS, HTML,.Net Framework 2.0, VB.Net, C#, ASP.Net, ADO.Net, Quest LITE Speed, Informatica 8.5/9.1, Cognos 8.4.

Confidential, New York Jul 10 - Oct 11
Role: SQL Server DBA

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Migrated from SQL Server 2000/2005 to SQLServer 2005/2008.
• Configured security and access per SOX and PCI standards.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running DBCC consistencychecks, and fixing data corruption in user databases.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Implemented and Monitor the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Setup log shipping and troubleshooting log shipping errors when arises.
• Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Used BCP command line utility to replicate a database.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Created Dash board reports using COGNOS report studio.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Configured and worked on SSRS.
• Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005, Windows Enterprises 2003 servers, IIS Web server, Toad for SQL Server, LiteSpeed, JavaScript, CSS,HTML, SSIS, SSRS,VERITAS NetBackup,SYBASE,C#,VB.Net, ASP.Net.

Confidential, Boston Dec 09 - Jun 10
MS SQL Server DBA

Responsibilities:

• Upgraded several databases from SQL Server 2000 environment to SQL Server 2005.
• Configured Policy-based Management to enforce policies across SQL Server Enterprise.
• Performed Back-up, Restoration of Databases in Full Recovery & Bulk-Logged modes.
• Configured Database mirroring, multi-instance SQL Server clusters as part of high availability solutions for mission critical TJX database Servers.
• Monitored backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Implemented table and index partitioning to resolve performance issues for Instant Credit application.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
• Monitored SQL Servers to examine top resource consuming queries and tuned them to reduce the server load.
• Created unattended installation packages for SQL Server Service Packs and/or hot fixes.
• Established relationships and worked closely with application development teams.

Confidential, Springfield, VA Sep 08 - Nov 09
Role: SQL Server DBA

Responsibilities:

• Installed SQL server 2005 based on the Requirements.
• Performed Back-up, Restoration of Databases in Full Recovery & Bulk-Logged modes.
• Implemented the Security Permissions/Logins utilizing the SQL 2005.
• Performance Monitoring & Tuning is done and identified the Reasons for Slow-Running of the System. Ran Trace. Done the Troubleshooting work and rectified the bottlenecks to achieve High Availability.
• Monitored, done the troubleshooting for import export, maintenance, log shipping, replication jobs.
• Implemented log shipping and performed change role.
• Implemented Log Shipping and Replication (Snapshot/Transactional/Merge).
• Rebuilt the log shipping standby databases.
• Several times truncate the transactional log file.
• Added the new data files for existing databases.
• Increased the space in existing data files.
• Resolved blocking issues in databases.
• Troubleshot the slow running queries and applications.
• Created indexes, updated index statistics and rebuild indexes.
• Created SSIS packages to transfer the data from development to testing and production.
• Several times truncated the tables and reloaded data into tables.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Migrated from DTS packages to SSIS packages.
• Reporting Services/Analysis Services are performed using SSRS/SSAS as and when required by the Company.
• Created maintenance plans for user and system databases.
• Implemented database mail and created operator and assign the operator to jobs.
• Implemented database mirroring on SQL server 2005.
• Assigned the privileges to newly created stored procedures.
• Supported on call 24\\7 on rotational basis
• Performed Data with Microsoft SQL Server 2000/2005, SSIS / SSAS.
• Experience in Creating and managing user accounts / logins for development purpose

Environment: MS SQL Server 2000/2005, Windows Enterprises 2003 servers, Toad for SQL Server, SSRS, Oracle.

Confidential, Bangalore, India May 04 - May 08
SQL Developer/DBA

Responsibilities:

• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Created and designed data models using Erwin data modeling tool.
• Designed physical data models.
• Created DDL scripts to create database schema and database objects.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package and schedule the jobs for batch processing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Environment: MS SQL Server 2000, Oracle 9i, MS Access, Erwin, SQL Query Analyzer.

Work References: Will be furnished upon request