We provide IT Staff Augmentation Services!

Sr. Apps Dba Resume

5.00/5 (Submit Your Rating)

PROFILE:

  • Having total 7+ years of experience in IT as Oracle DB administrator and 5 years as Oracle EBS.
  • Energetically visualize and Implement tactical initiatives in DBA role.
  • DB Core DB and HA Infrastructure Administration. Adopt Backup strategy
  • Administration and Disaster Recovery Process for Database Environment.
  • EBS Administration, Maintenance and Troubleshooting of EBS R12Administration Worked in Single and Multi Node Environment.

TECHNICAL SKILLS:

  • Oracle 9i/10g/11g/12c 10g /11g RAC & ASM 10g/11g Datagaurd
  • Oracle 11i/R12/R12.2 10g iAS LDAP, OID
  • 11g WLS 10g/11g/12c Grid Unix Scripting
  • Solaris/Linux/HP - UX AIX/Windows AWR,ASH,ADDM

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Apps DBA

Technology: R12,11g, Datagaurd, OBIEE, Peoplesoft 8.4

Platform: Linux

Responsibilities:

  • Working closely with Functional/ Technical and business operations team to ensure delivery of database/application services within the SLA's.
  • Installation and configuration of Oracle Application of Oracle EBS R12 on Linux server.
  • Create CUSTOM-TOP and assign the required responsibilities for application user.
  • User account management - creating users, disabling users, responsibility management.
  • Implementation of DMZ Configuration in EBS R12.1.
  • Workflow Mailer Configuration and Resolving Workflow issues.
  • Configured EBS DR for Single instance and Done the Switchover/DR Test.
  • Audit trail functionality.
  • Basic level administration skill for Peoplesoft application.
  • Expertise in Patch management, cloning, code migrations, release management etc.
  • OBIEE and Informatica Repository on Windows o/s.
  • Managing concurrent managers - ensure system is running smooth, monitoring throughput, watch for long runners.
  • Work with Oracle Support to provide technical assistance to users and troubleshoot and resolve application and database related problems.
  • Fixed the Leak Connections issue in Oracle Application.

Confidential

Oracle Consultant

Technology: R12,11i,11g,10g, Oracle Apex,11g Web logic (10.3),11g RAC & ASM, DG, 12c Grid

Platform: Linux

Responsibilities:

  • Responsible for administrating 11i/R12 Applications, Single instance/Cluster databases, Oracle ASM, 11g Weblogic and Physical & Snapshot standby database.
  • Applied one-off, mini and family pack patches in 12.1.3 applications using adpatch. And Periodical Applications Cloning and Database Refresh.
  • Installation and Configuration of Oracle E-Business Suite R12 on Linux for Development box.
  • Administrating OID, LDAP and SSO.
  • Performed R12 apps Clone of 8 nodes Apps Tier and 3 node DB Tier.
  • Upgraded Standalone Databases from 11.2.0.2 to 11.2.0.4 and Applied Database Bug fixing and security Patches using OPatch Untility.
  • Build 11g Physical Standby for Disaster Recovery.
  • Performed 10g iAS Infrastructure installation. And setup for Database using LDAP to OID.
  • Proficient in Oracle Weblogic server administration, setup and troubleshooting.
  • Oracle software installations using Binary Clone and Silent mode, Database creations, Managing Users, its Roles and security management.
  • Involved in Various third party application’s oracle Database upgrade, Cloning and Refresh like SAP and Peoplesoft application databases.
  • Good experience in working with large size Databases of 20 Terra Byte size.
  • Well versed with adadmin, adpatch, adrelink, adctrl.
  • Experience in forms, Apache load balancing, PCP for concurrent managers.
  • Exposure in RAC to NON-RAC and RAC to RAC DB cloning.
  • Troubleshooting all Oracle Apps Issues like Forms, Apache, Concurrent Managers.
  • Successfully done Oracle ASM diskgroup migration activity and Migrating an existing Non-ASM Database into ASM.
  • Knowledge in Shared Application Environment.
  • Successfully Migrate Database (10g-11g) from HP-UX server to Linux server.
  • Monitoring, Configuring All Databases, E-business Suite through OEM 12 cloud.

