SUMMARY

• Oracle Database Administrator with 10 Years of experience in information technology as Applications & CORE DBA and have hands on experience on design, implementation, administration, configuration and maintenance of Oracle Applications and Databases
• 10 years of experience In Information Technology Which Includes as an Oracle Applications DBA and Core DBA.
• Experience in installation and configuration ofOracleRAC.
• Extensive knowledge ondatabase administration of 11g,12c and 19cwith experience in very large scale database environment.
• Involved with installation and maintenance ofORACLE 10g RAC/oracle 11gRAc C and standby database for High Availability and Disaster Recovery purpose.
• Hands on experience inOracle 10g/11g/12c RAC implementation & administration(Oracle Cluster ware setup and configuration, RAC installation usingASM, Grid Installation).
• Extensive experience in DatabaseBackups RMAN(Full/Incrementalbackups) and in traditionalhot/coldbackups.
• Good experience inPATCHING AND UPGRADATION.
• Expertise inupgradingOracleDevelopmentandProductiondatabases from 12c to 19c
• Experienced in RAC and STANDBY, ASM and GOLDEN GATE database maintenance
• Experience inDatabase Refresh, patch management and inDatabasecloningwith RMAN and manual methods.
• Good Hands on experience on applying WebLogic patching on 12.2 environments.
• Oracle database migrations 12c to 19c in EXADATA using RMAN duplicate
• Code deployment using CI/CD tools like Harvest/ Bitbucket/Jenkins tool
• Supporting & rebuild physical standby databases such as reporting and backup purpose.
• Supporting and configuring OEM alerts, and upgrade OEM 13c
• Backup, recovery, and migration using RMAN, data pump and export/import.
• Worked on Application of Quarterly release of Oracle Critical Patch Updates to Oracle Applications and Databases.
• Experience on AWS cloud for creating EC2 instances, alert monitoring and configuring using cloud watch, creating dba using RDS, and IAM management for user creations poly creations and so on
• Experience on DB backup and clone tools RUBRIK and DELPHIX
• Having Experience on DB Upgradation from 11.1.0.7 to 11.2.0.4 and EBS Application Upgradation from 12.1.3 to 12.2.4 and 12.2.3 to 12.2.7.
• Experience 12.2 online patching (ADOP) and cloning activities.
• Online Patching (ADOP) in R12.2 environment Dev & Test instances.
• Expertise in patching, cloning and EBS related activities using Jenkins’s tool.
• Having good knowledge on 12.2 concepts.
• Experience on WebLogic Patching and Maintenance Activities.
• Excellent working skills in installation, cloning, upgradation, maintaining concurrent managers.
• Install, Configure and Administer Oracle EBS Applications R12 and Experience in Implementing New Release Oracle Application EBS 12.2.
• Troubleshooting Experience for all EBS Application & DB - Tiers.
• Experience on Application-SYSADMIN activities like creating and managing users & their Responsibilities and setup for Profile creation, Menus and Functions.
• Experience in handling production database support environments and maintenance as well.
• Taking scheduled backup of Oracle Database and monitoring backups as per backup strategy by using RMAN and involved Database cloning with Cold/Hot and RMAN Backups.
• Experienced in taking regular off-line, on-line, traditional and logical Backups.
• Expertise in installing different versions of Oracle on Linux and OEL.

TECHNICAL SKILLS

Operating System: Red Hat Linux 5, Sun Solaris on SPARC 10.5, Linux, Windows 95/98/2000/NT/XP, VMware.

Databases: ORACLE 10g, 11g, 12c and 19c

DB Tools: SQL*Plus, SQL*Loader, Export & Import utility, OEM, Database Configuration Assistant, RMAN, Toad, PL/SQL developer, AWR, ADDM, Data Guard, Rubrik and Delphix

Languages: SQL, PL/SQL, HTML, Java, C, C++, Perl Scripting, K sh. C shell

Internet: ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript, Flash MX

ERP: Oracle E-Business Suite 11i, R12.1.1, R12.1.2, R12.1.3 and R12.2

GUI Tools: Oracle Enterprise Manager, Visual Basic 6.0

CLOUD: OCI, Azure and AWS

PROFESSIONAL EXPERIENCE

Confidential

Application Database Administrator

Responsibilities:

• Fulfill DBA daily activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.); space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Implementation of Oracle Backup and Recovery strategies using COLD BACKUP, HOT BACKUP, and RMAN environment.
• Working on Delphix tool for provision, backup, daily refresh, rewind and clone the Database and EBS applications
• Working on Rubrik for taking regular backup and implementing backup strategies
• Monitoring File systems thresholds for all Exadata server, non-Exadata server, cluster databases.
• Experienced in RAC and STANDBY, ASM and GOLDEN GATE database maintenance
• Work closely with the developer provides Oracle DBA support and technical support for multiple applications in development, test and production environments.
• Creating and maintaining IAM user management in AWS cloud
• Alert monitoring and configuring using cloud watch in AWS cloud
• Creating or migrating on premise DB to AWS cloud using RDS
• Involves in Database schema refresh activities from Production to stage.
• Experienced in Tuning: Used Explain plan and TKPROF for SQL/PLSQL Tuning; Performance tuning, troubleshooting (locks, network connection etc.) and documents database problems as they arise.
• Strong analytical, technical, Research, technical writer, general business, and functional skills are blended with excellent communication skills with around 7 years of working experience.
• Configuration and Creation of the database and Upgrades.
• Creating a Physical backups script using RMAN.
• Creating and implementation of RMAN With and without Recovery Catalog.
• Creating and maintaining standby databases.

