Yudhistir Chourasiya

Detail-oriented Database Administrator with over 10 years of experience managing SQL Server databases in production environments. Maintained servers and systems to ensure smooth business operations, a passionate contributor to team success with a track record of empowering teams. A self-starter who is versatile with server, database, cloud technologies, always motivated to learn, grow and stay current.

• Automated processes to reduce workflow by creating maintenance plan that runs daily to reorganize, rebuild and update statistics, Backup, and Cleanup task in my environment and DB refresh as per App teams requirement.
• Solid understanding of SQL Server architecture with the ability to design and optimize database systems for scalability, high availability Always On feature/Clustering, and disaster recovery.
• Automated Powershell Scripts to deploy Audit Reports.
• Migrated SQL Databases from On-prem to AZURE, configure Geo-replication for High availability, Manage database on Elastic pools and Manage instances.
• Importing and exporting on-prem data to Azure using Backpack and Dacpack.
• Setup and Manage Always-ON High Availability for HA/DR; High availability and Disaster Recovery. Setup and manage Log shipping to automate and Synchronize Backups and restore to a Secondary servers for Disaster recovery as an addition security for Mission Critical databases In our environment.
• Database server migration from lower to Higher Version of various SQL Server
• Strong understanding and expertise in solving patching issues.
• Create Data Models for new and modernized legacy Databases, implement database design following best recommendations to maximize performance and reduce data redundancy and inconsistencies. In doing so, I understand the need for a Business requirement document that outlines the business needs from the conceptual to the logical, and a good strategy for the physical model and design like normalization in OLTP vs OLAP.
• Maintain Database Security and Consistency in Sql Server Databases by Running database validation Checks and database consistency checks to proactively resolve data corruption and Inconsistencies.
• Extensive experience in SQL Server database administration, including installation, configuration, monitoring, and patching maintenance.
• Proven track record in database performance tuning, query optimization, and index management to ensure optimal database performance.
• Proficient in managing database security, user access controls, and ensuring compliance with industry standards and best practices.
• Strong expertise in backup and recovery strategies, implementing disaster recovery plans, and ensuring data integrity and availability.
• Experienced in cloud database administration, particularly with Azure and AWS, including provisioning, scaling, and managing database services in the cloud.
• Excellent problem-solving and troubleshooting skills, adept at identifying and resolving complex database issues promptly.
• Strong communication and collaboration skills, capable of working with cross-functional teams and stakeholders to deliver database solutions aligned with business objectives.

• Microsoft Certified: Azure Fundamental AZ-900 (Issued Feb 2021)
• Microsoft Certified Professional: 70-462 Administering Microsoft SQL Server 2012 Databases.
• IBM Private Cloud- Foundation Technology.
• Introduction to Cyber Security Tools & Cyber Attacks.
• Google Cloud Platform Fundamental: Core Infra.
• ITIL V4 Certified: Certificate Number: GR671447417YC Issue date: 11/6/2022