• Upgrade Core HIS Databases from 10gR2 to 11gR2 with Migration from single Instance to RAC on two node cluster using Grid Infrastructure with ASM.
• Upgrade 11gR2 RAC Databases to 19cR2 (19.9.0) RAC.
• Implementation of Data Guard (Real Time Apply) RAC to One Node on Disaster Recovery Site.
• Query Optimization and Tuning of using SQL Tuning Advisor.
• Implement Database Security as per GDPR requirements on Oracle & SQL Servers Databases.
• Implement Database Security Hardening for Secure Installation of Oracle & SQL Server.
• Quarterly Patching on RAC Database and Grid using Rolling Patch method by Opatch utility
• Daily compressed backup of Oracle Databases using RMAN and Data-Pump using parallelism.
• Storage Migration of RAC 19c Databases from EMC to Hitachi without any downtime using ASM.
• Implementation of Storage Redundancy on ASM level using failure groups.
• Implementation of Failover Cluster using SQL Server 2012 & 2014.
• Implementation of AOA Group using Listener configuration of SQL Server 2014, 2016 & 2019
• Installation and Configuration of SSIS, SSRS and SSAS Services on SQL Server 2016 & 2019.
• Installation and Configuration of SQL server 2016 on Azure Cloud.
• Installation and Configuration of MySQL single instance on Windows, Linux and Ubuntu.
• Users creation on MySQL Databases and provide Access on Database using access roles.
• Backup, Copying & Recovery of MySQL Databases Single Instance.
• Install, deploy and manage MongoDB on physical and virtual machines
• Create, configure and monitor large-scale, secure, MongoDB sharded clusters
• Create users and provide appropriate permissions based on the requests
• Enabled security on mongo instances authorization on production servers to keep the data safe
• Configure and monitor numerous MongoDB instances and replica sets
• Improve database backups and test recoverability regularly
• Tracing the workloads and suggested to create proper indexes to improve the performance.
• Maintain database performance and capacity planning
• Migrated Mongo servers from on-prem to Azure cloud without downtime with replica sets
• Own and manage administration activities of the database (DBA)
• Backup and restore databases and collections as needed between environments, using JSON
• Strong DBA with performance tuning skills
• Reviewing and deploying JSON code as requested by application teams.
• Configured and supported Sharding in production environment.
• Having good experience with Mongo Replication.
• Having good experience in backup/recovery procedures
• Upgrading lower to higher versions