SUMMARY:

• An astute Oracle DBA with 7 years of IT experience in Oracle products both production and development environments.
• I have participated in a wide array of activities in support of multi - tier production and development environments which include the installation and configuration of Oracle RDBMS versions 9i, 10g, 11g on UNIX/Linux/Windows platforms, database administration, production support, installation, configuration, upgrades, patches, database security, troubleshooting database design,
• UNIX shell scripting, Backups and Recoveries, Data pump, Data Replication, Performance Tuning and OEM.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX,
• Red Hat Enterprise Linux (RHEL) and Windows on highly transitive and Very large databases (VLDB) and mission critical large OLTP, OLAP systems.
• Experience in configuring and managing Oracle Real Application Cluster databases with ASM technology.
• Installed and Configured the GoldenGate software and created manager, extract, replicate trail files and tested the data is flowing from source to target database.
• Technical expertise in Oracle DB implementations, maintenance, trouble shooting and administration.
• Excellent experience in Installation and configuration of Oracle 12c,11g, 10g, 9i, in UNIX/RHEL, Sun Solaris, AIX and Windows environment.
• Implementation and Administration of Oracle Data guard.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.
• Upgraded Databases from to 10g, 10gto 11gand 11g to 12c on various platforms.
• Established standby/cloned production database via Data Guard for Database Disaster Recovery
• Configuring and Administering Oracle 10g Automatic Storage Management (ASM).
• Working knowledge in Oracle GRID control (Oracle Enterprise Manager).
• Experience in applying Oracle PSU, CPU Patches on 9i, 10G and 11G.
• Experience in Patching Grid Infrastructure home.
• Experience includes Reorganization of database, monitoring tablespaces, indexes, extents and performance tuning.
• Exposure of working on OEM and Strong in Database Backups using RMAN, Export/Import, and Data pump, SQL Loader.
• Backup, Recovery and Cloning of databases using RMAN also profound in using the new Oracle 11g features in these utilities.
• Strong Experience in Cloning of databases using RMAN, VERITAS Net Backup.
• Creating and maintaining user accounts/profiles as well as well as managing security like Roles, Privileges and Passwords.
• Carried out logical backups using full/ partial export/import and Data Pump.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Oracle Exadata Administrator (Maintenances of Exadata System, installing Exadata software offline and rolling mode, bundle patching, performance tuning, exacheck processes, migration to
• Exadata (RMAN Restore, switchover, data broker, export/import dump, transportable tablespaces).
• Creating multiple Listeners for load balancing and using LSNRCTL to Manage Listeners.
• Co-ordinate with UNIX administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers.
• Worked on 24/7 environments, responsible for monitoring, upgrading, configuring, managing and troubling shooting over 300 oracle 10g and 11g databases.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11g, 10g,

OS: Linux, AIX, Solaris, Windows

Technologies: Data Guard, RAC, ASM, GoldenGate, Exadata

Tools: OEM, TOAD, RMAN, SQL Developer,

DB Utilities: SQL * Loader, exp/imp, Data Pump, RMAN, tkprof

Language: SQL, PL/SQL, Shell programming

Shell script: Shell Script (Bourne shell & Korn Shell)

PROFESSIONAL HISTORY:

Confidential, Sanjose, CA

ORACLE DBA

Responsibilities:

• Providing supports to mission critical databases running on 10g/11g RAC, Data Guard
• Planning and implementing database migration with Zero downtime from Oracle 11.2.0. 3 to 11.2.0.4
• Oracle grid infrastructure and database upgrade from 11g to 12c
• Streamline processes to improve database management and operation
• Installing and configuring Golden Gate for replication and high availability (HA) solution
• Installation of Oracle databases Oracle 11g R2 Grid Infrastructure: RAC and Oracle Restart architecture.
• Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/ instances on 12c/11g/10g RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Configuration of Maximum High Availability features like DataGurad, Flashback, LogMinor for Non RAC / RAC database, monitoring and au tomation of switchover and fail over.
• Configuration of network for High availability and Transparent Application Fail over (TAF) features.
• Planning and implementation RMAN backups using NetBackup and conducted / tested the disaster recovery for Single inst ance and RAC databases.
• Set-up and execute database performance benchmarks
• Implement best practice examples for Oracle RAC, ASM and Data Guard operational procedures

Environment: Oracle 11gR2, Streams Replication, DB2, RAC, Golden Gate, RMAN, ASM, Data Pump, Shell Scripting, Red Hat Linux 5.5, Toad, Putty, Oracle Enterprise Manager, Grid Control, SQL*Loader

Confidential, Forster City, CA

ORACLE DATABASE ADMINISTRATOR

Responsibilities:

• Assisted in management and database administration of OEM 12c on Oracle Database Appliance (X5­2).
• Managed more than 1500+ databases on OEM 12c like scheduling backups, reports, administrative & maintenance tasks.
• Managing ODA using various command like utilities like oakcli, iloms, dmidecode, odachk etc.
• Managed Oracle Enterprise Manager with 6­OMSs on 2­node repository (ODA).
• Have experience managing ServiceNow ticketing system.
• Upgraded various databases from 11g to single node 12c on ASM.
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security.
• Installed Data Guard standby databases and performed disaster recovery testing.
• Monitored and optimized performance, resources, availability, and operation of all systems.
• Involved in a data center migration of 18 TB EDW databases using ASM disk rebalancing and Data Guard.
• Resolved/Diagnose Node Eviction on ODA.
• Implemented Flashback and Guaranteed restore point on Physical Standby database to active the standby database into READ WRITE mode for testing using snapshot standby feature.
• Setup Heterogeneous DB links using ODBC connectors from various sources to oracle database(s).
• Installed, Configured and Supported Oracle 11gR2 databases on various platforms (SOLARIS, IBM­AIX, HP­UX 64 bit and LINUX AS 5).
• Implemented ASR to trap alerts from the database machine to send an alert to oracle support and OEM12c Ops Center.
• Hands on Experience in Installing / managing 11g ACTIVE DATAGUARD and Offloading Backups and Reporting queries to Active DR Site.
• Implement RMAN full and incremental backups to schedule for off working hours for all Production, UAT and Development Databases.
• Worked extensively on TSPITR, CLONING database using RMAN.
• Experience working with Oracle Enterprise Manager, working with ASH, AWR reports, ADDM, STATSPACK and gathering statistics.
• Experience in using packages like JOBS, DBMS DBMS SCHEDULER to schedule tasks and used DBMS STATS to gather the statistics.
• Upgraded OEM Cloud Control and all server agents from 12.1.0.2 to 12.1.0.3.
• Configured Server Load Balancer for OEM 12c.
• Worked on deploying and upgrading different plugins for OEM 12c.
• Implemented Stored procedures for truncating and triggers for auditing purpose.
• Excellent working experience on EMC, NetApp and ASM Storage technologies.

Environment: Oracle 10g/11g/12c, AIX, RHEL 5.x/6.x, TSM, RMAN, ODA, RAC, Active Data Guard, OEM 12c, AWR/ADDM, Unix Shell Programming, TOAD 12, PL/SQL Developer, SQL Developer, Stored Procedures, Triggers

Confidential, Chicago, IL.

ORACLE DATABASE ADMINISTRATOR

Responsibilities:

• Supported as 24X7 production/development DBA to 25+ databases on 10 different servers with 2 TB in size.
• Installation and configuration of Oracle Database Software 11g.
• Involved in the project implementing and configuring Real Application Clusters (RAC) on Oracle 11g on different nodes using ASM.
• Setting up new environments (Development, Production etc.).
• Performed Cloning for Oracle 10g databases to transport it to different machine, from development to testing environment applied patches using Opatch when required.
• Upgrading database from Oracle version 9i and 10g to 11g and migration of data.
• Involved in logical backup using and full/ partial export/import and DataPump.
• Developed and maintained logical schema, physical records, and SQL queries for Oracle applications 9i databases.
• Executed compound based and deterministic based masking using Oracle Data Masking Pack for transferring the data from production databases to less secured test and development databases.
• Data Migration (from 10.2.0.4 to 11.2.0.3) on AIX 4.3, which is made on a UNIX platform.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).
• Installation and configuration of Statspack and analysis of Statspack.
• Installed and Configured OEM, OEM Grid Control and OEM agents for 10g and 11g databases.
• Performance report and subsequent tuning, monitoring of production database.
• Setting up Physical Standby Database environment using Data Guard in 9i/10g/11g in NoData Divergence mode.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
• Prepared documentation for ongoing support, Documented backup and recovery plans and tuning procedures.
• Worked on scheduling DB down times for maintenance and promoting new builds, monitoring the batch loads and provided 24x7 support. Moved data from production to test & development environments.
• Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.

