PROFESSIONAL SUMMARY

• 7+ years of experience as Oracle DBA and Python Developer.
• Developed Database Provisioning Automation Tool using Python/Shell Scripts.
• Developed PLSQL procedures as part of Automation Tool.
• Developed various Shell scripts to monitor production database services.
• Responsible in all aspects of Oracle and Oracle Applications Database administration and maintenance of production, development and test environments.
• Installed and configured 11g Oracle Identity Management (IDM).
• Implemented and production support for oracle 11g OID - LDAP/TNS.
• Production support for Oracle Connection Manager (OCM).
• Installed Oracle Fusion Middleware components (Weblogic 10.3.6).
• Upgrading Oracle applications from 12.1.3 to 12.2.5.
• Implemented data replication using Golden Gate.
• Installed and configured Oracle Timesten 11.2.2.8 with active-standby and standalone setup.
• Recreate Timesten data source before data load activities.
• Worked on Oracle 12c RAC environments, alongwith DataGuard setup (Maximum Availability).
• Install Oracle Enterprise Manager Agent, discover targets and setup monitoring for production databases in OEM.
• Installing 10g/11g/12c CRS and maintaining Oracle RAC 10g/11g/12c databases.
• Developed various custom Shell scripts to automate daily or repetitive tasks.
• Familiar with Hadoop 2.6 installation, configuration, YARN distributions and various components such as HDFS, NameNode, DataNode, Job Tracker, Task Tracker.
• Knowledge on decommissioning and commissioning of node on Hadoop cluster.
• Knowledge on administrative tasks such as Hadoop installation in pseudo distribution mode and upgrading Hadoop 1.0 to Hadoop 2.0.
• Currently undergoing self-training on AWS solution architect.
• Provide L3 support for P1/P2 production databases.

TECHNOLOGY

• Below is a list of important hardware, software products, tools and methods that I have worked with:
• Hardware
• Software Products
• Tools
• Languages
• Red Hat Linux RHEL 5.x, 6.x, 7.x.
• Oracle database 12c/11g, Oracle Applications (R12), Identity Management, Connection Manager,
• Weblogic 10.3, Oracle Internet Directory 11g, Timesten 11.2, Oracle Enterprise Manager (OEM).
• SQL*Plus, Import, Export, OEM, TOAD, VNC, Remedy, Xming.
• Python 2.6, SQL, Shell scripting, PLSQL.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Python Developer, Oracle DBA.

Responsibilities

• Developed scripts in python 2.6 to automate Oracle 12c Database provisioning. It includes GRID installation for Oracle RAC environments.
• Designed, Planned and Developed the DRIVE Automation tool.
• Completed new Oracle 12c database and GRID installation, used as repository for DRIVE tool.
• Developed Python scripts to receive and update data from other tools using REST API.
• Developed Python modules for each sub task, for example send email, updating current job status, resume job.
• Created different schemas, tables as per various user roles and repository requirement.
• Developed SQL procedures for various requirements such as fetch available servers as per client request.
• Planned the Custom views for UI team to fetch various details from repository.
• Tested backup for DRIVE production database.
• Developed scripts in shell to automate database installation steps on target servers.
• Reading and replying data in JSON format for any WEB Call to script.
• As part of post database provisioning, developed scripts in python to check and insert data for Cisco Custom Tools (TNS, LDAP) as per the Standards.
• Developed module in python to send Email notification to end client, support team and other respective team.
• Developed Shell scripts to monitor WebLogic Admin, Managed servers, Oracle Database services.
• Deploy custom application in Oracle WebLogic.

Solution Environment: Linux RHEL 7, Oracle 12c, Oracle WebLogic 10.3.6, Oracle Enterprise Manager, Python 2.6.

Confidential

Oracle FMW Administrator.

Responsibilities

• Create 12c Oracle RAC databases on all the datacenter.
• Install, configure and administer WebLogic server 10.3.6 on Red hat Linux 6 in both production and development environment and SOA environment.
• Managed Weblogic clusters having various managed servers on cluster of machines.
• Configured Lightweight Directory Access Protocol (LDAP) directory server and directory integration on top of oracle database.
• Integrated LDAP with Oracle Fusion Middleware and Oracle Fusion Applications.
• Install Java EE development framework, Application Development Framework (ADF).
• Install and configured 11.1.1.9 Oracle Internet Directory (OID) with multiple directory server instances.
• Install and configure Webgate (11.1.1.9 OHS) on all the datacenters.
• Integrate all the ERP environments with 11g IDM, including Production, Development, Test environment.
• Created different schemas, tables as per requirement.
• IDM integration for all ERP environment post refresh.
• Developed custom shell scripts to start and stop Admin server and Managed Server services.
• Develop scripts for monitoring the entire IDM stack and individual component services.
• Create Datasource with Oracle Thin Driver for instance connections and JDBC Url.
• Deploy custom application for each environment in Oracle weblogic 10.3.6.
• Apply patch on weblogic/OID to avoid security vulnerabilities.
• In case of issue, manually Create/Modify/Delete user in OID.