Confidential

Oracle DBA & Application DBA

Responsibilities:

• 24x7 Production database and applications support.
• Maintenance ofORACLE 12C RAC and Standby databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
• ImplementedOracle database backup & recovery solutions using RMAN.
• Responsible inconfiguring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Applied Oracle Applications and database patches.
• Cloned/RefreshedOracle Databases and Oracle Applications.
• Monitoring the Oracle applications and provided 24x7 On-call support.
• Managing the patches and dealing with Oracle Support for many productions and Test/development Instances single node and multi node.
• Cloning and Patching of Oracle Databases and Oracle Applications on weekly basis.
• Good knowledge on 12.2 File system like Run, Patch edition and non-edition file systems.
• Maintenance and monitoring of Database and Listener and applications
• Resolving user’s day-to-day issues.
• Responsible for managing the Oracle RAC database and standard alone databases.
• Taking RMAN backup and cold backup in regular basis.
• Checking Alert log in regular basis for any error, if error is critical logging the call with oracle and take the resolution of issue with limited time.
• Checking AWRRPT report for CPU usage and which query taking long time.
• Managing the ASM Storage and tablespaces.
• Responsible for code migrations using Harvest tool.
• Responsible for apps password change on quarterly.
• Responsible for performance testing by load runner with different scenarios.

Confidential

Oracle DBA & Application DBA

Responsibilities:

• Good Hands-on Experience on EBS upgrade from 12.1.1 to 12.1.3.
• Monitoring the Oracle applications and provided 24x7 On-call support.
• Cloning and Patching of Oracle Databases and Oracle Applications on weekly basis.
• Troubleshooting the issues raised by user community and development.
• Defining customized transaction Concurrent Managers work shifts and their specialization rules.
• Having the experience on Platform Migration of servers from HPUX to Linux.
• Supporting development teams, general troubleshooting & support in administration of Product & Test instances.
• Monitoring Concurrent managers, its operations and troubleshooting and long running jobs.

Confidential

Oracle DBA & Application DBA

Responsibilities:

• 24x7 Production database and applications support.
• Monitoring the Oracle applications and provided 24x7 On-call support.
• Managing the patches and dealing with Oracle Support for many productions and Test/development Instances.
• Cloning and Patching of Oracle Databases and Oracle Applications on weekly basis.
• Good knowledge on 12.2 File system like Run, Patch edition and non-edition file systems.
• Providing Month end closing support for AP inEBSdatabases.
• Having good Experience on 12.2 cloning and patching.
• Defining customized transaction Concurrent Managers work shifts and their specialization rules.
• Applying patches and PROD and NON-PROD using ADOP on weekly basis for deployments.
• Applying WebLogic patching on weekly basis for deployments
• Patching in R12.2 using ADOP and tested all phases in oracle apps R12.2.
• Cloned R12.2 environment from PROD to test and another environment.
• Having the experience on Migration of servers.
• Having Experience on applying patches using Jenkins tool.
• Having good experience on cloning using Jenkins tool and manual.
• Monitoring the tickets and working for P1 issues on PROD priority bases and supporting development teams in general troubleshooting & support in administration of Product & Test instances.
• Troubleshooting on Concurrent manager long running jobs and resolving.

Confidential

Oracle DBA & Application DBA

Responsibilities:

• Good Hands-on Experience on EBS upgrade from 12.1.3 to 12.2.4 and DB Upgrade from 11.1.0.7 to 11.2.0.4
• Cloning the DEV, TEST, STAGE instances from PROD 12.2.4.
• Performing Health checks forOracleApplication services.
• Online Patching (ADOP) in R12.2 environment Dev & Test instances.
• Cloning ofOracleE-business suite R12.1.3 and R12.2.4
• Patch Impact Analysis and patch management and apply patches using ADOP.
• Installing and Configuring the EBS R12 and 11g R2
• Check Alert Log errors and make necessary actions to rectify them.
• Perform logical backups using Export and Import utilities.
• Patch management and doing patch analysis regularly
• Cloning Oracle Apps environment to test environments.
• Supporting development teams, general troubleshooting & support in administration of Product & Test instances.
• Monitoring Concurrent managers and its operations like starting and stopping the concurrent managers, troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Well-versed with Sysadmin module like enable tracing of conc. changing the process of managers to improve performance (of Conc. Req. processing) and also worked with menus/responsibilities.
• Monitoring, identifying and resolving user issues. supporting Day-to-Day Production Support Activities
• Involved with installation and maintenance ofORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
• Responsible inconfiguring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Restoration and Recoveryof databases at the times of occurrence of critical failures.
• ImplementedOracle database backup & recovery solutions using RMANand manual methods.
• Responsible for patch analysis and impact for all kinds of patches.
• Monitoring table spaces for space usage and adding required space whenever it reaches threshold.
• Checking database locks and clearing the blocking sessions.
• Created new schemas and maintained privileges.
• Raising the SR through Meta link to resolve new issues and interacting with the support team for fixing the new issues.
• Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, frequently applied Patches for Bug Fixes in Both DB & Applications using Opatch & Adpatch.
• Monitoring and administering Concurrent managers and resolved the issues related to concurrent manager