Mukhtar Ahmad Ganayee

• Design and Implement Oracle Database architecture for Migration from On-prem to AWS RDS
• Design and Implement Database Migration to RAC
• Support Database in AWS RDS (MongoDB ,postgres,MySql)
• Manage the administration and support for all development/testing/production databases
• Provide performance tuning, high availability implementation and support change management / release management
• Manage design and implementation of backup and recovery processes for all databases
• Automated management and maintenance of all databases
• Establish performance baseline standards for new and existing databases
• Install, Configure and setup replication for Databases using Golden Gate
• Install, Configure and setup replication for Databases using Datagaurd
• Establish, implement, and execute regularly planned upgrades
• Experience Implementing Database Upgrades from 9i to different releases till 19c upgrades
• Work closely with other IT resources across the enterprise
• Working experience on maintenance activities on RAC databases and ASM level
• Establish monitoring standards to ensure all events are monitored for proper system performance
• Develop long-term strategic goals for production databases
• Performed Database cloning and Database refresh using hot and cold backups
• Performing Refreshes using Datapump and imp/exp utilities
• 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
• Knowledge of Data guard and few implementation setup experiences
• Knowledge of setup like PDB and CDB
• Experience is basic performance tuning via Oracle OEM
• Experience in database Exadata hardware
• Setting up monitoring in OEM and configuring alerting mechanism for the same
• This also includes creating reports mostly on capacity and database usage and auditing reports
• Experience in proactive performance activities based on recommendation from ASH ,ADDM and AWR reports with Tuning advisor
• Running TKPROF and SQL Trace as and when required
• 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 ,MySql and SQL Server.

Project involves Design architect database structure and installation setup

• Redesign, migration and support for AWS Oracle Database RDS environments.
• As part of project support applying latest Product support provided Patches, Refreshes and other maintenance in AWS cloud
• Project architect role involves Schema level organization and reorganization of big table using partitioning etc
• Schema segregation is also part of project
• Database capacity planning and performance is designed and implemented with data purging for big tables of more than 1 TB size
• Project has Oracle databases been migrated from physical servers to AWS cloud
• Migration was done using expdp/impdp and DMS
• Which brought some big databases as 13 TB Database to 9 TB around in AWS RDS environment
• Architecting these migration projects involves database design from a RAC to non RAC standalone database
• Decision making of Hardware design and architecture from Database mining reports
• After Migration, Team 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 same.
• Project also required basic support for mongodb , database table partitioning
• Project also required basic support for mongodb ,Postgres and MySQL dbs also.

• This project involves Architecting, designing, installation setup and support for Oracle Databases environments
• As part of project support applying latest Product support provided Patches, Quarterly updates and bug fixes and vulnerability fixes on Database and Grid Infrastructure
• This 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, the project also involves tuning expertise, as and when required.

• 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.
• Project also involved integration of 2 ERPs mainly OLTP and ASCP with 3rd Party applications.
• Project was also required coordinating with these 3rd part vendor support teams for issues and bug fixes during integration.
• Project had rigorous number of clones and patches and custom code deployments as well apart from regular operations support
• Project involved the integration and basic support for Aventx, Sabrix, Virtual Trader, Tesis applications during this upgrade as well.

Project involves 24/7 support with 16 Hour support from India, supporting 11i and R12 EBS environments.

• Project supports around 100 databases, which have been mostly migrated to 11gr2 RAC now.
• Project also involves testing of Oracle EBS 12.2 release.
• Team has also implemented OEM 12c, which is in implementation phase and monitoring development environments.
• Project also involves supporting databases only for other applications.
• Team started moving some of our EBS applications in cloud server, which are Private cloud servers for GE.Migrated most of 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 upgrades migrated databases to RAC 11gr2 as well.
• 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 are also involved in performance tuning of SQL’s performing slow as and when user request for same.
• Have written some shell scripts for Archive backup automation at certain thresh-hold and PL/SQL programs for specific database activity automation and recording incidents.
• Optimized team performance through effective communication, training, and leadership techniques.

• 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 installation setups for OBIE and BI (Oracle Business Intelligence application) setup for Databases
• 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.
• Delivered high-quality solutions for clients through comprehensive research and analysis of industry trends.

• Project was supporting projects for ERP DBA in TSG team for GE customers.

• 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.
• Managed user access rights to maintain a high level of information security while ensuring appropriate levels of accessibility for authorized personnel.
• Planned and implemented upgrades to system hardware and software.