SUMMARY

• Over all 11 years of experience in Oracle working as a Sr Oracle Database Administrator, RAC Administration and also Application DBA on various platforms .
• Oracle Exadata, RAC Expert in Oracle database technologies aspect. Having expertise skill in Install, Configure, Upgrade, Migrate, Maintain and Support Oracle Databases, related tools and products on various Infrastructure platforms.
• Expertise in support Oracle Real Application Clusters and Oracle Exadata Machine environment includes cell nodes administration which is hosting critical applications of database environments for Investment Banks & Financial Institutions.
• Hands on experience in GlodenGate configuration and support.
• Hands on experience in configuration of Oracle Real Application Cluster 11g/10g/9i databases on Linux/Solaris Servers
• Hands on Experience in Oracle Real Application Cluster (RAC), ASM, Data Guard configurations, administration and troubleshooting.
• Have work exposure to third party Vendor High availability product such as VERITAS Cluster ware.
• Experienced in oracle clusterware patching, CRS & Voting disks backups and restore.
• Having hands on experience in Upgrade/Migrate Oracle Database from 8.0 to 9i, 10g,11g and 12c.
• Experienced in applying One - off patches, Patch sets, CPU/PSU Patches against Cluster and standalone database infrastructure.
• Experienced in Oracle binaries Home/Database refresh between prod and Uat/dev environments using cloning method.
• Hands on experience of database backups and Recovery strategies using RMAN, Hot Backup, Export, and Transportable Tablespace.
• Experienced in Capacity Planning, Configuration, Installation, Upgrades and High Availability (HA) solutions and & Backup & Recovery, performance tuning & Cloning.
• Expertise Confidential database administration activities such as monitoring database instances activity for blockers, waiting sessions, locks, dead locks, services start-up problems, Cluster management, connectivity problems, and max session reached errors etc…
• Interfacing wif Oracle technical teams for upgrades, versions and utilities.
• Proactive O/S, Applications & Database Maintenance & Monitoring.
• Create & Maintain UNIX Shell scripts and automating activities through shell scripting.
• Experience in Oracle E-Business Suite 11i, R12.1 and R12.2.
• Administration and management of Oracle E-Business suite which included patching using adpatch, rapid cloning using adpreclone.pl and adcfgclone.pl, schema password change using fndcpass, files version identification using adident, administration, compilation and re-linking application objects using adadmin etc.
• Upgrade 12.1.3 to 12.2.0 and 12.2.0 to 12.2.4 on linux and Sun OS.
• Installation of OEM grid control, configuration and installing agents on all database servers.
• Demantra installation and integration.
• Proficient in scheduling jobs, patches, alerting for databases, hosts and also database administration through OEM grid control.
• Expert in Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform
• Patch analysis, PAL creation and estimate downtime for teh patching
• Creating Custom Top, Responsibilities, menus, value sets, XML templates, data definitions and performing application sysadmin activities
• Performance Tuning using SQL Tuning Advisor, Statspack, ADDM and AWR report
• Configuring Work flow mailer and alerts
• Plan, test & implement teh database Backup & Recovery strategy depending on teh database size. Checking teh daily, weekly, monthly backup status
• Maintaining teh Technical document, Patch log and Activity log
• Creating and Managing Users, Responsibilities and Request Groups
• Planning for storage spaces requirements and placing them for optimum me/O performance
• Installation and administration of web tools like 10g Application Server, Oracle Internet Application Server (9iAS), weblogic, 10g OID, SSO, ODI and Oracle Portal.

TECHNICAL SKILLS

Operating Systems: Sun Solaris, RH Linux, Oracle Linux, IBM AIX

Database: Oracle 8i/9i/10g/11g, 12c, PostgreSQL, MongoDB

Database Administration: Oracle 8i/9i/10g/11g/12COracle EBS: Oracle E-Business Suite 11i, R12.1, 12.2

Other Administration: Fusion WebLogic 10g, 11g.

Database Tolls: Oracle RMAN, Export-Import, SQL Loader, TOAD, DBCA, Netca, ASM, RAC, TOAD, PLSQL Developer, GlodenGate, Sql Loader Utility, OEM Grid Control, NETCA.

