Shibaprasad Pasha

Experience on Cloud and database Migrations

• Migration of infrastructure, data, and applications out of legacy data centers into the cloud and hybrid environments (i.e public (Azure & GCP) and private)
• Analyze the systems and identify problems, evaluate, design solutions, and document for various use cases like Payment and transaction processing app (eg. cart and checkout,OMS) while migrating to Azure and GCP cloud env.
• Leading the Migration team at Walmart Global Tech.
• Extensive experience in Homogenous and heterogenous migration for public and private cloud databases.
• Experience in Migrating RDBMS to RDBMS (i.e Oracle, MSSQL, Mysql/Maria DB to Azure &GCP MySQL,Postgres, SQL DB and vice versa)
• Experience in migrating site facing application (eg - payment,cart,checkout etc) to other RDBMS and NOSQL env without downtime. (eg GCP spanner and Azure Cosmos).
• Extensive experience on migration tools such as Attunity/Qlik replicate.
• Experience in Kafka messaging system and implemented through migration strategies for various aspects.
• Designee and deliver a TOOL for data validation as a service and datamigration as a service in dx and manged service.
• Experience on Automations ,deploying and managing code through GitHub.

Experience on Cloud Database Administrator

• Experience in analysis, capacity planning, designing, and configuring for the various RDBMS on Public and private cloud environments(i.e GCP and Azure Cloud)
• Experience in deploying the Cloud SQL and Postgres databases on GCP and Azure cloud environments.
• Experience in deploying the Cloud spanner instance on GCP environments.
• Experience on optimize and tune the Cloud spanner instance on GCP environments for various application.
• Experience in creating the grafana dashboard (MMS monitioring) for system and DB monitoring.
• Extensive experience in cloud database performance Tuning such as Mysql,Maria db, Postgres,spanner etc.
• Experience of GCP cloud sql,Spanner, Azure Redis and COSMOS

Experience in Open-source RDBMS (MySQL/Maria DB)

• Installation, the configuration of Galera cluster with Maria DB at Open stack and Azure cloud in one-ops environments.
• Experience in creating the three nodes Galera cluster (Master and Master replication) with Maria DB.
• Experience in creating and configuring the six nodes Galera cluster DR replication (Master and slave replication) with Maria DB.
• Experience of switch over and failover for Galera Cluster with Maria DB environments.
• Experience of Percona Xtrabackup tool for backup the Maria DB databases.
• Automate the Backup process for Maria DB through the Percona Xtrabackup tool.
• Experience in Rebuild the DR using export & import for small databases and Percona Xtrabackup tool for large databases.
• Experience of design and configuring the various test cases for Galera cluster performance at master and slave database environments.
• Experience of PT online schema changes tool for schema changes in Maria DB
• Experience in installing the various DB Plugin for MariaDB and MySQL databases.
• Strong experience on Maria DB with Galera architecture.
• Experience of bootstrap the cluster manually for any cluster hung situation.
• Experience of upgrade the Maria DB database with Galera cluster environments with Zero downtime.
• Experience in performance tuning of large-scale databases in MySQL and Maria DB environments.
• Experience in configuring the multiple slaves in Maria DB database with Galera cluster environments.

Experience on Oracle Database Administrator

• Experience on Oracle, RAC, and Exadata which includes High Availability technologies like RAC (Real Application Cluster) with ASM, Streams, OEM 10g/11g/12c/13c, Production support, SQL, PL/SQL, etc.
• Providing the Site lead role for cloud RDBMS in Walmart Bangalore.
• Experience in Applying the PSU Patch on Exadata Machine.
• Creating the Monitoring templet in OEM 12C and apply the Templet for various targets.
• Experience in upgrading the database with minimum downtime using various upgrade methods.
• Experience in configuring RMAN and scheduling the backups for the databases.
• Implementing backup and recovery strategies using Hot/Cold backup, RMAN, Logical (Import/Export, Data pump)
• Experience in the partition objects maintenance for test, development, and production database.
• Experience in generating and analyzing the report like by AWR, ASH,and ADDM, etc.
• Experience in database Performance Tuning on various aspects.
• Experience in making the automation by using shell scripts,Python,Anisble,concord on various aspects.

Experience on Oracle RAC

• Experience in analysis, designing, and configuring Hardware and OS for RAC implementation.
• Implemented Oracle RAC (Both 10g/11gR1/R2/12c/19c) on test, development, and production environments.
• Experience in implementing add and remove nodes from the cluster.
• Experience in creating and managing the RAC services as per requirement.
• Experience in converting the NON-ASM TO ASM file system
• Experience in converting the Non-RAC database to RAC database.
• Experience in Storage migration from EMC to NETAPPS for Oracle RAC databases.
• Experience in Data-guard for both RAC and Standalone databases.
• Experience in Upgrading the RAC Environment with minimum downtime.

• Leading the 8 members Oracle DBA team at India off-shore.
• Installation, Configuration, and Maintenance of Oracle RDBMS Software and providing 24*7 cross support.
• Implemented Oracle RAC (10g/11gR1/R2/12c) on test, development, and production environment.
• Implemented add and remove nodes from the cluster. Creating and managing the RAC services as per requirement.
• Experience in Applying the PSU and one-off patches of OracleCluster- ware and grid.
• Experience in Applying the PSU Patch on Exadata Machine.
• Exadata Administration and support.
• Converted the Non-RAC database to the RAC database.
• Storage migration from EMC to NETAPPS for Oracle RAC database.
• Implemented and maintained Data Guard (Standby-active data-guard) for 11gr2/12c RAC Production database.
• Upgrading databases to Oracle 12c from Oracle 11g.
• Worked on RAC Database performance tuning and troubleshooting.
• Worked on partition objects maintenance for test, development, and production databases.
• Installation, Configuration, and Support of Goldengate and Streams.
• Experience in Installation, Configuration and discover the targets of
• OEM 12c and monitoring the database Using OEM 10g/11g/12c. Configured various plugins of OEM 12c.
• Created the Monitoring templet in OEM 12C and apply the Template for various targets.
• Implemented various automation by using UNIX shell scripts.
• Knowledge and experience in writing SQL queries, Functions, Procedures, Packages, Triggers.

• Installation, Configuration, and Maintenance of Oracle RDBMS Software and providing 24*7 cross support.
• Implemented oracle RAC (10g/11gR1/R2/12c) on test, development, and production environment.
• Creating and managing the RAC services as per requirement.
• ASM Deployment for NON – RAC and RAC database to optimize IO on the storage subsystem.
• Converted the Non-RAC database to the RAC database.
• Experience in Applying the PSU and one-off patches of Oracle Cluster-ware and grid.
• Implemented and maintained Data Guard (Standby-active data-guard) for 11gr2 RAC Production database.
• Upgrading databases to 11gr2 from Oracle 10g.
• Creating and managing the databases, objects, users, roles, privileges, profiles, etc.
• Experience in database refresh by using RMAN, EXP/IMP, DATAPUMP, COLD & HOT backups.
• Worked on RAC database performance tuning and troubleshooting.
• Worked on partition objects maintenance for test, development, and production databases.
• Worked on improving the database performance by gathering stats, implementing the SQL profile and baseline.
• Experience in the database deployment for changes at the application level