SUMMARY

• Over 8 years of in - depth experience as Database Administration using Microsoft SQL Server.
• Proficient in designing & implementing various solutions for effective SQL server Administration.
• Performed migrations from SQL Server and 2008 R2, SQL Server 2005, SQL Server 2008 to SQL Server 2012.
• Expertise in applying Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005 and SQL Server 2008R2 versions.
• Has a good understanding of SQL Server 2012 features like always ON, user defined server roles and contained databases.
• Strong experience in monitoring database performance and tuning using various native tools namely Performance Monitor, Activity Monitor, SQL Profiler, SQL logs and Third Party Tools.
• Experience in Query Optimization techniques using DMV’s and DMF’s, DBCC commands, Index Rebuild / Reorganising and also used tools to identify slow running queries using Server-side tracing.
• Monitoring locking/blocking and space management issues.
• Experience on Database Mirroring and Log shipping.
• Worked on SQL Server Replication dat is Snapshot, Transactional &Merge.
• Experience in controlling teh user privileges, monitoring teh security and Audit issues.
• Experience in deploying reports in a reporting server and providing required permissions to users on teh reports in reporting server.
• Experience in implementing SSIS packages, Scheduling Jobs, Setting up Alerts & notification using Database Mail.
• Performed Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Worked in designing of SSIS packages for integrating data using OLE DB connection from heterogeneous sources(Excel,CSV,Flatfile,Text fomat data) by using multiple transformations provided by SSIS such as Aggregate, Data conversion, conditional split, bulk insert, fuzzy grouping.
• Created reports using SSRS.
• Troubleshooting failed jobs.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks
• Created complex stored procedures, triggers, tables and other sql joins and statements for applications by using T-SQL.
• Experience in writing T-SQL (DDL, DML, DCL and TCL).Reviewing T-SQL code, maintaining coding standards across teh board in all SQL server environments.
• Review of physical and logical database design, promote teh reliability of database design by ensuring appropriate referential data integrity is Implemented and appropriate data types are used.
• Possess Strong analytical skills wif attention to detail and ability to work effectively in a fast paced environment.
• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/ 2005/2008/2008 R2/2012

Operating Systems: Windows 2003/2008/2008 R2/2012

Tools: SQL Server Management Studio, T-SQL, Query AnalyzerSQL Profiler, Replication, Clustering, Database Tuning Advisor, Upgrade Advisor, SQL Configuration Manager and Service Manager, Activity Monitor, Performance Monitor, Resource monitor, Lite Speed, Tivoli Storage Manager, SSIS,SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Elk Grove, CA

MS SQL Server DBA

Responsibilities:

• Performed migrations from SQL server 2008R2 to SQL server 2012
• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
• Implemented and Maintained Transactional and Snapshot Replication for reporting purposes.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Scheduling jobs and monitoring and troubleshooting them.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and built in performance reports.
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.
• Creating logins and database users, roles and providing permissions to users and roles according to teh requirement and security policy.
• Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
• Worked in designing of SSIS packages for integrating data using OLE DB connection from heterogeneous sources(Excel,CSV,Flat file,Text fomat data) by using multiple transformations provided by SSIS such as Aggregate, Data conversion, conditional split, bulk insert, fuzzy grouping.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.
• Resolving SCOM alerts and implemented maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries and purging old files for preventing space issue.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks

Environment: SQL Server 2012/2008R2/2005, Windows Server 2008(x64), SQL Server Management Studio, T-SQL,SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, SCOM, SSRS,SSIS etc

Confidential, Concord, CA

MS SQL Server DBA

Responsibilities:

• Responsible for installing and maintaining SQL Server 2005, SQL 2008 R2 Cluster environment.
• Performed migrations from SQL server 2005 to SQL server 2008R2/2012.
• Applying existing servers wif relevant Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
• Implemented High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and log shipping.
• Implementing backup, restores and logshipping using Litespeed tool.
• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Monitoring locking/blocking and space management issues
• Scheduling jobs and monitoring and troubleshooting them.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Implementation of SQL Logins, roles and Authentication Modes as a part of Security Policies for various categories of users.
• Scheduled Backup/Recovery jobs and developed Disaster Recovery Plans.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Analyzed long running /slow queries and tune teh same to optimize application and system performance.
• Created and maintained data objects such as tables, views, indexes, referential integrity depending on user requirements and converting them to technical specifications.
• T-SQL programming for writing stored procedures, used-defined functions, triggers, views, cursors..
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Performed Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

