A qualified, enthusiastic, reliable, persuasive, detail-oriented, dedicated, and proactive IT engineer with over 6 years of experience in SQL Server Database Administration and 4 years of experience in Providing leadership in large scale infrastructure migration methodologies and techniques (LaaS/PaaS) including application migrations to cloud platforms within a large enterprise environment.
• Configure and use Azure Security tools: Azure firewall, NSGs, access key and SAS key, IAM, Azure policies, resources lock, Encryption.
• Define and implement cloud network architecture: Azure virtual networks, Subnet, VPN, WAN, Hub, and express route to establish connectivity between cloud resources and on premises.
• Collaborated effectively with Application Engineers. Network Team, Engineering Supervisors, Programmers, and IT Managers to ensure project deliverables are on track.
• Deploy Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure Vnets and subnets.
• Provided research, analysis, executing job designs, quality control, and reporting on specific technical issues.
• Maintained High Availability and disaster recovery solution for all my environments, while proactively detecting potential problems in database health before issue arises. Production level support for onsite and offshore - On Call 24/7 environment Used Microsoft Entra ID authentication, Temporal Tables.
• Work as Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, Elastic Pool, Azure Vault, Geo-Replication.
• Design pipeline to load data from various sources, transform and load to the destination.
• Backup Configure and Restore Azure Virtual Machine using Azure Backup.
• Monitored and analyzed trends in system performance, cost, capacity, and reliability of cloud resources.
• Collaborated with user groups, development teams, and ops team to plan and communicate database upgrades/ patches and releases.
• Implemented data guard with maximum availability, protection and performance configurations and worked with data guard fail over and switch over cases at the time of gradation and migration.
• Experienced in data center migration of databases to prepare the proof of concept, db migration procedures and scripts, developed templates that includes check list for migrating the databases.
• Implemented Transparent Data Encryption (TDE) to protect sensitive data.
• T-SQL Development includes Stored Procedures, Indexed Views, User.
• Defined Functions, Triggers, and Distributed Queries.
• Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, and disaster recovery.
• Experience in troubleshooting real application clusters database and engaging with the application team for gaining performance enhancements for application in a clustered environment.
• Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.
• Exported reports into various formats and resolved formatting issues.
Troubleshooting
undefined