Summary:

• experience as an expert Oracle RAC DBA/Oracle Applications DBA on Linux Red Hat, SUN/Solaris, IBM/AIX, HP-UX and Windows supporting Oracle Databases on RAC and non RAC versions from 11gR2, 10g, 9i, 8i and Oracle Applications versions latest Release of OracleApplications R12 12.1.3 , 11.5.9, 11.5.8, 11.5.7 and its modules including AP, GL, AR, PO, FA, Order Management ONT , Oracle Inventory INV , WIP, BOM, HRMS, Procure to Pay iProcurement , iExpense Self Service Web Applications
• Highly experienced in Oracle Applications E-Business Suite EBS Applications 11i ERP and R12 Installations, configuration, Cloning, Security, Patching, Upgrades and Maintenance using AD and other utilities.
• Oracle application upgrades from to R12.1.3 on VCP instance in both Linux HP-Unix.
• Assisting in preparing and auditing an R12 Assessment as required as per project requirements.
• Expert in platform migrations from HP-UX to Linux for 11i / R12 applications and databases.
• Highly expert in RAC Upgrades and internal functionality and process.
• Good Knowledge on DMZ server configuration and Setups..
• Knowledge in Golden Gate installation Configuration setups in both windows/Linux environments
• Proficient in Oracle application Installation, ad-utilities, System Administration, patching, maintenance, security, Sysadmin functions and Administration.
• Installing Oracle Application Server AS10g Single-Sign-On/OID/LDAP and configuring with OracleApplications E-Business Suite 11i R12 Release 12.0.3
• Excellent working experience in administrating Oracle databases, which includes database designing, creation, configuration, development, security and backup/recovery.
• Installed and supported Oracle Applications ERP servers on Single and Multi-node
• Configured and supported Oracle 9i, 10g, 11g and Real Applications Clusters RAC on Linux RH-3, 4, 5
• Experience with setup and configuration of Oracle Data Guard / logical Standby and physical Standby databases with Oracle Applications 11.5.10 R12
• Monitored and optimized the Performance of the database, Tuning Management, capacity planning, created new technologies and SQL tuning using utilities/tools like explain Plan, TKPROF, Auto trace, AWR reports, STATSPACK, OEM and SQLTXPLAIN.
• Database upgrade and migration experience on various versions of Oracle Database from 8i to 9i 9i to 10g 10g to 11g
• Experience with Oracle applications upgrade from 11.5.8 to and to R12.1.3
• Oracle Server Installations/Upgrades, Space Management, Capacity Planning, Backup Recovery using Manual and RMAN, Disaster Recovery, Database Performance Tuning, Memory Tuning, Security Administration, Data Architecting, normalization/de-normalization, Data Warehousing, Multithread Servers, Distributed Databases for Oracle 8i/9i Databases, table partitioning and OracleStandby Server.
• Experience in many systems development lifecycles SDLC , from requirement development, architecture design, testing, and post implementation revisions.
• Install/setup/configure Oracle Enterprise Manager OEM tools for monitoring of Oracle Database Oracle Applications 11i R12.
• Proficient with monitoring tools, Grid Control, third party software and Oracle Application Manager OAM , HOTSOS.
• Creating users, roles and profiles, granting and revoking privileges and access for database object proactively using events and fixit jobs from OEM to monitor database high water marks.
• Working skills in managing with features like Oracle Managed Files OMF , Auto Space / Undo Management, Managing tables, indices, views, tablespaces, redo logs, etc using sqlplus, OEM.
• Knowledge in Implementation, installation, Cloning, maintaining concurrent manager processes, Patching related to Oracle Applications.
• Proficient in PL/SQL and Shell Scripting, SQL query tuning, Database performance tuning and Ebiz performance tuning
• Worked extensively on patching using KINTANA HP PPM and applying patches manually ofOracle Applications 11i R12 EBS Systems
• Expert in maintenance routines using ADADMIN recompile Apps Schema, Generate ENV files, Generate JAR files, take APPL TOP snapshots etc.
• Hands on experience with cloning using Rapid Clone and managing oracle instances.
• Expert in packages Oracle Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, Schema Manager. Working in environments constituting IAS, Oracle Self Service Web Applications, XML, Discoverer 10g.
• Working pro-actively with UNIX Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely passion.
• Worked On-call providing 24 7 365 days Support for production databases across organization.
• Worked with Off shore team as level 3 support and mentored them with training an knowledge transfer, was responsible for any escalations for the off shore team
• Dedicated, hard working individual with the interpersonal communications skills to work at all levels of the organization.
• Exceptional analytical and problem-solving skills. Work efficiently as a team or individually to achieve goals and objectives.

