PROFESSIONAL SUMMARY:

• A versatile, detailed - Oriented Oracle DBA professional with over 6 years of diligent experience in Oracle and 8 years in whole in the field of IT. I have supported the complete life cycle of the SDLC. I have worked on Oracle versions ranging from 9i, 10g, 11g and 12c. I have done database administration duties including production support, installation and configuration, database upgrades, patch management, database migration, backup and recovery, performance tuning, database cloning, golden gate and security management. I have supported customized Applications like HR, FIN and PEOPLESOFT HR / PEOPLESOFT FIN with on-call rotation.
• An Oracle DBA effective Confidential collaborating with other staff, supervisors and program directors. Self-motivated, patient and reliable with excellent oral and written communication skills. Conscientious staff bringing years of experience in the DBA field. Displays perseverance in the face of challenges.
• Have ample knowledge in implementing policies, procedures for disaster recovery and archival processing to ensure data protection.
• Experienced in Performance Monitoring tools like OEM, AWR report, DBMS PROFILER for troubleshooting some PL/SQL codes.
• High ability to analyse and understand the AWR reports and can fine tune the databases for maximum performance.
• Expertise in implementing partitioning methodologies (Range, List, Hash, Composite partitioning) on tables and INDEXES for high performance.
• Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, OEM GRID, SQL TRACE Utilities
• Experienced in Installation, configuration, Upgradation and applying Patches (CPU, PSU and Grid) to Oracle Databases and its related products on UNIX and Windows servers.
• Experienced in RAC, DATAGUARD and GOLDENGATE/ORACLE STREAMS configuration for high availability. Hands on deck with Golden Gate setup for 5+ years now. Managed the clustered environment for 5 years.
• Efficient in Database migration across 11g,12c databases, different platforms with the help of Golden Gate.
• Have profound Understanding of Oracle Architecture and have been involved in Creation, Migration, reorganization and connectivity configuration of Oracle Databases.
• Expertise in the creation of Data Guard database on different server, switching standby database mode to read-only, recovery mode and Snapshot Standby Database as well as shipping and applying archive logs from production to standby. (log gap scenario)
• Efficient in building catalog for RMAN repository and extensively worked on Backup & Recovery strategies using RMAN utilities, Logminer, Datapump and EXP/IMP.
• Efficient in building RMAN and User managed database cloning.
• Sound knowledge of logical backup export/import objects, tablespace and Confidential database level.
• Great understanding and experience in Oracle ASM concepts, administration and well experienced in ASM disk group creation and disk addition activities.
• Good shell scripting Skills and OS knowledge.
• Profound understanding of creation and Maintenance of DB objects. Tablespaces and datafiles.
• Handling user management, tablespace management and performance issues.
• Creating and refreshing materialized views.
• Good hands on deck with Oracle Software cloning to a different Unix Server
• Performance tuning tools consisting of, Explain Plan, iostat, sar, vmstat. Top and sql tuning of production databases and programs.
• Configured ORACLE ENTERPRISE MANAGER (OEM) Grid Control (11g, 10g) for monitoring multiple databases and application servers.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.

AREAS OF EXPERTISE:

Data Migration | Customer Service | Data Security | Business and Systems Analysis | Performance Tuning | Data Guard | 24/7 Production Support Capacity Monitoring | Backup and Recovery Administration | Database Creation and Configuration | Patching and Upgrade | Cloning and Refreshes | RAC | Golden gate for replication |

TECHNICAL ACUMEN:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, NX client, WinSCP.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

TWS Scheduler: ADF

APPLICATIONS: HR, FIN, PEOPLESOFT

PROFESSIONAL EXPERIENCE:

Confidential, DALLAS, TX

Oracle Database Administrator

Responsibilities:

• Conducted Oracle database administration tasks for customer, in charge of improving database performance, restoring, and implementing recovery processes while overseeing performance tuning and performing regular system backups.
• Administered operating system tuning by utilizing top command to see load average, CPU, memory, and Zombie processes; which includes database and applications through ASH, AWR, ADDM, EXPLAIN PLAN, TKPROF, SQL Trace.
• Expertly managed database creation and configuration through Database Configuration Assistance (DBUA) and scripts.
• Installing, upgrading and implementing quarterly patches on version 9i, 10g, 11g, 12c of more than 80 medium large-scale executions while supervising projects from business requirements analysis to delivery of support and solutions.
• Utilized data pump in performing numerous schema, object, and overall database refreshes.
• Organized tablespace threshold alerts and checks for password expiration using database and OEM grid control.
• Served as database administration (DBA) responsible for tablespace and database migrations across endian format utilizing RMAN for file conversion; database backup and recovery base on backup window and SLA through recovery manager (RMAN) and user manage; logical backups using data pump; and backup scheduling and job monitoring through crontab.
• Execution of standard auditing, fine grained auditing, and valued based auditing base on company SLA. Created users and expired their passwords when need be as well as delegating necessary roles and privileges.
• Proficiently used Transparent Data Encryption (TDE), Data Masking, and Data Redaction in implementing advanced security measures to restrict access to sensitive data.
• Made significant contributions in configuring GOLDENGATE for real time replication, DATAGUARD for disaster recovery, and RAC for scalability.
• Expert in SQL server DB Mirroring, Log shipping, Replication, Data migration
• Experience in Backup Recovery models for MS SQL server.
• Performed Tablespace Point in Time Recovery and RMAN Table point in time recovery.

Environment: Oracle 12c RAC, 11g RAC, 10g RAC, 9i, AIX, LINUX, OEM, Grid Control, RMAN, ASM, SQL server 2008/2012/2014 Windows XP/Vista/Win7.

Confidential, MINESSOTA, MN

Oracle Database Administrator

Responsibilities:

• Utilized explain plan and Oracle optimizer to improve SQL statements performance, handled and monitored tablespace and data files mount point growth.
• Conduct user requirements and troubleshooting activities and promptly addressed connectivity issues.
• Led the execution and maintenance of daily backup and archived data tape, while developing user accounts as well as system and user-level database objects.
• Experience in advanced primary database storage structures and objects, operating system security for database users.
• Tracked database instances and storage space for production environments and developed storage requests to UNIX groups.
• Provided significant contributions to a team that configured GOLDENGATE for real time replication and DATAGUARD for data disaster recovery.
• Observed RMAN backup operations and schedules as required, while controlling database and schema refresh from production to creation.
• Fulfilled on-call DBA functions every month and assisted end users on Oracle related issues.
• Utilized DDL scripts to define a table using Create or Alter command and DML scripts to modify table records using insert, update and delete statements to query databases.
• Performed general DBA tasks like user management, tablespace management, and security management of the databases.
• Performed general tasks like database patching, OEM Agent installations/patching.
• Involved in the data migration from Oracle 10g to 11g on both RAC and NON-RAC databases.
• Experienced in performance tuning of high volume databases using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ADDM. Also used OEM Grid Control to monitor the performance.
• Used import/export, Data pump to refresh databases, tables, schemas from production when requested by the application team.
• Monitoring disk space utilization, sizing and capacity planning.