SUMMARY

• Seasoned IT professional with comprehensive Technical skill set in SQL Server DBA production support.
• Proficient problem - solver who envisions business and technical perspective to develop workable solutions.
• Experienced in handling Production issues and providing efficient solutions.
• Excellent database support record demonstrating excellent customer service, ability to troubleshoot and ability to innovate and customize.
• 12 years of experience as SQL Server Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008, 2005 and 2000
• Have Hands-On experience on various databases (Oracle,PostgreSQL)

AREAS OF EXPERTISE

• SQL Server Database Migrations / Upgradations
• Proficient SQL Server DBA with excellent understanding of database concepts like T-SQL, Backups, Log Shipping, Replication, Mirroring, Always-On, Clustering (Windows, Veritas)
• Worked in Client Side (Microsoft).
• Hands-On experience in Oracle and PostgreSQL databases
• Hands on experience in SQL Server DBA production support, WLBS Cluster
• Power shell scripting and SQL Queries

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Operations support/ Database Administration

Technologies used: SQL Server 2005, 2008, 2012, 2014 and 2016, Oracle, PostgreSQL

Responsibilities:

• Worked on SQL Server 2016 & 2012 migration from SQL Server 2008 / 2005 (using Backup/Restore, Detach/Attach and Drive/Mount point mirroring)
• Worked on SQL server Import/Export for moving the data from higher version to lower version
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
• Expertise in designing databases and capacity planning.
• Implemented Merge Replication for CISCO databases
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Handling database space issues
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Troubleshoot performance problems
• Implemented Always-ON (AAG) on SQL Server 2016 SP1 (4 Node Configuration)
• Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 (2 Node Configuration)
• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Logging into the server and setting the environment
• Creating Users and granting them access
• Creating schemas and Roles
• Created DB link as per the users request
• Performing Import/Export on the schema level as per the users request
• Executing scripts as on the Oracle databases and spooling the output of the scripts
• Looking for active sessions and checking if any queries are running longer
• Checking the database status in RAC using SRVCTL commands
• Checking the TableSpace details and increasing the space if required
• Installing Postgres on the Linux server
• Creating database and connecting to the database
• Creating users and granting them the required access
• Creating the tables as per the application requirements
• Taking backup and restoring the database using PGADMIN tool
• Stopping and starting the Postgres instance
• Creating schema’s and creating tables on the schema
• Executing the scripts on the Postgres database using PGADMIN tool

Confidential

SQL Server Operations support/ Database Administration

Technologies used: SQL Server 2005, 2008, 2012 and 2016

Responsibilities:

• Worked on SQL Server 2016 & 2012 migration from SQL Server 2008 / 2005 (using Backup/Restore, Detach/Attach and Drive/Mount point mirroring)
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
• Expertise in designing databases and capacity planning.
• Created SILENT install scripts for installing SQL server 2012 and 2016 without any manual interruption
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Handling database space issues
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Troubleshoot performance problems
• Implemented Always-ON (AAG) on SQL Server 2016 SP1 (4 Node Configuration)
• Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 (2 Node Configuration)
• Strong experience in mentoring team members and writing documentation.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Experience in using SQL Server Profiler, SQL Server Agent

Confidential

SQL Server DBA

Responsibilities:

• Installations, Up-gradations, Applying Service packs, Handling Production issues, Monitoring Backup jobs, Applying Security Settings, Monitoring SQL jobs, Doing Master Rebuilt, Creating RCA’s.

Confidential

Database Administration

Technologies used: SQL Server 2000, 2005, 2008.

Responsibilities:

• Troubleshooting of backup failure
• Doing master rebuilt
• Creating RCA’s
• Migration of the Databases from lower version to Higher versions
• Creating Logins and granting access to the users
• Handling T-log space issue
• Working with clustering and standalone SQL servers
• Failover in Clustering
• Restoration of DB’s from PROD to Pre-PROD, DEV, etc…
• Creating Logins and providing the access
• Installing SQL server 2005, 2008
• Creating secondary data and log files in case of space issues both in standalone and Clusters
• Table refresh between instances using IMPORT and EXPORT
• Creating databases
• Doing table level restore
• Install / Upgrade the SQL server on production servers
• Troubleshooting space issue
• Creating and scheduling the change

