SUMMARY

• Having 10+ Years of IT experience in the field of Oracle Database Administration and Web logic & SOA Administration.
• Extensive experience in implementation, maintenance, installation, administration of Oracle databases 11g/10g/9i/8i running on various operating systems UNIX (Sun Solaris, HP - UX, AIX), RedHat Linux and Windows.
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)
• Solid experience on Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Extensive knowledge on Oracle Golden Gate
• Experience in usingoracle Goldengateto support data replication in the Oracle database environment.
• Performing DatabaseCloningin Oracle 9i, 10g and 11g usingRMAN.
• Extensive experience in Oracle 10g/11g Data guard Configuration and Maintaining Standby Databases.
• Extensively worked on RMAN Backup & Recovery strategies, expertise in Database Recovery.
• Strong experience in Backup and Recovery strategies using Export/Import, Datapump, Hot and Cold backups.
• Upgrading databases to higher versions, applying patches and patchsets.
• Expertise in Database Cloning, Database Duplications, Refreshes.
• Extensive knowledge on Database cross platform migrations
• Administration experience in Very Large Multi Terabyte Databases (VLDB) environments.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management, monitoring, scheduling jobs, UNIX Shell Scripting.
• Expertise in Oracle performance tuning using statspack, tkprof, explain plan, AWR, ADDM.
• Extensive knowledge and experience in Implementation of the DR, Capacity planning and Volumetric Analysis for DR databases.
• Extensive experience on Database Upgrades to Oracle 11g R2 from 9i/10g/11g
• Extensive Knowledge on BCP Planning and Disaster recovery BCP plan.
• Proficient in Shell scripting, extensively worked on automation. Developed various monitoring/analysis/health check scripts.
• Expertise in Critical Patch installation, Relinks.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Logical and Physical modeling using Erwin.
• Experience in understanding business requirements for analysis, detailed design, database design & development of applications.
• Experience in using REMEDY, Toad, OEM across enterprise
• Experience in all facets of the systems development lifecycle, from requirement development, design, testing, and post implementation revisions.
• Expertise in DBA support for 1000+ production, Staging, Dev, QA and test environments (24x7 On-Call Production support).

Areas of Expertise:

• RAC installation and implementation
• Oracle Database 9i/10g/11g Administration
• Data guard setup
• Hardware(H/W) & software(S/W) sizing
• Golden gate configuration and administration.
• Production Support
• ASM implementation and support

TECHNICAL SKILLS

Operating Systems: Sun Solaris/Linux/Unix/hp-ux, Windows NT, 98, XP

Databases: Oracle 11g/10g/9i.

Application/Web servers: Weblogic 10g/11g,apache,OHS

Database Tools & Utilities: Toad, OEM Grid Control, Oracle RMAN,SQL Loader,Datapump and OSWatcher

Fusion Middleware Technologies: OAM & OIM,SOA,ECM, Web center Portal.

Enterprise Tools: OEM Grid Control 11g

High Availability Technologies: Oracle RAC 10g/11gR2,Dataguard,Streams,Goldengate.

PROFESSIONAL EXPERIENCE

Confidential, TX

Oracle Database Administrator

Responsibilities:

• Architecture, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)
• Worked with customer for different RAC related issue: hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on
• Implemented and configured TAF policies for the fail-over mechanism and load balancing mechanism.
• Prepared and scheduled RMAN backups.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Implemented High availability using Golden Gate Replication.
• Actively working with other teams for Server Consolidation & Database Consolidation.
• Monitored the production Oracle alert logs for database errors.
• Monitored system resource availability and responded to system memory and data issues.
• Expert with OEM Grid Control.
• Worked with Data pump as part of schema refresh based on the requirement.
• Troubleshooting various db level errors.
• Working with Application teams on performance tuning issues.
• Working with Oracle on various bug fix issues.
• Analyzing the Database growth and doing periodic purging strategies.
• Planned and implementation partitioning mechanism for the large tables.
• Configured almost all Fusion Middleware products in standalone and High Availability mode with Web logic.

Confidential, CA

Oracle Database and Fusion Middleware Admin

Responsibilities:

• Installation of WebLogic Server, SOA and web tier (OHS), RCU and Database.
• Clustering SOA and resolving issues related to clustering.
• Upgraded weblogic,SOA,ADF from 11.1.1.5 to 11.1.1.7
• Performance tuning of JVM memory and Database connection.
• Backup strategies setup for Fusion components.
• DR setup strategy
• Pre & post go live support for Database and Fusion components.
• Monitored the production Oracle alert logs for database errors.
• Monitored system resource availability and responded to system memory and data issues.
• Expert with OEM Grid Control.

Confidential

Oracle Database and Fusion Middleware Admin

Responsibilities:

• RAC Database 11g setup with ASM as storage.
• Installation of SOA 11g with HA (clustering)using LBR successfully completed data centre migration activity which includes oracle application server 10g,Webcenter interaction 10g.
• Implemented Oracle Application Server 10.1.3.1.0 in Development, Test and Production environment.
• Implemented and Configure Aqua Logic Interaction 6.5 with Oracle Weblogic 10.0.
• Integrating BPEL, ESB, OWSM, work list with LDAP.
• Providing support to Development team in migrating application from Test to Production.
• Provide support to multiple environments, specifically, the Independent Test Facility, Verification & Validation, and Production systems.
• Ensure the effective daily operation of the production applications and provide administrative support for new implementations, upgrades, and migrations.
• Application administration like Creating user accounts, database extracts, position/responsibility administration, monitoring server tasks, etc.
• Middleware environment administration like migrations, tuning, administration.
• Perform Maintenance as needed
• Effective collaboration with infrastructure teams, application development teams, testing and release teams.
• Monitor the application systems for issues with disk space, CPU usage, memory problems or other issues that may impact the end-users.

Confidential

Oracle Database and Fusion Middleware Admin

Responsibilities:

• RAC Database 11g setup.
• Installation of SOA 11g with HA (clustering).
• Analysis of requirements for project and impact analysis.
• Installation & Weblogic patch upgrading, Domain Creation
• WebLogic Administration, Monitoring and Troubleshooting.

Confidential

Oracle Database Administrator

Responsibilities:

• Provision of 24*7 and for over 200 databases ranging from 10 GB - 20 TB.
• Working in 24x7 production environment and provided on-call and day-to-day support.
• Providing support to 3 RAC systems
• Active participation during RAC system outages and dealt with Service start/Stop activities.
• Working on stopping/starting CRS during outages and validating CRS status.
• Starting/Stopping ASM instances and worked on Space addition on ASM instance(New Diskgroup creation)
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Monthly Maintenance activity of Streams like starting and stopping streams process.
• House Keeping Activities like clearing space issues in OS level like trace files, Archive log files and Database level doing re-org on Tables for resetting High Water Mark.
• Monitoring and Maintenance of RMAN backups (Using RMAN Merge Feature).
• Performance tuning issues
• Data refresh includes Database level, Schema level, Table level.
• GRID Agent upgradation
• Database upgradation to 11g

Confidential

Oracle Database Administrator

Responsibilities:

• Administered and provided Development and production DBA support using OEM.
• Creation of databases on Different servers
• Implemented Database migration from Windows to Linux servers.
• Database cloning using RMAN from production server to Test server.
• Handled SOX Compliance on every Quarter.
• Monitoring daily, weekly and monthly Activities.
• Implemented RMAN Backup strategies.
• Production server support.
• Space management, user management support.