SUMMARY

• 9 years of professional experience in IT and more than 7 year as a SQL DBA on Microsoft SQL Server 2000, 2005, 2008, 2008R2 and 2012 in multiple Production, DEV and UAT SQL Database environments.
• Experience in Analysis, Design, Development, Testing, Maintenance, Capacity Planning, Performance Tuning and Optimization of MS SQL Database Information systems of OLTP and OLAP in the Client - Server, internet and intranet environments.
• Experience in Installing, Configuration, Upgrading and Migrating SQL Server databases in and from SQL Server 2000, 2005, 2008 and 2008 R2 across multiple data centers.
• Expert in RDBMS Software installation, applying patches, upgrading, configuring, trouble shooting of SQL Servers on Windows NT, 2000, 2003 and 2008 servers in Standalone, Clustered, Physical and VMware Environments.
• Good knowledge on advanced features of SQL Server including Data Compression, Transparent Data Encryption (TDE), Resource and Query Governance etc... In SQL Server 2008 and 2008 R2.
• Experience with HA, DR and Load Balancing using Windows and SQL Clustering, LogShipping, Mirroring and Always On Availability.
• Experience in managing very large databases (VLDBs) and Complex databases in multiple SQL Server 2000, 2005, 2008 and 2008 R2 environments.
• Handled up to 4 TB size databases on Microsoft SQL Failover Clusters on Optimized SAN Storage and mount points.
• Hands on experience in configuring SQL Clustering in Active/Active and Active/Passive nodes.
• Experience in configuring Database Replication in types (Snapshot, Transactional and Merge)
• Experience in Query Optimization and Performance Tuning of SQL Server Databases using SQL Profiler, Database Engine Tuning Adviser, Execution Plans, Performance Monitor and DBCC Commands.
• Hands on configuring Temp DB with proper Memory and RAID Levels for better performance.
• Expertise in Troubleshooting SQL Server Databases using PDMC, DMF, SQL Profiler, Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks .
• Excellent skills in database Backup, Restore, Refresh and Recovery, updating DB Statistics, Reorganizing and Rebuilding indexes, Replication, Linked Servers and Database Maintenance Plans.
• Managing Database Users, Logins and Security of multiple critical Database servers SQL and ADS domains logons.
• Good knowledge in using DMVs and DMFs to resolve the SQL Server Performance Issues.
• Hands on experience in Planning and Scheduling Maintenance Plans, Scheduling Jobs and Alerts.
• Experience in Documenting DR plans and participated in DR Drills and Root cause analysis (RCA).
• Experience in working with Tables, Views, Functions, Stored Procedures, Triggers and Code Reviews.
• Hands on experience with Batch Processes, Import/Export, BACKUPs, BCP, DTS and SSIS packages.
• Experience in working with SQL Server Management Studio (SSMS), (SSAS), (SSIS) and (SSRS).
• Good Team Player with Strong Communication and Interpersonal Skills with self-motivation.
• Experience in working with Production SQL Server Databases in 24/7 support model.

TECHNICAL SKILLS

SQL Server Tools: MSSQL 2012, 2008R2, 2005 SSMS, Configuration Manager, SSIS, SSAS,SSRS, Business Intelligence Studio, Microsoft Visual Studio 2010, Profiler, Query Analyzer, Export & Import (DTS), SSIS, Mirroring, Log Shipping, Replication and Cluster.

Databases: MS-SQL Server 2000/2005 and 2008, 2012

Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS) 2005

Web Servers: Web Logic, Apache Web Server and IIS.

Languages: T-SQL, Visual Basic, VB Script, Shell Script.

Tools: MS Visio, Idera SQL Safe and virtual DB, SQL LiteSpeed, RedGate, VERITAS Backup Exec Agent for MS SQL Server, MS Office, MS Project, MS Outlook 2010

Operating System: Windows Server NT 4, 2000, 2003 and 2008R2.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Responsibilities:

• Work as Operations Support DBA for maintenance tool kit for DB optimization and backup.
• Work on VLDB and its file group, mounting points.
• Work on SQL databases in highly consolidated virtualized environment.
• Work on SQL Server Instances, Database and Table; Performance and tuning .Used SQL Server Profiler / DB Engine Tuning Advisor, Idrea Diagnostic manager and Perfmon tools to analyze the issues and performance.
• Work Extensively on Clustered High Available Servers.
• Created various Database maintenance plans at server, database, schema and index levels for maintaining the database performance up-to-date.
• Work on Automate database manual processes.
• Installation and update patching of MS SQL 2008R2 & 2012 Enterprise servers on production, UAT and Development boxes.
• Successfully planned and coordinated in completing the Decommission and Migration of DBs from SQL SQL R2 and from SQL 2008R2 to SQL 2012 in Dev/QA/Prod Environments.
• Worked closely with System support for DR and any issue with SQL Server Hardware and OS or configuring issues.
• Monitoring SQL server performance using profiler to find performance and dead locks.Used Performance monitor, DTA and SQL Profiler to optimize queries and enhance the performance of database servers.
• Documenting and review the Standard Operation Procedures.
• Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
• Provide 24*7 on call support to production databases

Environment: MS SQL Server 2012/2008R2 Windows Server 2008R2/2003R2, T-SQL, HA Clusters, DB Mirroring, Replication, Idera SQL DM, NET BACKUP and MSOffice 2010.

Confidential, NJ

SQL DBA

Responsibilities:

• Working on more than 3500 Instances Core Operations Support DBA for maintenance tool kit for DB optimization and backup, Remediation of Security vulnerabilities and patching.
• Worked on VL 4TB Databases and its file group, mounting points.
• Worked on SQL databases in highly consolidated virtualized environment.
• Worked in SQL 2000 Legacy / Special Server Environments having Different Business critical applications residing on a Highly Available Servers.
• Worked on SQL Server Instances, Database and Table; Performance and tuning .Used SQL Nexus, PSSDIAG, SQL Server Profiler / DB Engine Tuning Advisor and Perfmon tools to analyze the results.
• Worked Extensively on Clustered High Available Servers.
• Worked on Monitoring the Weekly Server checklist for all the Assigned Servers.
• Installation of MS SQL 2008, 2005 & 2000 Enterprise servers on production, Test and Development boxes.
• Successfully planned and coordinated in completing the Decommission and Migration of DBs from SQL 2000 to SQL 2005 and from SQL2000/2005 to SQL 2008R2 in Dev/QA/Prod Environments.
• Worked with Wintel & SAN teams on Capacity Planning of SQL Server Hardware and in configuring the Storage to the Servers.
• Documenting and review the Standard Operation Procedures.
• Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
• Provide 24*7 on call support to production databases

Environment: MS SQL Server 2012/2008R 2/ 2008/2005/2000 Windows Server 2008R2/2003R2/2000, VMware ESX 4.1,, T-SQL, HA Clusters, DB Mirroring, Log Shipping DRs, Release-Now Change management system, Simpana commvault, LiteSpeed, NET BACKUP, PSSDIAG and MSOffice 2010.

Confidential, GA

SQL Server DBA

Responsibilities:

• SQL Server 2005, 2008, 2008 R2, 2012 Database Administration.
• Installed, Configure and administered the MS SQL Server 2008R2/2012 Production and Non Production Servers.
• Good hand on experience of Server Migration Planning and Migration in place and side by side.
• Performed installation of SQL in VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise datacenters.
• Handled up to 1.8 TB size database in Active/Passive Clustered Environment.
• Worked in huge Replication Environment, Configured and worked on Database Mirrored.
• Expert in using DMVs, Database Snapshot and Performance dashboard.
• Managed VERITAS net backups and Litespeed backups.
• Extensively work on Log shipping/Transactional Replication, DB Mirroring, AlwaysOn Availability Group and Clustered Configuration and Monitoring.
• Maintained the Database Consistency with DBCC at regular intervals.
• Worked and responsible for monitoring and making recommendations for performance improvement by Index creation, Index reorganize, file group modifications and adding scheduled jobs to RE-INDEX and UPDATE STATISTICS in databases.
• Extensively worked on Profiler, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Monitored security using SQL Logins, Roles and Security Models for various users. Handled orphan users while moving databases and Active Directory user and group Handling.
• Monitoring and troubleshooting of weekly and monthly Maintenance tasks and performance Optimization.
• Worked and tuned T-SQL Stored Procedures, Views, Complex Queries, Functions on OLTP and OLAP Environments.
• Reviewed stored prods developed by developers and given suggestions and recommendations for the code modifications for Performance.
• Involved and worked for Design and Development of SSIS Packages to load the Data from various databases and files.
• Extensively work on Migration from SQL 2000 and 2005 to SQL 2008R2 and 2012.
• Monitor VERITAS NET-BACKUP for Tape Storage, Manage it if need also in Retrieving for restores and other special purposes.
• Configure Virtual Data Base for report purpose with help Idera Virtual DB
• Worked closely with the Application Teams/Vendors for the Application Database Upgrades on many of the Third Party Vendor Applications.
• Participating in weekly SQL Database Services Meetings and updating the Project status to the Operations Leads and Peers.
• Provide 24*7 on call support to production databases each 5 week rotation.

