SUMMARY:

• 8 years of experience in Oracle database administration with diversified exposure to advanced technologies.
• Oracle Core Database Administration on Oracle 12c, 11g and 10g
• Oracle Real Application Clusters (RAC)
• Grid Infrastructure and ASM
• Data Guard, Data Guard Broker
• Oracle Maximum Availability Architecture * Disaster Recovery
• RMAN Backup and Recovery * Capacity Planning
• Clone Export Import and SQL*Loader * Table Partitioning
• Performance Tuning
• Expertise in setting up GRID infrastructure and RAC 11g Installation, Creating RAC Databases, Troubleshooting and Performance tuning, Monitoring and Maintaining.
• Evaluating patches on requirement basis applying PSU, CPU Patches on clustered, non - clustered and Disaster Recovery environments.
• Expertise in handling and resolving Severity1/2 issues on Production Environment.
• Hands on experience in Migration of databases from 11g to 12c.
• Performance tuning at Database level and SQL level.
• Identifying database Hung Issues, Hot-Block issue identification, Tracing Oracle Sessions degrading performance and fine tuning queries usage of Oracle utilities like TKPROF
• Performance tuning of the database using AWR, ADDM, ASH, SQL TRACE, EXPLAIN PLAN and SQL advisor
• Experience in migration of databases from non-RAC to RAC and non-ASM to ASM
• Good working Knowledge on Oracle Grid Control/Enterprise Manager tools.
• Strong skills in SQL*Plus, SQL*Loader and UNIX Shell scripts (KSH)
• Involved in development of scripts to automate backup and recovery procedures for development databases.
• Knowledge in usage of Oracle internal tools for debugging like Oradebug, OSWatcher, System State dumps, Process state dumps.
• Very fluent in creation of Instances, Table spaces, Partitioned tables, Indexes, External Tables, Materialized Views, Bitmap Indexes, SQL*Loader, objects, roles.
• Good hands on experience on MSSQL server 2012/2014 and MySQL 5.7
• Flexible and excellent team player.

TECHNICAL SKILLS:

Platforms: AIX 6.1, 7.1, Linux RHEL 6.6, Windows 2003, 2008 R2, XP/7/8, Iseries

RDBMS: Oracle 12c,11g,10g, IBM DB2, MSSQL server 2008 R2, 2012, 2014, as400

Languages: PL/SQL, Shell Scripting, Jython, Python

Tools: Export/Import, DATAPUMP, RMAN, OEM Grid Control, SQL*Loader, OSWatcher

High Availability: Oracle 10g/11g RAC Advanced Replication, Clustering and Data Guard Setup, Configuration and Tuning

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr. Oracle DBA

Responsibilities:

• Successfully implemented physical standby database using Oracle 11g Data Guard feature for High availability and Disaster Recovery purpose.
• Installed and configured 2 node oracle 11gR2 RAC with ASM on Linux RHEL 6.1 for production environment.
• Involved in addition of third node to existing two node RAC cluster.
• Worked on 2 node RAC performance issues related to RAC Cluster, ASM and Cluster Interconnect issues.
• Upgraded databases from Oracle 10g to 11g.
• Configured ASM disk groups to store Data files, redo log files, and control files.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers
• Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
• Identified index fragmentation and rebuild of indexes.
• Monitoring the health of RAC databases by checking the logs and OSWTAHCER
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommended solutions for faster execution.
• Analyzed and monitored wait events on production databases to implement improvements for buffer busy waits/sequential & scattered read contentions.
• Developed advanced shell scripts, SQL and PL/SQL scripts in support of database operations
• Applied relevant patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering Statistics
• Wrote shell scripts for automation of tasks and used shell scripts with crontab for job scheduling.

Environment: Linux, AIX, Oracle 12c/11gR2, OEM, RAC, DataGuard, ASM, Datagaurd broker, RMAN, Export/Import, SQL, SQL Developer

Confidential

Systems and Database Engineer

Responsibilities:

• Migration of Oracle Databases from NON-RAC to RAC and NON-ASM to ASM.
• Installation and creation of Oracle10g, 11g Databases for test, dev servers.
• Implementation and support of Oracle 11g and 12c migrations and upgrades from Oracle 11g to 12c database.
• Set up Disaster Recovery using physical standby databases for mission critical Oracle instances.
• Implemented snapshots on a separate instance to use it as a reporting server minimizing load using Datagaurd Broker on production.
• Tested Oracle 12c regression testing prior to production implementation for a 900GB oracle DB.
• Performed database tuning using Explain Plan, Tkprof, Statspack and other custom utilities.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Provide support for 12c Oracle Enterprise Manager Grid Control and Agents.
• Maintain, schedule and troubleshoot all RDBMS related software Oracle Enterprise Manager (OEM) Cloud Control 12C on Linux and Unix Environment.
• Creation of databse objects like tables, views, materialized views, procedures and packages using oracle tools like PL/SQL Developer and SQL* plus.
• R es ponsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Worked on Flashback to restore on point in time recovery.
• Restored / Refreshed downstream Oracle database instances for various DEV, QA, and UAT purposes.
• Managing Tablespaces, Data files, Rollback segments, Temporary TBS.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like PL/SQL developer and SQL*PLUS.
• Proficient in using Flashback technology, Log Miner, Automatic Storage Manager.
• Maintain, upgrade, troubleshoot all Enterprise oracle and SQL server databases
• Clear communication and documentation of technical specifications.

Environment: Oracle12c/11g, SQL server 2012, RAC, Datagaurd, Datagaurd broker SQL, PL/SQL, RMAN, ADDM, AWR, ASM, Statspack reports, Shell Scripts, WebSphere, MSSQL, SQL Developer, RHEL-6.3/6.4, Windows 8

Confidential, Bangalore

Junior DBA

Responsibilities:

• Responsible to both manage and support 15 development/test databases with sizes of databases varying from 50 GB to 500GB.
• Installed and Upgraded 10g to 11g.
• Perform daily administration support for database backups, performance tuning and monitoring.
• Monitored and diagnosed database performance through monitoring of alert files, trace files.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked on Data pump to take the logical backups of databases.
• Worked on performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.
• Performance tuning via OEM, STATSPACK/AWR for 10g/11g.
• Maintenance tasks like bouncing the production database, services through Veritas.
• Installed IBM db2 database on AIX servers
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.