Confidential

SQL Server DBA

Responsibilities:

• Installations, Handling Production issues, Security patches, Monitoring Backup jobs, Applying Security Settings, Managing IIS servers, Involving in Smoke Testing, Monitoring SQL jobs, Reporting.

Confidential

Database Administration

Technologies used: SQL Server 2000, 2005

Responsibilities:

• Troubleshooting of backup failure
• Migration of the Databases from lower version to Higher versions
• Creating Logins and granting access to the users
• Handling T-log space issue
• Working with clustering, mirroring, Replication and Database Mirroring
• Failover in Clustering
• Restoration of DB’s from PROD to Pre-PROD, DEV, etc…
• Creating Logins and providing the access
• Installing SQL server 2005
• Creating secondary data and log files in case of space issues both in standalone and Clusters
• Creating maintenance plans and scheduling the jobs
• Configuring Replication, adding an article in Publications, Troubleshooting Transactional Replication issues
• Table refresh between instances using IMPORT and EXPORT
• Creating databases
• Install / Upgrade the SQL server on production servers
• Troubleshooting space issue
• Moving the system DB’s to another location (Master, Model, MSDB and Tempdb)
• Taking backups of the Encryption Key
• Executing the scripts on user’s request
• Patching SQL server

Confidential

DBA for Production

Technologies used: SQL Server 2000, 2005 & 2008

Responsibilities:

• Migration of the Databases from lower version to Higher versions
• Creating Logins and granting access to the users
• Handling T-log space issue
• Working with clustering, mirroring, Replication and log shipping environment
• Table refresh between two servers using DTS
• Database refresh (using Backup, restore and Detach, attach)
• Creating Logins and providing the access
• Installing SQL server
• Creating maintenance plans and scheduling the jobs
• Creating databases
• Install / Upgrade the SQL server on production servers
• Troubleshooting space issue
• Recreating the Index
• Moving the system DB’s to another location (Master, Model, MSDB and Tempdb)
• Taking backups of the Encryption Key

Confidential

DBA for Production

Technologies used: SQL Server 2005, Windows.

Responsibilities:

• Working as Primary DBA for production database, Solving On calls Issues and Supporting PG (Product Group) Team
• Monitoring, rerunning the backups and trouble shooting in case of failures
• Adding or removing the servers in DPM backups as per the customer’s request.
• Upgrading the DPM agent in all the servers (ie.., Master servers as well as the client servers) across all the regions
• Reducing the manual efforts by writing SQL Queries.
• Creating and using the power shell scripts to pull the backup details for the protected servers and their resources.
• Checking the connectivity issues between master servers and protected servers.
• Checking the connectivity issues between master servers and protected servers.
• Monitoring and rerunning the SQL jobs which are using to pull the BACKUP success report details.
• Troubleshooting the SQL jobs in case of any failure and engaging the respective teams for further clarification and for further Analysis.
• Changing the password for the account which is used to run the jobs (SQL Server Agent Services).

Confidential

DBA for Production

Technologies used: SQL Server 2005, IIS 6.0 and Windows

Responsibilities:

• Working on SQL authentication
• Monitoring backup jobs
• Monitoring SQL machines and IIS machines using Sitescope tool
• Checking the SQL replication between EBIS DB and Confidential DB
• Adding and removing the IIS servers whenever needed,
• Smoke testing Confidential tool, once the ops team upgrade,
• Given proper training for new joiners.
• Checking all the terminal servers and doing DELPROF if the users are facing any issues,
• Applying the Security Patches and rebooting the servers.
• Checking the backend if the user is having any problem while creating an account
• Rerunning the jobs (FEEDSTOREMETROUSERFEEDJOB & VENDORPORTALSYNCJOB)
• Activating the support location in Back end.
• Installing the upgraded Confidential in all the Terminal servers
• Monitoring and optimizing the performance of the Confidential Database.
• Raising Change request in order to increase the LUN growth in production servers