Environment: SQL Server 2012/2008R2/2008/2005, Windows 2008 server, Windows Server 2008(x64), SQL Server Management Studio, T-SQL,SSRS,SSIS,SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, Tivoli storage manager, litespeed etc.

Confidential - Monterey, CA

MS SQL Server DBA

Responsibilities:

• Experience in SQL Server 2005/2008/2008 R2 installation, Configuring, Deploying applying patches, upgrade, troubleshooting and operations
• Experience in database backup and disaster recovery procedures
• Created and maintained SQL 2008 R2 Cluster environment.
• Perform Database upgrades from SQL server 2005 to SQL server 2008/2008R2.
• Experience in High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and log shipping.
• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Monitoring locking/blocking and space management issues
• Scheduling jobs and monitoring and troubleshooting them
• Monitoring SQL/Windows/application/security event logs, Monitor and support client server databases on Windows 2003/2008 R2 servers.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Experience in query optimization and performance tuning.
• Implemented SSIS (SQL Server Integration Services) packages
• Maintaining high availability of SQL servers by proactively monitoring teh critical services in a 24*7 support environment

Environment: SQL Server 2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64),SQL Server Management Studio, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, T-SQL, Data Compression, Resource Monitor etc.

Confidential, Washington, DC

MS SQL Server DBA

Responsibilities:

• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Troubleshooting locking/Blocking issues.
• Monitoring and resolving space management issues.
• Scheduling jobs and monitoring and troubleshooting them.
• Exporting and importing databases using attach/detach or backup and restore.
• Experience in controlling teh user privileges, monitoring teh security and Audit issues.
• Monitoring SQL/Windows/application/security event logs, Monitor and support client server databases on Windows 2003/2008 R2 servers.
• Applying patches/hotfixes to SQL server.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and built in performance reports.
• Performed both in place and side by side Database migration from SQL server 2005 to SQL server 2008/2008 R2.

Environment: SQL Server 2008R2/2008/2005, Windows 2008server, SQL Server Management Studio, T-SQL, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Resource Monitor etc.

Confidential, Reston, VA

MS SQL Server DBA

Responsibilities:

• Monitor Server capacity and Daily health checks for teh Database servers.
• General Maintenance me.e. Re-indexing/Reorganizing Indexes, Monitor and support client server databases on Windows 2003 server.
• Controlling access permissions and privileges.
• Resolving security issues such as orphaned users, creating roles and granting permissions on various objects.
• Applying hotfixes to SQL Server.
• Checking backups and making sure enough space on teh disks.
• Resolving space management issues.
• Troubleshooting failed jobs.
• Troubleshooting Locking/Blocking issues.
• Providing daily backup reports to Senior DBA.
• Checking SQL Logs and Event Viewers for any errors.

Environment: SQL Server 2000/2005, Windows Server 2003(x64),SQL Server Management Studio,T-SQL, Query Analyzer, SQL Profiler, Performance Monitor, Resource Monitor.

Confidential

MS SQL Server DBA

Responsibilities:

• Exporting and importing databases using attach/detach or backup and restore.
• Controlling access permissions and privileges.
• Implementation of SQL logins, roles and authentication modes for various categories of users.
• Managing alerts, managing security, Re-indexing/Reorganizing Indexes, performing DBCC checks
• Monitoring Server capacity and Daily health checks for teh Database servers.
• Troubleshooting Locking/Blocking issues
• Troubleshooting space management issues.
• Applying update/patch to SQL server.
• Ensuring dat storage, archiving, backup and recovery procedures are functioning correctly and verifying backups are restorable by restoring them in test environments.

Environment: SQL Server 2000/2005, Windows Server 2003(x64), SQL Server Management Studio,T-SQL,Query Analyzer, SQL Profiler, Performance Monitor, Resource Monitor.

Confidential

MS SQL Server DBA/Developer

Responsibilities:

• Create stored procedures and user defines functions to supports efficient data storage and manipulation.
• Developed objects (me.e. tables, views and stored procedures, functions, triggers, indexes) to get a better and faster performance.
• Defined check constraints, rules, indexes and views based on business requirements.
• Generated standard Tabular type reports wif Drill down and Drill through functionality and reports.
• Exporting and importing databases using attach/detach or backup and restore.
• Rebuilding indexes at regular intervals for better performance.
• Checking backup and make sure enough space on teh disks.
• Installed and configured SQL Instances.
• Provided technical support and maintenance.

Environment: SQL Server 2000/2005, Windows Server 2003(x64), SQL Server Management Studio, Performance monitor, Resource Monitor.