Oracle core and applications DBA Resume Profile - Hire IT People (2024)

• Over Eight years of experience as an Oracle core and applications DBA providing 24/7 support for development and production 11g/10g databases Oracle Applications 11i/R12on UNIX/LINUX environments.
• Proficient in Installation, configuration and maintenance of 10g/11g RAC and standalone databases.
• Good experience on Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle Database and Application Tiers.
• Good hands on experience working on physical standby databases.
• Proficient in Database Administration activities such as installing, upgrades, patches, cloning,backup and recovery, performance tuning, script development, and documentation.
• Experience in platform migration from Sun Solaris to HP Linux using traditional export/import and datapump utilities
• Strong Experience in Cloning Patching Oracle 11i/R12 Instance using Rapid and manual cloning.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes database health check, automate RMAN backups, disk space availability, alert log errors, stats gathering etc.
• Experience with setting up of physical standby and resolving the physical standby database gap.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMANand knowledge of Golden gate.
• Proficient in Concurrent Manager Setup and trouble shooting.
• Experience in performing application's sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions, Profiles, Alerts.
• Expertise in performance-tuning, SQL tuning EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM, collect and maintain performance statistics and improve the database performance.
• implemented are General ledger GL , Account Payables AP , Account Receivables AR , Cash Management, Fixed Assets, Purchasing and gained expertise knowledge in the above modules.
• Good at Financial Statement Generator FSG Reports Architecture
• Has vendor specific objective evidence experience VSOE
• Involved in Post Production Support for Oracle Financials Modules
• Experience in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Expert in SQL Loader, export/import and data pump import to load data in to tables.
• Proficient in Installing, configuring and maintaining Oracle 11g Grid Control.
• Expert in writing UNIX shell scripts for DBA task automation and assisted Junior DBAs both on technical functional areas.
• Expert in understanding and resolving issues related to Capacity planning, Network configuration, Trouble shooting and Security Administration.
• Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
• Expertise in Tuning Applications, Memory, Disk usage, Space utilization, Oracle Security.
• Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator handle business service requests using Helpdesk Service Management/Call centre.
• Practical solutions to problem solving with creative ideas, identify patterns, linkages and underlying situations, consider customer needs in evaluation of solution.
• True team player maintain client/customer relationships by providing timely, superior quality products and services understanding of client/customer needs, opportunities and satisfaction criteria.
• Education: Bachelor of technology from Geetam university,Vizag, India.

Technical Skills:

PROFESSIONAL EXPERIENCE:

Confidential

• Monitor Production and Non-Production EBS R12.1.3 Application and 11.1.0.7 Databases on Oracle Enterprise Linux.
• Identify Performance intensive SQL Query and operations and suggest solution
• Storage and Capacity planning
• Work with Oracle support and Oracle On-Demand in Administrating the Databases and Applications
• Work in progress on Migrating Peoplesoft Databases from MS Windows to Linux Operating System
• Move Oracle EBS R12.1.3 and Database 11GR1 to Virtual Servers.
• Worked with Oracle support to resolve various issues with the database by opening SR's.
• Database recovering using RMAN backup and Applied Oracle Security and DST Patches.
• Worked in High Availability environment as VCS and VMware.
• Communication with Oracle support for identification of bugs and resolution for Service Requests.
• Experienced in troubleshooting any Oracle EBS R12 issues including performance, Work Flow, forms, reports and concurrent programs.
• Several missions related to e-commerce and ERP projects.
• Assist to choice of software solution, aid for system completion and process, interfacing with presented systems, configuration of the tools for analysis.
• Experience in Oracle Cluster Services on 10gR2/11gR2.
• Installed and configured Oracle Enterprise Manager 10G/11G Grid Control for Enterprise.
• Configured and managed physical standby database using Data Guard for disaster recovery on a different node for different production servers.
• Performed Data Guard switchover/failover as per the requirements.
• Created monitoring scripts to send alerts in case standby is out of sync.
• Configuring and Managing two nodes UNIX RAC environment for high availability, highly busy databases.
• Worked in Oracle 10g/11g RAC environment and troubleshooting for RAC issues.
• Worked on RAC/ASM interconnect issue.
• Worked with Developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Backup and recovery via RMAN scripts and troubleshooting.
• RMAN cloning of databases from source.
• Coordinated with Oracle functional analysts for gathering of business requirements to produce specification documents.
• Implemented procedures for coding and unit testing of application software regarding production support services.
• Executed processes for response and resolution of production support services through service level agreements.
• Assisted in designing and development of technical solutions as per defined requirements.
• Suggested enhancements and modifications to improve performance of Applications domain.
• Formulated procedures for code tuning, table review and application of indexes.
• Developed components such as reports, modifications, customizations, views and workflows.
• Provided 24/7 production support for infrastructure and performance areas.
• Performed the migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and Transportable tablespaces.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Upgraded and patched Oracle binaries in the development environment and production environment.
• Strong knowledge of Software Development Life Cycle SDLC as well as Testing Methodologies for EDI Specialist.
• Created reports Using Hyperion Financial Reporting, SmartView and Excel Add-ins.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Worked Extensively on Shared Services, Essbase applications 11.1.1.3. Performed weekly, monthly, and quarterly data loads and verifications.
• Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly budget data.
• Responsible for month-end tie-out and provide related support to financial controllers.
• Proficient with EDI translators, EDI and FTP standards, ANSI X12/EFIDACT and XML
• Comprehensive knowledge of EDI or EC Electronic Commerce systems
• Experience with data flow and object modeling, case analysis, workflow analysis and functional decomposition, customization, data migration, testing and training services involving the following Oracle EBS R12 and Oracle EBS 11i modules.

Environment: Oracle 10g/11g/ RAC/R12,Linux, Essbase Administration Services 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Shared Services 11.1.1.3, Hyperion Work Space, Windows 7, Oracle Enterprise Manager, Quest Toad , EDI,RMAN,OAF, Putty, AR,SQL Loader, sql Plus.

Confidential

• Upgraded 11.5.10.2 EBS Application to EBS R12 R12.1.3 on Linux OEL 5.6 and 6.1
• Manage EBS 11i and R12 Application on RAC
• Administer Oracle 11gR2, 4 Node RAC Production Database and Oracle EBS 11.5.10.2 on Oracle Enterprise OEL Linux 5.6 with EBS 11.5.10.2 Application.
• Administer RAC and non-RAC Test Instances on Oracle Enterprise OEL Linux 5.6.
• Clone RAC to RAC and RAC to non-RAC Database using active database RMAN duplication and cloned EBS Application.
• Installed and configured Grid Control 11gR1 and Agents to monitor several Oracle Instances.
• Cloned 11.2.0.2 Grid Infrastructure to create a new RAC.
• Upgraded out-of-place Oracle Grid Infrastructure and Oracle Database from 11.2.0.2.2 to 11.2.0.3.2
• Installed Oracle Unbreakable Linux 5.6 on 7 servers, Installed 11.2.0.2 Grid Infra Structure and 11.2.0.2 RDBMS SW on 4 Node RAC, Upgraded Oracle Database 10.2.0.4 from another Production Servers to the new Servers to Oracle 11.2.0.2. Configured 3 node EBS Middle Tier with PCP.
• Cloned Single Node Database with 10gR2 and EBS 11.5.10.2 to 2 Node RAC with 11gR2 and EBS 11.5.10.2.
• Installed, configured and administer Physical Data Guard with MAX Performance default mode on 10.2.0.4 Single node Oracle Database.
• Installed, configured and administer Physical Data Guard with MAX Performance default mode on 11.2.0.2 RAC Primary with EBS and Single Node Secondary/Standby.
• Recovered Database from block corruption
• Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.
• Educated and trained staff of assigned business areas on EDI applications. Developed and prepared EDI documentation for internal and external use.
• Conducted detailed review and analysis of requirements of external custom applications.
• Developed technical designs for conversion of Oracle EBS extensions utilizing OAF systems.
• Provided technical assistance for designing and development of technology solutions by translation of requirements into workable programs.
• Maintained detailed technical documentation during all phases of SDLC lifecycle.
• implemented procedures for coding, unit testing and conversion functions in Oracle development tools.
• Configured setups of iExpense, iSupplier iProcurement
• Setup employee user account, default expense account and expense report templates for iExpenses.
• Worked on integration of CE module with AR and AP module for reconciliation.
• Reconciling Bank Statements, Reconciliation Tolerances, Posting Amount differences within Tolerances, Changing the Reconciliation Status, Entering Reversals
• Bank Statement Error Reconciliation, Matching Bank Statement Lines with Transactions
• Worked on functional specifications and test scripts
• Provide implementation and post implementation functional support for the Oracle eBusiness Applications suite Oracle 11i.
• Prepared reports and related enhancements in Oracle projects.

Environment: Oracle 10g/11g, Solaris 5.6, HP-UX, Linux Red Hat , Windows, SQL, PL/SQL, SQL Plus,Procurement,Toad,OAF, EDI,Data Guard,Order management,SQL Navigator, SQL Developer.

