VAIBHAV CHAVAN

12+ years of experience in Database Administration for very large and complex databases in SQL Server (2005 to Current Release 2022), Azure SQL Databases, AWS RDS MSSQL & MySQL Databases, MySQL 8.0 RDBMS, PostgreSQL DB, MariaDB, MongoDB, Azure MySQL Databases, Ali Cloud MySQL Databases. Managed a Team Of 10+ DBAs. Experience in implementing, Managing, and troubleshooting. • SQL Server (Always-On High Availability, Replication, Log Shipping, Mirroring, Clustering) • Azure SQL Cloud (Single Database, SQL Elastic Pool, Azure SQL Managed Instance, SQL Server on Virtual Machine (Availability Options, Load Balancing (Azure Load Balancer, Application Gateway)), Geo Replica, TDE (Transparent Data Encryption), Dynamic Data Masking, Query Tuning, Query Performance Insight) • AWS Cloud (Amazon Aurora MySQL-Compatible, Aurora Serverless MySQL-Compatible, AWS RDS MSSQL, MySQL, PostgreSQL, Multi AZ Cluster, Cloud Watch, Performance Insight) • MySQL 8.0 (Replication (Master-Slave), Innodb, MyISAM storage engines, cluster, Percona server) • Azure MySQL (Single Server, Flexible Server, Replication, High availability) • PostgreSQL (Replication (Master-Slave), Continuous Archiving and Point In Time Recovery(PITR)) • Ali Cloud (ApsaraDB RDS for SQL Server, PostgreSQL, MySQL - Replication (Master-Slave)) • MariaDB (Replication (Master-Slave), Clickhouse DB (Replication (Master-Slave). • MongoDB (Replication, Atlas, Robo3T, Sharded Cluster(replica sets), high availability, Index creation) • Azure Data Engineer: Azure Synapse Analytics, Azure Data Factory, Databricks, Data Lake, Blob Storage. • Azure Power BI Analyst: Design Power BI Dashboard, Power BI Desktop, DAX Expression. • Databricks: Unity catalog, Create Workspace, Manage access control, Configure metastores. • Oracle: Shrinking data file, tablespace, data file resize, delete archive log, RMAN Backup, temp tablespace.

12+ years of experience in Database Administration for very large and complex databases in SQL Server (2005 to Current Release 2019), Azure SQL Databases, AWS RDS MSSQL & MySQL Databases, MySQL 8.0 RDBMS, PostgreSQL DB, MariaDB, Azure MySQL Databases, Ali Cloud MySQL Databases.  Experience in installation, configuration, migration and upgrading MSSQL server, Azure SQL, AWS RDS MySQL Databases under the role of DBA. Managed a Team Of 10+ DBA’s. Experience in implementing, Managing, and troubleshooting a. SQL Server (Always-On, Replication, Log Shipping, Mirroring, Clustering) b. Azure SQL (Single Database, SQL Elastic Pool, Azure SQL Managed Instance, SQL Server on Virtual Machine (Availability Options, Load Balancing (Azure Load Balancer, Application Gateway)), Geo Replica, TDE (Transparent Data Encryption), Dynamic Data Masking, Query Tuning, Query Performance Insight) c. AWS Cloud (AWS RDS MSSQL, MySQL, PostgreSQL, Multi AZ Cluster, Aurora Serverless, Cloud Watch, Performance Insight) d. MySQL 8.0 (Replication (Master-Slave)) e. Azure MySQL (Single Server, Flexible Server, Replication, High availability) f. PostgreSQL (Replication (Master-Slave) g. Ali Cloud (MySQL - Replication (Master-Slave)) h. MariaDB (Replication (Master-Slave), Clickhouse DB (Replication (Master-Slave).  Administering MSSQL Server and MySQL High Availability, Backup/Recovery and Disaster Recovery strategies. Experience in Database Migration: a. MSSQL DB On-premise to Azure SQL DB, Azure SQL MI using Data Migration Assistance, Database Migration Service, BACPAC file. b. MSSQL DB On premise to AWS RDS MySQL DB (AWS Data Migration Service, AWS Schema Conversion Tool, Data Loader tool) Experience in Database DevOps, Database CI/CD and Deployment Automation Troubleshooting database performance problems, fine-tuning, and index Analysis Experience in SSIS, SSRS installations and Deployments. 24x7 production Database on-call support.

Installation, configuration and maintenance of MS SQL Server Database.  Implementing the latest Services packs and its hot fixes. Database administrating with proficiency in SQL Server 2008 & 2008 R2, 2012, 2014, 2016 & 2017 Production Environment.  Providing support to 460 Production databases on a cluster environment with 24*7 DBA support and same number of Staging, Development and QA Environment databases. Size of the production databases range from 1GB to 4 TB with total size of 20 TB for all databases.  Upgrading/Migration and consolidation of SQL Server.  Involving DC to DC migration of database servers and prepared cook book for steps.  Implementing backup and DR strategy for production databases.  Process improvement through Six Sigma methodology for cost saving in various projects  Managing Security (Creating users, logins and roles, granting permissions).  Disk management through automated SQL script.  Ensuring Data consistency in the database through DBCC commands.  Create and maintain Database jobs and SSIS packages on production server.  Proactively check SQL server performance by using Perfmon counters, Profiler, SQL Script and other third party tools. Analyze long running slow queries and tune the same to optimize application and system performance.  Rebuilding/Reorganizing indexes at regular intervals for better DB performance.  Configuring DR techniques like Log shipping, Replication, Mirroring and Clustering in production environment. Developing automated SQL scripts for process improvement.  Providing 24/7 On-Call support for critical production databases.  Troubleshooting SQL related problems  Creating Monthly analysis reports for the Database Growth and Performance Statistics.  Participation in the conference call with the client on processes and upcoming task.  Prepare High level design (HLD) document for SQL Server for new customer.

I worked On-site at SAP Hungary Kft in Budapest, Hungary.  Involved in installing and configuring MS SQL Server 2008 & 2008 R2, 2012 on Windows Server 2008 and 2008 R2, 2012 environment.  Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transactional log backups, fixing backup failures.  Managed Logins, Users, Roles and User permissions.  Implementing and Monitoring of high availability solutions like Log shipping.  Implementation and Configuration of complex transaction replication  Creating and Managing Databases and its Objects. Giving role to database according to requirement.  Shrinking database & Transaction logs.  Setting up maintenance tasks for integrity, consistency checks and Database optimizations.  Backup, Restoring and Recovering Databases  Implementing Database Security  Configuring and Maintaining Log Shipping  Created and transferred Logins with passwords and its mapping with users.  Performance and Tuning (Performance Monitor, SQL Profiler, Query analyzer, Index Tuning Wizard)  Email Configuration to send database mail.  Attending & resolving tickets from ITSM (BMC Remedy user) and CASDM and Service Now  Monitoring using Insightsd.

 Responsible for the Management of 350 Database Servers with size up to 20TB  Deftly manage installation and configuration of SQL Database Windows, various applications, configuration of SQL Application and necessary SQL upgrades. Database Administration in SQL Server, taking backup, creating roles, giving rights to users, up gradation and migration.  Implementing Log shipping (As a Part of Disaster Recovery Plan), Implemented Mirroring, Creating Linked Server  Responsible for planning and organizing database, Database creation, manage users, password security, privileges & roles, performance tuning, restoration, user creation, script running, patch installation etc  Accountable for Planning and implementing database Backups and Recovery strategies and Run Integrity checks  Importing data to Databases through SSIS. Performance monitoring and tuning  Security Management for Databases. Shrink database & Transaction logs.  SQL Server Job Management. Availability Management, Create and Test Disaster recovery Plan  Disk Space management, Database Design and also perform maintenance and Log shipping  Creating Maintenance Plan and SQL Jobs  Database space management & finding growth per day  Deftly handling the task of database access, roles, users and privileges