We provide IT Staff Augmentation Services!

Sr. Oracle Apps Dba Resume

0/5 (Submit Your Rating)

Milwaukee, WI

SUMMARY

  • Oracle Professional with 10 years of experience that includes developing, deploying, administration, and managing Databases in Production environments ranging in size up to 10TB on various platforms such as Solaris, Unix, AIX, Linux etc. Versions include 9i,10g,11g and 12c and Oracle Apps R12, 12.2.4 and 12.1.3 /11i.
  • Area of Expertise mainly includes Database support & maintenance, installation, configuration, administration, security management, memory management, backup, recovery, cloning, Golden Gate, up - gradation in RAC and Non RAC environments.
  • Installing oracle 10g, 11g,database and oracle applications 11i, R12.1 and R12.2.
  • Patching in 11i and R12.1 and 12.2 (adop) release .
  • Expert on AD utilities like adpatch, adadmin, adident and adctrl, etc.
  • Worked extensively on SYSADMIN tasks of oracle Applications 11i/R12.1/R12.2.
  • Good experience in cloning oracle apps 11i/R12 databases using Rapid Clone and also manual clone.
  • Expertise with Auto config tool in Apps to configure oracle Applications 11i and R12
  • Expertise in Database Backup & Recovery strategies.
  • Design, Implementation and support of Oracle 11g R2 Grid infrastructure with multi node RAC.
  • Expertise in Oracle Database Migration Activities (Across platform as well as same platform).
  • Oracle Upgrade from 11.2.0.1 to 11.2.0.4 to 12.1.0.1 - GRID Home, RDBMS Home and database.
  • Applying latest GI Patches for Grid infra & GI PSU’s for RDBMS home
  • Finding RCA (Root Cause Analysis) for Node Eviction, CRS reboots & other issues.
  • Database Refresh from PROD to DEV/QA/TEST servers using RMAN (Duplicate and Active Duplicate) and cloning.
  • Applied CPU, PSU patches and regular bug patches with Opatch utility as per the business requirement.
  • Implementing DR TESTING exercises for client requirement to maintain high availability for 10g/11g.
  • Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups and Created Unix Shell scripts to automate database operation.
  • Excellent in the use of the import to load data and performing exports as supplemental to daily hot, cold and RMAN backups to be used for database restore and recovery.
  • Extensive experience in Data Center Configuration and Migration from Linux to AIX.
  • Implementation of golden gate and replication using Unidirectional method.
  • Strong Experience in Database Performance Tuning.
  • Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
  • Creating the partitioned table using Range, hash, list partitioning.
  • Hands on experience in Installing, Migrating, Upgrading, Patching and Maintaining different oracle versions on HP-UX, UNIX, AIX, Linux and windows Platforms.
  • Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
  • Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g and 12c, Oracle Apps R12, 12.2.4 and 12.1.3 /11i

O/S LINUX Platforms: RHEL 6, 5.x, AIX 5.1, 5.2,6.0, Sun Solaris, HP-UX 10.x, 11.x & Windows 2003

Tools: Golden Gate, DBArtisan, TOAD, DB verify, RMAN, Export & Import, Data Pump, AWR, ADDR, Oracle Partitioning, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning, ASH, SQL Advisor, SQL* Loader, Clear case and Kintana High-Availability, Oracle BEA Web logic Oracle 10g RAC / Oracle 11g RAC and Data Guard / Active Data Guard

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Sr. Oracle Apps DBA

Responsibilities:

  • Manage and support 450+ Oracle databases.
  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Applying the application patched using ADOP with minimal down time by starting the patching cycle.
  • Adding nodes to EBS.
  • Taking the backup of databases using RMAN.
  • Performing the clones using RMAN.
  • Good Implementation knowledge in 12.2 and new feature like applying patches in 12.2 using ADOP and weblogic.
  • Patching in 11i, R12.1 and R12.2 releases.
  • Attended the regular issues related to database/environment.
  • Administration by using AD Utilities.
  • Database Refreshes (both hot and cold).
  • Cloning stage and test instances from production using Rapid Clone process.
  • Carrying out system maintenance and outages.
  • RDBMS patch application, Installed patch sets and upgraded Oracle (RDBMS).
  • Client installations in various environments.
  • Administration of We glogic.

