Mukhtar Ahmad Ganayee

Principal Consultant at Genpact LLC

Email :ady1ex@r.postjobfree.com Cell:-+1-203-***-****

Summary:

Mukhtar is a result-oriented professional having with over 18 Years of experience in Oracle Core DBA, Oracle ERP application DBA, Fusion Middleware DBA (WebLogic Admin) and Oracle Enterprise manager administration. Has strong experience in implementation, support of production, development and test environments.

Oracle Database Migration from On-prem to AWS RDS.

Database Upgraded from 9i to different releases till 19c upgrades.

Database Migration to Rac.

Performed Database cloning and Database refreshes using hot and cold backups.

Performing Refreshes using Datapump and imp/exp utilities.

Performed Schema Refreshes using Datapump.

Patch analysis and application in various test, development & Production instances & documenting the technical instructions for patch application. Proactive analysis of PSU Patches and other patch-sets to keep the system updated.

Configuring and Scheduling Database backup and monitoring in case of any issues.

Experience is basic performance tuning via Oracle OEM.

Experience in proactive performance activities based on recommendation from ASH and AWR reports.

Sizing recommendations of SGA, redo etc. based usage and Oracle recommendation.

Rebuilding Indexes as and when required.

ERP database and application cloning.

ERP patching and other maintenance activities

Done Installation of WebLogic and patching of the same on Linux.

Done OLM implementation for 11i and R12.

Done Discoverer setup for 11i and R12.

Done APEX upgrade from 3.2.0 to 3.2.1.

Monitoring setup experience for non-oracle databases like MongoDB, PostgreSQL and SQL Server.

Specialized Skills.

AWS Cloud Technologies: Expertise in Amazon RDS Oracle Database, DMS, Cloud Watch.

Oracle Applications DBA: Skilled in administering Oracle E-Business Suite, patching, cloning, and backup/recovery procedures.

OEM Monitoring & Administration: Proficient in Oracle Enterprise Manager Cloud Control for database monitoring, performance tuning, and proactive management. Familiar with setting up notifications, creating custom metrics, and executing automated jobs.

Database Administration: Comprehensive experience in database design, install, patch performance tuning, backup and recovery, and replication.

Security & Compliance: Familiarity with AWS and Oracle security standards.

Database Technologies: Oracle, PostgreSQL, and MySQL.

Automation & Scripting: Terraform, Shell scripting, and SQL.

Projects Profile

Project Name: Wabtec Database Service Support

Client Wabtec

Project Date: Started Aug 2015 and till date.

Project Description

The project involves installation setup, migration, and support for AWS Oracle Database RDS environments. As part of the project support applying latest Product support provided Patches, Refreshes and other maintenance in AWS cloud. The project also involves Schema level organization and reorganize big table using partitioning etc. Schema segregation is also part of the project. We are also doing data purging for big tables of more than 1 TB size. Working on AWS RDS oracle database. Which has been migrated from physical servers to AWS cloud. Migration was done using expdp/impdp and DMS. Which brought a 13 TB Database to 9 TB around in AWS RDS environment. After Migration we are working on database capacity planning and data retention. Have already partitioned more than 40 tables of size more than 200G avg.. And working on next set of tables around 10 for the same. Also working on a separate project for PostgreSQL database table partitioning.

Projects Profile

Project Name: GE Digital Database Service Support

Client GE

Project Date: Started May 2015 and till Aug 2019.

Project Description

The project involves installation setup and support for Oracle Databases environments. As part of the project support applying latest Product support provided Patches, Quarterly updates and bug fixes and vulnerability fixes on Database and Grid Infrastructure. The Project supports around 100+ databases, which have been mostly migrated to 11gr2 RAC and now in process of upgrade to 12c versions. Apart from regular support, project also involves tuning expertise, as and when required.

Experience

Genpact 10 years Principal Consultant DBA at Genpact LLC July 2017 - Present (6 years 1 month)

Project Name:

Client GE Transportation

Role Upgrade and custom integrations

Organization GENPACT

Project Date: Started Sep-2014 till May 2015.

Project Description

The Project involves 24/7 support and upgrade of ERP from 12.1 to 12.2, which included WebLogic Administration support for new 12.2 ERP applications. The project also involved integration of 2 ERPs mainly OLTP and ASCP with 3rd Party applications. The Project was also required coordinating with these 3rd part vendor support teams for issues and bug fixes during the integration. The project had rigorous number of clones and patches and custom code deployments as well apart from regular operations support. The project involved the integration and basic support for Aventx, Sabrix, Virtual Trader, Tesis applications during this upgrade as well.

Project GE Capital Finance

Project Date: Started August-11 And Sep-2014.

Production Support 24/7

Client: GE

The Project involves 24/7 support with 16 Hour support from India, supporting 11i and R12 EBS environments. The Project supports around 100 databases, which have been mostly migrated to 11gr2 RAC now. The Project also involves testing of Oracle EBS 12.2 release. We have also implemented OEM 12c, which is in implementation phase and monitoring development environments. The Project also involves supporting databases only for other applications. We have started moving some of our EBS applications in cloud server, which are Private cloud servers for GE.

Migrated most of the databases and EBS environments upgraded to latest tech stacks. Which is Databases upgraded to 11gr2 and upgraded EBS to 12.1.3. Migrated databases also to 64 bits from 32 ones. Once completing the upgrades migrated the databases to RAC 11gr2 as well. The Project also involves core database activities like Schema refreshes, managing backups, database tuning. In Support daily activities include schema refreshes, clone, patching and other user requests. We also are involved in performance tuning of sql’s performing slow as and when user request for the same. Have written some shell scripts for Archive backup automation at certain thresh-hold and also PL/SQL programs for specific database activity automation and recording incidents.

Oracle Senior Consultant (Oracle Corporation)

November 2006 - August 2011 (4 years 10 months)

Consulting, support, implementation. Installation, configuration of Oracle ERP Applications 11i and R12, FMW Hyperion Upgrade of Databases, EBS, FMW, Application Servers, Hyperion etc. Worked on multiple client locations in India for telecom companies and banks in India, Nigeria, and Poland. And worked on UK based support project from Oracle Bangalore office.

PointSoft Hyderabad Senior AppsDba

June 2006 - November 2006 (6 months)

Pointsoft Hyderabad has changed the name to Infokal Solutions, My Client at Pointsoft was GENPACT. My project was supporting projects for ERP DBA in TSG team for GE customers.

BMC software Apps DBA

2005 - 2006 (1 year)

Production Support for Oracle Applications 11i. Development support and user groups for support spread across more than 16 countries. BMC was ERP DBA role with SOX compliance-based support.

Education

Masters in compute Management. Savitribai Phule Pune University MCM, Computer Management and programming languages · (2001 - 2003).

Licenses & certifications

Oracle Cloud Database Migration and Integration 2021 Certified Specialist

Oracle Cloud Infrastructure 2021 Architect Associate

Oracle Autonomous Database Cloud 2021 Certified Specialist

Oracle Cloud Infrastructure Foundations 2021 Associate

AWS Certified Database – Specialty (DBS-C01): 1 Introduction and Services

AWS Certified Database – Specialty (DBS-C01): 3 Migration and Management

Learning Oracle Database 19c

Technical Recruiting1

AWS Certified Cloud Practitioner

Amazon Web Services (AWS) Issued Jan 2021 · Expires Dec 2024Issued Jan 2021 · Expires Dec 2024

Reference :- Available on Demand.

Contact this candidate