SUMMARY

• Around 9 Years of total IT experience including SQL Server Database Administration for very large and complex databases in SQL Server 2014, 2012, 2008R2, 2008, 2005 & 2000. installation, configuration and maintenance of MSSQL Server 2014/2 R2/2005 updating with hot fix and service packs
• Experience on SQL server Always on Availability Groups and Always on Failover Cluster Instances
• Administration, Maintenance of SQL Server instances in Production, Test & Dev environments.
• Worked on VLDB’s sizing around 250 GB to 7 TB.
• Provided 24 x 7 Production support for the database and application issues.
• Experience and good Knowledge about the newly added features like Always ON High Availability and contained databases in MSSQL 2014/2012.
• Experience in implementing and managing backup strategies.
• Having hands on experience implementing DR solutions like Log shipping, database mirroring and clustering.
• Patching all the DB Servers to the Latest Service Pack levels periodically to be Compliant with the Microsoft Support.
• Design and Setup of SQL Server Security - Active Directory Groups, Logins, Users, Roles and Permissions
• Experience on configuring and implementing Replication.
• Upgrading the environment from SQLSERVER 2005 to SQL SERVER 2008 R2 and 2012 and updating the hot fix and service packs.
• Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Experience in implementing and managing backup strategies, disaster recovery solution Log Shipping, Database Mirroring and Replication for database high availability.
• Experience in Database Backups and Restores
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Database refreshes from Production backup to Test and Development environments.
• Experience in cluster installation and applying patches on cluster environment.
• Experience on creating maintenance plans like database backups, update statics and rebuild indexes and database integrity check
• Created the SQL Server Integration Services (SSIS) Packages for exporting the data.
• Configured the SQL Server new features like Policy Based Management, Performance Data Collector and Transparent Data Encryption (TDE),
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Checking the status of Backup and troubleshooting the failed backups.
• Set up linked servers and troubleshooting any issues related to ODBC connectivity.
• Experience in SQL Server tools, including Management Studio, Query Analyzer, Profiler, SQL Server Agent and database tuning adviser.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Managing Security (Creating users, logins and roles, granting permissions).
• Extensively involved in Performance and tuning.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experienced on Incident Management, Problem Management and Change Management
• Worked on the ticketing tools like BMC Remedy, Sales force & Service now
• Aware of IT compliances -Sarbanes-Oxley (SOX) and HIPAA

TECHNICAL SKILLS

Operating systems: Windows server 2000, 2003, 2008R2 & 2012

RDBMS: SQL Server 2014, SQL Server 2012, SQL Server 2008 R2/2008, 2005MS Access 2000/2005.

Languages: T-SQL, HTML

Software/Tools: SQL Profiler, DTA, SQL Server management studio, Perfmon, Time Finder, PowerShell

Backup/Restore: Symantec & Tivoli

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential, New York

SQL SERVER DBA

Responsibilities:

• SQL server Installation and maintaining SQL servers of 2014, 2012 & 2008R2
• Configured the SQL Server new features like Policy Based Management, Performance Data Collector and Transparent Data Encryption (TDE),
• Applying patches on production and non-production servers.
• Database creation, database refreshes & monitoring the alerts.
• Supporting multiple customers and providing as per business solutions.
• Having good experience on implementing and managing always on.
• Have configured two node Active-Passive clustering.
• Database refreshes from production backup to non-production servers.
• Checking Alerts and resolve issues to take appropriate action as need.
• Configuration and troubleshooting issue in Log shipping.
• Managing user creation and providing permission as per user’s requirements.
• Fixing Orphaned users through Stored Procedures.
• Monitoring the Scheduled jobs and fixing the failed jobs.
• Rebuilding the indexes at regular intervals for better performance.
• As a part of the DBA team providing 24x7 production support to the clients.

Confidential

SQL SERVER DBA

Responsibilities:

• SQL server Installation and maintaining SQL servers 2014, 2012, 2008R2, 2005.
• Applying patches on both production and non-production servers.
• Database creation, database refreshes, alert monitoring and Backup script creations.
• Database migration from SQL 2008 R2 to SQL Server 2012 and 2014.
• Supporting multiple customers and providing as per business solutions.
• Having good experience on implementing and managing Always on feature on SQL SERVER 2012.
• Have configured log shipping and as per customer requirements.
• Checking the database data files and log files is located specific drive and observe the available free space.
• Addressed the Replication Issues and have setted up the new replications.
• Patching all the DB Servers to the Latest Service Pack levels periodically to be Compliant with the Microsoft Support.
• Database refreshes from production backup to non-production servers.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Experience in using DMV and dynamic management functions to find out long running queries.
• Experience in setting up two node Active-Active and Active-Passive clustering.
• Created the SQL Server Integration Services (SSIS) Packages for exporting the data.
• Implemented SQL Server new features like Policy Based management, Performance Data Collector and Transparent Data Encryption (TDE),
• Configuring database mail for SQL server alerts.
• Checking Alerts and resolve issues to take appropriate action as need.
• Configuration and troubleshooting issue in Database mirroring.
• Managing user creation and providing permission as per user’s requirements.
• Set up linked servers and troubleshooting any issues related to ODBC connectivity.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks
• Fixing Orphaned users.
• Responsible for trouble shooting failed jobs and Replication Related issues etc.
• Monitoring the Scheduled jobs and fixing the failed jobs.
• Checking Fragmentation and Resolving Fragmentation issues.
• Rebuilding the indexes at regular intervals for better performance.
• Configured database mail for alerts.
• Participate in meetings and partner calls regarding support issues and processes on weekly basis
• As a part of the DBA team providing 24x7 production support to the clients.

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005, 2000, Windows 2003/2008/2012 , SSRS, SSIS, SSAS, BMC Remedy, Tivoli.

Confidential

SQL SERVER DBA

Responsibilities:

• SQL server Installation, Patching and up gradation.
• Database creation, database refreshes, alert monitoring and Backup script creations.
• Database migration from SQL 2008R2 to SQL Server 2012
• Have configured replication and mirroring as per customer requirement.
• Checking the database data files and log files is located specific drive and observe the available free space.
• Database refreshes from production backup to Test and Development environments.
• Managing Installation of SQL server 2008 R2 cluster and applying the latest service packs.
• Configuring database mail for SQL server alerts
• Installation of SQL server 2008 R2 and applying the latest service packs.
• Setting up and troubleshooting issue in Replication.
• Experience in setting up two node Active-Active and Active-Passive clustering
• Patching all the DB Servers to the Latest Service Pack levels periodically to be Compliant with the Microsoft Support.
• Experience in setting up two node Active-Passive clustering
• Responsible for trouble shooting failed jobs and Replication Related issues etc.
• Managing user creation and providing permission as per user’s requirements.
• Set up linked servers and troubleshooting any issues related to ODBC connectivity.
• Checking Alerts and resolve issues to take appropriate action as need.
• Configuration and troubleshooting issue in Database mirroring.
• Building databases with Transactional Replication.
• Worked on the Time finder.
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning
• Managing Security of the Database.
• Fixing Orphaned users.
• Monitoring the Scheduled jobs.
• Implementation of SQL Logins, Roles and Authentication Modes.
• Rebuilding the indexes at regular intervals for better performance.
• Managing space for data files and log files.
• As a part of the DBA team providing 24x7 production support to the clients.

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005, 2000, Windows 2003/2008/2012 , SSRS, SSIS, SSAS, BMC Remedy, Salesforce Ticketing.

Confidential

SQL SERVER DBA

Responsibilities:

• Managed All Production, Development and Test environments running MSSQL Server.
• Involved in Migration of Production Database Servers from SQL Server 2005 to SQL Server 2008R2 & 2012.
• Creating and scheduling jobs for Database Maintenance.
• Involved with maintenance of ACTIVE/PASSIVE Cluster Environments.
• Implemented Database mirroring for High Availability.
• Configuring database mail for SQL server alerts
• Configuring the Replication and Log shipping.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Involved in Performance Tuning on Production, Development and Test Servers.
• Checking Alerts and resolve issues to take appropriate action as need.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Working with application development team to review and deploy changes during database object release include with system upgrade.

Environment: MS SQL Server 2012/2008R2/2008/2005, 2000, Windows 2003/2008, SSRS, SSIS, SSAS, BMC Remedy.

Confidential

SQL SERVER DBA

Responsibilities:

• Involved in all aspects of Database Administration in MS-SQL Server 2005 and 2008R2.
• Designing a data restoration Strategies depending upon the business needs (Full, Simple and Bulk logged Models).
• Creating and scheduling jobs for Database Maintenance.
• Checking specific back up and restoration files are storing specified drives are not.
• Database migration from SQL 2005 to SQL Server 2008R2
• Rebuilding the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters.
• Checking the database data file and log file is located specific drive and observe the available free space.
• Configuring database mail for SQL server alerts
• Setting up the Replication and Log shipping.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Checking Alerts and resolve issues to take appropriate action as need.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implementation of SQL Logins, Roles and Authentication Modes.
• Managing space for data files and log files.

Environment: MS SQL Server 2008R2/2008/2005, 2000, Windows 2003/2008, SSRS, SSIS, SSAS, Service-Now Ticketing, Semantic Net Backup.

Confidential

SQL Server DBA

Responsibilities:

• SQL server Installation, Patch maintenance and up gradation.
• Database creation, database refreshes, alert monitoring and Backup script creations.
• Database migration from SQL 2000 to SQL Server 2005 & 2008R2.
• Maintenance plan for MSSQL server (DBCC, Update statistics, backup etc.).
• Have configured replication and mirroring as per customer requirement.
• Checking the database data files and log files is located specific drive and observe the available free space.
• Creating and scheduling jobs for Database Maintenance.
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Database refreshes from production backup to Test environments.
• Patching all the DB Servers to the Latest Service Pack
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Configuring database mail for SQL server alerts
• Checking Alerts and resolve issues to take appropriate action as need.
• Setting up the log shipping
• Managing Security of the Database.
• Fixing Orphaned users.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, and Strategies using Maintenance Plans
• Implementation of SQL Logins, Roles and Authentication Modes.
• Checking Fragmentation and Resolving Fragmentation issues.
• Rebuilding the indexes at regular intervals for better performance.
• Managing space for data files and log files.
• As a part of the DBA team providing 24x7 production support to the clients.

Environment: MS SQL Server 2008R2/2008/2005, 2000, Windows 2003/2008, SSRS, SSIS, SSAS, BMC Remedy.

Confidential

SQL Server DBA

Responsibilities:

• Involved in all aspects of Database Administration in MS-SQL Server 2000 and 2005.
• Designing a data restoration Strategies depending upon the business needs (Full, Simple and Bulk logged Models).
• Creating and scheduling jobs for Database Maintenance.
• Checking specific back up and restoration files are storing specified drives are not.
• Rebuilding the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters.
• Checking the database data file and log file is located specific drive and observe the available free space.
• Configuring database mail for SQL server alerts
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Checking Alerts and resolve issues to take appropriate action as need.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implementation of SQL Logins, Roles and Authentication Modes.
• Managing space for data files and log files.

Environment: MS SQL Server 2008/2005, 2000, Windows 2003/2008, SSRS, SSIS, SSAS, BMC Remedy.