Environment: ORACLE 10g/11g, Oracle 11g RAC, ASM, Oracle Apps R12, 12.2.4, Oracle Solaris 10, AIX 5.x,6.x, Windows, Golden Gate, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Oracle Partitioning, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning, Shell Scripting, Auto ys.

Confidential, Stamford, CT

Senior Oracle DBA

Responsibilities:

  • Working 24*7 along with DBA team to maintain & support more than 3000 Oracle Database in Production (RAC & NON RAAC), Test and Development Environment.
  • Worked on Shared Application tiers/ Shared Appl Top/ Distributed Appl top configurations..
  • Worked on Oracle Applications Cloning and Oracle Database Refreshes..
  • Performed upgrading the Oracle Applications Database from 10g to 11g..
  • Performed patch analysis and applied latest RUP Levels to be in line with the minimum baseline patch requirements for the extended support for Oracle E-Business Suite 11i.
  • Worked on troubleshooting various issues with Oracle E-Business suite as well as other third party applications of client.
  • Scheduled several cron jobs for alerts .
  • Working on RAC systems.
  • Performed Upgraded RAC Databases.

Environment: Oracle 11g/10g/9i Oracle 10g RAC and Oracle Apps R12, 12.2.4 and 12.1.3 /11ion LINUX Platforms RHEL 6, 5.x, Sun Solaris, Oracle Partitioning, RMAN, Data-Pump, RMAN, Golden Gate, OEM, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning, Auto sys

Confidential, NJ

Oracle DBA

Responsibilities:

  • Supported over 200 databases and over 75 Production databases which includes RAC databases.
  • Supported various Oracle Database for various applications viz., SAP, PeopleSoft, JD Edwards and other in-house application and various other Data Warehouse Applications at NBC Universal.
  • Applied Security Patches for DEV, QA, TEST and PROD.
  • Performed Cloning and database refreshes as and when requested by users.
  • Having good knowledge in UNIX shell scripting to prepare Database monitoring scripts and scheduling backups at scheduled intervals and various other jobs.
  • Back-up of database using Logical (Export and Import), Physical (Hot and cold) Backups and RMAN.
  • Performed performance tuning from time to time.
  • Creating the partitioned table using Range, hash, list partitioning.
  • Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose
  • Monitored the production Oracle alert logs for database errors.
  • Implemented and maintained database security (create and maintain users, roles and assign privileges).
  • Performed "trouble shooting" of the problems faced by Application Developers and End Users.
  • Coordinate and Monitored Application Outage Activities.
  • Created technical documentation and KT with the team.

Environment: Oracle 9i, 10g/11g with RAC, Oracle Data Guard, HP-UX 11i v3, Sun Solaris, RHEL 6.x, TOAD,RMANControl-M, Auto sys, DBArtisan, Aqua studio, DBA Pool-Analyzer, TKProf, Explain Plan, Automatic SQL Tuning.

Confidential

Oracle DBA

Responsibilities:

  • Managed and executed database change requests .
  • Handled database Refresh from production to development and support databases.
  • Performed Data transfer using Oracle transportable table space feature.
  • Involved in DBCC requests handling, batch job monitoring, database health checking, ensuring the database availability and monitoring the database.
  • Performed switch over activity.
  • Performed character set migration activity .
  • Monitoring Table space usage, Temp table space usage and undo table space usage.
  • Production Change controls.
  • Upgraded Oracle 9i databases to 10g.
  • Application of Quarterly release of Oracle Critical Patch Updates.
  • Table space Management and Re-orgs.
  • Performed schema refreshes from production to test & de using exp/imp and expdp/impdp.
  • Worked on scripts for creating new schemas, assigning roles and privileges.

Environment: Linux, Solaris and ORACLE 9i/10g/11g, Windows Server, TKProf, Explain Plan, Putty, Winscp and Toad.

Confidential

Corporate Librarian

Responsibilities:

  • Created users and gave specific roles and privileges.
  • Checkout sources for SCF’s in For Locking status .
  • Check in files in PVCS when SCF’s status is “For INT Promotion”.
  • Verify checksums of releases .
  • Promote SCF’s .
  • Promote sources to SIT.
  • Deploy & Test Build.
  • Make release note for all SCF’s being released by consolidating all release notes.
  • Upload EAR file to SIT server.

Environment: Solaris, Oracle 9i, PL/SQL, CVS and Oracle SQL Developer, WinScp and Putty.

We'd love your feedback!