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 DBATechnology: 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 ConsultantTechnology: 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 AnalystTechnology: 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 EngineerTechnology: 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 AdministratorTechnology: 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.