SUMMARY

• Over 14 Years of IT experience as a Microsoft SQL Server Database Administrator of real time challenging projects and looking for a creative and challenging career. Primarily as MS SQL Server Database Administrator focused on Installation, administration, upgrade, migration, security, backup and recovery, performance tuning and database migration from SQL lower version to latest version in On - Prem or Azure cloud.
• Administer Microsoft SQL Server environments and dependent infrastructure, including installation, configuration, monitoring, security and architecting and engineering of High Availability and Disaster Recovery solution for SQL Server
• Proactively optimize performance of databases through ongoing administration, performance and index optimization and updating/verifying current backup/recovery procedures
• Experience with SQL Server Reporting Services, Integration Services, Analytical Services
• Strong knowledge of SQL Azure database including migration from on-prem SQL servers
• Demonstrable skills of high availability SQL Server solutions, including C lustering, A lwaysOn, Replication Models (Snapshot/Transactional/P2P), Log Shipping and Mirroring.
• Document installation, configuration, and optimization procedures so they can be automated
• Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of user’s query tuning and performance optimization for the databases
• Provide support 24/7/365 for any troubleshooting or corrective actions related to incidents impacting application availability within the production environments
• Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

• SQL Database Administration 2000/2005/2008/2008 R 2/2012/2014/2016/2017
• Clustering and AlwaysOn Availability groups and DR recovery planning
• SQL server performance tuning and index optimization
• Cloud databases hosted on Azure & AWS
• SQL features - Query store, Always encrypted, TDE encryption, Data masking
• Diagnostic and monitoring tools like SentryOne, SolarWinds and Ignite

PROFESSIONAL EXPERIENCE

Senior SQL Server DBA

Confidential, Milford CT

Responsibilities:

• Managed and administered 300+ instances. Initiated a project to consolidate servers and to remove old/unused databases to reduce the number of databases and instances for on-prem and Azure cloud
• Installed and configured various SQL server’s version with clustered environment and availability groups including replication, mirroring and log shipping to provide HA-DR solutions and to achieve scalability of databases and improve read performance
• Approved and deployed builds in production servers for Quality Assurance and production releases following change request management
• Performed database maintenance, tuning, archiving, backups, recovery, software upgrades, capacity planning and optimization for SQL Server database and ensured accuracy of information and automated numerous functions
• Proactively monitored the database health through automated scripts for checking the database growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
• Improved performance, reliability, security and scalability by improving internal processes and make recommendations on new storage hardware including controlled and monitored user access to the database, backed up and recovered the database
• Maintained system security and monitored/optimized database performance for Data warehouse and OLTP applications and recommend and implement database server’s audits and security policies that are consistent with security guidelines and best practices.
• Provided 24/7 support to respond to SQL Server alerts and potential production database issues
• Worked with several teams and lead database team in the process of development of a Disaster Recovery and high availability solutions.

SQL Server DBA

Confidential, Danbury, CT

Responsibilities:

• Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
• Configured database Mirroring, Log shipping & AlwaysOn technology for the Disaster Recovery and business continuity plan
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Assist developers with complex query tuning and schema refinement.
• Provide 24x7 support for critical production systems.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

SQL Server DBA

Confidential

Responsibilities:

• Actively involved in Capacity Monitoring and short and long-term Capacity planning in collaboration with development resources, System Administrators and System Architects.
• Installed and configured Active/Passive SQL cluster with SQL Server 2008 R2 for high availability of SharePoint 2010.
• Created Individual/group logins and granted appropriate role to access database instance.
• Actively involved in SharePoint 2010 backend support and configured SQL Server databases as per application requirement.
• Performed database migration from SQL Server 2005 to 2008 and also migrated databases from 2008R2 to 2008 using import/export wizard.
• Troubleshoot performance issue with SQL Server databases and improved database performance.
• Identified issue with failed SQL jobs and resolved it in a timely manner.
• Monitoring event log and Server error log to troubleshooting purpose.
• Performed database refresh as per application requirement to support development work.
• Identify and resolved Blocking and Locking issue using DMV (Dynamic Management View) and Activity Monitor.
• Configured and monitored Maintenance Plan for daily and weekly maintenance activity.
• Identified data fragmentation and performed Index reorg or Index rebuild when required.
• Applied Microsoft Security patches on standalone as well as on cluster servers.
• Monitored Server disk space and took corrective action if required.
• Scheduled and monitored existing/new jobs on production environment.
• Worked on linked servers to run distributed queries between SQL servers

SQL Server DBA

Confidential

Responsibilities:

• Installation and configure SQL Server 2005.
• Partly Involved in System study and database designing.
• Manage SQL Server login and Users.
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server 2000
• Configure Log shipping for disaster recovery solution.
• Created linked server to access data using cross database query.
• Created backup, Integrity check, Index reorg/rebuild and update statistics using maintenance plan.
• Migration of data from different RDBMS to SQL Server.
• Export& Import the data between different SQL Servers And different Oracle servers.
• Check and Resolve the connectivity issues for development and Production Database Servers.