­ ­­­­

SUMMARY

• Dynamic professional with 7+years of exposure in Backup & Restore, Security in SQL, always on & Mirroring, Replication & troubleshooting of database issues, currently functioning as Senior Analyst
• Well versed in installation, configuration and database creation & monitoring of MS SQL Server 2005/ 2008, 2012 & 2014 implementing Database Security, administration of user access permissions, roles and privileges.
• Skilled in runtime database optimization & performance tuning, configuration of high availability options always on, Mirroring, Log Shipping & Replication etc.
• Monitor & maintain production, test & development environments, schedule jobs, identifying performance issues & troubleshooting & DR Testing
• Proficient in monitoring database, checking error logs, checking log file size & free space in data drives, connectivity of databases. Backing up & restoring system, user databases, scheduling & assigning jobs, backup and recovery of databases.
• Silver Star award for Nov2012 in Confidential .
• Received monitory award from Confidential - 2016
• Received Employee of the month award Confidential -2017
• Good communication, interpersonal & problem solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives.

AREAS OF EXPERTISE

• Database Administration
• Configuration Management
• Troubleshooting/ Maintenance
• Windows Failover cluster / Clustering
• Backup/Restore, Disaster/Recovery and Security procedures
• DR Failover & fail back
• SQL Azure & basic power shell scripting

PROFESSIONAL EXPERIENCE

Confidential

Sr. Analyst

Responsibilities:

• Experience in SQL server 2014 installation, migration and upgrading SQL server from various versions.
• Failover cluster configuration on always on environment
• Maintaining and Monitoring DR sites.
• Hands on experience in Capacity Planning.
• Expert in Creating Standards, Compliances, Processes and Guidelines for Database Design, Coding, Test and Production Release and well versed with full SDLC.
• Managing Database Users and Security.
• Responsible for database performance monitoring and tuning for and identifying performance issues. This includes ensures that server is running with optimal performance, monitoring event log or error log for database errors.
• Jobs creation & scheduling including alerts.
• Basis idea on PowerShell & SQL Azure
• Experience on Failover cluster & always on configuration
• Monitoring space on server, handling issues with Log files, Shrinking Log and Data files.
• Experience in Database Consistency Checks using DBCC commands and checking server status using DMV’s.

Confidential

Sr. DBA

Responsibilities:

• Focus on automation of job creation & scheduling including alerts and other back up jobs.
• Performing Backup and Recovery. This includes establishing standards and schedules for database backups and making sure that the backup schedules meet the recovery requirement
• Maintaining and Monitoring DR sites.
• Managing Database Users and Security.
• Migration of production Database to new server.
• Decommissioned SQL Server, created scripts for proactive database monitoring and managed day to day database alerts.
• Responsible for database performance monitoring and tuning for and identifying performance issues. This includes ensures that server is running with optimal performance, monitoring event log or error log for database errors.
• Managing Database Users and Security.

Confidential

Sr. Specialist

Responsibilities:

• Accountable for maintenance of 450+ production & development databases servers spread across India, US and Boise.
• Importing & exporting & replacing in SQL Server 2005 Integration Service Packages.
• Upgraded service pack onto SQL Server and in cluster.
• Monitored database performance, tuned & identified performance issues, alerts & backup jobs and performance of OS & DB level.
• Migrated objects between database instances and production database to new server.
• Created & managed Database, Table, Views, Indexes & other Database Object. Automated creation & scheduling of jobs. Involved in replication & mirroring in SQL 2000 and 2005.
• Troubleshot business critical issues in SQL server including blocking and disk space issues.
• Installed SQL Servers, 2005 & 2008 & 2012 and resolution/ rectification of production issues within Service Level Agreements.
• Upgraded SQL server from 2005 and 2008 version. Monitored jobs, error logs, server space, health of databases & servers.
• Performed daily health check-up of production database servers; checked instance & DB level.
• Worked on various DBCC commands and rendered DBA support for various production & development servers.
• Implanted change requests, scheduled backup, exported/ imported and restored databases.
• Maintained tables & data objects; configured & troubleshot log shipping.
• Refresh database, generated back up reports and monitored/ troubleshot backups.
• Decommissioned SQL Server, created scripts for proactive database monitoring and managed day to day database alerts.
• Migrated & maintained data using various utilities like DTS, EXPORT & IMPORT and ATTACH & DETTACH Databases.
• Deployed database structures in production environment.
• Coordinated with the application development teams pertaining to performance tuning.
• Conducted Pre checks & testing prior to implementation of plans and checks to ensure prompt resolution of post migration issues.
• Have upgraded service pack onto SQL Server and in cluster.
• Responsible for database performance monitoring and tuning for and identifying performance issues. This includes ensures that server is running with optimal performance, monitoring event log or error log for database errors.
• Managing Database Users and Security.
• Planning and execution Backup/Restore, Disaster/Recovery and Security Procedure. Automated the Job Creation and scheduling

Confidential

Specialist

Responsibilities:

• Involved in administration of 160 high end database DB servers across different data centres including installation & configuration of SQL servers on various environments.
• Enhance availability of database through database mirroring, log shipping etc.
• Analyze & implement requested modifications to existing database structures for change requests and run database utilities (backup, recovery & creation of maintenance plans).
• Migrate objects between database instances (development, testing and production) and production database to new server.
• I have configured the SQL server mirroring, I have involved mirror failover & fail back during windows patch applying.
• Optimize space utilization through monitoring of space requirements for databases and adding storage space (disk drives) based on requirements. Perform Backup & Recovery, maintain and monitor DR sites.
• Manage database users & security through creation & management of Database, Table, Views, Indexes and other Database Objects.
• Planning and execution of Backup/Restore, Disaster/Recovery and Security procedures.
• Focus on automation of job creation & scheduling including alerts and other back up jobs.
• Performing Backup and Recovery. This includes establishing standards and schedules for database backups and making sure that the backup schedules meet the recovery requirement
• Maintaining and Monitoring DR sites.
• Managing Database Users and Security.
• Migration of production Database to new server
• Creating and Managing Database, Table, Views, Indexes and other Database Object.
• Planning and execution Backup/Restore, Disaster/Recovery and Security Procedure.
• Automated the Job Creation and scheduling.
• Monitoring the alerts and all backup jobs.
• Applying SQL server service pack & hot fixes.

Confidential

SQL Server DBA

Responsibilities:

• Verifying all instances are up and Running
• Day-to-day activities like backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement
• Installed and configured SQL Server 2005 on WINDOWS 2003 system. Applied service packs and security fixes to all SQL Servers
• Setup Transaction and Snapshot Replication and maintain the servers
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views.
• To analyze long running slow queries and tune the same to optimize application and system performance
• Monitored and modified Performance using execution plans and Index tuning- blocking & deadlocks.

Environment: Windows 2003/2000, MS SQL Server 2005/2000.