SUMMARY:

• Ten Years of IT industry experience in Database Administration for very large and complex databases in Microsoft SQL Server 2017/2016/ 2014 (SP1/CU - 5)/2012(SP1)/2008R2/2008/2005 on Windows Server 2008/2008R2/2012/2012R2.
• Expertise in Installing, Configuring, Troubleshooting SQL Server 2016/2014/2008/2008 R2 on SQL Cluster/Standalone Environments (Test/SIT/UAT/Staging/PROD).
• Extensive experience in managing 500+production and 1000+non-prod servers and experience in Migrating and Upgrading SQL Server 2014/2012/2008 R2/2005 on Clustered/stand-alone Environments.
• Experience in migrating the SQL Server cluster 2008/2008R2 to Always on availability SQL server 2012 SP1/2014 SP1/2016 on Windows server 2012/2012 R2 for Production/UAT/Staging.
• Experience in configuring Always on High Availability(AOA)and ensuring High Availability between primary and secondary replicas and Disaster Recovery (DR) and Implementing High Availability options with Zero Data Loss and real-time apply environment.
• Excellent Experience in Replication, Log Shipping and Database Mirroring and experience in Attunity replication between SQL to SQL servers, SQL to Netezza.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity and also performing database consistency checks, planning, scheduling and automating Backup & Recovery.
• Hands-on working experience with analyzing query plans, managing indexes, locks, troubleshooting the slowness issues in timely manner on prod environments
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics, and Index tuning Wizard and Expertise in Hardware SAN and RAID levels configuration and placement of database files/file groups across different drives.
• Hands in experience on third-party tools like Delphix (used for refreshing the databases from prod to dev/sit/uat), lite speed/Idera (used for taking backups and restoring the databases), Red gate (used to compare/sync the data between different environments), Vormetric (encryption for Data & log files at disk level), Solar winds/DPA/Ignite (used for monitoring the performance of the servers).
• Experience in cloning process (Databases) using Replication manager (EMC) and running/managing nightly refresh jobs for 30 reporting servers.
• Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using SSIS and developed the reports using SQL Server Reporting Services (SSRS).
• Knowledge in T-SQL (DDL, DML, DCL) in implementing, developing SP’s, joins Triggers, Cursors and views.
• Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of MS SQL Server Databases is my primary responsibility.
• Addressing prod server alerts that are configured in third party tools Scom, Splunk and App-dynamics.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box
• Co-ordinated offshore team for all kind of Prod and Non-Prod performance issues and provided knowledge transfer to the team.
• Worked in 24 X 7 Production Database on Call Support environment.

TECHNICAL SKILLS:

Windows: Server 2003/2008/2012 ; SQL Server 2005/2008/2008 r 2/2012/2014/2016 /2017

SQL Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Enterprise Manager, SQL Export & Import, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication,, SQL reporting, SSIS, SQL Compare, SCOM, Idera.

Third Party Tools: Delphix, Attunity, Replication manager console(EMC), Red gate, I-serve, Lite speed,Vormetric

Network Topologies: TCP/IP, DNS, SMTP

PROFESSIONAL EXPERIENCE:

Confidential . Long beach, CA

Sr.SQL Database Administrator

Environment: s(OS/SQL)

Responsibilities:

• Installed, upgraded and configured SQL Server 2017/2016/2014/2012 for several applications with latest service packs.
• Administering SQL server databases, database security and 24/7 production support for mission critical systems with high availability solutions (Clustering and always on high availability).
• Worked with building, Installing, Configuring and Maintaining MS SQL Server 2008/2008R 2/2012/2014/2016 /2017 Always on, Active-Active and Active-Passive two and four node failover Clusters.
• Worked on migrating the SQL Server cluster 2008/2008R2 to Always on availability SQL server 2012 SP1/2014 SP1/CU5/2016 on Windows server 2012/2012R2 for Production/UAT/Staging in different domains including DR.
• Worked on creating missing indexes, update statistics, rebuild/reorganize indexes, scheduled jobs on all production servers to monitor failed jobs and disk free space issues to avoid unnecessary breakdowns.
• Configured backups, optimization jobs and involved in restoring database to point in time in of case issues, troubleshooting long running queries and slowness issues.
• Responsible for production and non-production support for SQL server database based application and assist in trouble shooting production issues and application performance issues.
• Worked on Attunity replication between SQL to SQL servers, SQL to Netezza and running/managing nightly refresh jobs on reporting environments for end users.
• Supported development team in deploying the prod scripts from TFS path via change requests which are approved in CAB meeting and worked on all types of tickets (Access, linked server, DB refresh).
• Worked on third-party tools such as Delphix for refreshing very large databases within less time, less storage and installing and configuring Vormetric agent for encypting user database files at disk level.
• Addressing different production Sev1 alerts by interacting with different teams (App, Network, storage and server) through bridge calls and these production servers thresholds are configured in third party monitoring tools like CheckMK,Scom,Splunk and App-dynamics
• Developed SSIS packages, handled SSRS reports for automation of backups, long running and blockage on prod servers.
• Comparing the database structure, generate the scripts and then sync between the servers using Red gate tool and refreshing the databases by using replication manager (EMC).
• Effective shift handover, Recommend, plan & lead new initiatives for improvement in service level, Proper communication with the client, RCA (Route cause Analysis) for frequent happening problems. Monitoring for unusual activities
• Review data-base design of new development projects during design phase in order to capture performance bottle-necks upfront, Raise VOC (Voice of customer) for analyzing project health, Escalation Tracking & Resource Analysis with 24*7 on call support.

Environment: s: SQLServer2008/2008R 2/2012/2014/2016, Windows 2008/2012/2012 R2, Lite speed, EMC, Delphix, Red gate, vormetric, TFS, DPA, SCOM, Splunk, CheckMK.