Confidential

Oracle DBA

Responsibilities:

• Been part of the Scope analysis for supply chain domain
• Collated the issues in the current version and requirements in the latest version
• Prepared AS IS and TO BE process documents.
• Performed all the setups for ABC Analysis.
• Interacted with Business System Analyst for requirement Gathering.
• Prepared Functional specification document and High level Design document.
• Exhibited good coordination with Technical team for Design and Development.
• Prepared Unit test plan and scripts for verifying the conversions
• Conversion and verification together done within the timelines.
• Worked on 11g OEM migration project with the team.
• Installation/Creating new databases.
• Worked on performance tuning, Supported on-call rotation, 11g OEM install/config Agents and deploying, used export import and Data Pump.
• Used RMAN Backups to refresh databases, Set up crontabs to automated jobs as required, Brief Advance Compression.
• Providing 24 7 supports for all production and non-production databases.
• Automated workarounds by creating baselines.
• Handling all day to day issues in production environment.
• Reorganizing the database: That is to eliminate excessive database fragmentation and to move data between different table spaces.
• Analyzing and providing solutions to performance problems of databases.
• Space maintenance across tablespaces and data files.
• Coordinate deployments with offshore DBAs

Confidential

Oracle DBA

Responsibilities:

• Requirements gathering for providing Offshore Support for various applications Oracle EBS 12.2.3, EBS 12.1.3, SOA, Oracle WebCentre, OBIEE, Oracle HTTP servers and etc.
• Driving Offshore teams based on Onsite DBA's requirements for Installations, Upgrades, Clonings, Patching, Code Migrations, Deployments and Issues troubleshooting.
• Performing Development servers maintenance activities like Server reboots through OVM, volumes mounts unmounts, Package Installations
• Successfully prepared and Documented first clone of Oracle EBS R12.2.3 Instance.
• Documents preparation as per Oracle Standards D0XXX
• Supporting Development teams for Code Deployments Procedures on R12.2.3 Instances.
• Applying Patches using adop on R12.2.3 and adpatch on R12.1.3
• Troubleshooting various issues of R12.2.3, R12.1.3 Instances
• Working with SA teams for new servers preparation and validations
• Performing Weekly filesystem level Snapshot Offline Backups for all non-prod servers.
• Configuring Load Balanced URL for Oracle EBS R12.1.3 and R12.2.3
• Installation of WebLogic Server 11gR1 and Oracle HTTP server
• Installation of Oracle SOA Suite 11.1.1.7
• Installation of Oracle Web Center Content Management WCC 11.1.1.7 and Oracle Web Center Portal WCP 11.1.1.7

Environment: Oracle EBS 12.2.3, Oracle EBS 12.1.3, Oracle Database 11.2.0.3, OAS 10.1.3.4, Web Logic 11gR1, SOA 11.1.1.7, Web Center, Oracle HTTP Server, OEM 12c, OVM, Operating System: RHEL 6/5.

Confidential

Oracle DBA

Responsibilities:

• Installed and maintained 3 Node 11g RAC and created database for production, development and test environment on Hp-Unix platform.
• 24 x 7 production support group member supported by our team.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using Net-backup.
• Involved in migrating single instance databases to RAC databases.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
• upgraded Databases from 10.2.0.4 and to 11.2.0.1
• Worked on ASM environment performed various tasks like creating disk group using ASMCA, adding a disk to disk group, making disk online/offline in disk group.
• Implemented data-guard for databases and maintained Data guard DR server and have good experienced in Trouble shooting issues in Data-guard Environment.
• Configured physical standby databases and converted snapshot standby database.
• Converting data files across different platform using RMAN convert, Transportable Tablespaces TTS , Export/Import and Data-pump expdp/impdp .
• Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.1 on Linux.
• Manage and maintain database and user security using OEM Grid Control.
• Documented backup and recovery plans and tuning procedures.
• Efficient in using the Oracle Tools like OEM, SQL Plus, SQL Loader, TKPROF, LOGMINER, STATSPACK, SQL Net, IMPORT/EXPORT, and RMAN.
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query perfoRMANce bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager OEM .
• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers. Writing backend procedures, functions, packages and triggers using PL/SQL.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing which are kept in CRONJOB