Languages: PL/SQL, SQL*Plus, UNIX shell scripting, Unix CRON jobs.

PROFESSIONAL EXPERIENCE

Confidential - GA

Sr Oracle Database Administrator

Responsibilities:

• Provides high technical expertise for teh planning, analysis, design, development, implementation, maintenance and control of teh organization’s server-class databases.
• Participating and monitoring in stress tests.
• Identifying performance bottlenecks using AWR and ADDM reports and resolving them.
• Worked on SQL and PL/SQL tuning.
• Worked on Oracle 11g/12c Grid Control including monitoring/setup and performance tuning purposes.
• Creation, configuration and monitoring Shards sets. Analysis of teh data to be shared, choosing a shard Key to distribute data evenly.
• Identifying deadlocks and other lock contention issues during stress tests.
• Extensively involved in fine tuning home mortgage application SQL’s.
• Proactive tuning, suggesting recommendations to avoid performance problems.
• Extensively used EXPLAIN PLAN, Auto Trace and TKPROF for query refining.
• Analysis of Execution plans for each and every query for above application and recommending required Indexes, hints and partitioning to improve SQL query performance.
• Setup, configuration and installation of teh RAC environment and ASM.
• Developed multiple automation scripts using shell script
• Used Grid Control and OEM Tool to monitor Stress tests.
• Oracle Advanced features to resolve performance issues.
• Extensively worked on Partitioning to improve performance.
• Extensive noledge for PL/SQL programming.
• Performed POC for implementation of Oracle 11g new features.
• Architectural design for Gloden Gate Implementation.
• Participated in designing and development of software using agile development practices.
• Performed research and development tasks to design and implement new components
• Developed user interface (UI) and data analysis component wif integration of duplicate file finder
• Created automated diagnosis, testing and debugging modules
• Lead architect in data retention and data purging strategy.
• RMAN for backup and recovery.
• Dataguard for maintaining physical standby database.
• Exploring 12C database new features on local machine.

Environment: Oracle 10.2.0.4/11.2.0.3/11.2.0.4 , 12c Super Clusters RAC, Backup Scheduler, Linux/HP/AIX/Sun Solaris 9&10, Veritas Cluster, OEM/OEM Grid Control, Data guard,GlodenGate and RMAN.

Confidential, GA

Oracle Database Administrato

Responsibilities:

• Maintaining High availability Oracle Instances on Real Application Clusters wif high-end 24*7 support process.
• Monitoring critical errors such as locks, dead locks, services start-up problems, Cluster management, connectivity problems, and max session reached errors and etc…
• Participated in setting up of cron jobs for backup jobs, service monitoring alerts, disk space utilization threshold alerts.
• Monitoring Cluster Services, resources status using cluster server manager and teh logs of scheduled rman backup, export jobs and data load jobs.
• Configuration management and monitoring for database, application resources in HP Openview monitoring tool.
• Monitoring of cluster resources on RAC environment wif VERITAS cluster server manager.
• Participation in Change review board meetings and coordinating wif application support team and execution of change requests as per schedules.
• Documentation and maintain database, application standards, Fix teh issues and provide root cause analysis.
• Ensure Database RMAN, other backup operations happening smoothly all over enterprise environment.

Environment: Oracle 10.2.0.4/11.2.0.4 , Sun Solaris 9&10, SQL,PL/SQL,OEM/OEM Grid Control and RMAN.

Confidential

Oracle Database Administrator

Responsibilities:

• Responsible for issue resolutions participates in client meetings and presentation.
• Managed performance of team members, career, training and development planning.
• Facilitated goal and objective setting, promotions and performance reviews.
• Installation and Configuration of Oracle 11g R2 Real Application Clusters (RAC) databases on OEL 5.5
• Responsible for managing and supporting all Production, Development and Staging instances of Oracle Version 10g & 11g.
• Adding nodes to existing RAC environment.
• Cloning teh Oracle Applications from Production to Development servers.
• Performing Logical backups using Export and Expdp Utilities.
• Performing daily incremental backups, weekly backups using RMAN.
• Schema, Table, Database refreshes on demand for dev teams
• Cloning teh databases from Production to Test environment using Hot/cold/export/RMAN backups.
• User creation and providing necessary Roles, Privileges and quota as per teh requirement.
• Monitoring teh Table spaces and adding/resizing datafiles.
• Created indexes and rebuild indexes in order to improve query performance.
• Configured physical standby database (DATAGUARD) and tested for failover and switchover.
• Configured teh Cloned databases for reporting purpose.
• Generating AWR reports to monitor database health.
• Oracle Application patching 11i/R12(code level A,B)
• Oracle Database Patching.
• Create data source in SOA.
• Upgrading teh database from 9.2.0.6 version to 10.2.0.3 version
• Doing cross platform migration using Export/Import from Sun Solaris to Linux server.

