SUMMARY:

• Experienced with all facets of Oracle DBA day - to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Working with backup and recovery issues related to corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Issues with block change tracking & flash recovery area.
• Extensive experience with Data Guard setup, troubleshooting, switchover, failover, active Data Guard, fast starts failover and snapshot standby databases.
• Excellent knowledge on query optimization and database performance tuning.
• Extensive experience with performance tuning and health check of Oracle databases using AWR/ADDM Reports, Explain Plan, SQL Trace, TKPROF and OEM 12c.
• Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Installation and configuration, maintenance for Oracle Golden Gate.
• Performing complete and incomplete recovery during disasters, failures and user errors.
• Data Guard administration and maintenance.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
• Installation, configuration, upgrade and performance tuning of Oracle 11g R2 & 12c R1.
• Installed and configured oracle Grid control (12cR1 and 11gR2) .
• Worked on Upgrade/Migration of Databases from Oracle 11gR2 to 12cR1.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Perform Logical backup using full/partial export/import and data pump.
• Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through Roles.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Cloning of production databases as needed for testing, development using RMAN or scripts
• Strong Exposure in creation on an Oracle 12c Multi-tenant RAC data base with 2 node cluster and instances using ASM storage.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. 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, Listner, 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.
• Expertise in all the phases of Software 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 with VERITAS Net Backup & IBM TSM.
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
• 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), 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, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 22TB.
• 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)

TECHNICAL SKILLS:

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

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

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Oracle Database Administrator

Responsibilities:

• Installed and configured ORACLE 10g, 11g and 12c on HP-UX and Windows NT.
• Performed Upgrade of databases from Oracle 10g to 11g and 12c.
• Planned and implemented physical backup (both hot and cold) & recovery procedures for the database using RMAN utility of Oracle 10g.
• Creating the users and assigning them the required privileges.
• Provided 24x7 on-call support as needed.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, 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, STATSPACK, SQL*Trace, TKPROF. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Installation and configuration of Oracle Golden Gate.
• Replicating data from the source to the target with the use of a pump process.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate.
• Monitoring and maintenance of oracle Golden Gate for real time replication.
• Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.
• Experience with MySQL server, troubleshooting bottlenecks on MySQL.
• Experience with backing up MySQL Server, tuning MySQL Server.
• Implemented proactive monitoring using STATSPACK, SQL TRACE & TKPROF, EXPLAIN PLAN.
• Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
• Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, and other OS related utilities like pstack, pmap, top, vmstat, iostat, prstat, strace, and also used Oracle Enterprise Manager(OEM) 11g and 12c to monitor single instance and RAC databases.
• Converting Standby database to Snapshot standby database for pre-go live activities
• Performed oracle Software's Installations, Creation of new standalone and clustered databases.
• Administering and setting up of 11G RAC and 10G RAC clusterware and instances.
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.
• Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace.
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Implemented 11g Interval Partitioning for monthly partitioning of large tables..
• I monitored and troubleshoot the Extract Process, the Trail Process for real time replication.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• 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 11G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration, and solved the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Tools: Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Established best practices and best procedures for database administration. Responsible for Software life-cycle support to includemigration of all custom application changes through four different instances to production.
• Standby Database (Data Guard) setup and configuring DB links.
• Developed 2 node RAC environments for a 1TB database and Implementing Data guard on this RAC environment with another RAC Standby Database.
• Monitored/managed 2 node RAC environments, databases using OEM Gridcontrol, and RMAN database backup and recovery.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers
• Experienced of managing and administering 24 X 7 running databases and support
• Applied bug patches according to the Oracle Critical Patch alerts.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the 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.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.

Environment: RHEL 5.X; Oracle 10g,11g, OEM, Linux, HP-UX, TOAD, STATSPACK, TKPROF, UTL SMTP, EMC ERWIN, SQL*LOADER