Environment: Oracle 10g/11g, Oracle 10g RAC, ASM, HP-UX 11, RHEL 5.8, Data Warehouse, OEM, SQL Loader, Grid Control, RMAN, ASM, Data guard, TOAD, Data pump.

Confidential

Oracle DBA

Responsibilities:

• Installed and maintained 3 Node 11g RAC and created database for production, development and test environment on Hp-Unix platform.
• 24 x 7 production support group member supported by our team.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using Net-backup.
• Involved in migrating single instance databases to RAC databases.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
• upgraded Databases from 10.2.0.4 and to 11.2.0.1
• Worked on ASM environment performed various tasks like creating disk group using ASMCA, adding a disk to disk group, making disk online/offline in disk group.
• Implemented data-guard for databases and maintained Data guard DR server and have good experienced in Trouble shooting issues in Data-guard Environment.
• Configured physical standby databases and converted snapshot standby database.
• Converting data files across different platform using RMAN convert, Transportable Tablespaces TTS , Export/Import and Data-pump expdp/impdp .
• Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.1 on Linux.
• Manage and maintain database and user security using OEM Grid Control.
• Documented backup and recovery plans and tuning procedures.
• Efficient in using the Oracle Tools like OEM, SQL Plus, SQL Loader, TKPROF, LOGMINER, STATSPACK, SQL Net, IMPORT/EXPORT, and RMAN.
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query perfoRMANce bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager OEM .
• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers. Writing backend procedures, functions, packages and triggers using PL/SQL.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing which are kept in CRONJOB

Environment: Oracle 10g/11g, Oracle 10g RAC, ASM, HP-UX 11, RHEL 5.8, Data Warehouse, OEM, SQL Loader, Grid Control, RMAN, ASM, Data guard, TOAD, Data pump.

Confidential

Oracle DBA

Responsibilities:

• Installed and maintained Oracle 11g/11gR2 databases having good exposure on Linux, HP-UX and Windows.
• Upgrade 10g to 11g and patching Oracle databases.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redologs.
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Monitor Oracle databases, server performance and capacity. Formulate and execute plans for resolving performance issues and meeting resource, growth/capacity demands.
• Investigate, diagnose, and quickly resolve database issues and problems in production and testing environments. Work closely with operations staff to quickly resolve production problems.
• Create, maintain, and test backup and recovery procedures for all databases.
• Install and configure database changes, builds and deployments in support of QA and production testing and release schedules.
• Managing users and resources, controlling user privileges, roles and auditing database use.
• Configuring the Dataguard set up for Disaster recovery.
• Database cloning for development and testing.
• Served as rotating on-call DBA in support of 24x7 operational databases.
• Creation and maintenance of users and roles.
• Monitoring user sessions using OEM 12c and TOAD. Worked with security team and generated audit reports.
• Supported backup and recovery using cold backup, hot backups, and flashback in 10g, written shell scripts for the UNIX environment.
• Worked on ASM redundancy levels, load rebalancing on RAC as well as standalone systems.
• Use of explain plans to tune SQL queries, building indexes to improve performance.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Gather table/schema stats on regular basis to improve performance.
• Analyzing and applying of quarterly security patches.
• Experience with Oracle Golden Gate software.
• Involved in setting up and Managing Disaster Recovery sites.
• Monitoring Smart Flash Cache Activity on Oracle Exadata.
• Configured various Oracle Exadata Database Machine.

Environment: Oracle 11g R2/11g, Oracle 10g 10.2.0.3/10.2.0.4 , SQL, PL/SQL, RMAN, Dataguard, OEM, 11g, 12c SQL Plus, TOAD, Solaris, RAC, HP-UX, LINUX, UNIX, Golden Gate, ASM, Exadata.