Mohyaddin Khan

To pursue a challenging growth oriented position with an organization, which can provide me with a dynamic work sphere, scope for creativity and innovative thinking, promotes learning & acquiring new skills where expertise and dedication towards work are appreciated, always keeping organizational goals as priority.

12 years of extensive work experience in Installation, Creation and Maintenance of Oracle production databases 1 years of extensive work experience in Installation, Creation and Maintenance of PostgreSQL databases (secondary skill). Currently working as Senior Database Engineer with Thomson Reuters, Bangalore. Good Team player. Responsible decision maker in oracle tower. Taking ownership for all the major critical activities like disaster recovery/upgradation/migration. Installation and Configuration of Oracle databases on various Unix platforms such as Sun Solaris, IBM-AIX, HP-UX, Red Hat Linux and Windows platforms from scratch. Installing and configuring the 12c release Goldengate binaries for standalone database. Installing and configuring the 2 Node 12c RAC on ASM from scratch. Installed and configured the 13c Oracle enterprise Manager. Configured Newly created database in 13c OEM by installing 13c agent. Configuring Oracle RMAN backups (Level 0/Level 1/Archive) via OEM. Crossplatform migration of oracle standalone database from AIX to Suse Linux via exp/imp and expdp/impdp Upgrading Oracle database from Oracle 10g (10.2.0.5) to 12c Release 1 (12.1.0.2). Cloning Oracle databases using Cold Backup, Hot Backup and RMAN backups (Duplicate). Installing, Configuring and Upgrading 2 Node 12c RAC. Applying interm and bug fix patches to oracle home. Implemented DDL and DML Goldengate replication. Creation of dblink’s across the databases for application dependencies. Creation of databases, tablespaces, tables, indexes and other database objects. ASM online lun migration. Implemented Transparent Database encryption by creating wallet in Oracle RAC database. Good knowledge in troubleshooting Oracle standalone and RAC databases. User Management, Space Management, Roles, Privileges and Authentication. Monitoring proactively the different memory components of SGA such as Library cache, Data dictionary cache, Database Buffer cache, Redo Log Buffer. Collecting database performance statistics periodically using performance tools such as AWR, ADDM and advisors via OEM. Collecting the monthly database space utilization report at tablespaces level via OEM to recommend additional space requirement at OS level. Having good knowledge in configuring RMAN catalog for database backup/restore/recovery. Moving data between databases using utilities like Export, Import and Transportable Table spaces. Preparing scripts to automate the jobs at database level. Having Knowledge on configuring ASM Disks & ASM database creation. Implementing Archivelog destination to archive redo logs to support database recovery. Managing redolog files, control files, data files and archived log files like adding and renaming. Scheduling Export backups and RMAN backups for tapes and disks using cron jobs. Having good experience in applying database patches on both standalone and RAC. Interacting with Oracle for Technical Support, Raising and handling SR. Having very good knowledge in ITIL. Managing Production in 24x7 high availability environment. Having through knowledge in configuring Dataguard /Standby Database for Disaster recovery. I possess excellent technical, organizational and time management skills and good public speaking and communication skills which can help me to succeed under challenging conditions. Results-driven Senior Database Engineer with a knack for enhancing productivity and efficiency in database management tasks. Specialize in SQL optimization, database architecture design, and performance tuning to ensure seamless data flow and access. Strong problem-solving skills, adaptability, and communication enable successful collaboration and innovative solutions in fast-paced environments.

• High level of commitment and performance award in Cognizant (2016-2017).
• Best New comer award in Cognizant in the year (2016-2017).

• ORACLE CERTIFIED DATABASE SQL EXPERT.
• ORACLE CERTIFIED ASSOCIATE (OCA).

Having valid Indian passport (Z4538331).

