Amruta ANKOLA

• Demonstrated creativity and resourcefulness through the development of innovative solutions.
• Exercised leadership capabilities by successfully motivating and inspiring others.
• Paid attention to detail while completing assignments.
• Identified issues, analyzed information and provided solutions to problems.
• Strengthened communication skills through regular interactions with others.
• Participated in team projects, demonstrating an ability to work collaboratively and effectively.
• Proven ability to learn quickly and adapt to new situations.
• Demonstrated strong organizational and time management skills while managing multiple projects.
• Used critical thinking to break down problems, evaluate solutions and make decisions.

Technical Skills:

· Operating Systems: Windows Server (2008, 2008R2, 2012,2012R2,2016), Windows (7,8 & 10)

· RDBMS: Microsoft SQL Server (2005, 2008, 2008 R2, 2012, 2014 ,2016,2017,2019) & Oracle 10g to 12 c

· Language: Intermediate Knowledge of T-SQL and PL/SQL

· Clustering, Hyper-V, VMWare.

· Azure Administration-104 Certified.

· Azure dp-300

Amazon Certified:AWS Database Speciality and have cleared DBS-C01

• Experience in implementing SQL Server Security and Object permissions like maintaining Database authentication modes, creation of logins & users, configuring permissions and assigning roles to users.

SQL Performance

===============

• Configuring Log Shipping for databases on Production and Development environments.
• Knowledge of SQL Server tools (Profiler, DTA, SSMS, PerfMon, Process Explorer, , DMV’s).

· Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

• Setup, configuring and troubleshooting various high availability solutions like Log Shipping, SQL Cluster, Database Mirroring and AlwaysOn.

· Sound knowledge of indexes & statistics creation, effective management, working and storage.

· SQL Development: Ability to write and troubleshoot small SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints).

SQL Core

========

• Installation, Configuration, Maintenance and Administration of different versions (2005 to 2016) and different editions (Express to Enterprise) of SQL Server.
• Troubleshooting Installation, Upgrade and Patching Issues of SQL Server Standalone and SQL Clusters.
• Configuring and Validating Windows Cluster configuration and SQL Server Clustered instances on Physical as well as Virtual Environments.
• Understanding of various Database Recovery models, Backup and Restore, Implementing Point-in-Time recovery for databases and disaster recovery procedures.
• Scheduling Jobs for full, differential and transactional log back up of databases, configuring other maintenance plans to perform index de-fragmentation, re-indexing and updating the index statistics, troubleshooting issues related to failure of backups and maintenance jobs.
• Performing consistency checks of databases and tables using various DBCC commands and Handling issues related to corruption of databases.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Experience in implementing SQL Server Security and Object permissions like maintaining Database authentication modes, creation of logins & users, configuring permissions and assigning roles to users.

SQL Performance

===============

• Configuring Log Shipping for databases on Production and Development environments.
• Knowledge of SQL Server tools (Profiler, DTA, SSMS, PerfMon, Process Explorer, PSSDiag, DMV’s and SQL Nexus).

· Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

• Setup, configuring and troubleshooting various high availability solutions like Log Shipping, SQL Cluster, Database Mirroring and AlwaysOn.

· Sound knowledge of indexes & statistics creation, effective management, working and storage.

Leading projects with DR activities configuring HA for Various clients.

SQL Core

========

• Installation, Configuration, Maintenance and Administration of different versions (2005 to 2016) and different editions (Express to Enterprise) of SQL Server.
• Troubleshooting Installation, Upgrade and Patching Issues of SQL Server Standalone and SQL Clusters.
• Configuring and Validating Windows Cluster configuration and SQL Server Clustered instances on Physical as well as Virtual Environments.
• Understanding of various Database Recovery models, Backup and Restore, Implementing Point-in-Time recovery for databases and disaster recovery procedures.
• Scheduling Jobs for full, differential and transactional log back up of databases, configuring other maintenance plans to perform index de-fragmentation, re-indexing and updating the index statistics, troubleshooting issues related to failure of backups and maintenance jobs.
• Performing consistency checks of databases and tables using various DBCC commands and Handling issues related to corruption of databases.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Experience in implementing SQL Server Security and Object permissions like maintaining Database authentication modes, creation of logins & users, configuring permissions and assigning roles to users.

SQL Performance

===============

• Configuring Log Shipping for databases on Production and Development environments.
• Knowledge of SQL Server tools (Profiler, DTA, SSMS, PerfMon, Process Explorer, PSSDiag, DMV’s and SQL Nexus).

· Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

• Setup, configuring and troubleshooting various high availability solutions like Log Shipping, SQL Cluster, Database Mirroring and AlwaysOn.

· Sound knowledge of indexes & statistics creation, effective management, working and storage.

SQL Core

========

• Installation, Configuration, Maintenance and Administration of different versions (2005 to 2016) and different editions (Express to Enterprise) of SQL Server.
• Troubleshooting Installation, Upgrade and Patching Issues of SQL Server Standalone and SQL Clusters.
• Configuring and Validating Windows Cluster configuration and SQL Server Clustered instances on Physical as well as Virtual Environments.
• Understanding of various Database Recovery models, Backup and Restore, Implementing Point-in-Time recovery for databases and disaster recovery procedures.
• Scheduling Jobs for full, differential and transactional log back up of databases, configuring other maintenance plans to perform index de-fragmentation, re-indexing and updating the index statistics, troubleshooting issues related to failure of backups and maintenance jobs.
• Performing consistency checks of databases and tables using various DBCC commands and Handling issues related to corruption of databases.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Experience in implementing SQL Server Security and Object permissions like maintaining Database authentication modes, creation of logins & users, configuring permissions and assigning roles to users.

SQL Performance

===============

• Configuring Log Shipping for databases on Production and Development environments.
• Knowledge of SQL Server tools (Profiler, DTA, SSMS, PerfMon, Process Explorer, PSSDiag, DMV’s and SQL Nexus).

· Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

• Setup, configuring and troubleshooting various high availability solutions like Log Shipping, SQL Cluster, Database Mirroring and AlwaysOn.

· Sound knowledge of indexes & statistics creation, effective management, working and storage.

• Installation, Configuration, Maintenance and Administration of different versions (2005 to 2016) and different editions (Express to Enterprise) of SQL Server.
• Troubleshooting Installation, Upgrade and Patching Issues of SQL Server Standalone and SQL Clusters.
• Configuring and Validating Windows Cluster configuration and SQL Server Clustered instances on Physical as well as Virtual Environments.
• Understanding of various Database Recovery models, Backup and Restore, Implementing Point-in-Time recovery for databases and disaster recovery procedures.
• Scheduling Jobs for full, differential and transactional log back up of databases, configuring other maintenance plans to perform index de-fragmentation, re-indexing and updating the index statistics, troubleshooting issues related to failure of backups and maintenance jobs.
• Performing consistency checks of databases and tables using various DBCC commands and Handling issues related to corruption of databases.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Experience in implementing SQL Server Security and Object permissions like maintaining Database authentication modes, creation of logins & users, configuring permissions and assigning roles to users.