SUMMARY:

• A talent and resourceful Oracle DBA professional with more than 8 years’ experiences seek s to build a long - term career as an Oracle Database Administrator to utilize my solid skills in Oracle database, Go l denGate, Data Guard, RAC/ASM,E xadata, Unix/Linux, RAT, PLATFORM migration, Performance tuning and shell scripts on AIX, Linux, Windows, Solaris

TECHNICAL SKILLS:

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

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

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

Data Replication: Oracle Confidential 11gR1/11gr2, 12c, Export/Import,ATTUNITY,DATA Resilient Layer (DRL),DATA GUARD,APPWORXTools / Utilities: EXPDP/IMPDP, OEM 11g/12c, AWR/ASH, RMAN, Logdump, SPM, SQL*Plus, SQL*Loader, RAT,External Tables

PROFESSIONAL EXPERIENCE:

Confidential - saint-Louis MO

Oracle application Database administrator

Responsibilities:

• Provide 24/7 on call rotation
• Does database refresh using rman
• Familiar with serviceNow ticketing system ticketing system
• Datagaurd management using the datagaurd broker
• Security through auditing and granting of privilege as well as creating users
• Analysing developers query and given recommendations on better performance
• Performance tuning on standalone environment using OS tools like vmstat,iostat,telnet,sar,mpstarts,top.sometimes running AWR report which gives details information
• Moving tables using data pump utility i.e. impdp,expdp from one environment to another
• Carry out full backup, incremental cumulative and differential backup, archival backup using RMAN
• Performs Rman refresh where we create directories and run the command in the run block
• Refreshing database from hot backup, cold backup
• Repair block corruption using dbms.block corruption package and sometimes using Rman
• Extensively use application replication tool like ATTUNITY which replicates data from a different source database to different target database
• Experienced using APPWORX tools which refreshes materialized views from source to target
• Experienced in writing shell scripts
• Can improve performance of a query
• Experienced in code review as well as deployment
• Experienced in using data resilient layer tool (DRL) which replicates data from source database to target
• Always get projects done based on given timelines and also based on SLA of the business
• Follows business rules of the company
• Patching the database using the latest version of the release via PSU patch (opatch utility)

Oracle Database DBA

Confidential - Saint Louis, MO

Responsibilities:

• Experience in planning, installing, configuring, and administering Active dataguard in Linux as well as AIX
• Provide 24/7 on call rotation
• Involved in upgrade/migration of databases from Oracle 11g to Oracle 12c.
• Installed and configured 12c Oracle Enterprise Manager(OEM) cloud control.
• Monitored top wait events /top SQLs/ top sessions/using OEM
• Perform cloning of production to dev for script testing
• Involved in database troubleshooting and maintenance activities and solve some dataguard issues such like lagging, inability of primary to communicate with standby etc.
• Worked on Production Support, attending production calls, troubleshooting the application, and resolving bugs.
• 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).
• 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.
• 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.
• 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.
• Tuned performance with tools like AWR, ADDM, ASH, SQL tuning advisors, indexes, partitions, VMSTATS,IOSTATS,MPSTATS,SAR,TELNET,explain plan etc

Oracle DBA

Confidential - Austin, TX

Responsibilities:

• 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).
• Compare workloads between two environment through the use of RAT (real application testing)
• Performance Tuned and optimized SQL Query, SGA and Disk I/O using OEM..
• Resolved all sort of Confidential abend/latency issues.
• 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.
• 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 / Confidential 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.
• Diagnosed node evictions for the root cause using cssd, crsd, alert log, trace files and Oracle diagnostic tools.
• Implemented GoldenGate to replicate data and keep databases sync until the time of cutover.
• Configured and maintained physical Data Guard. (RAC to RAC, RAC to single instance, single instance DB to Single instance standby DB).
• 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.
• Monitored database performance using AWR and ASH in OEM and generated reports as needed.
• 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.
• Heavily utilized OEM Grid Control & TOAD for administrative, monitoring, & diagnostic tasks
• Refreshed/cloned databases using RMAN utility work on multitenant database where CDB had PDB attached to it.created local users and current users.did patching as well as Backup on the CDB

Oracle DBA

Confidential - CHICAGO, IL

Responsibilities:

• 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).
• Installed, configured and migrated OEM Agents on multiple servers to 11g and implemented standard monitoring and alerting procedures.
• Configured RMAN Incremental differential and cumulative backups for 10g/11g database in in Linux/UNIX.
• Implemented Database Security, Management of role-based security.
• 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
• 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 Confidential for data sharing using EXTRACT, REPLICAT, DATAPUMP,MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies.

Junior Oracle DBA

Confidential

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.
• 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 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.
• 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.