Environment: Windows Server 2008R2/2003R2, VMware ESX 4.1, MS SQL Server 2012/2008R2/2005/2000, TSQL, HA Clusters, DB Mirroring, Transactional Replication, Log Shipping, BMC Remedy, MS SCOM Quest NetVault LiteSpeed, VERITAS NET BACKUP, Idera Virtual DB, RED Gate SQL Tool Belt, MS Visio 2007, MSOffice 2010.

Confidential, NJ

SQL Server DBA

Responsibilities:

• Worked on more than 400 Servers with more than 5000 Databases in a Very Large Microsoft Shop as Operations Support DBA along with 24/7 on-call rotation.
• Worked on VL Databases ranging from 100 GB to 4 TB in Size.
• Worked on SQL databases in highly consolidated virtualized environment.
• Was Engaged in Priority 1 and 2 Business Critical Applications in resolving Issues on the War Room Bridge Calls.
• Worked in a Managed / Legacy / Special Server Environments having Different Business critical applications residing on a Highly Available Servers.
• Worked on SQL Server Database Load Testing and also in analyzing the performance of the Server. Used SQL Nexus, SQL Server Profiler / Query Tuning Advisor and Perfmon tools to analyze the results.
• Worked on recovering a corrupt database of 2 TB in Size due to Disk Issue and also due to HBA Card Issues.
• Worked Extensively on Clustered High Available Servers
• Configured Peer-Peer Transactional Replication for Reporting Purposes
• Worked on Data and Schema Migration from Development to QA and to Production Environment Manually and also using through Automated Tools RedGate for the Schema Management
• Extensively used Idera Diagnostic Manager for monitoring the Instances of SQL Server on Production Environment
• Worked on Monitoring the Weekly Server checklist for all the Assigned Servers.
• Installation of MS SQL 2008, 2005 & 2000 Enterprise servers on production, Test and Development boxes
• Worked on Distributed Rapid Recovery for Enterprise Disaster Recovery Test Process using SAN Replication.
• Successfully planned and coordinated in completing the Migration of DBs from SQL 2000 to SQL 2005 and from SQL2000/2005 to SQL 2008 in Dev/QA/Prod Environments.
• Worked with Wintel & SAN teams on Capacity Planning of SQL Server Hardware and in configuring the Storage to the Servers.
• Used HP Service Desk Applications for Production Issues & Resolution Tracking
• Used Mercury ITG for automated Code Execution in Dev / Test / Stage Environments
• Used Tivoli Storage Manager for Pushing Backups to the Tape and also in Retrieving for restores and other special purposes.
• Documenting the Standard Operating Procedures
• Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
• Provide 24*7 on call support to production databases

Environment: Windows Server 2008/2003, VMware, MS SQL Server 2008/2005/2000 , TSQL, HA Clusters, DB Mirroring, Transactional Replication, Log Shipping, BMC Remedy, Team Track, Veritas Backup Agent, SQLSafe, Informatica, RED Gate SQL Tool Belt, MS Visio 2007, MSOffice 2007.

Confidential, NY

SQL Server DBA

Responsibilities:

• SQL Server 20 R2 Database Administration.
• Installed managed and administered the MS SQL Server 2008R 2/ 2008/2005/2000 Production and Non Production Servers.
• Setup development, testing and production environment with SQL Server 2008 R2 Enterprise edition.
• Performed installation of SQL Enterprise bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise datacenters. Patch applications.
• Handled log shipping, Mirroring and Active/Passive Clustered Environment.
• Expert in using DMVs, Mirroring, Database Snapshot and Performance dashboard.
• Worked and responsible for monitoring and making recommendations for performance improvement by Index creation, Index reorganize, file group modifications and adding scheduled jobs to RE-INDEX and UPDATE STATISTICS in databases.
• Configured IIS, SSRS services using SSRS configuration.
• Extensively worked on Profiler, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Monitored security using SQL Logins, Roles and Security Models for various users. Handled orphan users while moving databases
• Scheduled weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.
• Worked and tuned T-SQL Stored Procedures, Views, Complex Queries, Functions on OLTP and OLAP Environments.
• Configured IIS and Report Server using Report Services configuration.
• Reviewed SP developed by developers and given suggestions and recommendations for the code modifications for Performance.

