SUMMARY:

­­­

• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
• Experience in Oracle (12c, 11g, 10g) Multi - tenancy, DataGuard, ASM, RAC database, Grid, OEM, CPU patches, Oracle installation, database Upgrades, Migration, Backup, Recovery, troubleshooting, SR (TAR) support, Golden Gate, configuring new & leas-rolling.
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Installed, configured, and maintained Oracle 10g and 11G on Linux and also Upgraded from Oracle 10g to 11g and 12c.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU)) using "runInstaller" and "opatch" utility .
• 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
• Collaborate with Oracle my support by submitting Oracle SRs to resolve complex incidents
• Automated routine DBA tasks like database backup and db stats by using Grid control /Crontab.
• Upgraded Oracle Databases from 10g to 11g and 10gRAC to 11gRAC.
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.
• Created RAC Database on Test Hosts refreshed them with the latest snapshot of data from Prod Environment. Recovering the database from Block corruption.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Experience in applying oracle patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer.
• Experience in database migration by designing and implementing database logical and physical storage structures.
• Performance Monitoring and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self-developed scripts, Oracle Enterprise Manager, Spotlight on Oracle, Toad, AWR, ADDM, ASH reports and Application tuning using Explain Plan, SQL Trace, Tkprof Utilities and statspack.
• Experience in optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
• Developed database support processes and automated tasks through tools, PL/SQL and UNIX Shell Scripting. Oracle SQL*Net, SQL, PL/SQL, writing triggers, functions and PL/SQL procedures, Functions, creating Tables, Views and Indexes.
• Expert in RMAN backups including full, incremental and cumulative.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.

TECHNICAL PROFICIENCIES:

­­­

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Tools: and Utilites RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer

RDBMS: Oracle 10g, 11g, 12c

Operating Systems: HP-UX 10.x, 11.x. Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

WORK EXPERIENCE:

Confidential, East Syracuse, NY

Oracle Database Administrator

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsibilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications
• Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC )
• Design and Maintaining Physical standby maintenance (Switch over - using Data Guard Broker).
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems.
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• 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 10G to 12c.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitored and trouble shooted database issues with OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Performed database recovery using GRP (Guarantee Restore Point)
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues. Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.
• 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.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)
• Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle.
• Experience in designing and configuring high-availability systems using DataGuard with physical standby effectively configured and used DataGuard Broker utility.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Performed logical backups using Export/Import and Data Pump
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction
• Performance Tuning of SQL statements and Database Tuning using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK, ADDM, AWR reports etc
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage. Debugging SQL tuning
• Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases
• Administered databases of various sizes from 5GB to 6TB
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.
• Preparation of High Level & Low Level Design documents.

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Confidential, Ann Arbor, MI

Oracle Database Administrator

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Worked on disaster recovery of dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• 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.
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
• 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.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN