Ashwani Kumar Gandla

Sr. Database Administrator

Contact: 267-***-****

Email id – ad4xmb@r.postjobfree.com

Database Administrator with Azure, AWS, and On-premise hands-on.

Professional Summary:

●Over 8 years of experience as a SQL Server DBA including migrations.

●Resolved report failures due to objects structural changes, server settings and timeout settings.

●Experience in Azure SQL Databases and Managed Instances.

●Experience in Elastic Jobs creation for Azure SQL databases where there is no SQL Agent for automation.

●Experience in Azure Arc - Windows servers and SQL Managed Instances.

●Setting up Azure Arc managed instance for Kubernetes clusters.

●In-Depth knowledge and experience in data modelling including gathering and analysing business requirement.

●Solid working experience in managing large databases in 24/7 data processing environment including backup/recovery, performance tuning, monitoring, stored procedures, triggers, functions, constraints, and views etc.

●Have performed 400 successful Database server migrations including 3000 databases approximately involving SQL 2005 to 2012, SQL 2012 to 2016, SQL 2012 to SQL 2019, SQL 2016, 2017 to Azure Cloud, SQL 2012,2016 to AWS RDS.

●Hands on experience on various migration methodologies involving Backup restore, Attach Detach, Scripting the Schema & Data, Bacpac, Replication and Data Migration Services.

●Hands on experience in implementing High availabilities and Disaster recovery solutions including Always ON Availability Groups, failover Clustering up to 6 Nodes, Database Mirroring and Log shipping.

●Configured SQL Server Always Encrypted for sensitive data.

●Hands on experience in configuring and troubleshooting multi-subnet Always ON availability clustering and experience in providing solutions for Performance, availability, and recovery of Always ON Databases.

●Have unique and industry standard troubleshooting methodologies in resolving SQL Server related issues.

●Worked on providing solutions to the clients on Capacity planning of the New Database servers and providing Microsoft standard recommendations along with appropriate DB architecture diagrams.

●Hands on experience in troubleshooting performance issues involving indexes, missing indexes, unused indexes, statistics, Execution plans, Perfmon and Database Tuning Advisor.

●Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.

●Hands on experience on performing optimal Database maintenance daily, weekly, monthly involving Index maintenance, Index tuning, Rebuild & Reorganizing based on Index fragmentation levels, integrity and consistency checks and Updating Statistics accordingly.

●For highly business critical DBs, implemented processes to notify of Data corruptions, Database blockings, long running queries, identifying disk IO slowness issues.

●Experience working in business critical 24X7 live environments.

●Experience in handling extremely large Databases up to 30 TB.

●Very good understanding of SQL Server Architecture and recommendation of optimal Memory settings and CPU configurations for SQL Server.

●24*7 Production support for various client applications that include enhancement and upgradation based on the Change requests that are set to implementation.

●Have good knowledge on isolation levels in SQL Server and wait types of SQL Server.

Technical Skills:

Operating Systems

All Windows PC and Servers

RDBMS

Azure SQL Database, Azure SQL Managed Instance, SQL Server 2005 till 2019

Cloud Technologies

Microsoft Azure, AWS (EC2 and RDS)

SQL Server Tools

SSMS, Configuration Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Server Profiler, Database Engine Tuning Advisor

Languages

DDL, DML, T-SQL

Reporting Tools

Nagios XI

Third Party Tools

ActiveXperts, Litespeed, Nagios

Professional Experience:

Employer: i-Fact Technologies

Client: Lumentum, USA

Role: Database Administrator

Duration: October 2019 to Till Date.

Project Contribution:

●24*7 application support including CRQ that are in implementation statuses.

●Experience in migrating on-premise standalone SQL servers to Azure and AWS.

●Installed SQL Server AlwaysON Availability Groups with multiple replicas as HADR solution.

●Managed with Basic Availability Group in order cut down license costs.

●Applied Service Packs and Cumulative Updates for around 70 Prod Servers only after testing them on the Dev/UAT servers.

●Created logins and assigned limited permissions to the developers as part of security control.

●Configured backups using Litespeed as well as Ola scripts based on the environment.

●Worked on Restoration through Litespeed backups.

●Followed ITIL process for all the SQL related tasks.

●Creating logins and assigning proper permissions to the created logins, mapping logins to the database users and granting appropriate permissions, including orphan users fixing.

●Creating Maintenance Plans, Scheduling Jobs, Setting-up DB-Mail, Alerts and Operators using SQL Server Agent.

●Creating Users on both Development and Production environments.

●Experience in deploying SQL Databases in cloud (Azure and AWS).

●Have worked on Replication, Database mirroring and Log-shipping and fail-over clustering high availabilities

●Resolved critical performance issues and finetuned the queries that were having issues

●Worked on creating reports for the Database backups, database growth on multiple servers.

●Resolved critical performance issues involving missing indexes, unused indexes and statistics.

●Worked on performing Database refreshes as per the request of the Dev and UAT teams.

●Implementing end to end Database security solutions involving Database level, table level and object level security.

●Worked 24x7 in rotational shifts as per the client requirements.

●Provided on-call support for critical Production database Environments.

Employer: i-Fact Technologies

Client: US Concrete, USA

Role: Database Administrator

Duration: January 2018 to Oct 2019.

Project Contribution:

●Analysing your database workload on an Amazon RDS for SQL Server DB instance with Database Engine Tuning Advisor.

●Experience operating Microsoft data platforms (Azure and Amazon) database design and data modelling.

●Performed SQL Server Database Administration, Installations, configuration, and maintenance.

●Managing Backups daily and Recovery as per request.

●24*7 application support including CRQ that are in implementation statuses.

●Automating the Backups, Shrinking the T-Logs.

●Creating Indexes as part of performance enhancements.

●Creating Maintenance Plans, Scheduling Jobs, Setting-up DB-Mail, Alerts and Operators using SQL Server Agent.

●Reorganizing or rebuilding the indexes based on Fragmentation levels (percentages).

●Applied Patches & Hotfixes as and when released.

●Perform installation, configuration and maintenance of database management systems and related software within the context of a database administration plan.

●Develop/maintain database utilities and automated reporting.

●Creating Users on both Development and Production environments.

●Monitoring Disk Space of all the Servers and freeing up space.

Employer: i-Fact Technologies

Client: Brinks, USA

Role: Database Administrator

Duration: August 2014 to Dec 2017.

Project Contribution:

●Experience in migrating sql servers to AWS.

●Experience in migrating databases from on-premise to RDS.

●Installed SQL 2012/2014 with AlwaysON (2 & 3 replicas).

●24*7 application support including CRQ that are in implementation statuses.

●Good hands-on experience in resolving issues with AlwaysON.

●Built 2 node and 3 node Clusters with Active - Active and Active – Passive configurations.

●Worked on SQL Server 2008R2 Remediation and migrated them to SQL Server 2012.

●Involved in SQL Server 2012 Installation and applied Service Packs and Cumulative Updates for around 243 Servers.

●Creating logins and assigning proper permissions to the created logins, mapping logins to the database users and granting appropriate permissions, including orphan users fixing.

●Created backups with expiration as per user requirement.

●Managing Backups daily and Recovery as per request.

●Creating Indexes on frequently used columns of a table to make the query run fast.

●Creating Maintenance Plans, Scheduling Jobs, Setting-up DB-Mail, Alerts and Operators using SQL Server Agent.

●Reorganizing or rebuilding the indexes based on Fragmentation levels (percentages).

●Applied Patches & Hotfixes as and when released.

Educational Qualifications:

Bachelor of Commerce, Andhra Pradesh, India.

Specialization: Computers.

Contact this candidate