SUMMARY:

• 6+ years of experience as an Oracle DBA setup, configuration, maintenance and implementation of databases working hands on with Oracle 10g, 11g, and 12c. 3+ years’ experience with Golden Gate including set up, replication, data mapping, filter, developing parameter file, configuring GG on RAC environment, installing Golden Gate director.
• Performed logical backups EXPDP/IMPDP and extensively used for re - hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Configured, implemented and managed active Data Guard, creating both logical and physical standby databases in 10g, 11g RAC and 12C environment for standby databases for fail-over purposes and for production databases of sizes ranging from 50GB to 5TB.
• Experienced installing OEM 12c Cloud Control, migrating databases to 12C from Oracle 10g&11g, upgrading the 11g management agents to 12c agents, and duplicating the database with RMAN and user-managed (hot/cold) backups.
• Worked on network data encryption to improve and apply security/PSU patches, validated database structure, and troubleshot failed component in upgrade process, upgraded ASM and RAC from 10g to 11g. Created Oracle Wallets, implemented tablespace level TDE security, and implemented SSL wallet to secure the connections.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c

Database Tools: OEM, SQL*Plus, Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Oracle Database Administrator

Responsibilities:

• Configure Oracle database vault, Enterprise user security, TDE. Experience with LDAP, OID, OVD, AD, RBAC, Kerberos, radius, Dataguise, DG Secure.
• Restore of scores of multi-terabyte backups from tape and logical export for on demand archival solution
• Large scale deployment of OEM cloud control. Experience with DBsmart monitoring and compliance tools, Netcool monitoring
• Goldengate configuration and monitoring through OEM cloud control

Confidential, Los Angeles, CA

Oracle Database Administrator

Responsibilities:

• Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EMGrid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
• GOLDENGATE setup, data mapping, filter, troubleshoot, developing parameter file. Live reporting. Configure Golden Gate in RAC environment. Install Golden Gate director, Conflict Detection and Resolution, Logdump.
• Usage of enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging, Redo Log reduction on GTTs using temp undo enabled.
• Resolved/Diagnose Node Eviction issues.
• EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Experienced in configuration of ASM for RAC and NON- RAC environments.
• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
• Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions and events within managed Databases.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Test backups periodically to ensure minimal recoverability time to meet business objectives.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Performed patching on Oracle Database Server 10g and 11g using O patch utility.
• Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc
• Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions. Implemented 11g Interval Partitioning for monthly partitioning of large tables.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Experience with Logical backups EXPDP/IMPDP and extensively used for re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11g RAC& 12C environment for the Production databases.
• Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.
• Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.
• Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
• Migration of databases to 12C from Oracle 10g&11g.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes. Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.
• Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Confidential, St. Louis, MO

Oracle Database Administrator

Responsibilities:

• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Proficient in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Provided 24X7 support for all the production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases. Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Confidential, Portland, OR

Jr. Database Administrator

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Migration of Oracle databases from windows to Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Proactive database monitoring using 10g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF. Memory Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups and performed backup validations using RMAN.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Performed other DBA activities like including space management and performance monitoring.
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Confidential, CA

Software QA Tester

Responsibilities:

• Provided testing services for software designed to prevent copyright infringement from illegal peer-to-peer activity using a variety of innovative techniques.

Field Technician/helpdesk

Responsibilities:

• Support pc systems and peripherals, LAN, WLAN, WLL installation and maintenance, C-band, Ku-band based broadband equipment deployment.