SUMMARY

• Results driven information technology professional with over 7 years of progressive experience in Oracle database administration. Proven track record of providing strategic direction while deploying tactical technical solutions. Exceptional analytical and problem solving skills. Excellent ability to look at problems from a macro level and a detailed level; always keeping teh appropriate business prospective.
• Oracle 10g & 11g RAC, ASM, Stream, Data Guard (Physical, Logical standby), Enterprise Manager (EM) Grid Control, RMAN, Installation, Upgrades, Migrations, Performance Tuning Recent Experience.
• Troubleshooting teh production databases (RAC, Non - RAC) within less time.
• Highly Experience in Tuning database in RAC / Non-RAC environment for better Performance.
• Proactive Monitoring identifying areas that need to be improved performance in teh application and database using 11g/10gOEM Grid Monitoring.
• Performance tuning of teh database (Memory Allocation Tuning, me/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Creating extracts, data pumps and replicats on production servers, splitting replicats for efficient data transfer between servers, performance tuning using BATCHSQL, KEYCOLS, HANDLECOLLISIONS, CHECKPOINTSECS & troubleshooting extract/replicat ABEND issues.
• Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable table spaces).
• Oracle Database Administration … experience in variety of different environments Such as Linux, HP-Unix, AIX, SUN SOLARIS and Windows.
• Experience with RMAN to implement Backup/Recovery strategies and clear understanding of teh data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
• Experience with data pump, export and import utilities to backup and recovery database.
• Involve in Change Management process, Documenting, reviewing and approvals of teh database change at various levels.
• Worked as a team member to provide 24x7 on-call production database support.
• Strong analytical and problem solving skills with ability to work within team and independently.
• Experience in Oracle Support processes for technical requests through Metalink and other Support Procedures.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle DBA

Responsibilities:

• Daily Check activities including RMAN Backup Output, monitoring scripts outputs in case of any issues, OEM Grid Control Monitoring.
• Supporting 2 Node RAC Cluster on 11.2.0.4 and 11.2.0.2 Exadata and Linux X86-64 Bit.
• Installing Oracle RAC Database on 2 Node Cluster.
• RAC Rolling Patching.
• Upgrade from 11.2.0.3 to 11.2.0.4 on 2 Node RAC.
• Database Refreshes from Prod to DEV.
• Used Materialized Views for better performance of Queries.
• Worked on Partitioning on 11G and done maintenance on it.
• Worked on Writing shell script to automate regular jobs, scripts.
• Daily Support, Regular Maintenances on Dev/QA/Prod RAC / Non RAC Environments.
• Done 24*7 on Call Support
• RMAN Backup and Restore experience.
• Supported Big Regional Go Live Activities having done extensive monitoring.
• Generated Database Performance Reports and Global, Global Difference AWR Reports, done comparisons, created Baselines. Used OS Watcher, BMC Perceiver.
• Exposure to MS SQL Server 2008/2005.
• Installed Sql Server 2008 on Windows 2008.
• Worked on Multiple Platforms including AIX (6.1 TL5 SP1), Linux (RHEL 5 x86 64 bit), Windows ( Windows Server 2008/2005 R2)
• Worked on evaluation, configuration, installation or new projects from scratch w.r.t creation of databases..
• Installed, Configured and Supported MySQL 5.6.14 on Linux and Windows Machines.
• Worked on Troubleshooting/Configuring OEM for Alert Monitoring.
• Worked on Multi Tera Bytes of Database size ranging from 1 TB to 40 TB.

Environment: Oracle 11gR1, R2 and R4, RHEL 5 Oracle Linux 5, AIX 6.1 4, Win 2008, OEM, RMAN, RAC, Toad, Sql Developer, IBM Clearcase.

Confidential, Mason, OH

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle Database Software 10g on Zlinux, AIX in development, integration, Production Environment.
• Creation and configuration of Oracle database of various sizes 300 GB, 2TB in ITG and Production environments.
• Performance tuning of SQL queries and advising teh application programmer of teh opportunities in tuning teh application.
• Implement DBMS SQLTUNE to fine tune teh database
• Worked with Flash Recovery Area.
• Schedule jobs in cronjob including RMAN backup and other memory maintenance, security jobs. Worked on DBMS SCEDULER.
• Worked on 4 node RAC databases on AIX servers
• Created standby database and worked with data guard to provide high availability.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Migrated databases from Oracle 10.2.0.2 on window 2003 to Oracle 10g on ZLinux development, integration, production environment using Import/Export.
• Auditing and security with Oracle databases.
• Install OEM agent on widow 2003 servers and z linux Servers
• Monitor and Configured Oracle 10g databases using OEM.
• Created and Managed user, table spaces, datafiles, archive log.
• Performance tuning of SQL queries and advising teh application programmer of teh opportunities in tuning teh application.
• Involved in performance monitoring and tuning of teh database by fine tuning teh database implementation.
• Backup and Recovery using RMAN.
• Written Stored Procedures and Triggers, functions, cursor for database maintenance and management using PL/SQL.
• Applied CPU patches and other patches as required.
• Tuned and optimized SQL Query, SGA, and Disk me/O using Oracle Enterprise Manager and by monitoring teh Stats pack report generated from snapshots taken at teh peak business hours.
• Support application team to solve any issues in Production Environment.
• UNIX Shell scripting for backup and monitoring of databases.
• Provided 24x7 on-call production supports.