Environment: Oracle 11g/10g/9i, AIX 6.1, HP UX 11i v2, HP 9000, Windows NT 4.0, OEM Grid Control, LDAP, RMAN, TkPROF, LDAP, RHEL (Red Hat Enterprise Linux) v4.5.

Confidential

Jr. Oracle DBA

Responsibilities:

• Handled database size of more than 8TB.
• Managed and maintained the Oracle 10g/11gRAC OLTP Production, Pre­Production and Development Databases on Linux Platforms.
• Configured, Maintained and monitored the Physical standby databases, also enabled Active Data Guard for reporting tools.
• Migrated 10g databases from Non­ASM to ASM file system and later upgrading them to 11g.
• Configured and monitored Oracle 10g Grid control.
• Provided full technical support to various application teams before the databases go to Production.
• Experience in interaction with the top management and escalations of the complex issues.
• Performed entries capacity planning required creating and maintaining the databases.
• Used Triggers for database activities, like delete, update and users log on.
• Allocated the system storage and planned future storage requirements for the production database system.
• Done the Migration Review required before the database migration and QA after the database is migrated.
• Maintained the RMAN repository and customized recovery catalog.
• Worked with BI/Cognos team to tune various ad­hoc queries in the data warehouse environment.
• Created Partitions, materialized views, indexes, undo & temp spaces in the ware house environment.
• Creation of Users and Granting them privileges and roles.
• Maintained table and index Partitions.
• Implemented High availability using GoldenGate Replication, Implanted Bi­directional replication using GoldenGate.
• Hands on experience in Data warehouse databases.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization using cost based optimizers.
• Performed sql tuning using EXPLAIN PLAN, SQLTXPLAIN, SQL ADVISOR, ADDM and AWR reports.
• Proactive database monitoring using 11g grid control.
• Performed logical and Physical data modeling using Erwin tool.
• Used different oracle trace events for performance tuning.
• Responsible for conducting weekly meeting, tele/video conference with clients, development teams both onsite as well as offshore.

Environment: Oracle 10g/11g, SUSE 10, RMAN, RAC, Active Data Guard, OEM, AWR/ADDM, UNIX Shell Programming, GoldenGate, TOAD 10, PL/SQL Developer