Confidential

• Administer and Maintain 2 node RAC Production E-Business Suite 11.5.10.2 Application and 10gR2 10.2.0.4 Database, Data Guards and other Development, UAT and Test Instances on Linux OS.
• Administer and Maintain a Production, 11gR2 ImageDB databases that work with the EBS application and its Test Instances
• Administer and Maintain a Production Database for OBIEE and its Test Instances
• Configured nodes to be monitored from Grid Control
• Configured Data Guard Broker
• Handling Hot Backup of System Rollback Table spaces for reducing recovery time.
• Refreshing data from production to development and QA.
• Database tuning to resolve the contention if any using SQL Scripts.
• Database backup and recovery using Export/ Import.
• Tested and implemented the system and Trained end users.
• Created tables, views, indexes and sequences and database triggers.
• Managed and resolved design issues during development.
• proficiency and experience in a range of Hyperion products including Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial reporting, Smart View and Excel Add-In.
• Expertise in building Financial Budgeting and Forecasting OLAP applications with Essbase.
• Proficient in Designing and developing Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models Meta-Outlines across Block Storage BSO and Aggregate Storage ASO .
• Actively participated in team meetings with Business team for changes in design of the database.
• Involved in the logical and physical design of the database tables.
• Query Optimization using Explain plan and SQL trace with TKPROF.
• Sizing database objects for effective space management and optimal performance.
• Applying Patches with the help of Oracle Support and performing database recovery.
• Monitoring the space requirements for table spaces and adding of space.
• Database monitoring for deadlocked process.
• Worked with Oracle's CC B Customer Care and Billing Package.
• Trained new users on navigation of the CC B Package.
• Reviewed billing statements for accuracy.
• Wrote and ran SQL scripts for reports.
• Met with managers for CC B system review and modifications.
• Analyzed COBOL programs for enhancements.
• Created custom invoice reporting, revenue recognition and innovative collection procedures for the deployment of R12. Developed an integration plan for data from a legacy system, set-up invoices, debit and credit memos, customized dunning letter and the statement cycle in the accounts receivable module.

Environment: Solaris 5.6/5.9, Red Hat Linux, TOAD, Erwin, HyperionProducts,CC B,Data Guard,TKPROF, RAC, RMAN, Oracle 8i/9i, 10g. Oracle EBS R12,Procurement

Confidential

• Maintaining 2 Large Production Databases Terabyte Database : One with 6 Node, 10gR2 10.2.0.4 , RAC on Solaris for ATT Cingular Mobile , and the other one with 4 Node, 10gR2 10.2.0.4 , RAC on Solaris OS Platform for Belk
• Maintaining a 4 Node RAC Data Guard for the Production Database
• Maintaining 2 Medium size Production Single Node 10gR2 Databases on Solaris OS Platform
• Maintaining 12 QA and test Databases on Solaris, RHEL Linux 5 and AIX OS Platforms
• Installed 2 node 10gR2 10.2.0.4 RAC on RHEL Linux 5 OS Platform
• Created a 10gR2 Physical Standby Data Guard instance using RMAN backup.
• Export and Import Schemas and Full Database using Datapump
• Configured Netbackup client for RMAN Netbackup, backup and recovery for RHEL 5 Linux on a 2 node RAC 10gR2 10.2.0.4 Database
• Installed 2 node 11gR2 RAC Grid Infrastructure, ASM, Database on RHEL5 Linux Platform
• Standby Database Data Guard setup and configuration.
• Expert in creating clone/standby databases via Data guard for Database Disaster Recovery.
• Responsible for CPU and PSU patch management.
• Created Replication database, objects, groups and administered replication environment.
• I/O Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Tuned SGA, I/O Tuning, Identifying contention, waits and tuning.
• Extensively worked on Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Developed Shell Scripts for managing day-to-day activities and automation of backup.
• Backup and recovery strategy of Database using RMAN and scheduled manual backups to disks as well as tape drives.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, recovering data files, recovering from Block Corruption .
• Management of Control file, redo log, Undo and table partitioning Range, List methods.
• Expertise in design and development of conversion programs, interfaces and Trading Community Architecture TCA APIs to import data from legacy systems.
• Managed database security by implementing security policy, administering users and password files.
• Used export/import utilities and applied patches.
• proficiency and experience in a range of Hyperion products including Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial reporting, Smart View and Excel Add-In.
• Expertise in building Financial Budgeting and Forecasting OLAP applications with Essbase.
• Proficient in Designing and developing Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models Meta-Outlines across Block Storage BSO and Aggregate Storage ASO .
• Worked on PL/SQL packages, stored procedures, functions and triggers and assisted in generating reports using crystal reports.
• Led the implementation of the e-business tax module by performing a GAP analysis, gathering the requirements, overseeing the design, configuration and customization of the various components, data migration and providing testing, training and post go-live support.