Environment: Oracle10G, Oracle9i, Solaris 10, windows 2003 Server, Zlinux, AIX OEM grid, RMAN, SQL, PL-SQL.

Confidential, Baltimore, MD

Oracle DBA

Responsibilities:

• Upgraded 10g to 11g, 11g to 12c and applied latest PSU every quarter.
• Installed and configured new Quarterly ORACLE HOMES for teh 10g and 11g versioned servers.
• Primary DBA for all databases in DEV/TEST/PRODUCTION on 11g and 12c (Agents and Databases monitoring)
• Supported teh upgrade of RHEL and Hard work are diagnostics on various servers.
• Worked in all shifts and 5 days SNAP (production maintenance) at teh maximum handovers.
• Documented all teh incidents and presented in a form of report.
• Conducting meeting as a host on various occasions, preparing RCA (root cause analysis) as shift coordinator for several months.
• Supported teh agent patching for 12c server transformations.
• Regular work on 12c OEM for Monitoring teh system databases and applications for availability and maintenance.
• Conducting shift weekly team meetings and involved in giving sessions on topics to teh new folks, trained new team members in teh team including 12c upgrade and monitoring support in OEM cloud control.
• Experience in ITIL with Incident tracker maintenance and SLA agreement following.
• Making sure teh backups and file system usage is up to date.
• ASM is enabled and auto rebalancing is on.
• Supported teh quarterly reboots for multiple servers and involved in Data guard home relinking as well as RAC Relinking.
• Prepared teh document for applying quarterly UNIX patch over several databases.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Installed GRID Patch for 11.2.0.4 and moved ASM to newer homes.
• Installed teh fresh homes for 11.2.0.4 on Linux servers.
• Supported SAN Migration and ASM migration, allotted new candidate disks.

Confidential, Jersey City, NJ

Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g on RHEL.
• Created logical and physical standby databases using Data guard and converting physical standby to snapshot for testing purposes.
• Configured Recovery Manager (RMAN) and performed Hot and Cold backups for production databases using RMAN.
• Performed block recovery and data file recovery using RMAN.
• Created user accounts, roles and granting required access permissions and privileges to teh database based on teh application they are accessing.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve teh issue.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases.
• Configured listener and TNS names manually.
• Involved in Up-gradation of databases from 9i to 10g.
• Configured Oracle Data guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Converted physical standby databases to Snapshot standby database.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Configured and Tuned RMAN for better performance and backup strategies.
• Created user accounts, roles and granting required access permissions and privileges to teh database based on teh application they are accessing.
• Involved in taking logical backup using Data pump and Exports/Imports Utility.

Environment: Oracle 9i, 10g, RHEL, Windows 2000, RMAN, PL/SQL, Shell Scripting, exp/imp, SQL, SQL/PLUS.

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Requirements gathering for providing Offshore Support for various applications Oracle EBS 12.2.3, EBS 12.1.3, SOA, Oracle WebCentre, OBIEE, Oracle HTTP servers and etc.
• Driving Offshore teams based on Onsite DBA's requirements for Installations, Upgrades, Clonings, Patching, Code Migrations, Deployments and Issues troubleshooting.
• Performing Development servers maintenance activities like Server reboots through OVM, volumes mounts&unmounts, Package Installations
• Successfully prepared and Documented first clone of Oracle EBS R12.2.3 Instance.
• Documents preparation as per Oracle Standards (D0XXX).
• Supporting Development teams for Code Deployments Procedures on R12.2.3 Instances.
• Applying Patches using adop on R12.2.3 and adpatch on R12.1.3
• Troubleshooting various issues of R12.2.3, R12.1.3 Instances
• Working with SA teams for new servers preparation and validations
• Performing Weekly filesystem level Snapshot Offline Backups for all non-prod servers.
• Configuring Load Balanced URL for Oracle EBS R12.1.3 and R12.2.3
• Installation of WebLogic Server 11gR1 and Oracle HTTP server
• Installation of Oracle SOA Suite 11.1.1.7
• Installation of Oracle Web Center Content Management (WCC) 11.1.1.7 and Oracle Web Center Portal (WCP) 11.1.1.7

Environment: Oracle EBS 12.2.3, Oracle EBS 12.1.3, Oracle Database 11.2.0.3, OAS 10.1.3.4, Web Logic 11gR1, SOA 11.1.1.7, Web Center, Oracle HTTP Server, OEM 12c, OVM, Operating System: RHEL 6/5.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Installation, Administration, Maintenance and Configuration of Oracle Databases 8i, 9i, 10g.
• Created and maintained different database entities included Tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Provided on-call support regarding production-related database problems.
• Used RMAN for backup and recovery strategy.
• Tuning of databases which includes Server side tuning and application tuning.
• Capacity planning of teh databases / applications.
• Upgraded database from Oracle 8i/9i to 9i/10g
• Refreshing test and development environments (Oracle) from production databases as and when required.
• Optimized different SQL queries to insure faster response time
• Worked with Oracle Enterprise Manager.
• Work with Oracle Support to resolve different database related issues.
• Used Transportable table space, Data pump, RMAN for database migration between different platforms like Solaris to AIX.

Environment: Oracle 8i,9i,10g, RH Linux, Solaris, Installation, Migration, Upgradation, OEM, RAC, RMAN, ADDM, AWR, Statspack.