SUMMARY

• Over 10+ years of experience as Oracle DBA, providing 24/7 support of development and production 12c/11g/10g/9i databases on UNIX/LINUX and Windows environments.
• Perform various tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support Cloning, Backup and Recovery, Performance Tuning, script development, and documentation.
• Designing & Deploying Database Schema and Objects
• Excellent experience in Oracle database installations 9i, 10g, 11g and 12c in UNIX/LINUX, HP - UX, SUN Solaris, AIX, Windows environment with hands-on experience in upgrading the Oracle databases.( 9i to 10gR1,10gR1 to 10gR2,10gR2 to 11g, 11g to 12c)
• Experience in configuring oracle data guard and streams.
• Experience in applying oracle database patches using opatch utility.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager.
• Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning
• Experience in Korn Shell Scripting.
• Extensive experience in performance tuning of database, memory & I/O using tools such as AWR, ADDM and analyzing queries using EXPLAIN PLAN, SQL-TRACE and TKPROF.
• Extensive experience in performing backups and tested crash recoveries using conventional hot, cold backups and RMAN.
• Experience on Configuring ASM (Automatic Storage Management) which includes creating disks, disk groups for the RAC environment
• Hands on experience of daily monitoring of Oracle instances and maintenance of databases using Oracle Enterprise Manager(OEM), Oracle GRID and SQL*Plus Command line scripts.
• Proactive database monitoring using 10gGrid monitoring tool.
• Experience in shell scripting for various CRON jobs to be run.
• Experience with data transfers and sharing using flat files.
• Experience in using BITMAP, B-Tree indexes, composite indexes, hash partitioning and histograms.
• Proficient in SQL, PL/SQL, stored procedures, packages, triggers, forms and report.
• Efficient in security administration by creating and maintaining users with appropriate profiles, roles and privileges to access network resources.
• Extensive performance tuning experience, specializing in instance tuning, Oracle9i, 10g RAC, 11g RAC tuning and SQL optimization.
• Expert in configuration of 12cRAC 11gRAC, 10gRAC, 9i on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Monitored lock Escalation, Dead Locks, resources utilization by sessions, capturing long running SQL queries.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 6.x, Windows 98/NT/2000/2003/XP/7, Vista, Windows Server 2003/2008.

RDBMS: Oracle 12c/11gR2/11g/10g/9i/8i, 10g Data guard, SQL Server 2005/2008, Sybase, DB2, Exadata 2.0, Oracle Fusion middleware

Languages: PL/SQL, C, Linux, UNIX Shell Scripting, Korn Shell Scripting

Tools: RMAN, SQL*Plus, TOAD, Data pump, Gateway

Utilities: SQL Loader, Export/Import.

TuningTools: TKPROOF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH.

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Sr. Oracle Database Administrator/Performance Tuning

Responsibilities:

• Installation, configuration, administration of 6-node Production RAC databases on Oracle 11g/12c on RHEL.
• Excellent working experience and implementation knowledge on Data Guard (ADG/ Physical/DGMRL) and Stand-by databases for fail-over and recovery.
• Provide and implement performance and tuning recommendations of all components in the
• DatabaseMachines and Solid Exposure to Exadata Hardware Architecture including Database
• Grid, StorageGrid and Infiniband Solid Exposure to Exadata Configurations including X4-2 fullrack, halfrack.
• Experience with IORM, DCLI and ADRCI.
• Assisted in consolidation, integration and migration of Oracle database to Exadata with GoldenGate, dataguard.
• Managing Oracle half Exadata X4-2 systems for performance, hardware issues and in improving the ETL process to optimize run-time.
• Performed DR Test and DR resiliency test for high availability.
• Design and implement Oracle Golden Gate architecture with customized data transformations.
• Migration of Golden Gate / Oracle database to Exadata Server using dataguard switchover.
• Performed Database Refresh, Code Migrations and Data Migrations in all environments.
• Used SQL Profiles, SPM and stored outlines for plan stabilization and involved in collecting, planning and scheduling the stats collection job.
• Install/Configure Oracle Golden Gate Plug-in 12.1.0.2 for OEM 12c
• Experience in analyzing AWR, ADDM, ASH reports in troubleshooting the contention and concurrency in the database.
• Clusterware upgrade from 11.2.0.2 / 11.2.0.3 to 11.2.0.4 applied the latest PSU in rolling fashion to avoid the downtime for 2, 3, 5 and 6 nodes RAC.
• Upgrading GoldenGate to 12c from 11g and converting Classic Capture to Integrated Extract.
• Performed a Rolling forward on Standby database using RMAN Incremental Backup for un-resolvable large archive gap.
• Involved in planning and scripting to collect DB metrics and configure it with alert systems.
• Performed SQL Tuning using SQL TRACE/TKPROF, Explain Plan and Auto Trace.
• Installation, Configuration, administration of 2 node 12C OMS and configuring SLB.
• Converting Standby database to Snapshot standby database for pre-go live activities
• Implemented Oracle flash back feature in all the critical production databases
• Installed 12c agents and Migrated targets to 12c OMS from 11g OMS.
• Design and development of backup/recovery strategies using Oracle RMAN, Expdp and VERITAS Net backup.
• Experience with Oracle ACFS/DBFS and configuring Golden Gate on ACFS/DBFS.
• Estimate SAN Storage needed for Replication across multiple sites.
• Experience in Archival, Purging and Partitioning tables based on business requirement (Range and Hash).
• Test initial Data Load option of Golden Gate during environment build and Investigate
• Replication failures using Log Dump utility.
• Troubleshooting Golden gate issues like data sync issues, trailfile corruptions, network issues, ETROLLOVER and writing exceptions
• Identify risks involved with replicating highly volatile tables with large data volume.

