SUMMARY:

• A more than 9 years’ experience Oracle DBA seek s to a long - term career as an Oracle DBA, Golden G ate Administrator to utilize solid and professional skills in Oracle database, Go l denGate, RAC/ASM, Data Guard, Exadata, Unix/Linux, and shell scripts.
• More than 9 years’ experiences in Unix-like system administration (including Solaris / IBM AIX / HP-UX / Linux). Proficient in developing management scripts by using Korn/Bash Shell.
• 8 years’ solid hands-on experiences and outstanding troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g/11g RAC / ASM / Data Guard environments.
• More than 7 years’ experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate in Oracle to Oracle environment.
• 4 years’ first-hand administrative experiences in Oracle Exadata database machine (include X4/X5 full rack) administration, migration, health check, resource management, patching/upgrade, and SQL tuning.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full / incremental backup.
• More than 9 years’ experiences in PL/SQL, Procedure, Functions, Triggers, Packages development in applications such as Financial, Telecom fields.
• Excellent English writing, verbal and communication skills. Strong team player and can work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS:

Hardware / Server: Oracle X4 /X5 full rack Exadata machine

Operating System: Oracle / Red hat Linux, HP-UX, Solaris, Windows, IBM AIX

RDBMS: Oracle 10g to 12c(RAC/ASM).

Languages: SQL, PL/SQL, Unix Shell Scripting(Bash/Korn) and Python

Data Replication: Oracle Golden Gate 11gr2/12c, Export/Import, Data Pump

Tools: / Utilities: EXPDP/IMPDP, AWR/ASH, OEM 11g/12c, RMAN, Logdump, SPM, SQL*Loader.

PROFESSIONAL EXPERIENCE:

Confidential, Bryan, TX

Oracle DBA & GoldenGate Administrator

Responsibilities:

• Involved in upgrade/migration of databases from Oracle 11g to Oracle 12c.
• Implemented Data Guard on this RAC environment with another RAC Standby Database.
• Familiar with level skills in troubleshooting performance issues using Automated Workload Repository (AWR) and Active Session History (ASH) for optimum performance of database.
• Installed and configured of GoldenGate on 11g/12c database for data replication.
• Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction issues.
• Worked on Production Support, attending production calls, troubleshooting the application, and resolving bugs.
• Resolved the issues in conflicts between the target and source database in GoldenGate
• Experience in planning, installing, configuring, and administering multiple Oracle RAC in Linux and Non RAC databases in Linux/UNIX.
• Monitored/managed 3 node RAC environments databases using OEM Cloud control.
• Worked alongside programmers and contributing to the development process.
• Responsible for continuous database monitoring and reorganization for ensuring optimum performance.
• Installed ASM environment and migrated database from Non-ASM to ASM.
• Expert in SRVCTL and CRSCTL to manager RAC environment activities.
• Installed and configured 12c Oracle Enterprise Manager (OEM).
• Monitored top wait events /top SQLs/ top sessions using OEM.
• Used Oracle 12c/11g Automatic Storage Management (ASM) to fulfill the storage needs.
• Involved in construction of Disaster Recovery (DR) for all the production databases using Data Guard (Physical Standby).
• Migrate Oracle database 11g from Linux Boxes to EXADATA machine using GoldenGate and Export &Import.
• Administered and managed OCR (Oracle Cluster Registry) including manual backup of OCR and design the recovery strategy of OCR and monitoring of OCR daemons like CSSD, CRSD, EVMD and EVM.
• Tuned and balanced I/O by monitoring file system and table space I/O statistics
• Tuned performance of SQL statements in 11g/12c database.
• Created shell scripts for managing day-to-day activities and incremental and full image backup automatically.
• Implemented optimal space utilization in table space by avoiding fragmentation.
• Used partitions to improve the query performance and manageability.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications accessed.

Oracle DBA

Responsibilities:

• Configured and maintained physical Data Guard. (RAC to RAC, RAC to single instance, single instance DB to Single instance standby DB).
• Installed, configured GoldenGate to replicate data from OLTP to Data warehouse.
• Resolved all sort of GoldenGate abend/latency issues.
• Migrated data to a new ASM Disk group to improve the IO performance of the database.
• Worked on Data Guard configuration and maintenance activities like Switchover and Failover.
• Planned and upgraded databases using Patch Set Updates(PSU).
• Performed database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, database backup, performance tuning, table reorganizations, online segment shrink, index rebuilds.
• Installation, configuration, maintenance, and support of Oracle 11g and 12c database in in Linux/UNIX.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant(ASMCA).
• Performance Tuned and optimized SQL Query, SGA and Disk I/O using OEM.
• Implemented GoldenGate to replicate data and keep databases sync until the time of cutover.
• Implemented Disaster Recovery Plan for critical databases using Active Data Guard.
• Migrated oracle 10g/11g/12c databases cross platform from Solaris to Linux using transportable tablespaces / GoldenGate to reduce downtime.
• Involved in migration of oracle database from 11g oracle to 12c databases.
• Involved in Installation and configuration of 3 node Oracle 11g RAC.
• Performed database migration from non-Exadata to Exadata.
• Diagnosed node evictions for the root cause using cssd, crsd, alert log, trace files and Oracle diagnostic tools.
• Used GoldenGate to migrate large database (15TB).
• Monitored database performance in OEM and generated reports as using AWR and ASH.
• Configured job schedule to automate routine administrative tasks in Crontab.
• Created RMAN repository and configured RMAN full/incremental backups.
• Using shell scripts on Crontab to monitor database in case of OEM crashed.
• Ensured timeliness of project implementation and issue resolution and adherence to committed service levels.
• Maintained a regular project planning, review and meeting schedule with team, peers, management, and clients.
• Worked as tier II oncall rotation member for production support to solve issues in database.

Oracle DBA

Responsibilities:

• Installed and configure extract, pump, replicate, manager parameter file of GoldenGate.
• Cloned databases from production to test environments and refreshed periodic data from production to test environments, reorganize database structures etc.
• Implemented Data Guard with high maximum availability, protection, and performance configurations.
• Installed, configured and migrated OEM Agents on multiple servers to 11g and implemented standard monitoring and alerting procedures.
• Configured system to achieve high availability, load balancing and automatic failover.
• Successfully implemented Backup & Recovery using RMAN for hot and cold backups.
• Generated and interpreted Automatic Workload Repository (AWR), Active Session History (ASH).
• Implemented Database Security, Management of role-based security.
• Configured RMAN Incremental differential and cumulative backups for 10g/11g database in in Linux/UNIX.
• Worked with Data Guard failover and switchover cases at the times of update and migration.
• Installed, configured and managed Oracle ASM instance and disks.
• Performed day-to-day database administration tasks like table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, full and incremental database backup.
• Worked closely with Application Developers to design/create new Oracle databases and create new schemas/ database objects.
• Monitored the Oracle instances, users, tables, tablespaces, segments and rollback redo logs, archived logs, and alerts.
• Created users and granted them the required roles and privileges accordingly.

Oracle developer & Jr. Oracle DBA

Responsibilities:

• Involved in Business Requirements, System analysis and Design of the Data warehouse application. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Designed/Developed/Modified database objects like Tables, Indexes, Views, Materialized Views, Stored Procedures, Functions, Packages, and Triggers. statistics. Inserted hints and rewrote code as required.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Worked on various tables to create indexes to improve query performance. Also, worked on partitioning large Tables using Hash Partitioning, creating Index Organized Table (IOT), Cluster Tables.
• Unix Shell Scripting, and PL/SQL programming to resolve business problems of various nature.
• Tuned database SQL statements and procedures by monitoring run times and system
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Experience in Generating Reports with Oracle Forms& Report tools.
• Used hash/nested loop joins, indexes effectively in where clauses for Query optimization.