Solution Environment: Unix, Oracle 12c, OID, 11g IDM, Weblogic 10.3, Python 2.6, Shell.

Confidential

Oracle FMW Administrator.

Responsibilities

• Create 12c Oracle RAC databases on all the datacenters.
• Install, configure and administer WebLogic server 10.3.6 on Red hat Linux 6 in both production and development environment and SOA environment.
• Install Java EE development framework, Application Development Framework (ADF).
• Install and configured 11.1.1.9 Oracle Internet Directory (OID).
• Configure OID replication across both the Active Datacenters using Replication Environment Management Tool (remtool).
• Authenticating client to directory server and establishing authorization identity using Bind Operations.
• Developed Automation Tool, using Shell script, for users to Add/Delete LDAP entries.
• In case of any issue, manually Add/Modify/Delete TNS entries.
• Working in various Problem tickets assigned.
• Performed research for patches for specific problems, and download and apply patches.
• Apply Patch on WebLogic/OID to avoid security vulnerabilities.
• Worked with Oracle Corporation & opened TARs (SR’s) to resolve number of bugs.

Solution Environment: Oracle Apps R12, Oracle 11g, 12c, OID, LDAP, Weblogic 10.3, OEM, Shell Script.

Confidential

Oracle Apps DBA.

Responsibilities

• Supporting all P1/P2 production issues.
• Involved in discovery calls with client to setup new environment as per client requirement.
• Oracle Database upgrade from 11g to 12c.
• Responsible for all the databases owned by Infrastructure team, includes OCM, LDAP, SSO setup.
• Setup custom SHELL Script for monitoring various environments.
• Cloning oracle apps 11i/R12 databases using Rapid Clone and manual clone.
• Upgrade of Oracle applications from 12.1.3 to 12.2.5.
• Expert on AD utilities like adpatch, adadmin, adclone, adident, adctrl, adop.
• Disaster Recovery testing for databases with Data Guard setup.
• Install and configure Timesten 11.2.2.8 and underline Oracle 12c databases.
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Worked with Oracle Corporation & opened TARs (SR’s) to resolve number of bugs.

Environment: Oracle Apps R12, Oracle 11g,12c, OCM, OEM, Shell Script.

Confidential

Oracle DBA

Responsibilities

• Design and Building the DR environment (usually at 50% of Production environment) using Oracle Dataguard and replicated storage.
• Simulate DR scenarios like network, host and datacenter outage.
• Enabling snapshot database.
• Troubleshooting DG shipping and recovery issues.
• Restoring and testing the environment during DR scenarios.
• Restoring the Production environment after DR Testing.

Environment: Oracle 11g,12c, OEM, Linux Shell Script.

Confidential

Confidential DBA

Responsibilities

• Creating new environment for Confidential host.
• Developed Shell script to set custom parameters dynamically for Confidential databases.
• Creating Standalone and RAC VDB (Virtual DataBase).
• Monitoring daily basis snaps running for vdb.
• Monitoring Confidential engine alerts and warning messages.
• Upgrading Confidential engine to latest version.
• Creating DSource for DR in Confidential engine, which serves as source for VDB creation.
• Creating/Updating custom templates for VDB creation in Confidential engine.
• Updating VDB configuration as per custom requirements.
• Database creation, copy, refresh, backup activities.
• Connectivity and locking issues.
• Maintaining Archived log files.
• Monitoring Users access, CPU usage on server, Confidential engine space usage.

Environment: Confidential, Oracle 11g, 12c, Confidential Mission Control.

Confidential .

Oracle DBA

Responsibilities

• Support various releases including Go-Live activities.
• Support for daily/scheduled backup of Oracle database.
• Resolve different issues related to Oracle ERP.
• Enable or Disable supplement login as part of releases, and Golden Gate Implementation.
• Perform HOT and Cold backup validations.
• Creating DBLink as per client requirement.
• Managing control files like adding, recreating and tracking to physical locations and tracing backup.
• Responsible for Database and Application cloning.
• Managing REDO logs and Datafiles like adding, resizing, UNDO tablespace features of Oracle database.
• Connectivity and locking issues.
• Maintaining Archived log files.
• Monitoring Users access, CPU usage on database server.
• Monitoring Database status from Oracle Enterprise Manager.Solution

Environment: Oracle Apps 11i/R12, Oracle 11g,12c, Oracle Enterprise Manager.