We provide IT Staff Augmentation Services!

Lead Dba Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

PROFESSIONAL SUMMARY:

  • Over 12+ years of experience in Administration with expertise in Oracle APPS DBA, Oracle Database, RAC, Oracle Golden Gate, Data Guard, Exalogic, SOA admin, Fusion Middleware admin and Performance tuning.
  • Strong experience with building / administering 12c/11g RAC on ASM environments running on various OS platforms.
  • Expert on oracle ERP application upgrade/migration 11.5.10.2/R12.0.6 to R12.1.3/R12.2 on various platforms.
  • Having good experience in Oracle ERP patching in 11i,R12 and ADOP online patching on R12.2
  • Expert on R12.2 cloning on multi nodes while using dualfs and Add nodes on R12.2.
  • Having good expiries in R12,2 load balance configuration for High availability.
  • Expert on Parallel Concurrent Processing (PCP) Implementation for 11i, R12.1 and R12.2
  • Good experience in Oracle Application SYSADMIN Activities like Printer configuration, custom top creation etc.
  • Proficient on DMZ setup for external servers in EBS
  • Experience on Oracle Financials, Oracle Supply Chain, Oracle Payroll, CRM, HRMS, Indian Localization Rup patches
  • Proficient with all AD utilities (adconfig, adpatch, adlicmgr, adadmin, adsplice, adident, adctrl).
  • Installations and Configurations of Oracle EBS and Middleware products SOA, OBIEE, ODI, Web center portal, web center Content, OPA on single node and multi node on various Operating systems
  • Proficient in database design, development and configuration, performance monitoring and tweaking, back - end security, troubleshooting and support, data recovery and migration, and so much more.
  • Installations and configuration of IDM components (OIM,OAM,OAAM,OPAM and OID)
  • Installations and configuration of web gate and web tier for IDM integrations
  • Expert on Siebel installations and configurations, SRF and repository migrations.
  • Installing third party and oracle tools like Jira/Confluence, Bit bucket and Flexagaon and OATS
  • Expert on cluster installation/upgrade from 10g to 11g on HP-UX Itanium
  • Hands on experience on RAC to RAC clones and RAC to Non RAC clones.
  • Hands on experience Golden gate setup from oracle to no oracle databases.
  • Refresh for Golden gate databases from source to target.
  • Expert on fixing Golden gate LAG issues and replication issues.
  • Experience on migration from Solaris non RAC database to Linux RAC database with application services
  • Hands on experience cluster server issues and ASM related issues
  • Experience on work flow notification mailer configuration and troubleshooting
  • Proficient with database backup/restore methodologies including RMAN, hot and cold backups, export, import, data Pump
  • Ability to organize, prioritizes, and manages multiple workloads and projects with minimal supervision
  • Monitor and optimize the performance of Oracle Applications, FMW applications and the database as a unit and Day to day problem handling
  • Good understanding of Unix Operating systems & ability to drill down database performance issues associated with OS Commands/Tools for Identifying CPU/Memory/IO usage & bottlenecks
  • Expert in Code Migration and deployments
  • Experience in using TOAD, and Data Migrations using export/import, benchmarking using load testing tools.
  • Proficient in PL/SQL, SQL and UNIX Scripting.
  • Delivering Oracle Database performance tuning services for customers with EXPLAIN PLAN, TKPROG, SQL TRACE, ORADEBIG, 12c OEM Monitoring.
  • Good knowledge of performance views and command line skills to identify information about sessions, wait events, system performance.
  • Involved in tuning Applications for optimal response time using Optimizer Trace at various levels and events, and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Lead DBA

Responsibilities:

  • Providing productions support on ERP 12.2 and Middle ware applications.
  • Providing support on Middleware Applications(SOA/OSB,AIA,OSM,OBIEE),Siebel, BRM and Oracle ERP
  • Applying ADOP patches for product related issues
  • DR sync from production to standby databases
  • Applying Security vulnerabilities patches for oracle and Middleware products
  • Trouble shooting on ERP login issue and concurrent manager issues
  • Trouble shooting issues on Middleware applications during the deployments
  • Performance tuning of the database queries and application forms
  • Code deployments and migrations in oracle and Middleware applications
  • Patch analysis for ERP application, database, and Middle ware.
  • Applying CPU and PSU patches for all oracle databases, ERP and Middleware products
  • Monitoring Golden gate LAG and fixing LAG issues.
  • Refreshing GG databases from source to target while using exp/imp
  • Trouble shooting of WebLogic and deployment /Migration issues.
  • Performing health check reports daily on Applications and database side.
  • Monitoring DB availability /backups/ASM alerts through crontab jobs

Confidential, Carson City, NV

Sr. Oracle DBA

