SUMMARY:

• I have over 5 years’ of hands - on experience as an Oracle Database Administrator. Extensively worked on Installing and configuring Oracle 10g, 11g, 12c. Duties also included Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security and auditing. Managed databases on AIX, Linux, UNIX and Windows environments. I have worked both as an individual contributor and as a member of a team.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Data guard - configure primary -standby using duplicate from active database command of 11g.
• Apply SCN-based Incremental backup to sync standby after loss of Archivelogs on primary.
• Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• GoldenGate - Involved in GoldenGate setup and monitoring. Hands on Troubleshooting replication errors & reading Trail files to identify replication issues. Performance/Latency test of GG. Hands on GoldenGate director experience.
• Write parameter files for EXTRACT/DATAPUMP/REPLICAT process to perform Replication/
• Transformation/exception handling.
• Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, AWR and also Cluster Interconnect Tuning (RAC)
• Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, AWR, ADDM.
• Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, SQL*Trace.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Experience as 24x7 productions DBA as well the application (development) database administrator.
• Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 10TB.
• Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).
• Experience with database backup, recovery, and setting up disaster recovery Database servers.
• Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc)
• Expertise in all the phases of System Development Life Cycle (SDLC).
• Experienced in working with DBVERIFY utility and other method to find Data Corruption.
• Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files. Allocating logical storage structures like tablespace, schema and extents as well as configuring Oracle databases on Multi-Threaded Servers Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN.
• 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.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/ troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, SQL Tuning Advisor, ASH, ADDM, SQL TRACE. Applying patches under UNIX platform.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Oracle Database Administrator

Responsibilities:

• Performed Replication using materialized views with a complete refresh/Fast refresh.
• Development of policy and procedures as they relate to database maintenance, security and archiving.
• Monitoring and maintaining 2 nodes RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using Crontab.
• Database refreshes using export /import and datapump.
• Used ADDM and AWR reports to monitor the database performance.
• Creating, granting and monitoring user access rights and privileges through roles and profiles.
• Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.
• Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TOAD and Oracle Enterprise Manager.
• 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.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• 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
• 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 (Red Hat Enterprise Linux) and setup table level replication as well as DDL replication too.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Golden Gate on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured OEM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g environments.
• 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.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.9.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and ASH SQL Trace & EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Confidential, St. Louis, MO

Oracle Production Support Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Setup data guard, create physical-standby database using hot backup. Troubleshoot errors on standby. Manually register archive logs.
• Setup & test backup on databases. Writing RMAN scripts embedded in shell scripts. Recover full database by applying archive and redo logs. Duplicate database by RMAN on remote host. Optimize backup on RAC.
• Imp/Exp used for load data into users on daily bases. Import schemas as part of recovery process in times of logical corruption. Export statistics from production to test.
• Created new databases/instances on 12c/11g 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
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, Disaster Recovery switchover testing.
• Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 10g databases to 11gR2 RAC.
• Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR, ADDM, ASH reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Scheduled UNIX scripts in Crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
• Migrated data to a new ASM Diskgroup to improve the I/O performance of the database.
• Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.
• Data aggregation and replication setup using Oracle Golden Gate and Materialized views for reporting.
• Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.