PROFESSIONAL PROFILE:

• I have been a dba for more than 9 years with extensive experience in production support and working on project.
• Troubleshoot and resolve performance issues with extensive investigation and follow - up with respective application teams and proposed solutions.
• Resolve lock/latch and resource contention issues during production hours
• Configure Dataguard and Broker for administration of seamless switchovers.
• Upgrade Grid Infrastructure and DBs from 11g to 12c with physical standby DBs in place Installation and configuration of oracle Golden Gate.
• Experience in using Golden Gate to support data replication in the Oracle database environment.
• Experience in applying PSU patch on standalone as well as RAC databases.
• Experience in Golden Gate upgrade from 10.4 to 11.2.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g servers for the purpose of disaster recovery procedures.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle11g Golden Gate on RHEL 5 platform.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 10g and 11g databases.
• Management of schemas, objects & Partitioning the tables & indexes, AWR, ADDM and 10g OEM Grid Monitoring,11g AND 12c OEM Grid Control.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Experienced in using 10g, 11g and 12c features of Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and RecycleBin.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experienced in Oracle Support processes for technical requests through Metalink (MOS) and other Support Procedures.
• Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modelling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Experience in basic and advanced replication using Oracle Goldengate Classic and integrated Capture (both 11g and 12c) and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Experience in data migration across platforms: Solaris to Linux.
• Proficient in Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Installed, configured and Monitored Oracle Enterprise Manager Grid Control 11g & Cloud Control 12c.
• Expert in Database Health Maintenance using TKPROF, RACDIAG, AWR (statspack) ExplainPlan, SQL Tuning Advisor, Oracle Enterprise Manager(OEM), Self-developed Scripts & methodology, Procedures.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Administration experience in Very Large Multi-Terabyte Databases (VLDB) environments.
• Strong experience in Backup and Recovery strategies using RMAN, creating RMAN scripts, Export/Import, Datapump, Hot and Cold backups.
• Experience in understanding business requirements for analysis, detailed design, database design & development of applications.
• Involved in doing Data Modeling, Data Mart, Data Warehousing, Data Transformation.
• Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.
• Experienced in Oracle Support processes for technical requests through Metalink (MOS) and other Support Procedures.
• Always respect the business Service Level Agreements (SLAs) and a good team player.
• Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Participated in on-call (off hours) schedule in providing technical support.
• Good co-ordination and communication with system administrators, business data analysts and development teams.
• Good theoretical experience in DB2.
• Experience in System Development Life cycle(SDLC) especially in DEV, ATS, PRE-PROD and Production environment.
• Experience in Log gap monitoring and resolution in Data Guard environment.

TECHNICAL PROFICIENCIES:

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, Dell spotlight, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2

WORK EXPERIENCE:

Oracle Database Administrator

Confidential, Irving, TX

Responsibilities:

• Managing and Migrating databases from 11gR2 to 12C Cluster in Oraas(Oracle as a service)
• Manages Oraas Databases that run on ERP software
• Upgraded Oracle 11g to Oracle 12C database version.
• Automate some task like backups, and uses scripts to monitor tablespace growth.
• Monitoring database for growth and added space to table spaces as per demand.
• Generating AWR reports on regular basis to identify database performance at peak load.
• Tuning SQL statement by analyzing explain plan and ADDM reports.
• Performance Tuning Experience - AWR, ADDM, ASH, SQL Tuning Advisors, EXPLAIN PLAN, SQL Trace with TKPROF and Toad.
• Implemented scripts to monitor and get information on free space, alert log errors.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Upgrade/Migration of databases from Oracle 10 to 11g, cross platform migration from different platforms.
• Perform Primary/Standby database switch over/fail over using DataGuard Broker.
• Automate, developed and maintained UNIX shell scripts to collect and monitor database metrics and Produces Database health reports Using AUTOSYS.
• Utilized Grid Control 12C OEM to administer multi-node RAC database also managed redo and undo in RAC environment. Load balancing of RAC instances.
• Monitoring space, wait events, locks and long operations running on database .
• Supporting day-to-day Database administration activities like creating databases, troubleshooting tablespace issue, mount point space issue, high CPU utilization, locking/blocking sessions.
• Implemented Golden Gate Replication.GoldenGate Unidirectional and Bidirectional replication.
• Supported Oracle Financial Services lending and Leasing (OFSLL) application.
• Supported Monitoring session waits for database performance and resolving performance issues.
• Experienced in using 10g and 11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Control Monitoring and Recycle Bin.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS)
• Extensive experience Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database .
• Data guard Broker configuration and Managing Physical Standby databases using Oracle Data guard Broker.
• Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
• Experience on working with data guard physical/logical standby databases.
• Documented Standard Operation Procedures (SOP) for peers to follow.
• Applying upgrade patch, maintenance and interim (Opatch) patches on all databases.
• Expert in performance tuning,i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$ views, DBA views and Data Modeling, Logical and Physical databases design using tools like Erwin and Visio.
• Refreshing Dev and Test instances with data from Production on regular basis.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Used Data Pump for export and import. Wrote RMAN scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing from production to testing using Datapump and RMAN Duplicate.

Oracle Database Administrator

Confidential, Alpharetta, GA

Responsibilities:

• Used TOAD and OEM 12C for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Provide support for Oracle databases including applying patches, performance tuning, Backup and recovery issues with RMAN, trace analysis, service creation for apps to fail over, cluster and system management.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Maintaining Physical standby maintenance (Switch over - using Data Guard Broker).
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems.
• Implemented Unidirectional and Bidirectional Golden Gate for real time data replication.

Confidential, Evansville, IN

Oracle Database Administrator

Responsibilities:

• Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, OSWatcher and other OS related utilities like top, vmstat, iostat, strace, truss 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.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements and design indexes to improve response of queries.
• Automated monitoring of Golden Gate process and heart beat monitoring.
• Provide support for Oracle databases including applying patches, performance tuning, Backup and recovery issues with RMAN, trace analysis, service creation for apps to fail over, cluster and system management.
• Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
• Installed and Managing Oracle, 11gR2 3 nodes of cluster (RAC) on Solaris 11.
• Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC )
• Design and Maintaining Physical standby maintenance (Switch over - using Data Guard Broker).
• Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems.
• 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..
• 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 9i to 10G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and table spaces at performance standpoint.
• Performance tuning - Tune SQL statements, I/O, Memory, latches etc. Worked extensively on SQL Profiler, Explain Plan and Stats Pack for tuning top wait events, high cost SQL's.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• 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 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
• 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.
• Implementing Best Practices for migration regular databases to Oracle Exadata
• Resolved/Diagnose Node Eviction issues.
• Experience in Shell scripting, where I used it to automate my backups and also to set an alert.

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

Confidential, Seattle, WA

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10gGrid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• 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 databasesandDatapump import/export to move data between 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Implemented data guard for the critical production databases and tested switchover and failover. Logical standby databases for the real time DML apply in the remote databases. Disaster recovery plan for the production to standby database to check the data consistency.
• Maintain databases build database backup and recovery routines (RMAN), monitor database activities and conducting performance monitoring. Clone Development, test and UAT databases using RMAN.
• Handling multi-terabyte databases and the capacity planning for the data and application growth and recommend partitioning strategies for very large tables.
• Successfully implemented physical standby database using Oracle Data guard and Active Dataguard feature for High availability configuration in RAC environment.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Supportin resolving the SRs.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.