SUMMARY

• An Oracle DBA with 8+ years of Core and Application DBA experience in 24*7 OLTP, EBS and Data Warehouse databases (BO/DS). Supported production, Testing, development environments on Linux, Solaris SPARC 64 - Bit.
• Extensive knowledge and experience as an Oracle DBA (11g/10g/9i/8i) including installation, configuration, performance tuning etc.
• Experienced in installation and maintenance of ORACLE 10g/11Gr2 RAC, ASM database for high availability on Sun Solaris and Linux x86-64Bit.
• Implemented Disaster recovery using Data guard/Active Data guard.
• Experience in Migration of 9i, 10gr2 databases to 11gr2 databases from Linux Server to Sun Solaris SPARC Server using Transportable databases (very large databases (like > 1TB), RMAN, Data pump.
• Experienced in Oracle Migration and upgradation of 50 applications. Good understanding of migration processes and doing the migration and upgrades of 10gr2 databases to 11gr2 from HP-UX to 11gr2 SunOS servers, involving character set conversions using CSSCAN and CSALTER.
• Implemented daily Backup strategies for Oracle databases using RMAN.
• Experienced in administration of databases like Creating and Managing Users, Views, tablespaces, indexes, roles, space management, and resizing, partitioning and shrinking tablespaces. Database security by restricting users by granting related privileges, roles.
• Implemented Oracle Enterprise Manager Grid Control 12c on Linux x86-64Bit Environment to manage, monitor and administer the various Databases in the Enterprise.
• Implemented Oracle E-Business Applications Team (EBS 12.1.0.1) for Multi-node implementation of E Business R12 on Linux x86-64Bit.
• Worked on EBS 11.5.9/10 and EBS R12 adding and deleting responsibilities as per the JSOX requirements.
• Helped Oracle E-Business Applications Team (EBS) for Multi-node implementation of E-Business R12, upgrade, applying patches, and cloning, trouble-shooting concurrent managers.
• Experience with performance tuning, troubleshooting database, Perform database monitoring and Tuning to ensure database run at peak performance, Troubleshooting performance issues by using AWR report and Linux OS utilities.
• Experienced in SQL Performance and Database/Instance Tuning of the database using AWR/ADDM/ASH reports, SQL TRACE, Explains plans, Sql Tuning Advisor, Memory Tuning advisors.
• Good experience in Export/Import, RMAN, SQL*Loader, Oracle Enterprise Manager (OEM), Standby Database, AWR and Stat pack
• Applied oracle critical patches and other EBS Product related family pack and RUP’s patches using oracle utilities.
• Experience in Capacity planning, Sizing tablespace, Create database, scripts, Monitor databases, Interact with developers and 24x7 operation DBA support.
• Strong leadership qualities with ability to define individual and shared goals for teams and growth path for individuals. Good interpersonal Communication Skills and a good Team player with activities and timelines.

TECHNICAL SKILLS

Databases: OLTP, Data warehouse, Oracle Databases11g/10g/9i/8i.

DBA Skills: Database Maintenance, Disaster Recovery, Security Management, HA Management, RAC, ASM

Tools: /Utilities: CRON, TOAD 10.1, OEM Grid Control 12c, Data pump, export/import, SQL Loader, RMAN,DBNEWID, AWR, ADDM & Oracle Golden gate.

Shell Scripting: UNIX Shell Scripts on Sun Solaris and Linux platform

Operating Systems: RHEL 3.0/4.0/5.2/5.6/6.2 , Solaris 10, SunOS 5.10, Oracle Linux

PROFESSIONAL EXPERIENCE

Confidential, IRVINE, CA

ORACLE PRODUCTION DBA

Responsibilities:

• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on Linux x86-64Bit.
• Working on Migrations of 10g databases to 11g databases on Solaris SPARC environment.
• Installed and configured OEM 12c grid agents on Linux 5.6-x86-64 Bit servers.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Built Data Guard physical and Active databases on Linux/Solaris SPARC servers.
• Installed and Configured Data Guard Broker and Observer to implement FSFO
• Configured RMAN backup jobs for newly built databases.
• Worked on Performance issues which raised after migrations using AWR, ADDM, and Sql tuning Advisors
• Effective storage management of Database components using ASM for better performance and Fault tolerance.
• Use of Oracle RMAN as the primary utility for cloning, backup/restore & disaster recovery Solutions.
• Transportable Table space for cross platform migration.
• Maintain data integrity, managing profiles, resources and security.
• Handling database server tuning, application tuning, maintaining documentation, capacity Planning and database security.
• Deployed Oracle Patch Set Update (PSU), one-off patches and Bug fixes.
• Resolved performance tuning related issues, Sql tuning, wait Events and identify most expensive
• Top Sql statements etc.., Using AWR, tkprof and Explain plan, resolving a hung database, running a database health check.
• Experienced in supporting Oracle 11gR2 RAC databases on SunOS 5.10, Linux.
• Monitoring and supporting more than 50 databases instances using scripts and daily health check like alert logs, invalid objects, tablespaces usage, long running queries, backups, listener up and running, etc. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send an alerts in email.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.
• Involved in building backup and recovery plans for critical databases from failures with minimum downtime.
• Involved in creating templates and developing notification methods in OEM grid control 12c to support monitoring functionality for oracle databases and database/application servers.
• Provided Assistance to application team at the time of SQL tuning in applications.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc.. .
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Worked on Table partitioning to increase performance.
• Responsible for network configuration and involved in a Client - Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.
• Created and Managed users, user profiles, tablespaces, datafiles, archive log.
• Monitored and trouble shooted database issues with OEM grid control.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10, HP-UX 11.11,RHEL 5.6/6.2, Shell Scripting, RMAN, Data pump, OEM Grid Control. Confidential

Confidential

ORACLE PRODUCTION DBA

Responsibilities:

• Installation, Configuration, Maintenance of oracle 10gR2, 11gR2 databases on SunOS 5.10.
• Migration and consolidation of 9i, 10gr2 databases from hp-ux/Solaris to 11gr2 SunOS server Farm, involving character set conversions using CSSCAN and CSALTER.
• Migrated more than 50 applications (around 50 databases) using datapump, RMAN, Transportable tablespaces (TTS).
• Implemented transportable tablespaces method for migrating huge databases (up to 10 TB) and resolved the issues during the migration of live Production databases.
• Used Data pump export/import as the prime method for migrating smaller applications. Also, worked on customizing the process by creating pre-check, migration and validation scripts.
• Validated the database migrated from offshore as per migration process.
• Implemented, Oracle Golden gate for replication between Oracle database tables.
• Implemented RMAN cloning as a migration strategy for very large applications and later customized the target environment as per client standards. Renamed Databases to new name using DBnewid.
• Upgraded databases from 10.2.0.4 to 10.2.0.5 using Patch sets.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Scheduled jobs like collecting stats for tables/indexes etc., regular backups and monitoring tasks using Oracle scheduler, Crontab.
• 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
• Recorded in the document all the commands and responses in the testing scenarios in order to provide an accurate reference manual for doing recovery when disaster strikes.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10,Toad 10.1.1.8, Shell Scripting, RMAN, Datapump, CSSCAN, CSALTER, OEM Grid Control, Oracle Goldengate 10.

Confidential

ORACLE DBA

Responsibilities:

• Supported critical OLTP development and Production databases on RAC environment.
• Upgraded oracle databases from 9i to 10gR2 and 10gR2 to 11gR2.
• Installed and Configured of OEM Grid Control to administer and monitor database.
• Worked with a team for installation and maintenance of 4 nodes ORACLE 11g RAC, ASM database for high availability on HP-UX 11.31 server. Well conversed using the CRSCTL and SRVCTL tools for maintaining database.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.
• Installed, Configured and used BMC change control to track DDL changes for the Oracle databases.
• Involved in partitioning large tables to improve the performance.
• Performed troubleshooting of database using AWR and ADDM reports for 10g, stats pack for 9i databases.
• Performed SQL tuning using SQL Tuning Advisor in Oracle Enterprise Manager.
• Experienced in doing Complete/Incomplete and Tablespace point in time recovery of database using RMAN.
• Proficient in database administration involving in installation, configuration, tuning and migration of databases along with database design and management.
• Troubleshooted and Resolved RAC issues by checking logs and using RAC diagnostic tools
• Provided Proactive Performance management through AWR Analysis, Database re-organisation, Collection of Statistics

Environment: OEM Grid Control, Oracle 9i, 10g, 11gr2, RMAN, Import & Export, Datapump, Data guard, oracle 10g/11g RAC, ASM, CRS clusters, TOAD 8.2/10.1

Confidential

Oracle DBA

Responsibilities:

• Responsible for installation, design, configuration and production support of Oracle 9i / 10g databases on multiple platforms
• Involved in the migration of database from 9i to 10g on Linux
• Involved in tuning of production database using Statspack, AWR and ADDM reports.
• Provided Assistance to application team at the time of SQL tuning in applications.
• Server side tuning E.g. Rebuilding indexes, Analyzing Schemas etc.
• Recovered critical databases from failures with minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) and OS methods.
• Experienced in Database Cloning using RMAN and Data pump.
• Experienced in installation and configuration of SQL Server Software.
• Experienced in managing users, privileges and storage structures in SQL Server.
• Implemented partition feature on tables for improving scalability and performance
• Performed schema refresh from production to development environment using Datapump and export/import.
• Worked on SQL*loader to load data into database.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users along with installation of the oracle software and patch application for bug fixes
• Developed conceptual database using E-R models to improve fast loading mechanisms
• Responsible for monitoring databases using OEM Grid Control.
• Writing shell scripts for daily database maintenance.
• Check Alert Log files for “ORA” errors and Troubleshoot issues.
• Check the Servers for any space constraints.
• Sizing Memory Components for optimal Performance.
• Check tablespace for any space problems and their growth patterns and Gathering database statistics.
• Troubleshot and researched database issues related to operating system performance,
• Resolved query performance, space management, backup and recovery issues, and other database errors.

Environment: Oracle 9i/10g, HP-UX, RMAN, OEM Grid Control, Data Guard, PL/SQL, SQL*Loader, Stats pack, Data pump, AWR, ADDM, SQL Server etc.