Lead Oracle Dba Resume
EXPERIENCE SUMMARY:
- Oracle Certified Professional with over 16 years of DBA implementation life cycle experience.
- During past 15 years I provided technical expertise for implementations of Oracle - centric technologies for Commercial and Federal Government clients.
- While Oracle Applications DBA work may be my core skill set, recent roles have enabled me to expand my knowledge in WebLogic, Java, Security and Enterprise solution design and implementation. This varied experience developed the team management and communication skills necessary to ensure successful solution delivery.
- My customer-first attitude enables me to make decisions that best fit client needs and strengthens customer relationships.
- I am consistently viewed as a “solution provider” who will learn new technologies that provide the most value to the customer.
- Expertise in installation, maintenance and administration of Oracle Applications R12 (12.1.3, 12.0.4,12.2.4), 11i (11.5.8, 11.5.9, 11.5.10.2)
- Implementation of SSO for EBS using OAM,OID
- Expertise in installation, maintenance and administration of Oracle Databases 8i, 9i, 10g and 11g
- Expertise in defining instance strategy for Upgrade and Implementation projects
- Expertise in Oracle Applications (Ebiz) 11i to R12 (12.1.3 and 12.2.4) upgrade.
- Strategized and carried out upgrades with minimal downtime
- Expertise in Oracle Application 11.5.9 to 11.5.10.2 upgrade
- Expertise in database upgrades 8i/9i to 11g, 10g to 11g
- Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite 11i and R12
- Expertise in Dataguard. Managed extensively large databases
- Expertise in Oracle 11g Grid control (OEM)
- Expertise in defining backup and Recovery strategy
- Experience in defining Archive and purge strategy for Oracle ERP systems
- Experience in OBIEE and Weblogic administration
- Experience in SQL, PL/SQL, UNIX scripting and oracle tools
- 24/7 Production Database Support and maintenance
- Experience in providing and mentoring DBA’s
WORK EXPERIENCE:
Confidential
Lead Oracle DBA
Responsibilities:
- Supporting 11i RAC enabled instances on IBM AIX and Linux platforms.
- Oracle Clusterware and Database patch set upgrade from 11.2.0.3 to 11.2.0.4
- Database and application character set conversation from ASCII to UTF8
- Provided guidance on upgrade of EBS 12.2.2 to 12.2.5
- Provided strategies for upgrading EBS 11i to 12.2.5 and platform migration from AIX to Linux
- Support for internal systems sunflower, Grants management system (G5), Hyperion, APEX
- Perform quarterly password changes
- Analysis and application of quarterly PSU and CPU patches
- Support11g Oracle Access Manager solution for Single-Sign On with two factor authentication using PIV card.
- Support different Oracle Fusion Middleware software including Hyperion, Cognos and Sunflower.
- Implementing SSL and renewing SSL s using Oracle Wallet Manager.
- Support Core DBA activities for non-EBS environments.
Confidential
Principal Analyst / Service Manager
Responsibilities:
- Analysis and application of mini pack, family pack and RUP patches
- Resolving performance issues related to month end processes and ASCP programs
- Upgrade of database from 11.2.0.2 to 11.2.0.4.
- Upgrade of Oracle apps from 11.5.10.2 to 12.2.4
- Implementation of SSO for EBS 12.2 using OAM,OID
- Support multiple E-Business Suite 12.1.3, Oracle Database 11.2.0.3 instances.
- Migrate new customers to Mercury Servers.
- Install and patch 11.1.1.6 Weblogic, OBIEE, BIPublisher, Apex with Apex Listener and Weblogic for new and existing customers.
- Advanced Oracle E-Business Suite Software and Database Administration.
- Database and Oracle E-Business Suite issue investigation/resolution.
- Responsible for Maintaining Oracle Applications Releases 11i & R12 for six of MTG customers.
- Support multiple Oracle Fusion Middleware Products like OBIEE, OAM/OID, Hyperion etc.
- Installing and supporting third party vendor software and integrating with Oracle e-Business Suite - Vertex, Leeyo, Revpro, Excel4Apps, More4Apps Etc.
- As Service Manager, have complete knowledge and history of the specific customer database issues and maintaining logs of the fixes applied for future and to support customer audits.
- Primary contact for escalated tickets for the assigned customers. Responsible to resolve the issues in a timely manner meeting the SLAs.
- Work closely with different infrastructure teams - Infrastructure, Solutions, and Administration - for completing the assigned tasks and meeting SLAs
- Involved in all the project analysis and preparation of the project documents for assigned customers.
- Providing support to multiple clients with production support issues on the service desk. Work closely with Oracle support on Severity 1 issues.
- Acknowledging, analyzing and resolving Production SYS down issues and providing clients with incident reports.
- Cloning, patching of multiple environments on demand basis.
Confidential, MD
Oracle DBA Specialist
Responsibilities:
- Worked as Oracle DBA Specialist with functions of 24 X 7 production support for multiple MMIS projects for the different States MI(CHAMPS), WA(Provider One),MD(Maryland),LA(Prism).
- Have successfully upgraded JDK software in around 25 Oracle EBS environments.
- Have completed upgrade of Production / DR / DEV EBusiness Suite environments from DB 9.2.0.3 to 10.2.0.4
- Have completed upgrade of Production / DR / DEV E-Business Suite environments from DB 10.2.0.4 to 11.2.0.2
- Have provided support in oracle e-Biz Suite R12.
- Administered and tuned the Oracle Claim processing system (e-CAMS) database and data warehouse system totaling more than 7 TB.
- Have been actively involved in setup of the Disaster Recovery site of the Washington State’s MMIS production applications and database. Have completed mock DR test for applications with complete success in restoring applications and database.
- Have worked on upgrading of 10TB DB.
- Responsible for administration of Oracle Applications and databases for production system and all project environments.
- 24*7 support to all the production EBS servers.
- Resolving issues in application printing upgrade installation of new features within the product and support.
- Application Management includes bug fixing, performance issues, change request management, upgrade and enhancement requests, including interfaces and report customization / development and patch application in existing live systems.
- Technical testing and application of patches as per functional team’s requirement and documentation of the same.
- Have worked extensively on various Oracle EBS testing including Load testing, stress testing activities while implementing new changes.
- Liaising with Oracle for TAR resolution
- Working with technical team to prepare fix for EBS related issues
- Have maintained excellent relationship with other vendors for all planned outages, issues and maintenance actions carried on the servers.
- Implemented, administered and subsequently tuned 5-7 TB databases for claims and fraud detection using Oracle RAC on Sun Platform, EMC disk array and Veritas File System. Was the production support DBA for multiple MMIS client.
- Tested the custom concurrent programs, request sets and forms in DBA1 and UAT1 instances and then moved these objects to production using FNDLOAD.
- Applied the required patches using auto patch and adctrl AD utilities.
- Rebuild the indexes and dropped unused indexes.
- Cloned the Application instance from production environment to Proxy environment.
Environment: Oracle Applications 11.5.10.2 / 10 g with 2 node setup. DR with Data guard solution.. OEM, TOAD 9, Sun Solaris 9/10 with SRM implementation, SQL and PL/SQL, R12 Implementation, R12 Support, JDK Upgrade, Application Management, Oracle RDBMS Production RAC Databases 10.2.0.4/11.2.0.3 of more than 10TB size.
Confidential
Senior Oracle Apps DBA
Responsibilities:
- Worked Part time for supporting multiple initiatives of Tango MC. Supporting the environments mostly on weekends and if needed on week-days.
- Installed and maintained different versions (11i/R12) of Oracle e-business suite databases to support Tango’s development efforts in building GIS application for various clients.
- Installed Linux OS and OS patches on new servers when the Systems administrator was not available to meet project deadlines.
- Planned and implemented backup strategy for OLTP/OLAP and e-Business suite databases.
- Created/managed Oracle spatial databases for various GIS clients of Tango MC.
- Managed Oracle Spatial databases for NAVTEQ on behalf of Tango MC.
- Imported NAVTEQ spatial data into Tango MC Databases as part of preparation for various POC.
- Build spatial databases for McDonald’s POC and also integrated Spatial data with Cognos Reporting tool. Worked closely with Cognos development team to accomplish the requirements.
- Upgraded oracle databases from 9.2.0.3 to 10.2.0.4
- Worked diligently with Development and Functional teams to identify and resolve performance issues.
- Installed and Configured Oracle Analytics - OBIEE.
- Installed/configured/implemented Oracle SiteHub on Oracle e-Biz suite R12 (12.2)
- Worked with functional leads and development team in understanding and supporting many adhoc requirements in developing various products like TMC Analytics Platform, TMC Market Optimization Solution etc.
- Providing 24X7 Production Support.
- Implemented security policies for all the databases as per the client requirements
- Provide maintenance and support of Apps 11.5.9/11.5.10 on Windows 2000/2003 environment.
- Administration of Development, Test and Demo instances.
- Cloned the Application instances.
- Performed Application administration tasks using System Administrator, Application Developer responsibilities and AD utilities.
- Applied the required patches using auto patch and adctrl AD utilities
- Gathered database/Objects statistics using DBMS UTILITY, Diagnostics Collections. (IZU).
- Created and monitored the Additional concurrent managers, Administration & Tuning.
- Defined users, Responsibilities, Menu, Form functions,
- Defined Executable, Concurrent Programs, Request Sets, Profile Settings
- Defined Value set and assigning them to Concurrent Program parameters.
- Enabling and Compiling Flex fields, Descriptive Flex fields to Capture additional data.
- Refresh the database from one environment to another.
- Monitored the Applications and database using OEM.
- Working with Oracle support on Severity 1 service requests.
- Involved in database activities space management, undo management and database security.
Environment: Oracle Applications 11.5.10.2 - R12 / 9i/10g/11g DB on Linux/Windows platform.
Confidential
Oracle Apps DBA / Lead
Responsibilities:
- Responsible for the IT facilities management team and datacenter operations.
- Provide maintenance and support of Apps 11.5.9/11.5.10 on Windows 2000/2003 environment.
- Administration of APPS PROD, UAT, QA, TEST and CRP instances.
- Providing 24X7 Production Support.
- Cloned the Application instance from production environment to Proxy environment
- Performed Application administration tasks using System Administrator, Application Developer responsibilities and AD utilities.
- Created and monitored the Additional concurrent managers, Administration & Tuning.
- Defined users, Responsibilities, Menu, Form functions,
- Defined Executables, Concurrent Programs, Request Sets, Profile Settings
- Defined Value set and assigning them to Concurrent Program parameters.
- Enabling and Compiling Flex fields, Descriptive Flex fields to Capture additional data.
- Refresh the database from production to test environment.
- Provide maintenance and support of Apps 11.5.9/11.5.10 on Windows 2000/2003 environment.
- Performed Application administration tasks using System Administrator, Application Developer responsibilities and AD utilities
Environment: Oracle Applications 11.5.10.2 with 9i DB on Windows 2003 platform.
Confidential
Sr. Consultant (Oracle ERP DBA)
Responsibilities:
- Administered and provided production DBA support to the several databases of Financial Data Warehouse and production OLTP databases.
- Tuned the databases resulting in a 10% performance improvement.
- Lead Production Support and Design DBA
- Upgraded databases from 9i to 10gR2
- Implemented security policies for all the databases as per the client requirements
- Provide maintenance and support of Apps 11.5.9/11.5.10 on Windows 2000/2003, Solaris, AIX environments.
- Administration of APPS PROD, UAT, QA and TEST instances.
- Cloned the Application instance from production environment to Proxy environment.
- Performed Application administration tasks using System Administrator, Application Developer responsibilities and AD utilities.
- Applied the required patches using auto patch and adctrl AD utilities
- Gathered database/Objects statistics using DBMS UTILITY, Diagnostics Collections (IZU).
- Defined users, Responsibilities, Menu, Form functions,
- Defined Executables, Concurrent Programs, Request Sets, Profile Settings
- Defined Value set and assigning them to Concurrent Program parameters.
- Enabling and Compiling Flex fields, Descriptive Flex fields to capture additional data.
- Refresh the database from production to test environment.
- Monitored the Applications and database using OEM and OAM.
- Setting up the printers in Application environment.
- Working with Oracle support on Severity 1 service requests.
- Examine the RMAN database backups as per the ODE policy.
- Rebuild the indexes and dropped unused indexes.
- Updating of Project track and issues log.
- Providing 24X7 Production Support.
- Gathered database/Objects statistics using DBMS UTILITY, Diagnostics Collections
- Working with Oracle support on Severity 1 service requests.
- Tested the custom concurrent programs, request sets and forms in DBA1 and UAT1 instances and then moved these objects to production using FNDLOAD.
- Providing 24X7 Production Support.
Confidential
Oracle DBA
Responsibilities:
- Supported production and Non-production instances of Oracle e-business Suite 11.5.7 and 11.5.8.
- Analyzing and applying Patches, addition of new modules and licensing.
- Used ad tools like adpatch, admerge, adsplice, autoconfig etc. Upgraded production database from 9.2.0.5 to 9.2.0.6.
- Implemented OATM
- Implemented Data guard for standby database.
- Refreshing the instances periodically from production & integration instances.
- Regular Database activities like space management, user management, exports & imports, troubleshooting database issues.
- Involved in resolving performance issues.
- Periodic analysis of indexes and tables in ERP reporting instance
- Installed and integrated 10G grid control to application instance.
Confidential
Oracle DBA
Responsibilities:
- Involved in 11i Installation and Cloning
- Workflow Mailer Configuration
- Involved in daily DB Activities like Instance Monitoring, Rollback Segment Monitoring, Fragmentation Monitoring, DB Upgrade, Object Sizing etc.
- Application Patch Analysis and Patch Application
- Concurrent Program Monitoring and Troubleshooting
- Discoverer Installation and Troubleshooting
- Express Server Installation and Troubleshooting.
- Demand Planning Installation, Troubleshooting and applying DP Patches
- Secured Socket Layer(SSL) Implementation
- Configuration of Printers
- Analysis and application of patches
- Analysis and application of NLS patches for Simplified Chinese Language
Confidential
Oracle DBA
Responsibilities:
- Involved in database activities space management, undo management and database security.
- Rebuild the indexes and dropped unused indexes.
- Supporting for Offshore team and monitoring AOL Standards as per Policy.
- Updating of Project track and issues log.
- Providing 24X7 Production Support.
- Backup the database
- Prepare the system for migration
- Execute migration scripts
- Listener and Net 8 configuration
- Execute post- install scripts
- Update, remove, add parameter in init SID.ora file
- Compile all objects
- Perform post-upgrade tasks
- Working with Oracle for Technical Assistance.
- Raised and worked in priority 1 issues.
- Worked on Oracle Application Performance
- Executed Backup and Recovery procedures.
- Installing and upgrading the Oracle server and application tools.
- Backing up and restoring the database.
- Allocating system storage and planning future storage requirements for the database system.
- Worked with developers, quality assurance, business analyst, and system engineer to ensure software quality, product excellence, and achieving the overall mission of keeping the Oracle 11i Application environment running smoothly.
- Set up of database environment. Creation of development instances with all schemas and security.
- Database reorganization and Database Storage management. Data extraction and monitoring.
- Creation of application objects such as tables, indexes, views, synonyms, sequences, triggers, procedures and functions with proper grants to all the users and roles. Partitioning tables and indexes.
- Coding and performance tuning for several Reports for Enterprise Reporting System using Oracle PL/SQL and SQL.
- Standby database creation, administration & maintenance of the size 350 GB database with 25 users
- Develop and test database backup and recovery strategy for both Hot and Cold backups.