PROFESSIONAL SUMMARY:

• An Oracle Database Administrator with over 5 years of IT experience in Oracle (11gR2, 10gR2) 11gRAC, 10gRAC, installation, upgrade, designing, backup, recovery, migration and performance tuning.
• Experience in query optimization, cloning, patches, migration, troubleshooting, space management, and UNIX Shell Scripting.
• Independently built new 11g - 12c Databases from scratch on RHEL, OEL and Windows platforms from planning, testing through Release Management to validation
• Worked closely with support teams including Developers, SAS, Network, Backup, Storage, and Security.
• Experienced in Installation and Configuration of Oracle Primary and Standby (Data Guard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC
• Experience in multi-node and RAC environments including configuration of PCP.
• Experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode.
• Enabling Load Balancing in a Multi-Tier Architecture
• Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
• Implemented Data Guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Installed, patched, and upgraded Oracle 10/11g & 12c to support internal production and test environments.
• Evaluated Oracle 11gR2 Golden Gate for future purposes, reducing the complexity involved in Oracle Streams.
• Collaborated with Oracle my support by submitting Oracle SRs to resolve complex incidents.
• Strong interpersonal skills, enthusiasm for customer service, excellent communication skills, and the ability to work with customers, project managers, and staff of all different levels and skill sets to maximize availability in current and planned systems.
• Excellent experience as an Oracle DBA in various platforms such as Sun Solaris, Red Hat Linux, Windows etc.
• Planned, installed, configured, and performed upgrades of Oracle DBMS software on various platforms.
• Implementation of high availability solutions with Oracle 10g RAC, Physical Standby database, Data Guard, Materialized views
• Recovery of Databases from Media failure, Block Corruptions, User errors.
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and 11g OEM Grid Monitoring Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.
• Scheduling and Troubleshooting Database performance issues using Stats pack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Bulk loads and data migrations (using SQL*Loader, data pump import/export).
• Expert in RMAN backups including full, incremental and cumulative.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/DataPump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, Erwin.

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

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

Oracle DBA

Environment: Oracle 10g/11g, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.

Responsibilities:

• Installed, configured, and maintained Oracle
• 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Worked extensively with stored procedures, triggers, functions, packages, UNIX Shell scripting, Partitioning, and Indexes and excellent experience in installations, configurations, administration, and tuning of Oracle 10g, 11g, 12c and ASM for high available databases.
• Worked on administering 10 Production databases and more than 40 non production databases of size ranging from 10GB to 5 TB on Solaris/AIX/LINUX servers.
• Installed 11g/12c software and created databases in RAC and non RAC environments for new projects by interacting with multiple application teams.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Done migration of non ASM database to ASM database.
• Implemented, and configured 12C cloud control, agents and registered 11g/12c databases on SOLARIS servers.
• Worked on 11g Grid control and 12C Cloud control and intensively used for Diagnostic & tuning activities.
• Implemented Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Responsible for maintaining ORACLE 11gR2 using SRVCTL, OEM, maintaining Oracle Clusterware using CRSCTL
• Responsible for tuning of long running query’s by creating B-Tree and BITMAP indexes.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
• Effectively made use of PL/SQL features such as Bulk Collections/Exceptions/Inserts, Bulk Binding, Ref-Cursors, Multi Table inserts, SQL Types in Bulk Operations for better performance and readability, Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and TKPROF, SQL, PL/SQL and UNIX shell scripting.
• Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.
• Creating, maintaining, and tuning standby databases, disaster recovery using data guard.
• Implemented transparent data encryption (TDE). Used TDE with encrypted columns and data pump.
• Applied quarterly released CPU patches to update and security fixes to Oracle database 11g.
• Backup and recovery of the Oracle databases using RMAN and by logical backups using data pump.
• Provided sr. level technical expertise in system administration, application administration and automation using UNIX shell scripting.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, and ADDM to collect and maintain performance statistics and improves the database performance.
• Experienced in RAC Administration (11gR2) with ASM storage and backup and recovery using RMAN.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose and also fail-over and switch-over processes.
• Verifying, troubleshooting and fixing data corruptions
• Clone databases for development and testing from production.
• Setting up Golden Gate replication
• Using RAT(Real Application Testing) to Capture production work load and replay in a test system and SPA(SQL performance Analyzer) - to identify performance divergence between workloads on source and target platforms.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Confidential, Salt Lake City, UT

Oracle Database Administrator

Environment: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Responsibilities:

• Extensively used Oracle SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Worked on application and database security (data access, passwords, network, etc.).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases set up alarms for managing any exceptions in day to day management of the databases pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Database refreshes using EXPDP, IMPDP, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Backup/Recovery monitoring and reporting using Oracle RMAN.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.

Confidential, Herndon, VA

Oracle Database Administrator

Environment: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Responsibilities:

• Maintained backups for recovery using RMAN in tapes and disks.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
• Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities.
• Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.
• Modified and maintained database structures and views for the core system.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures.
• Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Cloned database for development needs
• Worked as Production Support for Oracle based systems and Unix based Server environments.
• Creating users and database links, snap shots on production and development servers.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Performed Backup and Recovery using RMAN
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.