SUMMARY

• A self - motivated team player with extensive 18 years of experience in Information Technology, handling various projects and responsibilities as Oracle Applications DBA, Oracle Database Administrator and also worked as a developer/programmer.
• Involved in all phases of the software development life cycle of software projects from the proposal phase through integration, installation, operations, and maintenance.
• Strengths in Customer Focus, Problem Solving, Detail OrientationSelf-motivation, Organizing, Prioritizing and Multi-tasking.

TECHNICAL SKILLS

Oracle Engineering Systems: Exadata X4,X3

Operating System: HP-UX, Sun Solaris, AIX, Linux, Windows2000/NT/95/98

Database: Oracle 11g, 10g, 9i, 8.1.x/8.0.x/7.x

Applications: Oracle Applications Release R12, 11.5.x/11.0.x/10.7, Oracle GoldenGate

Tools: DBArtisan, 12c, OEM, OAM, AD utilities, Quest Tools - Toad, Spotlight, stat5.6

Other Applications: Applimation, Weblogic, DB Extender - Subsetter & Optimizer

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Oracle Applications DBA

Responsibilities:

• Involved in planning, supporting, implementing and execution of R12 go live on Exadata.
• Consolidating and migrating all the oracle databases from other systems to Exadata
• Providing 24/7 on call support for all the Oracle related Applications and Databases in NA and LATAM regions.
• Providing support for Oracle Databases10g on Windows for France domain
• Patching Oracle Applications, Oracle Exadata and Oracle Databases
• Upgraded databases from 11.2.0.3 to 11.2.0.4
• Responsible for setting up DR systems for all the PROD environments in DR datacenter and participated in annual Disaster Recovery exercises
• Setting up cascaded DR for production systems in multiple locations for cloning and to minimize the load on the PROD database
• Involved in troubleshooting and tuning Oracle Application Month End jobs and export and import processes
• Monitoring Oracle Systems using 12c Grid on Exadata
• Upgraded Exadata Grid Infrastructure from 11.2.0.4 to 12.1.0.2 on X2
• Working on planning and implementing to upgrade and migrate 10g/11g Databases to 12c.
• Installed commvault agent on a VM and configured databases for backup using commvault to Exagrid

Confidential

Oracle DBA

Responsibilities:

• Used Oracle Golden Gate to replicate multiple databases from SunSolaris to Aix
• Implemented parallel extract, data pumps and replicats to divide the workload and to improve the performance.
• Implemented parallel replicats using key ranges on big tables to reduce the lag.
• Installed and configured 12c Grid Control
• Worked on multiple 10g/11g projects including upgrading and migrating from 9i 3 node RAC database to 10g/11g from Sun Solaris to AIX platform.
• Configured and setup Data Guard using RMAN on remote servers for 10g/11g databases.
• Installed and configured 11g OEM to monitor various 10g and 11g databases.
• Installed and configured 10g & 11g RAC multi node cluster.
• Worked on Database Security Administration, Audit Trails, and Oracle Alerts and Patch management.
• Worked on cloning databases using BCV technology from prod to QA and development environments.
• Installed and setup Oracle Golden Gate product to replicate from Sun Solaris to various 10g and 11g databases which are on AIX.
• Installed and configured Oracle GoldenGate Veridata agents.
• Worked on setting up Oracle GoldenGate extracts and replicats to replicate from Oracle 9i/Sun to Oracle 11g and 10g on AIX.
• Responsibilities include ongoing weekend and day to day activities like monitoring and applying patches and exp and imp of schema objects.
• Providing 24/7 on call support for production databases.
• Other activities include installing, cloning, patching CRS, ASM and RDBMS.

Confidential

Oracle DBA and Oracle Applications DBA

Responsibilities:

• Working as an Oracle Applications DBA in a 24/7 10g CRS 4 node RAC clusters on a Sun-Solaris with 8TB of database size.
• Managing and Supporting 40 RAC and non-rac QA and Development environments.
• Delivered major upgrade system on schedule with no interruption to production operations despite issues like hardware failures and oracle bugs.
• Assisting with the planning, reporting, implementation, and support for the project.
• Multitasking on various projects and tasks like cloning, installations and upgrades.
• Addressed cloning issues with custom applications.
• Involved in helping the development team in deploying the code in prod during various projects.
• Assisting in designing the logical data model and physical data model.
• Providing 24x7x365 Oracle database and applications support on a rotating schedule and support to the development, middle-tier, and test environments.
• Reviewing and implementing application releases into Production, Training, and Pre-production environments.
• Involved in building and implementing physical Data Guard (standby) and testing multiple DR systems for 11i and EPL environments using cascaded destinations.
• Monitor standby log application and syncing of application tier using rsync.
• Working proactively on researching latest 11i and database patches like CPU patches, RAC 10g CRS rollup patches.
• Responsible for installing and configuring Oracle 10g CRS
• Installed, configured and integrated 10G iAS Business Intelligence with 11i.
• Also supporting APS planning instance which is integrated in a distributed environment with 11i.
• And also supporting archive Applimation instances which are used for purging history data from 11i.
• Cloning and refreshing of E-Business Applications using Oracle Rapid Clone and NetApps Flex clone and custom automated procedures and cloning from RAC to non-rac development instances.
• Worked on various challenging projects like 10g upgrades and 9i upgrades and 11.5.10 upgrades
• Have experience in configuring Weblogic and also worked on Weblogic upgrade from 8.1 to 9.2 which is used for archiving and purging.
• Responsible for performing Oracle database tasks including installation, configuration, backup, recovery, and tuning.
• Worked on portioning workflow tables and rebuilding queues.
• Hands on experience in all ad utilities like adadmin etc.

Confidential

Lead Oracle DBA and Oracle Applications DBA

Responsibilities:

• Implemented and managed Instance Strategy for 11i EBS Cloning, Upgrades and patching to increase efficiency in handling the change management requests.
• Assisted QA team in improving and re-defining the process flows.
• Installed and configured custom applications like Markview to meet the Oracle Application AP module user’s expectations and business requirements.
• Provided support to almost over 10 Oracle Production databases on UNIX and NT.
• Managed strategic Backup and Restore procedures were implemented for 11i Production instance using SAN storage and business copy BCV storage architecture which is 1.6 TB of size.
• Analyzed database growth and proactively by implementing a repository strategy for the future segment and database growth analysis.
• Managing changes to all the database and Oracle Applications environments using the change management process.
• Identified High Water Mark Segments and did the re-org of segments in GL, INV and AR modules and rebuilt the corresponding indexes which significantly reduced the size of the database and increased the performance of the concurrent requests.
• Has lead and managed various projects from Initiation phase to controlling phases successfully to meet the stakeholder requirements.
• Configured and implemented iStore successfully by adding additional tier for the external customers to meet the client architecture and business security requirements using DMZ.
• Scheduling and Prioritizing concurrent jobs to resolve the conflicts like dead locks between on-line users and batch processing.
• Involved in database migration from 7.3.4 to 8.1.7 using export and import utilities.
• Successful execution of Database upgrades from 8.1.7.2 > 8.1.74 > 9.2.0.7
• Minimized or reduced Production downtime by proactively planning and executing the Oracle Applications 11i upgrade from 11.5.4 to 11.5.9
• Installed and configured 1159/9i on HP-UX with GSM and workflow java mailer with MLS/NLS for Brazil.
• Implemented EMC-Database Extender tools Subsetter and Optimizer - To reduce the database size of the target cloned instances used for development and testing environments and to increase the performance of the 11i Production database.
• Identified resources utilization and made recommendations to tune the OS kernel parameters and Oracle memory structures.
• Upgraded the application tier to 9iAS.
• Automated and handled all day to day Oracle Application and DBA technical maintenance related tasks.
• Installation and configuration of Oracle Fail Safe 3.3 on a 2 node Microsoft Cluster Server.

Confidential

Oracle Applications DBA

Responsibilities:

• Involved in supporting the client in a Post Production mode
• Involved in troubleshooting and configuring FSG reports
• Workflow administration
• Ongoing Backup and Recovery testing
• Daily backup validation via monitoring
• Applied patches for modules Purchasing and Project Management in a multi-tier environment
• Compiled invalid objects and generated messages, forms and reports using adadmin
• Cloned Test instances from Production
• Configured a test instance for the Multi Language implementation as they are going global by applying NLS patches.
• Performed Operational DBA activities like resizing datafiles and monitoring