SUMMARY

• 9+ Years of experience in Database Administration, Architecture, Design, Implementation, Performance Tuning, Deployment, Development, Capacity Planning, Scaling & Support of Mission Critical MS SQL Servers 2008/2005/2000 in Development, Production, Test, Replication, Cluster, QA and VLDB Environments.
• Installed, Configured, Maintained and Monitored MS SQL Server 2012/ 2008/2005/2000 /7.0 Versions in both mission Critical, Clustered (Active/Passive and Active/Active), Stand - Alone and VMware Environments.
• Implemented High Availability plans like Clustering, Log shipping & Database Mirroring.
• Performed Upgrades & Migration from SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008 in both 32 bit and 64 bit and resolved the issues.
• Designed, Implemented & Tested Archiving, Database Backup, Point in time Restores and Disaster Recovery Procedures.
• Resolved Database Performance, Replication, Database Mirroring, Connectivity, Security, Blocking, dead locking and Log-shipping related Issues.
• Performed Logical and Physical database design.
• Implemented different types of Replication models like Snapshot, Merge and Transactional replication and monitoring them.
• Deploying Reports using Microsoft Reporting Services (SSRS)
• Experience in Resolving Tickets, Software Development Life Cycle (SDLC), SQL Server Memory Management, Incident Management, Change Management, Version Control, OLTP, MS-DTC, Fixing database corruption.
• Used Tools like SQL Lite-Speed for backup-recovery and Spotlight for performance tuning.
• Performed schema management, Client/Server Connectivity, Database Rollouts, Load Testing, Load Balancing, Database consistency checks using DBCC Utilities.
• Created Linked Servers, Maintenance Plans, Entity- Relationship Diagrams, Perl Scripts, Power shell Scripts.
• Configured and Maintained the Report Manager and Report Server.
• Installed SQL Server 2005 Reporting Services in SharePoint integrated Mode and had done configurations.
• Provided 24X7 on call Production Support to both the Applications and SQL Servers.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server DBA

Responsibilities:

• Migrating from SQL Server 2008 R2 to SQL Server 2012 and Fixing the Issues.
• Creating Disaster Recovery Plan for the servers.
• Installed and configured SQL Server on both stand - alone and clustered platforms
• Monitored database performance through Monitoring Software
• Monitored the Jobs, Errors, Bottlenecks and fixed them
• Identified root cause and implement short and long term fixes for issues.
• Performed proactive audits and analysis on SQL Instances, databases storage configuration
• Managed the Log Shipping and Transactional Replication of all production environments
• Fine-tuned databases, indexes and processes for optimal performance
• Created and configured the databases in support of design specifications
• Created the linked servers, Maintenance Plans and managed them.
• Managing Clustered Servers.
• Configuring database mirroring on SQL Server 2008 R2
• Database files and file group management.
• Creation of AG Groups on SQL Server 2012.

Environment: SQL Server 2008/2005/2000 , Windows Server 2008/2003/2000 , SSIS, SSRS, Query Analyzer, Perfmon, Spotlight.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installed and configured SQL Server on both stand - alone and clustered platforms
• Monitored database performance and played the role of consultant to Development Teams
• Identified root cause and implement short and long term fixes for issues (Problem Management)
• Performed proactive audits and analysis on SQL Instances, databases storage configuration
• Managed the Log Shipping and Transactional Replication of all production environments
• Fine-tuned databases, indexes and processes for optimal performance
• Managing Clustered Servers.
• Optimized the design of large Databases which are TB in size
• Experience of handling 800+ GB Database
• Database files and file group management.
• Creation of AG Groups on SQL Server 2012.

Environment: SQL Server 2008/2005/2000 , Windows Server 2008/2003/2000 , SSIS, SSRS, Query Analyzer, Lite speed, Perfmon, Spotlight.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installed, configured SQL server 2008 on Active-Active Clusters and applied service packs.
• Performed performance tuning on the databases, Instances, servers, application and increased the Performance.
• Performed upgrades from SQL Server 2005 to SQL Server 2008 and applied Service Packs on them.
• Monitored and troubleshoot issues that impact database, Instances, servers, application performance, stability and overall service delivery.
• Had set up and monitored the Active-Active clusters, database Mirroring, Log shipping, Transactional Replication and the Resolved the Issues related to them.
• Took the Back Ups and restored them when it is necessary and troubleshooting the orphan users.
• Monitored the Jobs, Errors and fixed them.
• Created SSIS Packages for cleaning and Loading the Business data into the Data-warehouse.
• Created the Logins, Users and granted them the necessary access and Permissions to them.
• Resolved the Tickets on SQL Server.
• Managed the Log Shipping and Transactional Replication of all production environments
• Deploying Reports using SSRS.
• Designed and Implemented databases including schema and table layouts, underlying disk configuration, backup process, high availability and all other configurations.
• Created and configured the databases in support of design specifications
• Created the linked servers, Maintenance Plans and managed them.
• Performed production review of in house written code and assisted developers in optimization and troubleshooting
• Reviewed the client requirements and Performed the capacity Planning.
• Developed and tested the data recovery strategies and performed data restoration.
• Monitored and troubleshoot the databases, servers, Instances on the production, development, and test environments.
• Deployed the Databases on the Test, Production, Development Servers
• Developed, reviewed, and supported SQL code, stored procedures, Open Query statements, triggers, etc.
• Performed production code elevations following change management procedures

Environment: SQL Server 2008/2005/2000 , Windows Server 2008/2003/2000 , SSIS, SSAS, DTS, SSRS, Query Analyzer, Lite speed, Perfmon, Spotlight.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installed and configured SQL server 2005 in an Active-Active Clusters and applying service packs.
• Migrated from SQL Server 2005 to SQL Server 2008 and Fixing the Issues.
• Designed, Implemented and supported High volume Transactional databases.
• Created, documented, tested and Implemented disaster recovery plan, high Availability, Compressed Back-ups and Recovery strategies for all the databases.
• Developed, Implemented and maintained Security of the databases and Servers.
• Performed the capacity planning to find out the adequate space for the servers and databases.
• Creating Documents on DR, Back UP and Restore, Server Access and Database Access, Server Configuration (Hardware and software).
• Creating Clustered indexes and Non-clustered indexes as part of the Performance tuning.
• Took Lite Speed Back Ups and restored them whenever it is necessary.
• Implemented Database Mirroring, Log shipping, Data-warehouse.
• Checking the Errors and fixing them.
• Designing and Implementing the Physical, Logical Data Models.
• Migrating DTS packages to SSIS Packages
• Optimized the design of large Databases which are TB in size
• Setting up the log shipping and Transactional Replication using Push Subscription
• Created, scheduled and Monitored Maintenance plans, SSIS packages and jobs.
• Performing the daily checklist on the database and server as a day to day activity
• Performance tuning the store procedures and making them run faster.
• Monitoring the activities on databases and servers, Database Growth.
• Performed Query Optimization and tuning the Indexes.
• Traced the Bottlenecks and fixed the contention Issues, Increased the performance of slow running applications and Databases.
• Performed Database Consistency Checks using DBCC commands.
• Fixed the Deadlocks and prevented them from occurring again.
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Fog light Performance Analysis and Spotlight.

Environment: SQL Server 2005/2008, Windows Server 2003/2008, Enterprise Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, Lite-Speed, Perfmon, Spotlight, Idera.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installing and configuring SQL server 2005 in an Active-Active Clusters and on VMware and applying service packs.
• Migrating from SQL Server 2000 to SQL Server 2008, SQL Server 2005 to SQL Server 2008 and Fixing the Issues.
• Creating Disaster Recovery Plan for the servers.
• Creating Compressed Database Back UP’s and Recovery Procedures.
• Monitoring the growth of the databases and performing capacity planning both on the databases and on the disk space.
• Setting up Transactional replication using pull subscription, monitoring the replication and fixing the replication issues.
• Creating, Optimize, Deploy and Test SSIS packages and DTS packages according to the business rules.
• Doing the performance tuning on the slow running queries and optimizing the databases.
• Creating Clustered indexes and Non-clustered indexes as part of the Performance tuning.
• Performing Index Tuning, caching and Buffer tuning.
• Set up SQL Server 2005 Reporting Services on SharePoint Integrated mode on Microsoft Office SharePoint server 2007 and configured it.
• Creating users, assigning permissions to them and set up notifications in SharePoint.
• Setting up Clustering and also high availability plans like Database Mirroring.
• Performed Database Compression, Database Partitioning, Database Encryption.
• Installed the services packs and hot fixes.
• Creating Partitioning Keys, Partitioned Schemes, Partitioned Functions, partitioned Tables and aligned Indexes.
• Implemented various forms of Normalization, Data Models (Conceptual, Logical and Physical) and database designs.
• Created the Implementation plans/strategies, Roll Back plan for the changes.
• Assess the Change Impact and Implementing the Change
• Applying a structured methodology and lead change management activities.
• Completing the Change Management assessments.
• Identify, analyze and prepare risk mitigation plans
• Driving, developing, managing and maintaining the major incident.
• Preparing the Root Cause Analysis of the problem as a part of the Problem Management
• Creating Jobs, Maintenance Plans, Scheduling and monitoring them through SQL Server Agent.
• Provided 24X 7 Production support.

Environment: SQL Server 2000/2005, Windows Server 2003/2008, Enterprise Manager, SSIS, SSAS, SSRS, Query Analyzer, Lite-Speed, Perfmon, Spotlight

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installing SQL Server 2005 and updating it with the latest service packs.
• Involved in setting up a clustered environment on windows 2003
• Migration from SQL Server 2000 to SQL Server 2005,
• Exporting and Importing of databases using Export/Import
• Creating databases, tables, views, Pivot Tables, indexes and constraints on Very large databases like 18 TB.
• Creating and modifying clustered Indexes and non-clustered Indexes on all the required tables and increasing the performance.
• Designing Backup/Restore Strategy and automating it.
• Performed database mirroring.
• Implemented Linked Server between Order Placement databases to admin database for cross database transactions.
• Fine-tuned the stored procedures to improve the performance of the application
• Implemented Transactional replication between Order Placement databases to Admin and Report databases, monitored the replication and resolved the issues
• Assisting the Business Analysis team in developing functional and detailed design specifications and data models.
• Troubleshoot different conflicts between two servers in Replication.
• Setting up the Schedule jobs, alerts and notifications.
• Involved in Database Architecture design for scaling databases across multiple servers.
• Created users and logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Run DBCC consistency checks, rebuild indexes, and update statistics for databases on regular basis.
• Performed Data transfers between various servers using BCP and DTS/SSIS.
• Configured the Log shipping and created the Standby server.
• Moving and managing the schemas between different environments
• Took Back Ups using Lite Speed and Red Gate Backup tool restored them according to the necessity.
• Managed Published Reports using Report Manager.

Environment: SQL Server 2000/2005, Windows Server 2003, Enterprise Manager, SSIS,SSAS, DTS, SSRS, SSAS, IIS, Query Analyzer, Lite speed, Red Gate, Spotlight, MS-DTC.

Confidential

SQL DBA

Responsibilities:

• Administration of Clustered SQL servers in 24 x 7 Windows data center environment
• Installation and configuration of SQL Server 2005 components
• Migrated data from SQL server 2000 to SQL server 2005 and solved the issues
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio and SQL Server Agent
• Managing & troubleshooting SQL databases, Security, fine tuning of SQL queries
• Involved in database capacity planning and resolved the issues.
• Created transactional and merge replication on different servers, monitored it and solved the issues on replication.
• Created, Implemented and maintained Entity Relationship Diagrams.
• Configured Log shipping for the disaster recovery plan in SQL Server2005.
• Involved in using Quest tools like Performance analyzer and spot light for analyzing the performance of severs.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities
• Created and Managed Logins, Users, Roles and User permissions.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Identified the performance bottlenecks of CPU, Memory, I/O and tuned and resolved them to increase the overall performance of the server.
• Involved in creating Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Created and Modified System- Level Role Definitions and Item- Level Roles Definition using Report Manager and modified them.
• Creating and scheduling the Database Maintenance activities.

Environment: SQL Server 2000/2005, Windows Server 2003, Enterprise Manager, SSIS, Query Analyzer, Report Marshal