Confidential, Des Moines, IA

Sr. Oracle Database Administrator/Performance Tuning

Responsibilities:

• Installation, configuration, Maintenance and Support of Oracle 11g and 12c Databases as a part new Project implementation.
• Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
• Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using dataguard switchover and Export & Import.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Involved in capacity planning and resource planning.
• Pro-Active Monitoring of the Databases using 11g and 12c Enterprise Manager and fixing the issues, also working on Root Cause Analysis and documenting the issue resolution steps for future reference.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• SQL tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Worked on Re-Organizing the tables to convert from non-partitioned to partitioned tables using Online Re-definition (with minimal impact to live system ), CTAS(create table as select ), exp/imp and creating the table with new DDL and direct insert sql.
• Management of schemas, objects partitioning the tables & indexes.
• Actively participating in the meetings with application team for process improvement, Oracle Server Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, and Application Tuning.
• Worked on Database Character set conversion from Universal character set (AL32UTF8) to Western European (WE8ISO8859P1) and Vice-versa.
• Working with Server Admin to resolve the server level issues.
• Implemented Golden gate unidirectional replication on RAC using ACFS file system.
• Implemented 12c Grid control (Multi OMS architecture) on 11.2.0.4 database, Standby OMS architecture is under progress.
• Responsible for ASM migrations and tuning on all platforms.
• Responsible for downsizing and defragmenting the Very Large Databases by export / import, cloning them using RMAN Duplicate features and then upgrading them to Oracle 10g
• Perform routine database tuning and administration activities for several Oracle 9i/10g databases.

Environment: LINUX, IBM-AIX, Oracle 10G, 11G and 12c, OEM 11G and 12c, UNIX, SQL, Oracle Auditing, Oracle Partitioning, GoldenGate, Shareplex, Physical Standby (Active Dataguard, normal standby), LogMiner, EXADATA X4-2, Oracle 12c, 11gR2 and 10g R2 RAC and Standalone.

Confidential, Detroit, MI

Sr. Oracle Database Administrator

Responsibilities:

• Provided 24x7on call support for all the production and development databases.
• Implemented 10g/11g with one physical database.
• Configured and Upgraded to Oracle 11gR2 from 10g and from 11.2.0.2 to 11.2.0.3
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Writing PL/SQL triggers, procedures, and functions.
• Creating and Managing Table Spaces, Tables, Views, Indexes, and Partitions.
• Optimized the query result cache for best performance.
• Extensively used AWR, ADDM for database performance statistics.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack
• Oracle Database and SQLtuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Performed Cross platform migration using transportable table spaces and RMAN.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Performed version upgrades and patch installs.
• Demonstrated experience and competence with Oracle E-Business Suite Administration - configuration, maintenance, tuning, patching, and cloning, release 11i or higher.
• Architecture planning, installation, configuration, patching, administration and support for existing and new E-Business Suite environments.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• Checking databaseperformance on a regular interval, which includes checking various log files.
• Addition of users, objects etc as and when required and granting proper privileges for Database access.
• Taking care of database by checking the size the database and addition of table spaces, data files.
• Planned, designed, implemented, support, troubleshoot RMAN, RAC, Data Guard, RAT, Golden Gate and Streams.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Created standby database using data guard on testing server.
• Provided Oracle database administrative support.
• Oracle 9i,10g,11g grid control (OGC), Putty, sql*plus, RMAN, Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Oracle Fusion Middleware for investigating suspicious application behavior.
• Creating table spaces, tables, indexes, users, etc.
• Importing of dumps using impdp/expdp utilities.
• Define Backup Strategies and Implementation.
• Loading bulk data from flat files using sql*loader and external tables

Environment: Oracle 9i/10g/11g/11gR2 databases, Exadata 2.0, Data pump, Golden Gate, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, HTTP, F-Secure SSH,, F-Secure FTP, Oracle Enterprise Manager, TOAD

Confidential, Boston, MA

Oracle DBA

Responsibilities:

• Performed Installation, Configuration, and Designing, troubleshooting, performance tuning and production support of Oracle 10 g, 11g, and RAC (10g and 11g R2) databases on Sun Solaris, Red Hat Linux, and HP-UX 11.11.1. Installation, Configuration, Designing and Maintaining of ASM on Oracle 10g.
• Responsible for providing 24x7support for production Oracle databases
• Cloning the databases for TEST, DEVP and PROD and regularly refreshing the databases.
• Installation, Configuration and Maintenance of 10g RAC.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Involved in Data Warehousing, Data Modeling, Database Design and Creation
• Migration of database from 9.2.0.6 and to 10.2.0.2.
• Extensively used ADDM, AWR, ASSM features of 10g.
• Extensively used 10g Grid monitoring for proactive monitoring of databases.
• Implemented Hash and Range Partitioning.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Developed many PL/SQL functions, procedures, packages and triggers.
• Performed exhaustive performancetuning for a database server and Oracle instance.
• Involved in developing a disaster recovery (DR) plan & conducting/implementing a DR exercise.
• Creating and managing table spaces and rebuilding of indexes.
• Planned, designed, implemented, support, troubleshoot RMAN, RAC, Data Guard, RAT, Golden Gate and Streams
• Taking periodic backups of the database and the software using cold, hot and RMAN strategies.
• OS level activities like space monitoring of mount points.
• Planned and implemented for backup and recovery of database.
• Responsible in Managing and optimizing transactional replication in OLTP environments.
• Controlled and monitored user access to database; monitor and optimize the performance of database
• Responsible for ASM migrations and tuning on all platforms.
• Responsible for downsizing and defragmenting the Very Large Databases by export / import, cloning them using RMAN Duplicate features and then upgrading them to Oracle 10g
• Perform routine database tuning and administration activities for several Oracle 9i/10g databases.
• Replacement of Oracle Advanced Replication with Oracle Streams in Oracle 10g databases.
• Database cloning using RMAN and hotbackups.
• Allocated system storage and plan for future storage requirements for the database system
• Provided technical resolution to Oracle database related problems
• Enrolled users and maintain system security and integrity, ensuring compliance with database license agreements
• Performed system enhancements, including SGA, memory tuning and SQL Tuning, hardware and software modifications.
• Assisted developers in application performance tuning and evaluation of vendor supplied software packages.

Environment: Sun Solaris 9, Red Hat Linux 4.x, AIX v5.3, Oracle 9.0.1.5/ 9.2.0.1/ 10.1.0.2 /10.2.0.2 , Toad Ver8.5, SQL*Loader, TOAD, OEM, Oracle Streams, RMAN, Golden Gate, Windows XP/NT/2000.

Confidential, Pittsburgh, PA

Oracle DBA

Responsibilities:

• Working with Database Architecture Group who are managing 1000 plus databases on Oracle 10g and 11g from Development, Test to Production.
• Planned, designed, implemented, support, troubleshoot RMAN, RAC, Data Guard, RAT, Golden Gate and Streams
• Day-to-day activities like taking Backup (or schedule the backups daily/weekly/monthly for database using Red gate SQL backup tool) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Implemented Administrator tasks such as managing users, roles, and profiles.
• Provide DB design and architecture support for new and existing applications. Perform data modeling and evaluate requirements for performance, availability and replication incorporating them into the final design. (Creating tablespaces, schema, users, sizing of tablespaceetc) on ASM.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Data modeling of new and existing schemas to create new designs and optimizations for existing designs ensuring normalized data modeling of entities, attributes and relationships.
• Evaluate requirements and best practices to provide product recommendations based on suitability to task.
• Performed logical database design, capacity planning and external data interface specifications.
• Created PL/SQL proceduresand jobs to automate maintenance tasks.
• Created data loading plans, data maintenance plans, design security policies in conjunction with existing policies and security teams
• Documented and communicate the database design, analyze data in the current schema, make recommendations for improving data integrity and creating Oracle sizing guidelines to assist operational DBA's in setting up database environments.
• Assisted with the optimization of database instances, PL/SQL queries and to quickly escalate and resolve design related issues·
• Reviewed failures and provided recommendations to prevent future occurrences
• Supported data ware house databases

Environment: Oracle 10g, 11g, Solaris, Linux. DBArtisan, Patrol, SQLBacktrack, RMAN, PowerDesigner, RAC, ASM, Dataguard, Golden Gate. IBM P590, SQL Server 2005, DB2, HP Superdome, Informatica.

Confidential

Oracle DBA/ Developer

Responsibilities:

• Worked as a team member for 24x7 supports inboth production and development environments.
• Installation and creation of 9i and 8i databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
• Applied High priority, security patches downloaded from Metalink.
• Performing periodic backups, recoveries using RMAN, conventional hot and cold backups.
• Taking Backups on scheduled time and monitoring scheduled backups.
• Optimization and Tuning SQL queries using SQL Trace, TKPROF, EXPLAINPLAN.
• Experience with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
• Created UNIX Shell scripts for different database tasks and export/import for data transfer.
• Enabled security in creation of Database users, roles, privileges, profiles.
• Creating primary database storage structures (tablespaces) once developers have designed an application.
• Perform other regular DBA activities including schema management, space management and performance monitoring.
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data
• Database maintaining including backups, recovery, imports/exports.
• Monitoring the database daily activities.
• Created materialized views, table partition for Tuned databases.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.

Environment: IBM-AIX, Sun Solaris, Oracle 8i, 9i, RMAN, ASM, SQL, PL/SQL, UNIX Shll scripting.