Home

Mahendher - Senior Oracle DBA(12+)

[email protected]

Location: Houston, Texas, USA

Relocation: No

Visa: H-1B

Mahendher B Email: [email protected] Professional Summary 12+ years of IT experience as an Oracle 8.x/9.x/10g/11g/12c/18c/19c Database administrator. Excellent experience in Installing, Configuring, Patching, Up-grading Databases 9.x/10g/11g/12c hosted on Operating Systems such as Sun Solaris, AIX, HP-UX, Linux (Red Hat, Ubuntu, CentOS) and Windows. Experience working with Oracle high availability architecture 10g/11g /12c installations, configurations, and Maintenance. Excellent experience in installing and maintaining Oracle Dataguard to implement physical and logical Standby Databases for Disaster Recovery. Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) 12c/11g/10g with ASM and Oracle Clustureware File System (OCFS2) and manage RAC instances using CRSCTL and SRVCTL Utilities. Experience in migrating Standalone Database to High Availability Oracle RAC Environment in ASM. Experience in managing, troubleshooting, and resolving oracle database, RAC and applications issues. Experience in Installation, Configuration, maintenance, and support Oracle Golden Gate 10g/11g and 12c and Configured Unidirectional and Bidirectional Oracle GoldenGate replication Expertise in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle s regular performance tuning tools like Explain Plan, AWR, ASH, Sql tuning Advisor, STATSPACK (perfstat), SQL*Trace, TKPROF OEM and OSwatcher Expertise in RMAN database backup and recovery to tapes and disk in catalog and no catalog mode. Experienced with Golden Gate replication maintenance and tuning existing Golden Gate replications and supported implementation of new Extracts and Replicates groups. Configured Oracle GoldenGate integrated capture and classic capture for active-passive replication and for active-active replication strategies. Extensive troubleshooting of typical Oracle Golden gate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsci / log dump/discard file & ggserr.log analysis. Successful replication of Oracle Database 11g using Initial Load, Online Synchronization and Datapump process of Golden Gate. Proficient in troubleshooting replicate/extract ABEND scenarios, post ETrollover, data issues (handling with dev/app teams as necessary), check source from replicate, missing arch files and so on. Hands on experience on using of macros; exception handlers like handecollissions; ignore; skiptrans and logdump. Configure and build Golden Gate Extracts/replicate for multiple databases. Troubleshooting the GG errors, Worked on Replicated database/schemas/tables refresh, Worked on GG HUB server OS patching activity as part of support. Successfully worked on the data replication between operational and analytical enterprise system using Oracle Golden Gate. Implementing necessary monitoring scripts for Golden gate in UNIX scripting. Prepare GoldenGate parameter files for Extraction, Replication and Monitoring the GG processes using by GG Director. Excellent experience in Installation/Configuration/Performance Tuning/ Trouble shooting OGG in both Mobile : +1 (636) 312-8820 homogeneous and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle). Expertise in resolving generic database issues including startup/shutdown, characterset issue, instance parameters, archivelog generation. Fixing DB objects including compiling invalid objects and executing DML/DDL executions. Excellent experience of data migration, data archiving and data access techniques. Experience in using OEM (Oracle Enterprise Manager) and OEM agents for Managing and Monitoring Databases. Experience in creating plans, validating, analyzing PSU and Upgrade patches for both standalone and RAC database using DBLM feature in 12c OEM cloud control. Proficient with Oracle Database Upgrade Assistant for Upgrade and Migration of Oracle Data to higher Versions and Different Platforms. Strong knowledge of PL/SQL and UNIX shell scripting. Good at monitoring server performance, database transaction log growth and error logs. Experience in working with Different FTP software s like SFTP and SCP. Extensively used Oracle Support for resolving technical issues, opening SR and use collaborative support for database related issues. Experience in designing and implementing Backup and recovery Strategies using RMAN. Excellent experience in working with application team gathering information and working with them during new application installs. Having solid experiences in Linux/Unix administration. Ability to work independently and as part of a team. Adaptable to a fast growing and changing environment. Flexible and have excellent trouble shooting and problem resolution skills. Education Qualification and Certifications: Master s in computer Networking (M.Sc.) from Middlesex University, London, UK. Bachelor of technology in Electronics and communication Engineering (Btech) from Jawaharlal Nehru Technological University, Hyderabad, India Oracle Certified Associate (OCA 11g,) Oracle Certified Professional (OCP 11g) Oracle Cloud Infrastructure 2019 Architect Associate (OCI) Oracle Cloud Infrastructure 2019 Architect Professional (OCI) AWS Solution Architect Associate (SAA-C02) Technical Skills Databases Oracle 8i/9i/10g/11g/12c/18c/19c, Oracle RAC 10g/11g/12c, Oracle Goldengate 10g/11g/12c, Exadata X2, X3 & X6, ODA X5-2/X4-2/X3-2, Oracle EBS 11i and R12 Application and Operating System OEM 11g Grid control, OEM 12c/13c cloud control, Oracle Goldengate Director, OID (Oracle Internet Directory). Red Hat Linux, HP-Unix, AIX, Sun Solaris, Windows 95/98/NT/2000/08/12/XP. Database Tools DBCA, DBUA, RMAN, EXP, IMP, EXPDP, IMPDP, ASMCMD, ADRCI, ADDM, AWR, Putty, Tkprof, Toad, SQL*PLUS, SQL Loader, SQL Developer, STATSPACK, OPATCH, Datagaurd Broker, DGMRL, DBVERIFY. Languages PL/SQL, SQL, UNIX Shell scripting, C and C++ Cloud Infrastructure Oracle Cloud Infrastructure and AWS Client: Johnson & Johnson- Life Sciences Jul 2018 Till Date Location: New Jersey, USA Domain: Pharmaceutical Role: Senior Oracle DBA Role and Responsibilities: Working as a L2/L3 support DBA as part of Global Database operations team and point of contact for client to assist any issues/escalations. Performance Tuning of Oracle 11g/12C databases and providing dedicated support for critical applications. Upgrading/Patching on Oracle Data Appliance (ODA). Installed and configured 19c databases on Linux Environment for New Applications. Architecting, planning, designing, developing, deploying, and supporting databases. Refreshing development/test database from production using Export/Import & RMAN backups. Migrated data on different Oracle versions of 11g to 12c. Installation and maintenance of oracle 11gR2/12c RAC and standby database for High Availability and Disaster Recovery purpose. Applied Latest PSU patches simultaneously on multiple databases using DBLM feature in OEM 12c. Cloning/duplicate of database with RMAN and user-managed backups. Performing Health checks and monitoring Alert logs for any issues on Day-to-Day basis. Configured Incremental backups and weekly full backups for the databases. Configuration of RAC database with help of Enterprise manager agent on each cluster node. Successfully completed migration for the Databases from NON-RAC to RAC using ASM. Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility. Involved in monitoring the lock/block processes, releasing locks in case of resource blockage, and gathering statistics. Monitored/managed 2-node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery. Managing, troubleshooting, and resolving oracle database, RAC and applications issues. Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c. Manually created databases in RAC on ASM and configured RMAN and registered databases in catalog server and managing, troubleshooting, and resolving oracle database, RAC and applications issues. Creating and defining redo log files and undo tablespaces for RAC environments. Worked on RAC pre-installation tasks, like hardware requirements, software requirements, and environment configuration. Monitored the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, vmstat and top. Continuous review of Business-critical Database to proactively identify space issues, performance tuning issues. Working closely with DEV teams to create database objects (tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc.) as per the business needs. Prepare validation documents for database setup (installation, configuration, operation, etc.) in a control environment as SOP & run book standard documentations. Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental). Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports, imports, archiving old records and verification of such processes. Environment: Oracle 9i/10g/11g/12c, Oracle RAC 11G/12C, ASM, RHEL (Red Hat Enterprise Linux) v7.4, RMAN, TOAD, 12c OEM, DATAGUARD, Oracle Golden Gate 11g/12c. Client: Charter Communications, Inc. - Spectrum Oct 17 Jul 18 Location: North Carolina, USA Domain: Tele communications Role: Senior Oracle DBA Role and Responsibilities: Installation and maintenance of oracle 11gR2/12c RAC and standby database for High Availability and Disaster Recovery. Configuration of RAC database with help of Enterprise manager agent on each cluster node. Configured and maintained physical standby databases using Oracle DATAGUARD to perform quick disaster recovery. Develop database Backup and Recovery and Disaster recovery strategies; scheduling full and incremental backups using RMAN and remediated the existed backup strategies based on business-critical applications. Installer and Configured Oracle 11gR2 database instance running across two oracle RAC nodes on SunOS, RHEL, AIX and HP-UX. Successfully completed migration for the Databases from NON-RAC to RAC using ASM. Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility. Involved in monitoring the lock/block processes, releasing locks in case of resource blockage, and gathering statistics. Monitored/managed 2-node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery. Configured and maintained physical standby databases using Oracle DATAGUARD to perform quick disaster recovery. Develop database Backup and Recovery and Disaster recovery strategies; scheduling full and incremental backups using RMAN and remediated the existed backup strategies based on business-critical applications. Installer and Configured Oracle 11gR2 database instance running across two oracle RAC nodes on SunOS, RHEL, AIX and HP-UX. Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c. Manually created databases in RAC on ASM and configured RMAN and registered databases in catalog server and managing, troubleshooting, and resolving oracle database, RAC and applications issues. Creating and defining redo log files and undo tablespaces for RAC environments. Worked on RAC pre-installation tasks, like hardware requirements, software requirements, and environment configuration. Managed and Supported Database size around 4TB. Worked on Golden Gate setup and issue tracking and resolutions with Oracle support. Experience in maintaining more than 500+ Databases. Experience in doing the cross-platform migration of Oracle Databases from Solaris to Linux. Successfully upgraded database from 10g to 11g. Setting up of Oracle Security, Database Space Management, distributing the data files, index files, redo logs and rollback segments on different disks to optimize data retrieval, setting Unix Kernel parameters for improved performance, installing Patches, Performance tuning and monitoring of the applications and Documentation. Backup and Recovery with Disaster Recovery (DR) Plan Designed and implemented a comprehensive Oracle backup & recovery architecture. Configuring and managing Data Guard extensively Writing scripts to monitor Data Guard status and send alert messages if any issues occur that will make the standby out-of-sync with Production databases. Implementing/Testing SWITCHOVER/FAILOVER to Standby databases. Using RMAN for backups of Production/Developer Database Configuration of RAC database with help of Enterprise manager agent on each cluster node Creating and defining redo log files and undo tablespaces for RAC environments. Environment: ORACLE 9i,10/11g/12c, Oracle 10g/11g RAC, ASM, RHEL (Red Hat Enterprise Linux) v5.7, RAC, RMAN, OEM GRID, DATAGUARD, Oracle Golden Gate 10g/11g. Client: Time Inc. Synapse Oct 16 Oct 17 Location: Stamford, CT, USA. Domain: Media Company Role: Senior Oracle DBA Role and Responsibilities: Installed Oracle 11g Standalone and Real Application Cluster databases on two node and three nodes for achieving High Availability. Upgraded/Migrated databases from 10g to 11g. Worked with Application Owners on gathering requirements or troubleshooting issues during migration. Used physical standby database method for upgrading databases which hosted critical application to reduce downtime. Installed and configured OEM 12c and OEM 12c agents on database servers and configured the targets for monitoring. Experience in using OEM (Oracle Enterprise Manager) and OEM agents for Managing and Monitoring Databases. Experienced with Golden Gate replication. Maintained and tuned existing Golden Gate replications and supported implementation of new Golden Gate setups. Experience in creating plans, validating, analyzing PSU and Upgrade patches for both standalone and RAC database using OEM DBLM tool Proficient with Oracle Database Upgrade Assistant for Upgrade and Migration of Oracle Data to higher Versions and Different Platforms. Documented Migration Plans and schedules for successful Migrations to new environment. Created DATAGUARD with physical- standby configuration and performed switchovers/failovers as needed. Applied Patches to the databases for both standalone and RAC as required. Managed and Supported Database size around 4TB. Troubleshoot and provide technical solutions to database issues encountred by new and existing applications in the environment. Participate in the design, implementation and testing of enterprise-wide backup/recovery and disaster recovery. Contributed to testing and implementation throughout upgrade of Oracle 10g to 11g. Creating and dropping of users, granting and revoking permissions to users/roles as and when required. Collaborated with project managers, application developers to ensure the database integrity, high availability and security. Worked with change management team for creating change requests and getting database downtimes for performing maintenance activities. Key role in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, AWR, ADDM etc. Provided 24x7 support for Production/Development databases. Environment: ORACLE 10g, 11g, Oracle RAC 10g/11g, ASM, AIX, RHEL (Red Hat Enterprise Linux) 5.7, RMAN, OEM GRID, DATAGUARD, Golden Gate 10g/11g. Organization: Cognizant Technology Solutions Dec 14 Oct 16 Client: Johnson & Johnson- Life Sciences Location: Bangalore, India. Domain: pharmaceutical Role: Lead and Senior Oracle DBA Role and Responsibilities: Worked as a Senior DBA and lead DBA as part of Global database operations team. Develop database Backup and Recovery and Disaster recovery strategies, scheduling full and incremental backups using RMAN and remediated the existed backup strategies based on business-critical applications. Experience in creating plans, validating, analyzing PSU and Upgrade patches for standalone OEM DBLM tool. Upgraded the GG process from 12.2.0.1 to 12.2.0.2 in bi-directional replication. Re-instantiation to fix the GG replication issues. Splitting the extract group and replicates group for configuration change requests. Troubleshooting the GG errors, Worked on Replicated database refresh, Worked on GG HUB server OS patching activity as part of support Experience in designing and implementing Backup and recovery Strategies. Performance Tuning and provided L2 and L3 support for critical applications. Experience in handling SEV1 and SEV2 issues and representing in GCC call during the severity issues. Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM and ASH. Installed 12c databases on both Windows and Linux Environment for New Applications. Continuous review of Business-critical Database to proactively identify space issues, performance tuning issues. Experience in administering tasks like monitoring, error checking and running health checkup. Worked with change management team for creating change requests and getting database downtimes for performing maintenance activities. Create and review Documentation of implementation plan and queries for structural changes in db. Worked on SDDC (Software Defined Data Center) migration to maintain dedicated database server for critical applications using data pump, RMAN and Golden gate. Refreshing development/test database from production using Export/Import & RMAN backups. Managed and Supported Database size around 4TB. Upgraded/Migrated databases from 10g to 11g. Configured and maintained physical standby databases using Oracle DATAGUARD to perform quick disaster recovery. Worked with Application Owners on gathering requirements or troubleshooting issues during migration. Experience in maintaining more than 4000+ Databases. Experience in doing the cross-platform migration of Oracle Databases from Solaris to Linux. Backup and Recovery with Disaster Recovery (DR) Plan Designed and implemented a comprehensive Oracle backup & recovery architecture. Configuring and managing Data Guard extensively Writing scripts to monitor Data Guard status and send alert messages if any issues occur that will make the standby out-of-sync with Production databases. Implementing/Testing SWITCHOVER/FAILOVER to Standby databases. Provided support 24x7 for Production databases. Environment: ORACLE 10g/11g/12c, Oracle Datagaurd 10g/11g, RHEL (Red Hat Enterprise Linux) v5.7, RMAN,10g/11g/12 Golden Gate 11g/12c, OEM GRID. Organization: IBM India Pvt Ltd. Jul 12 Dec 14 Client: Sprint-Nextel Location: Bangalore, India. Domain: Tele communications Role: Oracle DBA Role and Responsibilities: Installed Oracle 11g Standalone and Real Application Cluster databases on two node and three nodes for achieving High Availability. Used physical standby database method for upgrading databases which hosted critical application to reduce downtime. Experienced with Golden Gate replication. Maintained and tuned existing Golden Gate replications and supported implementation of new Golden Gate setups. Proficient with Oracle Database Upgrade Assistant for Upgrade and Migration of Oracle Data to high-er Versions and Different Platforms. Installed and Configured Oracle 11gR2 database instance running across two oracle RAC nodes on SunOS, RHEL, AIX and HP-UX Familiar with Discoverer, Workflow configurations, Forms and Reports.Troubleshooting Concurrent manager, Apache and Discoverer issues. Created DATAGUARD with physical- standby configuration and performed switchovers/failovers as needed. Applied Patches to the databases for both standalone and RAC as required. Installation, upgradation of Oracle Golden Gate. Configured Oracle GoldenGate integrated capture and classic capture for active-passive replication and for activeactive replication strategies. Perform Goldengate re-instantiation for resyncing the source and target databases. Upgraded Oracle goldengate v10 to v11 Setup classic capture replication mechanism using goldengate Configured GoldenGate to achieve unidirectional and bidirectional replication Setup GoldenGate User with necessary privileges Contributed to testing and implementation throughout upgrade of Oracle 10g to 11g. Worked in 24x7 support model for Production databases. Environment: ORACLE 10g, 11g, Oracle RAC 10g/11g, ASM, AIX, RHEL (Red Hat Enterprise Linux) 5.7, RMAN, OEM GRID, DATAGUARD, Golden Gate 10g/11g, Oracle Apps 11i. Organization: IBM India Pvt Ltd. Aug 10 Jul 12 Client: Seadril, Norway Domain: Oil and Gas Role: Oracle DBA Role and Responsibilities: Implemented Oracle database 11g Two node Real Application Cluster (RAC) using Oracle Clusterware for achieving high Availability. Implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume. Managed on Oracle Enterprise Manager OEM, Automatic Workload Repository AWR, Automatic Database Diagnostic Monitor ADDM, Active Session History ASH , STATSPACK, TKPROF, CRSCTL, SRVCTL, EMCTL, DBCA, and CLUVFY for Db administration. Experience with Real Application Clusters RAC and Automatic Storage Management ASM, RMAN, Oracle Data Guard. Managing, troubleshooting, and resolving oracle database, RAC and applications issues. Implemented strategy for partitioning and management of historical data tables in RAC. Monitored/managed 2 node RAC environments, databases using OEM Gridcontrol, and RMAN database backup and recovery. Migration of databases to Oracle 11g from Oracle 9i on Linux to AIX. Creating DATAGUARD with physical- standby configuration with hot backup and testing it for fail-over and switch over in different modes. Upgrade database from 9i/10g to 11g. Performed data conversations. Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups. Performance tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components. Involved in full/ partial logical backup using DataPump. Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports and imports, archiving old records and verification of such processes. Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora Created Materialized views to make query response faster Utilized SQL*Loader and Data Pump import to load data into tables. Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software. Applied Latest PSU patches as needed to both standalone and RAC databases. Documented backup and recovery plans and tuning procedures. Participation in Logical Design discussions and designing physical database. Prepared documentation for ongoing maintenance and support. Environment: Oracle 9i/10g/11g, Oracle RAC 10g/11g AIX 5, HP-UX 11, RHEL (Red Hat Enterprise Linux) v4.5, PLSQL, RMAN, TOAD, OEM GRID, DATAGUARD. Keywords: cprogramm cplusplus user experience business intelligence database information technology hewlett packard microsoft procedural language Connecticut South Carolina