Responsibilities:

  • Installations and configurations of oracle products like EBS and FMW products like IDM, SOA, Web center, OPA, OBI, BIP,ODI and API Gateway on oracle Exalogic servers.
  • Upgrade EBS from R12.2.0 to R12.2.5 on Exalogic servers
  • Support on EBS, Middleware products and Siebel applications.
  • Recommending to fine tune the SQLs based on analysis of AWR reports and find the reason why it is slow and finding out the exact bottleneck causing performance issue.
  • Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
  • Performed FLASHBACK features to handle efficient database recovery
  • Integrations and deployments across the applications.
  • SMTP configuration for FMW products
  • SSL configuration for FMW products
  • Apply security CPU patches for oracle EBS and FMW products
  • Installation and configuration of IDM components (OIM,OAM,OAAM,OPAM and OID)
  • Installation and configuration of web gate and web tier for IDM integrations
  • Installation of oracle OPM, Jdeveloper, oracle database Clients, ODI studios for Developer operations
  • Trouble shooting application login issues and performance issues
  • Performed FLASHBACK features to handle efficient database recovery.
  • Fabricated multiple CLONING databases using manual method and RMAN utility
  • Good experience in applying Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches.
  • Extensively worked with NETSTAT, NET Manager and Ping Utility to resolve network problems
  • SRF migration on Siebel and Repository migration

Confidential, Los Angeles, CA

Sr. Oracle APPS DBA

Responsibilities:

  • Hands-on administrative experiences in migrations, health check, resource management, patching/upgrade and SQL tuning.
  • Clone from 11i Prod to Testing instance.
  • Apply 11i support patches in 11i node for R12 upgrade.
  • Upgrade from 11.5.10.2 to R12.2.4 with RPC patches on testing instances Like development, UAT, production systems as per client’s requirement on RAC databases.
  • PCP setup for concurrent managers.
  • Load balancer setup for the multiple application nodes
  • I-Supplier setup while using external servers
  • Performance tuning of the database queries and application forms
  • Trouble shooting the workflow manager configurations in all the environments
  • Troubleshooting the errors of OPP manager concurrent requests and various other concurrent requests.
  • Worked on building the shell scripting and OEM12c configuration for performing daily health checks of the system
  • Analysis and application of patches as and when required.
  • Clone from R12.2 instances to UAT and development environment.
  • ADD nodes on R12.2 cloned environment.
  • Configuration and implementing various RMAN Backup and Recovery using Catalog or control file
  • Configuration and implementing / Automating Data pump Backup jobs (Full DB, Schema Level, Table Level).
  • Frequently Cloning/Refresh Databases using RMAN, Data pump export and import utilities.
  • Configuring and performing Flashback, Restore point, Archive logs managing and Recovering Block-corruption using RMAN.
  • Performance tuning by Fine Tuning Initialization parameters, I/O, Memory, storage and Operating System kernel parameters, Oracle SQL, optimizer.
  • Capacity planning as per Data growth and work-load by working closely with other decision making Teams such as Development, Business / Clients.
  • Worked with Application Development and testing teams for new Project Builds and troubleshooting the performance issues for SQL.

Confidential, Boston, MA

Sr. Oracle APPS DBA

Responsibilities:

  • Installation of R12 application binaries & Designing / Creation / Upgradation of application from 11i to R12.1.3 for DEV & Production environments on LINUX servers.
  • Refreshing Databases from production to test and development using Export/Import, RMAN as well as traditional hot backup method for smaller databases.
  • Writing necessary Scripts for Startup and Shutdown, for Health Check of Databases and for Analyzing of Tables and Rebuilding of Indexes, for different type of Backups and to check ora errors in alert log file.
  • Designed, tested and implemented backup strategies using RMAN.
  • Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices
  • Prepared the instance strategy for R12.1.3 upgrade
  • Clone from production to development instances
  • Analysis of patches based on installed products in oracle applications.
  • Upgrade oracle application from 11.5.10.2 to 12.1.3 in CRP, SIT, UAT and MOCK instances.
  • Apply NLS patches for 12 countries
  • Code migration and deployment for CRPS and SIT instances
  • Document preparation with issues and solution for Go live
  • Preformed weekly backup for database and application tier in CRP and Testing instances.
  • Provided support and troubleshooting user tickets in CRP and Testing instance
  • Performed production upgrade without any DBA issues and performance issue within in the time line.

Confidential

Sr. Oracle APPS DBA