Confidential

SQL Database Administrator

Responsibilities:

• Installation, upgrading and configuration of Stand-alone SQL Server 2005/2008/ 2008 R2/2012 versions and maintained Microsoft best practices in applying Service Packs and Hot Fixes on cluster, Mirror and log shipping servers.
• Worked on production Clustered SQL Server database instances using Active-Passive nodes, and Active-Active nodes clustering.
• Worked on Backup, Disaster recovery planning and Security Management and Created Linked Servers between SQL servers in prod/UAT/SIT.
• Worked on Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild/Reorg Indexes and setup alerts like database size increase, log size full for all SQL server versions.
• Responsible for SQL Server tuning, performance evaluation, optimization and utilized features like SQL Dynamic Management Views on various Dev, Test, and Pre-Prod and Prod databases to fixed the issues.
• Configured Transparent Data Encryption for securing databases and backups to ensure Data Security.
• Configured and maintained Log shipping to provide backup server solution for environments
• Installation of Replication Server, Configuration and Monitoring the replication, implemented Transactional Replication and Snapshot replication.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Implemented Disaster Recovery for SQL Server DBA Production Database as Fail-Over or Standby Servers.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked on database Design and Architecture based on business user requirements and performed Normalization (Third Normal Form) and De-Normalization.
• Done Password Changes on cluster and Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Have completed Domain Migration on large cluster having almost 16 SQL Server Instances.
• Having Experience on Data center servers and handling 1.5 TB databases
• Monitored production servers using tools like SQL Profiler, Windows Perform, Performance Counters and SQL server logs
• Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.

Environment: s: Windows Server 2003/2008, SQL Server 2008/2008R2, TFS, Idera, Light speed, SQL Server 2012/2008 r2/2008

Confidential

SQL Database Administrator

Responsibilities:

• Monitored production servers using tools like SQL Profiler, Windows Perform, Performance Counters and SQL server logs.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Implemented the SQL Server concepts database mirroring, database snapshot, DMV’s, Mail Setup, Jobs and Alerts, SQLCMD and dedicated admin connection.
• Written and deployed SQL Scripts for low disk management, Rebuilding/Reorganizing index, CPU Resources usage using DMVs.
• Supported development team in deploying the prod scripts from TFS path via change requests which are approved in CAB meeting and worked on all types of tickets (Access, linked server, DB refresh).
• Comparing the database structure, generate the scripts and then sync between the servers using Red gate tool and refreshing the databases by using replication manager (EMC).
• Worked on DB refreshes by using Native and third-party tools like Delphix, lite speed and Created database maintenance plans, regular scheduled DBA tasks like Database Integrity Backups and optimization jobs.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Installation & Configuration of all editions of SQL Server 2000, 2005, 2008 (2008R2) and 2012.Designing & Deploying databases for various front-end applications.
• Planning and configuring Disaster Recovery plans using SQL High End Technologies. Setting up log shipping, Replication, database mirroring and maintaining them. SQL cluster installation and maintenance.
• Working on SQL Reporting services, analysis services. Deploying, scheduling SSIS packages and troubleshooting.
• Deploying EDS monitoring tool on all the servers. Database restructuring for PAM operations, this includes the Database Design for keeping their IAM and Privileged Access Management for Account vaulting and remediation.
• Ensure Recoverability of MSSQL databases: production and non-production. Maintain high standards of backup/recovery, conduct recovery tests
• Ensure best performance of the critical databases through efficient maintenance and performance tuning
• Wrote technical documentation. Support and implement database changes, ensure quality of the changes.

Environment: s: Windows Server 2003/2008, SCOM, Delphix, Red gate, TFS, EMC, SQLServer 2008/2008R2/2012

Confidential

SQL Database Administrator

Responsibilities:

• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008 /2005 Standalone environments.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• 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.
• Rebuilding and monitoring the indexes at regular intervals for better performance and analyzing, identifying and resolving slowness issues.
• Backup client databases and perform database restore and run consistency checks from SQL Server. Performs and monitors daily database operations and set-up backup schedules.
• Configured log shipping, Mirroring and troubleshooting issues.
• Worked closely and efficiently with all levels of management to satisfy project and productivity requirements, offered logical, forthright thinking and is able to provide effective solutions to solve difficult problems.
• Control operational procedures and support (including data modeling, replication, administration, maintenance, performance monitoring/optimization, SQL Tuning, capacity planning, space management and recovery)
• Evaluate specifications and requirements against available solutions. Ensure system integrity and efficiency.
• Ensure High Availability of the database systems: SQL Server backup & Recovery, clustering, replication, database-mirroring and Log shipping
• 24 * 7 Production Support. Compliance with the Daily/weekly/monthly activities.

Environment: Windows Server 2003/2008, SQL Server 2005/2008/2008 R2,SCOM

Confidential

SQL Database Administrator

Responsibilities:

• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008 /2005 Standalone environments.
• Meet the SLA (Service Level Agreement) established.
• Creation of Databases, Assigning Roles and managing user permissions.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Setting up Linked Servers across the environments based on the Requests.
• Backup client databases and perform database restore and run consistency checks from SQL Server. Performs and monitors daily database operations and set-up backup schedules
• Fixing Orphaned users through Stored Procedures.
• Configured log shipping, Mirroring and troubleshooting issues.
• Involved in configured transactional replication and resolving the issues.
• Ensuring Data consistency in the database through DBCC commands.
• Running Index tuning wizard and rebuilding indexes for faster query response
• Creating and Monitoring SQL Server agent jobs and troubleshooting as required.
• Used Process Explorer for maintenance of stuck process, and to release the handles on files
• Monitor the status of Maintenance jobs.

Environment: SQL Server 2005/2008/2008 R2, Windows Server 2003/2008.