Jones Praveen Yadala                                                 

 

 

Conifdential                                                                          

 

 

Relevant Experience

1. Around 5+ years of experience in MS SQL Database Management, Administration in IT Sector.
2. Having good experience in Azure Migration perspective.
3. Setting up backup using Azure Backup Solution such as Azure Automated Backup, Azure Backup for

SQL Server VM’s and Blob Storage.

1. Extensive experience in implementation, configuration & troubleshooting, Patch Management, Performance Tuning, Client/Server Connectivity and Disaster Recovery of MS SQL Server 2008/2008R2/2012/2014/2016/2017/2019.
2. Extensive database migration experience to Azure IaaS/PaaS/Managed Instance/Azure SQL Database.
3. Extensive migration experience in moving to Azure.
4. Migration tool used such as Database Migration Service in Azure and DMA etc.
5. User account management including grant of system, DB roles and permission on various database object.
6. Configuration and maintaining backup/recovery.
7. Setup of High Availability and Disaster Recovery using AlwaysON Availability Group (AOAG), Replication, Mirroring, Clustering and Log Shipping.
8. Responsibility     to     create    Backup    jobs     as     per     the    requirement                         in     SQL        Server 2008/2008R2/2012/2014/2016/2019
9. Maintain the MS SQL Server availability by proper utilization of the resources provided by my management.
10. Establishing and Evaluating SQL Server Performance Baseline.
11. Creating/tuning/optimizing indexes, stored procedures, DTS/SSIS packages and SQL jobs
12. SQL Server Monitoring through tools like Perfmon, Activity Monitor and SPLUNK.
13. Verifying and Archiving Databases Backups for surveillance.
14. Auditing SQL Server Security on weekly basis.
15. Adapt in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management.

 

 

 

Technical Skills

• Database: MS-SQL 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019.
  • Database Software Installation.
  • Database Backup and Recovery
  • Database Problem Research and Resolution
  • High availability technologies including:
    1. Database mirroring, Replication, Log Shipping and clustering, AlwaysON Availability Group
    2. Database backup and recovery.
    3. Having experience in Disaster Recovery of SQL Server.
    4. Upgrade/Migrate from SQL Server 2005 to the latest version
    5. Database and SQL server security and authentication.
    6. Configuration and Managing of SQL reporting services
    7. Configuration and managing Always On
    8. Migration from On-premises to On-Premises/IaaS Azure/SQL Azure
• Servers: Windows 2008/2012/2016/2019 enterprise server and standard edition.

 

 

Professional Experience

Conifdential Duration: October 2020  to March 2024

 

Project 1: Cloud Project

Role: Cloud Migration & Implementation

 

Responsibilities:

 

• Providing SQL Effort Estimation for several proposals.
• Providing SQL Staffing estimations.
• Define SQL Assumption based on project requirement.
• SQL Database Migration from On-premises to IaaS Azure, Azure Managed Instance,  SQL Azure
• Contribution provided towards technical documents using new technologies like migration to S