• Thomson Reuters, Senior Database Engineer (ORACLE DBA), From Jan,2018 – Till date, Thomson Reuters, The company is the market leader in financial data (ahead of rival information provider Bloomberg). Thomson Reuters provides electronic information and services to businesses and professionals worldwide, serving the financial services, media, legal, tax and accounting, and science markets. Data is primarily offered online, and to a lesser extent via CD-ROM and print formats; nearly all revenues come from subscription sales to its plethora of offerings. Thomson Reuters was created in 2008 as the result of the $16 billion cash and stock purchase of news service Reuters by information provider The Thomson Corporation. In early 2018 the company sold a majority stake in its Financial & Risk business for some $13 billion to Blackstone and other financial institutions., Am handling the team of 40 members in Oracle tower by effectively distributing the work and make sure not breaching the SLA’s., Taking ownership for all the major critical activities like disaster recovery/upgradation/migration., Responsible decision maker in oracle tower., Installing and configuring Oracle 12c standalone databases and RAC from scratch on client request., Installed and configured the 13c OEM to add newly created 12c databases for monitoring., Involved in critical database migration planning., Involved in patching planning for critical application databases., Involved in the upgradation planning for critical application databases., Crossplatform migration of Oracle databases from AIX to SUSE-LINUX and also from 11g to 12c version., Applying interm and bug fix patches to Oracle Home., Upgrading the databases from 10.2.0.5 to 12.1.0.2 Manual method., Replicating quarterly 1TB of database size from production to development with RMAN backups., Troubleshooting Oracle standalone database and RAC issues., Migrating the application data from one data center to another datacenter by creating the new latest version of databases in order to improve the performance of database., Working on P1/P2/P3/P4 tickets and finding the RCA if required., Upgrading the DST from 14 to 18 version, when we will get export/import bug while moving data from 12c to 11g., Configuring integrated DDL goldengate replication to perform crossplatform migration without down time., Configured DML goldengate replication from 11g to 12c database., Enabling the transparent encryption at tablespace level., Deploying application releases., Creating the DB LINKS across the databases based on application dependencies., Troubleshooting the performance issue., User Management, Space Management, Roles, Privileges and Authentication., Deleting old records which is no longer needed in Reporting databases and releasing the space at OS level. So that we can use the space for future updates and inserts., Scheduling RMAN Jobs in OEM, Raising SR to Oracle support on every complex issue, Taking Logical backups(export/import) as cumulative, incremental and complete, Database Administration activities like User Creation, Tablespace Creation, Space Management, Access Control, resolving lock problem etc. as required time to time, Working on Tickets and responding to them within SLA's, Creating and managing tablespaces and resizing datafiles, Solving issues like database block recovery, Every month restoration through COLD BACKUP, Creating new databases as per client requests
• Cengage, Technical Lead (ORACLE DBA), From Feb,2016 – Jan,2018, Cognizant, Cengage Learning, Inc. is an educational content, technology, and services company for the higher education, K-12, professional, and library markets worldwide. Cengage Learning has operations in more than 20 countries around the world. Cengage Learning offers print and digital textbooks, instructor supplements, online reference databases, distance learning courses, test preparation materials, corporate training courses, career assessment tools, materials for specific academic disciplines, and custom solutions., Am handling the team of 4 members in Oracle tower by effectively distributing the work and make sure not breaching the SLA’s., Taking ownership for all the major critical activities like disaster recovery/upgradation/migration., Responsible decision maker in oracle tower., Installing and configuring Oracle 12c standalone databases and RAC from scratch on client request., Installed and configured the 13c OEM to add newly created 12c databases for monitoring., Involved in critical database migration planning., Involved in patching planning for critical application databases., Involved in the upgradation planning for critical application databases., Crossplatform migration of Oracle databases from AIX to SUSE-LINUX and also from 11g to 12c version., Applying interm and bug fix patches to Oracle Home., Upgrading the databases from 10.2.0.5 to 12.1.0.2 Manual method., Replicating quarterly 1TB of database size from production to development with RMAN backups., Troubleshooting Oracle standalone database and RAC issues., Migrating the application data from one data center to another datacenter by creating the new latest version of databases in order to improve the performance of database., Working on P1/P2/P3/P4 tickets and finding the RCA if required., Upgrading the DST from 14 to 18 version, when we will get export/import bug while moving data from 12c to 11g., Configuring integrated DDL goldengate replication to perform crossplatform migration without down time., Configured DML goldengate replication from 11g to 12c database., Enabling the transparent encryption at tablespace level., Deploying application releases., Creating the DB LINKS across the databases based on application dependencies., Troubleshooting the performance issue., User Management, Space Management, Roles, Privileges and Authentication., Deleting old records which is no longer needed in Reporting databases and releasing the space at OS level. So that we can use the space for future updates and inserts., Scheduling RMAN Jobs in OEM, Raising SR to Oracle support on every complex issue, Taking Logical backups(export/import) as cumulative, incremental and complete, Database Administration activities like User Creation, Tablespace Creation, Space Management, Access Control, resolving lock problem etc. as required time to time, Working on Tickets and responding to them within SLA's, Creating and managing tablespaces and resizing datafiles, Solving issues like database block recovery, Every month restoration through COLD BACKUP, Creating new databases as per client requests
• Michelin, Tyre Manufacturing Company, Sr. Oracle DBA and RAC administrator, From JAN,2014 – JAN, 2016, IBM INDIA PVT LTD, Michelin is as French multinational tyre manufacturing company headquartered in Clermont-Ferrand, France. As of 1 September 2008, Michelin is again the world's largest tire manufacturer. Michelin produces tires in France, Spain, Germany, the USA, the UK, Canada, Brazil, Thailand, Japan, Italy and several other countries. Michelin first competed in the 1977 Formula One season, when Renault started development of their turbocharged F1 car. Michelin introduced radial tire technology to Formula One and won the Formula One Drivers' Championship with Brabham and McLaren, before withdrawing at the end of 1984., Installation of Oracle binaries on WINDOWS platform using DBCA and Silent installation of Oracle binaries in HPUX, AIX and LINUX., Conducting the Meetings with Oracle Architect and designing the New databases and getting the approvals for New databases., Creating the New databases, after getting the fully approved changes., Application of Latest patches to the Oracle 11g Home., Interacting with customer to understand their requirement and fixing issues., Implementing the approved changes related to RMAN restoration, RMAN cloning, RMAN refresh, Database creations and applying patches etc., Migrating the database from 8i,9i,10g to 11g., Upgradation of databases., Conducting the Team meetings and circulating MOM’s., On-Call support., RMAN cloning (Duplication and Active Duplication)., RMAN restoration and recovery of corrupted databases and datafiles., Applying of patch in datagaurd environment., Monitoring and administering PRODUCTION, QA, TEST, HRDEV databases., Involved in applying the patchset to upgrade the release version of Oracle 10.2.0.1 to 10.2.0.5., Oracle RAC Database Administration including installation, configuration, backup and recovery., Involved in adding a node to the existing RAC system., Managing and Restoring Voting Disk and OCR in RAC environment., Monitoring health check of Cluster databases., Backup and recovery of Oracle Real Application Clusters database using RMAN., Cloning of production instances on regular basis., Duplicating Oracle database using RMAN., Creating users and controlling user access to the database by assigning required privileges., Taking Logical backups(export/import) as cumulative, incremental and complete., Audited different users for suspicious activities., Database Administration activities like User Creation, Tablespace Creation, Space Management, Access Control, resolving lock problem etc. as required time to time., Monitoring and resolving database issues on production and test environment., Preparing AWR report for database health checkup and for performance improvement., Monitoring alert logs for production database., Creating and monitoring the tablespaces and datafiles, allocating tablespaces for users., Database backup and recovery procedures, security implementation including routine maintenance activities., Experienced in Providing 24x7 support & maintenance.
• Sanofi-Aventis, Pharmaceutical Company (US, JAPAN, GERMANY, FRANCE and CHINA), Oracle DBA, From Apr,2011 – Jan,2014, Accenture (Parental company: Resource square solution), Sanofi-Aventis is a French multinational pharmaceutical company headquartered in Paris, France, the world's fourth-largest by prescription sales. Sanofi engages in the research and development, manufacturing and marketing of pharmaceutical products for sale principally in the prescription market, but the firm also develops over-the-counter medication., Installation of Oracle binaries on UNIX platform using DBCA (i.e., Red Hat LINUX)., Silent Installation of Oracle binaries in command line., Database creation and administration., Security management by allocating proper privileges., Setup basic RMAN configuration and conduct a single RMAN backup to disk and tape., Applying CPU/PSU patch., Applying patch in datagaurd environment., Used Oracle Traditional Export and Import, Data pump Utilities to refresh databases and schemas upon client request., Hot/cold backups of database and datafiles., RMAN restoration and recovery of corrupted databases and datafiles., Decommissioning of databases., Taking full and incremental backups using RMAN., Bringing database from No-Archive log to Archive log and vice versa., Duplicating (Migrating) the oracle databases using available techniques like exp/imp, data pump, RMAN etc., Successfully tested and implemented Active database duplication., Good knowledge on Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names., Performing the point in time recovery., Good knowledge in Datagaurd., Created Oracle RAC database (2 node) using DBCA., Troubleshooting incidents related to backup failure jobs, user connectivity issues, tablespace issues, ORA-01555 error, ORA-600 errors, Availability of databases and listeners and archival issues etc., Manual upgrade of oracle database from 11.2.0.1 to 11.2.0.3 and 10.2.0.1 to 11.1.0.6, Timely Monitoring and troubleshooting alert logs., Expert in using Export/Import and data pump import, SQL
• Loader to load data in to tables., Good problem solving skills and capable of giving creative and unconventional solutions., Experience as On-Call 24x7 production DBA and development DBA and Oracle Support processes for technical requests through Meta link and other Support Procedures.

• Date of Birth: 12/25/87
• Gender: Male
• Marital Status: Married

English, Urdu, Hindi, Telugu