Environment: Oracle 10.2.0.4/11.2.0.4 , Sun Solaris 9&10, SQL,PL/SQL,OEM/OEM Grid Control, Glodengate and RMAN.

Confidential, NJ

Oracle Database Administrator

Responsibilities:

• Managing and supporting Production, Development, Test databases (9.2.07, 9.2.05, 8.1.7.4) and Oracle Applications (12.1.3,11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2)
• Study existing Production environment and prepare an approach document for Migration.
• Participate in planning wif server management team to setup teh SAN storage devices multipath configurations that includes pre-requisites, kernel configuration, and installation of Oracle software, configuring public/private and virtual IP addresses required for multi instances.
• Implementation of multi node Oracle10g RAC production setup wif 5TB of SAN storage using Oracle ASM feature.
• Configured ocfs2 filesystem and Installed Oracle 9i RAC on RedHat Linux 4.0 using 9i cluster ware for Production systems across multiple environments.
• Plan and perform database migration of 1TB size wif minimal downtime.
• Prepared backup strategy for high availability systems and Implemented shell scripts to perform RMAN level0 and incremental backups as per policy.
• Create DR database site for production database and configure Standby database for high availability and for huge report activity.
• Perform and assist application team in testing Oracle Forms, Oracle Pro*C applications and backend SQL, PL/SQL code after migration and application bit conversion.

Environment: Oracle 10g/9i, RedHat Linux 4.0, SQL, PL/SQL and SQL*Loader.

Confidential

Oracle Database Adminstrator

Responsibilities:

• Installing R12 Oracle applications, cloning, patch analysis
• Experienced in oracle clusterware patching, CRS & Voting disks backups and restore.
• Having hands on experience in Upgrade/Migrate Oracle Database from 8.0 to 9i, 10g,11g and 12c.
• Experienced in applying One-off patches, Patch sets, CPU/PSU Patches against Cluster and standalone database infrastructure.
• Experienced in Oracle binaries Home/Database refresh between prod and uat/dev environments using cloning method.
• Hands on experience of database backups and Recovery strategies using RMAN, Hot Backup, Export, and Transportable Tablespace.
• Implementing Disaster recovery
• Implementing PCP and DMZ
• Oracle Application Database upgrade from 9.2.0.6 to 10.2.0.4
• Creating dblinks and resolving application issues faced by developers
• Monitoring database backups
• Production support
• Monitoring Standby database

Environment: Oracle 10.2.0.4/11.2.0.4 , Sun Solaris 9&10, SQL,PL/SQL,OEM/OEM Grid Control and RMAN.

Confidential

Oracle DBA

Responsibilities:

• Installed teh Oracle 8.1.7/9i on Linux, Windows NT and created teh Database.
• Regular performance of teh daily statistics report of various instances which halps in determining how efficiently teh shared memory is being used
• Database security by creating users, managing their roles and privileges.
• Create and manage Rollback Segments.
• Test plan preparation of different types of recovery scenarios
• Connecting to remote databases in districts using Telnet via aliases.
• Allocating system storage and planning for future storage requirements for teh databases.
• Responsible for regular backups
• Implemented standby database.
• Logical Backups by using export and import utilities and taking scheduled/unscheduled backup as per a backup plan using EXP, IMP and Hot backup strategy
• Managing Oracle Instance and Database, Managing Control, Redo log, data files and Tablespaces
• Backups- Logical and Physical for Multiple Instances
• Backup & crash/disaster Recovery Locally & Remotely.

Environment: Oracle 8i and 9i, SQL,PL/SQL and RMAN.