Responsibilities:

  • Perform daily maintenance tasks on Oracle databases such as monitoring of Alert log files and resolve issues, daily check on the application of archive logs.
  • Provided support and troubleshooting user tickets in CRP and SIT instances.
  • Analysis of patches based on installed product in oracle Application.
  • Upgrade oracle Application from 12.0.6 to 12.1.3 in CRP and SIT instances.
  • Applied HRMS and Canada payroll patches
  • Applied RPC patches on oracle Application 12.1.3
  • Code migration and deployment
  • Handed over the DBA Documents to sign off the project
  • Experience in Backup and Recovery using RMAN, hot and cold backups
  • Expertise in applying database CPU, PSU patches and Bundle patches.
  • Expertise in Oracle database Upgradation and Migration of database across platforms.
  • Monitoring and tuning the database queries of the application team, using Explain Plan and SQL Trace.
  • Worked on Production and reporting databases, helped the application team to get data from production to reporting as per the request.
  • Importing/ Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
  • Troubleshooting the alerts generated from the cron scripts, and try to rectifying them ASAP.

Confidential

Sr. Oracle APPS DBA

Responsibilities:

  • Provided support and troubleshooting user tickets in CRP and SIT instances.
  • Installed 10G CRS and ASM on new HP Itanium boxes
  • Created ASM disk groups for database restoration.
  • Restored 10g database from production to target machine
  • Implemented RAC services on both nodes(HP itanium boxes)
  • Upgraded 10G CRS /Database to 11G GRID/Database
  • Application Upgrade/Migration from HP-UX11.5.10.2 to R12.1.3 OEL6
  • Configured Active/Passive mode for High availability Application services
  • Prepared instance strategy for 11G Grid upgrade and R12.13 upgrade/migration
  • Created new development instance similar to production
  • Performed analysis for 11g GRID upgrade and Application upgrade/migration.
  • Performed upgrade from 10.2.0.4 CRS to 11.2.0.4 grid/database
  • Performed oracle application upgrade/migration from 11.5.10.2 to R12.1.3
  • Code migration and deployment
  • Prepared and handed over all the DBA related documents to sign-off the project.
  • Troubleshooting the alerts generated from the cron scripts, and try to rectifying them ASAP.

Confidential, Atlanta, GA

Oracle APPS DBA

Responsibilities:

  • Provided support (24*7) and troubleshooting user tickets in Production, Test and Development instances.
  • Worked on sysadmin activities
  • Performed RDBMS patches and CPU/PSU patches on RAC nodes
  • Trouble shooting on OC4J components issues and R12 application services
  • Preparing Pre Patch Analysis for Rollup and applications patches.
  • Worked on work flow related issue like SMTP and IMAP server issues
  • Worked with code migrations activities
  • Custom top creations and implementations
  • Configured SSO for OID and LDAP
  • Monitor alert logs, space and object growth related problems in the databases
  • Daily and weekly backups through RMAN
  • Performed with Oracle application adutilites (adadmin, adident, adctrl etc…)
  • Performed application patches using adpatch utility as per patch schedule determined.
  • Clone the instances using Rapid Clone for making the respective instance.
  • Experience in using autoconfig for Oracle application system maintenance.
  • Interact with the customer to understand their requirement and technical
  • Performed Up gradations 10g to 11g database and 11i to R12 applications.
  • Performed RAC clones quarterly
  • Trouble shooting on RAC instance issues

Confidential

Oracle APPS DBA

Responsibilities:

  • Monitored the status of services like concurrent manager, form server, web server, Application Listener, Database Listener etc.
  • Setup jinitiator in client side machine(solving yellow bar errors)
  • Troubleshoot on Apache, forms and CM server issues.
  • Troubleshoot day to day database and application providing the support, Maintain Applications file system like re-link applications programs, copy files to destinations, generate message files, generate product jar files, Generate form files, generate report files, and generate graphics files using adadmin utility, create applications environment file.
  • Creation of Control files, Redo Log files and Data files.
  • Cloning the database for development and test instance.
  • Backups and recover the data from the daily backups in case of any loss of data.
  • Provided the first level troubleshooting by regularly verifying database alert log files.
  • Interact with End Users to understand their technical queries related to database and provide assistance in resolving them.
  • Supported 24/7 oracle environment database, co-ordination with Oracle for TAR using meta-link.
  • Performed Installations, configurations and maintenance of Oracle 11.5.0.2 application on Linux 4.0
  • Performed core DBA activities like monitoring log files and space management.
  • Monitor the status of services like concurrent manager, form server, web server, Application Listener, Database Listener etc.
  • Sys admin activities like creating users and responsibilities and managing Concurrent managers and concurrent programs.
  • Interact with End Users to understand their technical queries related to database and provide assistance in resolving them.
  • Re-linked the executable using ad-admin and ad-relink
  • Analyzed and reduced patch downtime using pre-patch analysis and apply the patch using adpatch utility.
  • Experience in handling regular maintenance tasks like purging concurrent manager log files, Gather scheme statistics.

We'd love your feedback!