Confidential

System Analyst

Technology: 9i, 10g, 11g, RMAN

Platform: AIX, Linux

Responsibilities:

  • Performing daily health check on Oracle Databases.
  • Sending Database health checkup report to client.
  • Logical Backup using exp/imp and Data pump Utilities.
  • Users, Tablespace, Data Objects and Space Administration.
  • Analyzed AWR, ADDM and Explain Plan reports.
  • Scheduling the monitoring scripts in Cronjobs and Finding and releasing DB lock.
  • Writen/maintained OS level scripts for DB maintenance.
  • Applyed patches on oracle single instance databases using Opatch Utility.
  • Upgrade database from 11gR1 to 11gR2.
  • Installation and configuration of Oracle RDBMS Software using DBCA & manual method.
  • Regular database capacity planning related to database growth and system utilization, trend analysis, future database resource requirements.
  • Analyze problematic SQL quires and provide the better solution to Developers.

Confidential

Principal Infrastructure Engineer

Technology: 11g,10g, 10g/11gR2 RAC, RMAN, 11g Grid

Platform: Solaris, AIX and Linux

Responsibilities:

  • Responsible for administrating Single instance databases and 10g/11g RAC database instances.
  • Responsible for Database administration work like applying CPU patches, Interim patches for the single instance and 11g RAC.
  • Knowledge in setting up Application Load Balancing in RAC and Creating services using DBMS SERVICE
  • Installation of Oracle Binaries/Oracle Client and Database Creation.
  • Cluster database Node addition and Deletion and convert database from Single instance to RAC instance using manual and rconfig
  • Installed 11g Grid management repository and agent for Grid Control.
  • Successfully done database upgrade 11.1.0.7 to 11.2.0.2 .
  • Refreshed RAC to Non-RAC environment using RMAN.
  • Successfully implemented RMAN Backup and developed script
  • Schema Refresh using exp/imp and expdp/impdp utilities.
  • Successfully done cross platform migration using Transportable database.
  • Configuration of TSM with Oracle RMAN.

Confidential

Sr. Database Administrator

Technology: 11i,R12 9i,10g, 11g, 10g Physical Standby, 10g RMAN, 10g Grid

Platform: Solaris and AIX

Responsibilities:

  • Day-to-day 24x7 mission critical production supports (incident, service and change requests) .
  • Successfully done database upgrade 10g to 11gR1.
  • Successfully Migrate Database from Solaris server to AIX server.
  • Managing the daily / weekly scheduled jobs: Gathering statistics, Purging data etc.
  • Assisting End-Users and fix their issues.
  • Applied patches with adpatch and opatch utility for Prod and non-prod environments.
  • Installation and Configuration of Oracle E-Business Suite R12 on Linux for Development Sever.
  • Worked in Concurrent Manager and Long running concurrent request Issues.
  • Experience in Oracle Applications 11i/R12 - System Administrator responsibility (creating users, creating responsibilities, using profiles, registering forms, reports, concurrent requests).
  • Successfully performed database refresh in many Business Critical databases using Rman
  • Schema refresh using expdp/impdp with Transport Tablespace option.
  • Monitoring database using 10g Grid control during month end load and taken AWR, ASH, ADDM reports for analyze the performance issue.
  • Build 10g Physical Standby database and monitor Primary and Standby GAP.
  • Performed yearly once COB Test for all Production Database's using Switchover and Failover/ Flashback option.
  • Configuration of Netbackup with Oracle RMAN.
  • Reorg the tablespace and File system and reclaim the OS level space.
  • Monitoring and taking care of File system/Blocking sessions issues.

We'd love your feedback!