Environment: Oracle 11g/10g ,RHEL5 Linux , SQL Trace, R12 GL, AP, AR and CMTKPROF,STATSPACK, export/import utilities, Data Guard, ASM, RAC, Toad

Confidential

• Maintained R12.0.6 Ebusiness Suite with Financials Module as the major functional application in HP-UX platform, version B.11.23 as an Application DBA and DBA for Production and 3 Test and QA instances.
• Day to day monitoring of Database using 10gR2 Database control and OEM Grid Control, monitoring of EBS Application using OAM, apply patches using adpatch, change configuration using context file and autoconfig, compile EBS objects using adadmin, clone database and EBS using RMAN, adpreclone and adcfgclone, help identify performance problems and help fix them, Monitor RMAN backup and check the usefulness of the backups.
• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Installed, configured and maintained Oracle 11g/10g/9i.
• Upgraded the database from oracle 9i to 10g.
• Real application cluster RAC 11g/10g managing nodes, node addition deletion and monitoring.
• Creating and maintaining services in RAC for best resources utilization and for high availability
• Implemented backup and recovery strategy and performed full, incremental and cumulative backup using RMAN.
• Implemented Replication of Oracle Databases using Logical Standby and Streams and Shareplex
• Installed configured Oracle 10g Enterprise Manager OEM grid control for monitoring of production development databases.
• Utilized ERWIN to ensure logical data models were mapped efficiently into physical data models.
• Wrote shell scripts for DBA's regarding the status, disk usage and performance of the database.
• 24x7 Oracle Production Database Administration including Oracle 10g/11g RAC.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Migrated databases from HP-UX to IBM-AIX.
• Designed solutions to enhance standard Oracle flows for order to cash, procure to pay, inventory, credit card transactions and GL accounting processes for this rapidly growing specialty retailer that handles over 3,000 transactions per day. Implemented automatic bank reconciliation functionality in CM and auto lock box functionality in AR.

Environment:

Oracle 10g/11g,HP-UX, Linux, Sun Solaris, Data Pump, Shell Scripting, Data Guard, RMAN, AR, Procurement,ASM, Oracle Enterprise Manager OEM , Toad.

Confidential

• Application DBA Maintained Oracle E-Business Suite 11i and R12 - Personalization, Patching, Compilation, Upgrade, Cloning, Performance tuning, Setup and administration.
• Installed, configured and Maintained Oracle E-Business Suite R12.0.1
• Implemented single node to multinode conversion of Oracle E-Business Suits 11.5.10.2
• Installed Oracle 11gR1 DB on RH Linux
• Configured RMAN 10gR2, 11g Data Guard and 10gR2 Grid Control
• Installed Oracle 10gR2, 2 node RAC, ASM and CRS on Linux and Solaris
• Involved in Oracle E-Business Suite 11.5.10.2 to R12.0.1 upgrade
• Tuned Oracle Ebusiness Suite listener load balancing, Java pool configuration, memory configuration, SQL tuning , Databases memory configuration, SQL Tuning, library cache performance problem , Middle Tier and Application for Performance using AWR, ADDM, Trace, tkprof, SQLTXPLAIN and other Oracle tools, Network Bandwidth tests using ping, traceroute, tnsping to find Network related problems.
• Installed and Configured Oracle databases on Sun Solaris and windows servers.
• Handling Hot Backup of System Rollback Table spaces for reducing recovery time.
• Refreshing data from production to development and QA.
• Database tuning to resolve the contention if any using SQL Scripts.
• Database backup and recovery using Export/ Import.
• Tested and implemented the system and Trained end users.
• Created tables, views, indexes and sequences and database triggers.
• Managed and resolved design issues during development.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Actively participated in team meetings with Business team for changes in design of the database.
• Configured various EBS server parameters to fine tune the application, configured to get Firefox working Linux client, co-ordinate work with developers to integrate and test custom code and custom objects in test and development instances.
• On Site Clients: GE Financials, Aetna Health Insurance, Aetna Specialty Pharmacy, Oracle Internals and others

Environment: Oracle11g/10g, Sun Solaris,Windows 2000, PL/SQL, SQL, SQL PLUS, SQL Loader,

AWR, ADDM, Trace, tkprof, SQLTXPLAIN, export/import.