EXPERIENCE SUMMARY:

• Having more than 16.09 years of experience in Oracle Database Administration including Oracle Apps 11i/R12 E - Business Suite administration mostly in operations
• Managed the operations and build work, preparing documents, meetings, reviews & discussions, process improvements and providing RCAs.
• Involved in various solution, designing and architectural work.
• Hands-On experience in 10g/11g/12c RAC Installation & Management.
• Worked on OEM Grid Control.
• Worked on RMAN to perform backup & recovery operations.
• Knowledge in Database Administration concepts as well as oracle architecture.
• Worked on Database Performance Tuning.
• Oracle Database Migration or Backups using Export/Import.
• Oracle Database Up-gradation.
• Worked on Oracle RAC, Data-guard, Streams and Clone databases.
• Worked on Oracle 11i Apps administration for around 2.0 years.
• Installing, Cloning, patching & upgrade Oracle 11i Apps.
• Automation using scripting in Shell, Batch and Ansible.
• Worked on MySql/Mariadb, DB2 databases.
• Basic idea in TimesTen In-memory database, Oracle VM, Oracle Golden gate, Oracle Exa-data.
• AWS cloud understanding and Knowledge of Ansible, Python, Chef & Docker.
• Microsoft Certified Azure Fundamentals. (AZ 900).
• Microsoft Certified Azure Solution Architect Expert. (AZ 303 & AZ 304).

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c.

Operating Systems: Windows, Linux, IBM AIX, HP-UX, Solaris.

Automation: Ansible, Shell & Batch script.

Tools: OEM Grid control, SQL-Developer, TOAD.

ERP: Oracle Apps 11i/R12 E business suite.

Cloud: Microsoft Azure Cloud.

PROFESSIONAL EXPERIENCE:

Confidential

Infrastructure Specialist - Database services

OS: Linux VM

Database: Oracle 12c/18c/19c/20c.

Automation: Using Shell scripting .

Responsibilities:

• Installation & Configuration, PSU patch, Up-gradation from 12/18c to 19c.
• Managing all backups, restore & recovery operations.
• Creating and managing standbys databases for DR & HA.
• Performing DR test switch-over & rollback across all the clients individually.
• Involve in whole transition and handover to BAU after project go-Live.
• Involve in automation through Shell for Monitoring standby gaps, health check, backups.
• Performing multiple cloning, trouble shooting and resolving all issues.
• Providing solution for replication/cloning as Snapshot Standby DBs.
• Providing solutions and designing of Oracle pluggable databases and its up-gradation from Non CDBs/PDBs.
• Automation of DR Testing Switch over and rollback -with shell scripting and integration with Anisble.
• Part of Azure Guild -Preparing Use cases in Azure Cloud-
• Azure Sql Server, Data Factory, Data Lake, Synapse, Cosmosdb.
• Managed Data Security in Azure sql server.
• VM creation and Virtual Networks.
• Connectivity between two Vnets using NSG.
• Log Analytic.

Confidential

Infrastructure Architect - Database services

OS: Linux & Windows VM

Database: Oracle 11g/12c.

Automation: Using Ansible, Shell and Batch script.

Responsibilities:

• Supporting IMI Regulatory clients
• Installation & Configuration of Oracle 11g/12c database, PSU patch.
• Managing all Maria-db databases with Galera Cluster.
• Involve in whole transition and handover for BAU and new projects.
• Involve in Automation through Ansible-Playbooks for Installation/ patching / health check, Cassandra-setup etc.
• Involve in automation through Shell/Batch for health check and backups.
• Execution of Handover to US team.
• Involved in DR and compliance activity with respect to audit, managing all NCIs & RCPs.

Confidential

Oracle Database Subject Matter Expert (SME)

OS: Linux VM

Database: Oracle 11g/12c.

Application: Oracle EBS 11i/R12

Responsibilities:

• Supporting Off-site to Confidential.
• Installation & Configuration of Oracle 11g/12c database, PSU patch.
• Installation of IBM DB2.
• Involved in Migration of Oracle EBS from 11i to R12 and DB from 11g to 12c.
• Automation through Shell- Created MEF extractors tool in Shell for fetching all user id for user access management, extractors are uploaded in IBM W3.

Confidential

Oracle Database Subject Matter Expert (SME)

OS: IBM-AIX, Linux VM

Database: Oracle 11g & 12c RAC.

Responsibilities:

• Installation & Configuration of Oracle RAC 11g/12c, around more than 40 RAC installations & PSU patch completed in Server Build Team.
• Implementing GSD/security as per SA&D process.
• Support in process improvement in SA&D and server build.
• Patching RAC Databases.
• Up-gradation of RAC (GI & DB) databases.
• Installing and configuring Standby-DR & BCV for production databases.
• Support in Operation team within 24*7 support as and when required and being on standby.
• Resolving various Sev-1 issues in operations like B&R, Block corruption/recovery, Hung & Slowness issues, CRS timeout etc.
• Support in backup strategies, OEM reporting and scheduling & maintaining alerts etc.

Confidential

Sr. Oracle DBA

OS: IBM-AIX, Sun Solaris, Windows etc

Database: Oracle 8i, 9i, 10g, 11g, 12c.

Responsibilities:

• Designing of a database for NPD & Finnonepro Projects.
• Migration of databases. (Oracle9i to Oracle10g, Oracle10g to Oracle11g, 12c etc.)
• Solving daily database requests, installation, creation, up-gradations, trouble shooting, Performance tuning of databases.
• Installation, configuration & troubleshooting of Oracle SQL-Developer.
• Knowledge of Oracle Streams implementation.
• Knowledge of Oracle VPD implementation.
• Oracle 11g, 12c installation & configuration, overview of new features.
• Other focus areas:-
• Oracle TimesTen In-memory Database installation & configuration.
• Oracle VM (server & manager) installation.
• Oracle Golden Gate installation & configuration.

Confidential

Oracle Apps DBA

OS: IBM-AIX 5.2

Database: Oracle 9i (9.2.0.6 & 9.2.0.7) RAC (3-Nodes)

Application: Oracle 11i (11.5.8 & 11.5.10) Multi Node

Modules: CRM, Finance, HRMS, OLM etc.

Responsibilities:

• Managing Oracle databases and Oracle 11i applications on IBM-AIX
• Managing, Hot & Cold user managed Backups.
• Building & Maintaining Standby database for CRM application and Oracle E-mail
• SQL Tuning, checking Explain - Plans, creating Trace files, running TKPROF.
• House Keeping activities like Gather Statistics, Index rebuilding, Table Re-organizing.
• Responsible for implementing RFC’s.
• Working with adpatch, adadmin, adctrl, adsplice and opatch utility.
• Administrating, starting & stopping Concurrent Managers, Forms & Report Server etc.
• Changing/Monitoring Concurrent Manager Work Shifts etc.
• Changing APPLSYS, Oracle User and Application User password through FNDCPASS.
• Compiling procedures, packages, function and forms (f60gen) etc.
• Responsible for all User Access activities and involved in solving application related problems.
• Changing System and User Profiles at different level in Application.
• Registering Printers and solving Printer problems at Application and OS level.
• Applying patches according to and as per the requirement.
• Doing Log Mining of archives.
• Oracle CRM and financial cloning.

Confidential

Sr. Support Executive

OS: HP-UX

Database: Oracle 9i (9.2.0.6) Standalone

Application: Oracle 11i (11.5.8).

Modules: Finance & HRMS.

Responsibilities:

• Managing Oracle database and Oracle 11i application on HP-UX.
• Doing RMAN, Hot & Cold user managed Backup, Recovery & Restorations.
• Making backup & recovery policies.
• Transferring and verifying backups on tape through HP-UX SAM GUI tool.