Confidential

MS SQL DBA

Responsibilities:

• Worked extensively on installation and configuration of MS SQL Server 2005 databases/Servers.
• Involved in migration of MS SQL Server 2000 to MS SQL Server 2005.
• Excellent in high level design of ETL, DTS packages & SSIS packages for integrating data using OLE DB connection from heterogeneous sources ( Excel, CSV, Oracle, Flat File, Text Format data) by using multiple transformations provided by SSIS such as data conversion, conditional splits, merge and union all.
• Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.
• Experience in the field of Unit Testing, have tested codes of T-SQL and SSIS packages in the testing environment.
• Configured Server for sending automatic mails to respective people when SSIS process fails.
• Used SSIS packages to transfer the data from legacy systems to SQL 2005.
• Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users.
• Scheduled the Backups for Databases and performed Restoration operations.
• Created, built and deployed successfully SSIS packages by using BIDS.
• Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.
• Working knowledge of creating, deploying and processing Cubes in SSAS by using Dimensions and Measures.
• Created calculated Measures and Dimension Members using MDX, Mathematical Formulas and User Defined Functions
• Created partition and Aggregates to optimize the OLAP data warehouse.
• Implemented and Maintaining Replication. Generate every day morning Replication reports from branch SQL Servers and Resolve Issues.
• Created jobs and scheduled jobs according to Requirements.
• Implemented Transactional Replication between Primary and Secondary Servers.
• Created Databases, Tables, Indexes and Views.
• Created Linked Server between MS SQL and Oracle Servers.
• Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
• Worked with SQL Server Profiler to Generate Traces.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: s: Windows server 2000/2003, MS SQL Server 2000,MS SQL Server 2005, SQL Server Analysis Services, DTS, VMware, SQL Server Reporting Services and

Confidential, WA

SQL server DBA

Responsibilities:

• Worked on Database development, administration, maintenance, server configuration and performance tuning and optimization techniques on OLTP databases.
• Installing SQL Server 2000 and 2005, applying Service Packs and Hot-Fixes.
• Trouble shooting various SQL Server 2000 and 2005 Database connectivity issues.
• Worked on High availability using clustering, replication, Database Mirroring and log shipping.
• Worked on architectural modeling and designing of databases using ER/studio.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Rebuilding the online indexes at regular intervals for better performance
• Resolving security issues by creating new roles and granting required permissions to the users at various levels.
• Worked on index implementation by finding missing indexes and removing excess indexes involved in degrading performance of server and rebuilding indexes.
• Created Adhoc reports, linked reports and custom reports using report builder in SSRS and deployed them and published into websites along with integration with SharePoint server.
• Worked with application teams in migration of databases from SQL 2000 to SQL 2005 involving DTS to SSIS, Report server.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Setup and maintained the Transactional replication with updatable subscribers and worked with snapshot and merge replications.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Discussions and meetings with web Hosting product development and sales teams based on customer requirements.
• Worked on CRM, PeopleSoft application databases on SQL and Sybase ASE servers.
• Worked with the middleware components like web sphere, Jboss finding and resolving the compatibility and performance issues.
• Worked with highly transactional merchandise and investment databases with PCI compliance involving data encryption with certificates and security keys at various levels.
• Provided 24x7 production support and necessary documentation for projects to track progress and for future reference and maintenance.

Environment: MS SQL SERVER 2000, MS SQL SERVER 2005, Windows 2000, Windows 2003, SSRS Reports, Erwin Case tool, red gate, BMC Remedy, VERITAS Net backup, SharePoint, Visual Source Safe, Crystal report.

Confidential

System Admin

Responsibilities:

• Confidential was the part of AIG Inc an Insurance company focus on Life, Bank insurance and Medial Insurance.
• Configure and Administrate SQL 2000, Support AS400
• Monitoring and Troubleshooting Data Center Issues.
• ADS, Exchange, IIS, firewall ASA and spam firewall Barracuda administration.
• Monitoring Tape backups and storage management.
• Mesh network Infrastructure, system software and Hardware support and upgrades.
• Support branches regarding authentication and VPN connectivity.