Amit Patil

Years of Experience in Database Training classes

10

Teaching Experience in detail in Database Training classes

I am Microsoft Certified (AZURE Cloud & SQL DBA) lead. Certified in Amazon AWS RDS & MS Power BI. With 14 years IT experience. I trained 1000+ students on DBMS, RDBMS concepts. Major training on MSSQL server, Azure SQL Cloud database & AWS RDS. I train on real time SQL server, Azure SQL. SSMS 2012 to 2022 on premise databases & cloud databases Azure SQL cloud database, migration from on-prem to cloud database, data analytics, data bricks, data factory data engineering basics. Database PaaS – SQL Azure DBA. • Understanding of fundamentals of Azure (IaaS, PaaS & SaaS). • Clarity on important Azure IaaS/PaaS Services. • Creating Azure Virtual Machines on Windows machines. Using Azure Virtual Machine Images (which includes SQL Server). • Creating/configuring Azure SQL Databases (PaaS/DBaaS) • Creating Server/Database firewall rules in Azure SQL Databases. • Creating logins & users for Azure database and securing databases. • Exporting DACPAC/ BACPAC from Azure SQL Databases. • Migrating On-Prem Databases to Azure SQL Databases (Singleton) using DMA. Exposure to DMA tools for On-Prem and Azure migrations. • Performed end to end migration using DMS (Data Migration Services) Azure Service. • Performed Lift/Shift migrations from On-Premises to Azure Managed Instance. AWS RDS Database Administrator • Implement databases in AWS cloud environments, aligning with the best scalability, security and performance practices. • migration from existing databases to AWS

Years of Experience in SQL Server Training

10

Teaching Experience in detail in SQL Server Training

SQL server DBA. RDMS, DBBMS, SQL query, TSQL. • Expertise in Installation, configuration, maintenance and troubleshooting of MS-SQL Server 2008 R2, 2012, 2014, 2016, 2019 on Windows platforms and on All Environments. • Experienced in Database Upgrade, Migration, Database Refresh and troubleshooting orphan users. • Automated processes to reduce workflow by creating maintenance plan that runs daily to reorganize, rebuild, and update statistics, backup & clean up task in my environment. • Experience in Managing Security of SQL Server 2012 to 2019 Databases by creating Database Logins, Users, Roles and Assigning proper permissions according to the business requirements. • Ensuring that all databases are backed up on a regular basis by monitoring & fixing backup failures. Restore failed Backups on Business requirement. • Database tuning and performance monitoring. • Performed DDL, DML & DCL Operation on as per Business need. • Performed writing DML Commands, JOINS, Bulk Insert, BCP & Update command on-Call responsibilities for Production database systems. • Managing of database objects like Tables, Views, indexes & Stored Procedure (SP), Trigger. • Handled issue on Database Suspect Mode. • Monitoring Disk and Log space issue on Server. DB Shrinking and DB Movement activities. • Monitored lock Escalation, Dead Locks, resources utilization by sessions, capturing long running SQL queries.

Years of Experience in Cloud Computing Classes

10

Teaching Experience in detail in Cloud Computing Classes

Microsoft Azure Cloud computing. Data analytics, Azure SQL database, IaaS, PaaS, SaaS concept, practical's & assignments on real time. SQL Azure Database Administrato, Datafactory • Understanding of fundamentals of Azure (IaaS, PaaS & SaaS). • Clarity on important Azure IaaS/PaaS Services. • Creating Azure Virtual Machines on Windows machines. Using Azure Virtual Machine Images (which includes SQL Server). • Creating/configuring Azure SQL Databases (PaaS/DBaaS) • Creating Server/Database firewall rules in Azure SQL Databases. • Creating logins & users for Azure database and securing databases. • Having knowledge on Azure Elastic Pool Databases and Elastic Jobs. • Exporting BACPAC from Azure SQL Databases. • Creating and configuring Azure SQL Database Managed Instance. • Migrating On-Prem Databases to Azure SQL Databases (Singleton) using DMA. Exposure to DMA tools for On-Prem and Azure migrations. • Performed end to end migration using DMS (Data Migration Services) Azure Service. • Performed Lift/Shift migrations from On-Premises to Azure Managed Instance • SQL Database, Elastic DBs, Managed Instance, Migrations • Migrated SQL Database from On-premises (On-Prem) to Azure Database (Cloud) using different techniques DMA, DMS, BACPAC. • Installation & configuring NOSQL database on Azure platform

Years of Experience in Class I-V Tuition

5

Teaching Experience in detail in Class I-V Tuition

I am Mrs. Sowmya, MBA graduate from Bangalore - Karnataka. I give tuition to school students from 1st to 5th standard. Near by Arekere, Vijaya Bank layout, Akshaya Nagar, JP Nagar, Hulimavu, Meenakshi Mall, BBTS Layout, Billekahalli. Trained 100 + students Special classes in Kannda.