SUMMARY

• Nine (9) years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 10g, 11g and 12cwith experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 10g, 11g and 12c in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Having hands on experience in management and database administration of Oracle applications on Exadata platforms.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• Good working experience with Container databases or Pluggable Databases (PDBs).
• 24*7 production database support with Support to developers & end-users.
• Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Experience with High Availability features (RAC/ DG/ ASM / RMAN).
• Excellent knowledge in logical backups,Hot/Cold Backup and Recoveryand Cloning of databases usingRMAN.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Good exposure to oracle technologies likeAWR, ASM, Flashbackand data pump import/export.
• Expert in implementing ORACLE STREAMS and Golden Gate 11x (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Having hands on experience in working with MS SQL 2008.
• Having hands on experience in installing and configuration of Enterprise Manager Cloud Control 12c.
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, Tuning heavy data loads, Monitoring and Performance tuning.
• Having knowledge on the ORACLE EXADATA for the extreme performance of the database.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having programming experience in stored procedures, functions, triggers and scheduled jobs.
• Having hands on experience in supporting Oracle EBS implementation.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMANwith VERITAS Net Backup.
• Experienced in usingOracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, 10g, 9i, SQL Server 2000, 2005

Oracle Products: Golden gate, Streams, Oracle (Grid Control), OEM (Oracle Enterprise Manager), Oracle Fail-Safe (OFS), RMAN, SQL*Loader, DATA PUMP, APEX, ASM, Oracle Measurement Toll (OMT).

Programming Languages: SQL, PL/SQL, JAVA, C, C++

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP Professional, Windows 2003 Professional.

Other Tools: VERITAS Cluster Manager (Java Console) v3.5, TOAD, Erwin, Putty, Oracle Streams, Quest Share Plex, Rational Suite-Clear Quest, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Sr. Oracle DBA

Responsibilities:

• Installed Oracle 10g/11g and RAC (4-node) systems, 11g, 12c OEM in HA environment on different OS platforms (IBM AIX, Linux, Solaris 10.0, RHEL and VMware).
• Responsible for providing 24X7 production support for critical Payments, Financial, and connectivity applications’ Oracle 10g/11g/12c databases on Solaris and RHEL.
• Installed Oracle 10g/11g/12c stand-alone and RAC systems in HA environment in different O.S platforms (AIX, Linux, Solaris, RHEL and VMware).
• Configured 11.2.0.4 RAC on 3 node cluster.
• Worked on upgrading RAC database from 11.2.0.4 to 12.1.0.2
• Good working experience with Container databases or Pluggable Databases (PDBs).
• Worked on upgrading RAC database from 11.2.0.3 to 11.2.0.4.
• Migrated Non-ASM Single Instanceto ASM RAC Instance.
• Experience with Change Management for all the database changes.
• Migrated oracle databases from oracle streams to oracle golden gate 11x Active-Active Bi-directional replication.
• Installed OGG 11.2 version on Linux and Solaris Boxes and configured High availability VIPs / XAG for the same.
• Assisted in designing and analysis of Oracle Exadata server for infrastructure and in other similar projects
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Configured the Database level Heart beat tables for Golden gate monitoring and deployed DBMS schedulers to check the latency over the sites.
• Improved performance of REPLICAT process using Range functions in Golden Gate and used some Macros and Tokens in GG.
• Experience in supporting Oracle EBS implementation.
• Experience in handling large database up to 14TB in size with 4 nodes cluster on various flavors of UNIX.
• Resolved Replicate/extract/pump issues and upgraded classic EXTRACT to Integrated capture to overcome the compression table’s issue.
• Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages
• Experience in Managing Applications on oracle 11g / 10g RAC databases using ASM file system with server control utility (SRVCTL) and CRSCTL for high availability.
• Configured high availability services TAF, load balancing and SCAN features for clustered databases.
• REFRESH/CLONING of Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.
• Hands on experience with 11g new features such as ADRCI, Duplicate from Active database, ASMCMD, Memory parameters, Incidents etc
• Implemented various backup strategies for big / med and small databases using RMAN and Netbackup technologies
• Installed, configured Oracle 12c grid infrastructure for standalone &RAC databases
• Upgraded Oracle 9i/10g to the Oracle 11g R2 database version.
• Responsible for identifying performance problems in production databases by identifying issues using AWR, ASH and ADDM reports.
• Applied CPU security patches and PSU in both RAC and standalone systems in ASM environment.
• SQL Query performance tuning for optimized results using tools like Explain Plan, SQL TRACE, TKPROF, SQL Profiler
• Good experience with Oracle performance issues in both application tuning &memory tuning.
• Worked on SAN/NAS storage migration
• Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.
• Experience working with Oracle Enterprise Manager, working with ASH, AWR reports, ADDM, STATSPACK and gathering statistics.
• Performed database refreshes using KFED and cloned production databases for the purposes of testing using RMAN
• Developed shellscripts for daily administration.
• Responsible for day-to-day activities such as creating users, roles, schemas, tables, views, indexes, verifying and running scripts given by the clients
• Worked as a primary for weekly and monthly releases and coordinated with application teams and development teams in release window times.
• Configured and managed Data Guard extensively for Production databases of sizes ranging from 50 GB to 5 TB.
• Closely monitored and administrated log transport services and log apply services in Physical/Logical databases.

Environment: Solaris 10, RHEL, Oracle Database Version 10g/11g/12c, RMAN, Data guard, RAC, Streams, Golden gate, ASM, ACFS, Oracle Enterprise Manager Grid Control 12c, MS SQL 2008.

Confidential, Milwaukee, WI

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on IBM-AIX nodes.
• Configured 11.2.0.3 RAC on 3 node cluster.
• Worked onupgradingRACdatabase from 11.2.0.3 to 11.2.0.4.
• Worked as a part of team in Data Center Migration project for 6 months.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• We have converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
• 24x7 remote support and on call Database support for Database developers & end-users.
• Experienced in implementing Oracle Database advanced security practices.
• Implemented Streams replication between RAC and non RAC database environments.
• Successfully configured and installed Oracle Golden Gate for replication.
• Improved performance of REPLICAT process using Range functions in Golden Gate and used some Macros and Tokens in GG
• Helped in developing applications based on Oracle Exadata platforms.
• Maintained the Heart beat tables to check the lag between the sites.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c on RHEL.
• Worked with application team to resolve conflict handlers and trouble shooted the replication issues.
• Experience in cloning RAC databases using RMAN tool.
• Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.
• Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.
• Writing and modifying UNIX shell scripts manage Oracle environments and for Backend Oracle Processes.
• Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases. Organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and audit ability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Logical and Physical Database Modeling using CA Erwin 4.1.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and SchedulingOracle Backend Process Jobs in Crontab.
• Cloning&duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Applying security patches both Server side and Client side and Performed testing.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.

Environment: Red Hat Linux 5.0, Oracle 10g, 11g and 12c, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, ASM,, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Confidential, IL

Sr. Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle10g database.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes10g.
• Installation, Upgrade and Configuration of Oracle 10g Database.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refreshin Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10gRelease 2.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
• Performed conversion single instance to Real Application Cluster (RAC) database instances.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink)

Environment: Red Hat Linux4, Oracle10.2.0.3, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1.

Confidential, Raleigh, NC

Oracle DBA

Responsibilities:

• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• 24x7 Production database administration, support and monitoring to ensure a proactive problemrecognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Oracle Grid Control Management Server Installation.
• Used transportable tablespaces (TTS) to move the data Oracle on a different platform and also much faster than performing either an export/import or unload/load of the same data.
• Implementation of 10g Data Guard and Bi-directional streams implementation.
• Handling large database environments using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges, Roles,
• Implemented Veritas Net Backup-using RMAN (Recovery Manager) as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Worked with production DBA team in perfect coordination with seniors and team members.

Environment: Oracle database 10g (10.1.0.5 to 10.2.0.4), 9i (9.2.0.8), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
• Modified Korn shell scripts as per technical specifications.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Involved in coding of data extraction scripts as per technical specifications.
• Analyzed the table structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIXshell script CRON UTILITY.

Environment: Oracle 9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.