SUMMARY

• 11 Years of experience in IT fields, Primary experience as SQL DBA, Azure database.
• Experience with various Industries as a SQL Server DBA in MS SQL SERVER administration, analysis, design, testing, presentation and implementation.
• Good knowledge in Installation, database maintenance, backup & recovery, performance tuning, upgrade, disaster recovery and high availability in SQL Server.
• Planning Backup/Restoration/Recovery strategy. Migration to cloud.
• Good knowledge of Relational Database Management Systems (RDBMS)
• Excellent understanding of TSQL.
• Managing Database Structure, Capacity Planning, Space Management and Data extraction
• Good knowledge about Window OS and active directory and bath scripting.

TECHNICAL SKILLS

• SQL 2005\2008\2008R2\2012\2014\2016\2017, Oracle 10g,11g. database, AWS database
• TSQL, VB, C#, Python, Powershell
• SQL Profiler, database tuning adviser, management studio.
• Windows and Unix
• Dell Spotlight, Idera diagnostic tool, Foglight, LightSpeed, NetBackupMicrosoft assessment and planning toolkit (MAP), Risk assessment and planning toolkit(RAP), sqlsafe, sqlSentry.TrueSight enterprise monitoring.

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL DBA SME

Responsibilities:

• Building SQL Server with Latest version of SQL Server in standalone and clustered environment.
• Working closely with Windows admin and SAN admin.
• Worked on building Windows and SQL clustered environment.
• Working on migration of SQL Servers to newer versions.
• Good knowledge of Relational Database Management Systems (RDBMS)
• Experienced in Installation, Configuration, Database Migrations and Upgrading of SQL Server from 2005 to SQL Server 2012/2014/2016/2017
• Experienced in Upgrading SQL Server Software to new versions with required Service Packs and Patches and hot fixes
• Management of high performance production CLUSTERED SQL Server database instances using Active - Passive nodes, and Active-Active nodes clustering.
• Handled all SQL administration related issues which includes, Installing, Configuring and troubleshooting Always-On, Replication, Mirroring, Clustering and Log shipping issues.
• Well knowledgeable in using advanced SQL Server features including alwayson, in memory OLTP,Query store, column store indexes.
• Analyze data and made performance recommendations that increased storage efficiency
• Analyze long running queries and tuned to optimize application and system performance.
• Experienced in Performance Tuning, Query Optimization, and Database Consistency Checks using DBCC Utilities
• Extensive knowledge in database maintenance and SQL Server Optimization using SQL tools such as SQL Profiler, Maintenance Plans, Foglight, Dell’s Spotlight, Idera diagnostic manager.
• Worked on controlling user privileges, monitoring the security and Audit issues.
• Experienced in managing Alerts, Operators and Jobs using SQL Server Agent and Active Batch Scheduler.
• Experienced in providing good production support for 24x7 over weekends on rotation basis
• Strong working knowledge on PowerShell scripting, performing automations of day today tasks.
• Knowledge on AWS, with RDS and EC2 instances. Worked on VPC and S3 (Simple storage Service).
• Strong knowledge of SQL Azure with IaaS and PasS.
• Experience in Azure data factory, Azure data Lakes, data warehousing.
• Experience in Azure log analytics and Azure storage.
• Experience in Azure file sync and Azure load balancers.
• Worked on Azure intersite connectivity, storage management.
• Good experience in high availability techniques and disaster recovery solutions.
• Capacity management making database growth forecast.
• Active participant in DR test.
• Working knowledge on SSIS and SSRS.

Confidential

Lead technology- Senior SQL DBA

Responsibilities:

• Implemented SQL Server 2012/2014/2016 new features like AlwaysOn Availability Groups for high availability of multiple databases in place of database mirroring and troubleshooting issues related to it. Implemented Stretch Database, in Memory OLTP for newer version of SQL Server.
• Migrating the on premise SQL databases to SQL Azure and Azure VM.
• Worked on developing PowerShell and TSQL script to automate database migration and day today activities. Good exposure on TSQL and PowerShell scripting.
• Provide development and design assistance to development and other application support teams
• Provide database administration, performance tuning and query optimizations support for Markets Business
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Perform database hygiene and maintenance to ensure optimum performance.
• Configuring the snapshot, transactional and merge replication and troubleshooting the issues related to it. supporting a production environment, working as part of an on-call rotation, and supporting off hour releases
• Database and SQL Query Tuning to improve performance.
• Daily support, troubleshooting, monitoring, optimization and tuning of server in SQL server Environments across entire system.
• Manage infrastructure performance and capacity and data security and make recommendations for improvements installed and maintained Active\Passive, Active\Active clusters with version 2008, 2012, 2014
• Help create, enforce and manage the policies and procedures for SQL Server security and Auditing.
• Participate in development and implementation of disaster recovery plans
• Developed SSIS packages to populate data from various sources, to extract data from flat files, Excel files.
• Working knowledge on SSRS and SSAS. Developed and deployed SSRS reports. Worked on troubleshooting SSAS database issues.
• Work with vendors to provide and monitor provided services
• Ensure the databases are highly secure, available, and recoverable
• Strong knowledge of SQL Azure
• Good experience in high availability techniques and disaster recovery solutions.
• Working knowledge on Active directory and domain controller.

Confidential

Senior Consultant -SQL DBA

Responsibilities:

• Production database Support for one of the largest staffing company.
• Leading DBA team by providing technical guidance to junior DBAs.
• Creation of SQL Server Audit report.
• Attending client meetings to explain newly available features in new versions of SQL Server and automation wherever possible.
• Document server and database policies and procedures. Creating Standard operating procedures for SQL Servers.
• Installation Standalone SQL Server and clustered SQL instances.
• Database Recovery and setting up a backup strategy.
• Implemented a recovery plan to a point in time failure.
• Technical Lead for migrating of databases from SQL 2008 to SQL Server 2012\2014\2016.
• Capacity planning for newly built servers and hardening of SQL servers.
• Performance tuning and query optimization of databases for slow running applications.
• Working on SSIS and SSRS and SSAS databases.
• Working and troubleshooting issues in Clustered Environment
• Setting up a snapshot\transactional\ Merge replication and troubleshooting issues related to it.
• Applying Service Packs and Security patches for the standalone and clustered SQL Servers.
• Implementing Alwayson high availability and troubleshooting issues related to it.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy
• Working on Performance optimization tools like foglight, spotlight, Red-gate diagnostic tool.
• Responsible for establishing best practices, standards
• Responsible for establishing and enforcing security mechanism.
• Writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Working on Powershell scripts to automate day to day work.
• Implementing Microsoft azure databases and Azure virtual machines.
• Migration of on premise SQL Servers to Microsoft cloud (Azure) and Amazon cloud (AWS)
• Installed and configured Oracle 10g and oracle 11G databases on Oracle Linux, RHEL.
• Provided regular DBA support for standalone oracle databases and RAC clusters
• Designed and implementation, monitoring a backup and recovery activities using RMAN, and Export/Import/data pump utilities.

Confidential

Senior SQL DBA, Shift Lead

Responsibilities:

• Configuring Mirroring, all types of Replication, monitoring and handling the issues related to it.
• Configuring and monitoring Log shipping of databases between the instances, and troubleshooting in case of failure.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Monitoring data and log files through script based monitoring.
• Preparation of daily backup report.
• Working and troubleshooting issues in Clustered Environment.
• User creation and assigning roles in all Environments.
• Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing.
• Reducing the dead locks by using the SQL server profiler hence the performance of the query is tuned.
• Installation and Configuration of SQL Server and applying Service Packs and Security patches for the standalone and Cluster servers.
• Installation and configuration of SQL Server Enterprise edition on Active/Passive Cluster and standalone environment.
• Security features were implemented for restricted set of users.
• Documented disaster recovery plans and participated disaster recovery drills.
• Implement table partitioning to improve performance and data management.
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.
• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using TSQL scripts, Backups and SQLA gent jobs without having any performance impact on Production server.
• Performed query tuning, assigned proper Indexes for better performance.
• • Provided 24 X 7 dedicated supports for SQL Server production server.