Hari Prasad MEDIKURTI

Possess 19+ years of experience in IT industry. 15 + years of experience in Database Administration for very large and complex databases in SQL Server 2022, 2019, 2016, 2014, 2012, and 2008 R2. Possesses advanced knowledge of SQL Server Database design Solutions. Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. Expert in using Extended Events, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). Hands-on experience in ADF for ETL Process. Hands-on experience with Azure SQL Database monitoring and diagnostics. Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Proven ability to design, implement, and manage Always-On Availability Groups for high availability and disaster recovery. Possess in-depth understanding and practical experience in applying Log shipping and Database Mirroring for disaster recovery. Optimize database performance by diagnosing and resolving issues, including fine-tuning and index optimization. Highly skilled in optimizing data warehouse table performance for large datasets (billions of records). Highly skilled professional with deep understanding of Columnstore Index design and implementation. Saved businesses valuable time and resources by identifying and resolving SQL Server query bottlenecks, resulting in significant performance gains. Proven track record of optimizing complex Data Warehouse queries for blazing-fast performance (from minutes to sub-10 seconds) through Columnstore expertise, strategic indexing, and SQL Server configuration mastery. Proven ability to design table partitioning strategies to enhance query performance on large tables and leverage partitioning to streamline data archiving processes. Responsible to choose the right SQL Server/Azure SQL service tier based on performance and cost needs, configure databases, and manage user access controls. Monitor database performance, identify bottlenecks, and implement tuning techniques to optimize queries and improve overall database efficiency. Configure robust security measures, implement access control mechanisms, and ensure compliance with relevant regulations and organizational policies. Establish regular backup schedules, automate backup processes, and ensure efficient recovery procedures in case of data loss. Automate routine tasks using Transact-SQL (T-SQL) scripting and azure tools to improve efficiency and reduce manual effort. Proactively monitor database health, identify potential issues, and troubleshoot performance problems or errors. Led successful upgrades of SQL Server from 2008 R2 to 2012, 2012 to 2016, and 2012 to 2019, demonstrating expertise in migration planning, execution, and troubleshooting. Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Developed and deployed SSIS packages for efficient data integration in SQL Server environments. Led the migration of complex on-premises SQL Server environments to Azure SQL Database, ensuring minimal downtime and data loss. Expertise in developing data integration solutions using Azure Data Factory. Solid understanding of clustering concepts, technologies, and best practices. Successfully completed data migration from SQL Server to Dataverse (Microsoft Dynamics 365) using Azure Data Factory. Expert in seamless database migration to AWS: SQL Server to RDS and MySQL to Aurora, leveraging DMS, SCT, and S3 for efficient data movement. Knowledge on SQL Server 2022 new features Sound knowledge on Azure Synapse Analytics, AWS Dynamo DB Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming, and problem-solving skills. Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box. A competent Team Leader in driving the team to performance excellence through knowledge transfer, motivation and mentoring as well as a Team Player with analytical, communication & interpersonal skills.

Capable [Desired Position] with solid background in managing and maintaining complex database systems. Successfully ensured data integrity and optimized database performance across various platforms. Demonstrated expertise in SQL and database security, effectively collaborating with teams to achieve project goals.

Driven Database Developer with [Number] years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments.

Systematic Database Developer with [Number] years of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems.

• Date of Birth: 05/13/82
• Gender: Male
• Marital Status: Married