PROFESSIONAL SUMMARY:

• 8+ years of experience in Oracle database administration in Linux, UNIX and Windows platforms. Experience include Installation, Configuration, Upgrades, Space Management, System maintenance, Cloning, patching, data replication, Database security, Troubleshooting database design, Performance Monitoring, Tuning, Backup and Recovery and also includes RAC, ASM, Data Guard, Golden Gate, Data Pump and Grid Control experience.
• Excellent experience in Installation and configuration of Oracle 12c, 11g, 10g, 9i in UNIX/LINUX and Windows environment.
• Upgraded Databases from 9i to 10g and 10g to 11g on various platforms, Managed Databases in the range from 50GB to 3TB.
• Proficient in Database administration activities such as user management, space management, Monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.
• Worked on Performance optimization of large objects (LOB, BLOB, CLOB) by monitoring redoes generation, increasing log buffer size, blocksize and changing archiving procedures and Query tuning using Statspack, TKPROF and OEM.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, SQL TRACE, EXPLAIN PLAN for the better performance.
• Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH etc)
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
• Experience in taking backup and performing recovery.
• Experience in performing point in time recovery at times of necessity.
• Design and implement backup and recovery including disaster recovery structures.
• Installation, Configuration and Maintenance of Oracle 9i/10g/11g RAC on two node and four node configurations.
• Designed and implemented Oracle Real Application Clusters (RAC) on Linux for an OLTP application with Transparent Application Failover.
• Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
• Experience in conversion of SingleNodeInstance to multinodeRAC with ASM, and adding instance to existing RAC.
• Experience in Migration of Oracle Databases from non - RAC to RAC and non-ASM to ASM Instances.
• Experience in Real Application Clusters(RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management(ASM).
• Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.
• Experience in maintaining Data Guard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control.
• Experience in using Golden Gate to support data replication monitoring, tuning and capacity planning.
• Experience in bi-directional and broadcast replication from source to target databases using Golden Gate 9.5 and Golden Gate 10.0.
• Implemented data load by replication methods like Materialized views, Golden Gate from OLTP systems into data warehouse databases.
• Experience in recovering Golden Gate corruptions and managing cluster maintenance mode blackouts.
• Performed Export/Import through Data Pump, worked with data pump to take the logical backups of databases.
• Installed, configured and updated EXADATA machines.
• Implementation of Flashback Technology.
• Experience in Implementing Streams, Data Pump, Export and Import Utilities.
• Good experience in resolving issues related to installation, upgrades and patches.
• Applied Patch Set Updates to 10g and 11g oracle databases.
• Excellent troubleshooting skills in OS level and Database level.
• Worked with development and operations staff in resolving problems quickly and efficiently.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer.
• Familiar with Data Mining and OLTP concepts and ASM.
• Experience in UNIX shell programming.
• Strong skills in SQL* PLUS, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc.
• Exposure to several industry sectors - Finance/Mortgage, Internet/Web advertising, Telecom, State, Retail, Power, Banking/Credit card processing, Federal and Manufacturing.
• Possess good leadership, excellent communication and time management and presentation skills with excellent technical, analytical, interpersonal, problem solving and organizational skills.
• Expertise in leading the teams for maintenance of 24X7 high-availability applications and databases.

TECHNICAL SKILLS

Database Utilities: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), Automatic Storage Management(ASM), SQL,TOAD, Data Pump (expdp, impdp), Query Analyzer, SQL*Plus, SQL*Loader, Golden Gate, Toad 7.6/7.5/10, SQL Developer

Databases: Oracle 8i, 9i, 10g,11g, 12c,RAC 11gR1, RAC 11gR2, Data Guard 9i/10g/11g.

Tool/Utilities: STATSPACK, EXPLAIN PLAN, Oracle Enterprise Manager 10g/11g/12c,Sql Developer, Putty, Super Putty

Operating Systems: Windows NT/2000/2003/XP, Red Hat Linux 7.x/6.x/5.x,HP-UX,AIX 4.3x/5.1/5.2,Sun Solaris 8/9/10

Programming: SQL,PL/SQL,MYSQL,C,C++,UNIX shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Goldengate Administrator / Oracle DBA

Responsibilities:

• The primary OracleGoldengate(OGG) resource to manage a very complex OGG enterprise infrastructure in collaboration with theDBAteam
• Installed and configured Orcale Goldengate 12c version on DEV/TEST/UAT/PROD instances.
• Good Knowledge on debugging and troubleshooting the goldengate issues.
• Involved in database troubleshooting and maintenance activities and solved GoldenGate issues such like abended, lagging, long transaction issues.
• Installed and configured of GoldenGate on 11g/12c database for data replication.
• Resolved the issues in conflicts between the target and source database in GoldenGate.
• Implemented GoldenGate to replicate data and keep databases sync until the time of cutover.
• Good Experience in Configuring GoldenGate Integrated Capture, Integrated Replicat and converted Classic Capture to Integrated capture and Classic Replicat to Integrated Replicat.
• Worked on GoldenGate utility like ggsci, logdump, defgen for troubleshooting issues, investigate replication failures using ggserr.log, report files and Performed data replication on Oracle database using GoldenGate.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Creating Views/Indexes/Synonyms on DEV/TEST/UAT/PROD instances.
• GoldenGate Downstream capture setup and Performance tuning of GoldenGate processes to achieve zero lag time.
• Developed Shell scripts for monitoring GoldenGate processes.
• Proficiency with Installation and maintenance of replication toolGoldenGateby creating extract process, extract pump, and replicat, troubleshootingGoldenGateEXTRACT and BIDIRECTIONAL REPLICAT issues.
• Handy in implementing CDR parameters inGoldenGate, Implemented Uni-Directional, Bi-directional replication usingGoldenGateand reviewing the error logs and troubleshooting abend scenarios inGoldenGatewith error reports and ggserror.log.
• Cross Platform Datacenter Migration and Upgrade and migrations from Oracle 11g to Oracle 12c and Performed cross platform migrations using Datapump andGoldenGate.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.
• Worked on Out of sync issues ingoldengateand used CDR parameters in bi-directional replication and resolved conflicts ingoldengate.

Environment: Oracle 11gR2, 12c, RHEL 6.x,5.x, RMAN, Datapump, OEM Grid Control 12c, Golden Gate 12c, Data Guard, TOAD.

Confidential, Mountain View, CA

Sr. Oracle DBA

Responsibilities:

• Supported 500+ databases including RAC production database, a Dataware house database and a lot of Development and Test databases and upgraded from 10g to 11g.
• Provided Production & Test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Playing vital role in streamlining all the databases on AIX, HP-UX, Linux, Solaris.
• Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX 6.1.
• Performed conversion of SingleNodeInstance to MultiNodeRAC with ASM, and adding instance to existing RAC.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Responsible for PerformanceMonitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
• Monitoring database performance and database operation to prevent downtime and slowness of the services.
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata servers.
• Migrated all the RDBMS database to EXADATA machine.
• By using EXADATA provided support to a combination of database system such as OLTP and OLAP.
• Wrote shell scripts for automation of tasks and used shell scripts with crontab for job scheduling.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Involved in architecting the environment requirements for the project, hardware provisioning, instance strategy, patching strategy.
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Troubleshooting Space Management & User accounts and privilege issues while coordinating with Unix and application teams.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shellscripts for automation of day to day activities.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
• Regular SecurityPatching and Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interimpatches for various bugfixes on database products.
• Production support for Oracle database 10g/11g RAC.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Expert in monitoring database using Oracle Enterprise Manager (OEM).

Environment: Oracle 11gR1, 11gR2, 12c,RHEL 6.x, IBM AIX 6.1,RAC, ASM, RMAN, OEM Grid Control 12c, Golden Gate 10.0, Data Guard.

Confidential

Sr. Oracle DBA

Responsibilities:

• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Installation and creation of 10g, 11g Databases for Development, Quality and Production environments and upgraded from 10g to 11g.
• Created 10.2.0.1 and 11.2.0.2 databases for Testing, Development and Production on Solaris 9.
• Used Data pump for faster export/import of data in various DEV/TEST/UAT environments.
• Performing all daily Maintenance tasks including scheduling backup jobs, monitoring job failures and troubleshooting RMAN backup job failures and interacting with Oracle Customer service when required.
• Upgraded and applied CPU patches and bug fixes as and when required and performed database refresh from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Worked on configuration of Oracle 10g RAC environment and troubleshoot performance problems.
• Responsible for Collecting and analyzing performance statistics for resource consumption and performance anomalies. Managing Tablespaces, Datafiles, Rollback segments, Temporary TBS.
• Used EXPORT/IMPORT to do table level and full database imports as per application team requirements.
• Implemented Streams replication between multiple Production databases (10.2.0.1)
• Developed materialized views for reporting purpose in Oracle 9i, 10g.
• Installed, configured and maintained Oracle 10g Real Application Cluster (RAC).Production support for Oracle database 10g/11g RAC. ASM and CRS installation and new database creation for 10g RAC.
• Performed Exadata for OLTP database systems.
• Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to be run.
• Used RMAN for incremental and cumulative backup/restore.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Designed GOLDEN GATE data bases to meet business uses.
• Experience in recovering GOLDEN GATE corruptions and managing cluster maintenance mode blackouts.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Responsible for user and session management.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.

Environment: Oracle 10g/11g, Sun Solaris 9, TOAD, Oracle Standby databases, RMAN, Hot backups, Real Application Clusters (RAC) or High Available Databases, Export/Import, Data Pump, Oracle Streams.

Confidential, Raleigh-Durham, NC

Sr. Oracle DBA

Responsibilities:

• As Production DBA, managed all database issues including database capacity, backup & recovery, scripting and Performance tuning.
• Worked as team member to provide 24/7 on call production database support.
• Supported and maintained multi-terabyte high transactionalOLTPRAC-enabled database.
• Implemented Upgradation and Migration of Database’s from 10.2.0.5 to 11.2.0.1 and applying patches whenever required.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• ASM Setup and maintenance on RAC databases.
• Used RMAN for backup and recovery.
• Configured and managed Data Guard for Production databases.
• Installed and configured Oracle 11g RAC, developed 2 node RAC environments for a 25TB database by implementing WAN technology to reduce the network traffic.
• Responsible for Installing, configuring and maintaining Oracle Grid Control (10g grid).
• Responsible for regular Security Patching on Oracle Products and interim patches for various bug fixes on database products.
• Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
• Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Installed, configured and supported uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Monitoring of database using Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plans, SQL Trace.
• Regularly monitoring the Production databases using OEM 11g Grid control.
• Applied Consolidated Update, Critical Patch Update (CPU’s), Security alert patches using Opatch.
• Monitor and tune database performance including SQL tuning.
• Implement complex enterprise changes as they pertain to the database environment.
• UNIX Shell scripts for monitoring the processes, sessions, transactions on Production RAC database after migration.
• UNIX shell scripts for partition splitting.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.

Environment: Oracle databases 10g/11g, Sun Solaris 5.9 and 5.10, Linux, Windows, TOAD, OEM 11g grid control, Datapump, Exp/Imp, Metalink,PL/SQL, SQL*PLUS, Oracle RAC, Data guard.

Confidential

Oracle DBA

Responsibilities:

• Responsible for, both manage and support 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.
• 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 alertlog, trace files.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Point in time recovery using RMAN.
• Used oracle configurationassistants 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, TNSnames etc.
• Standby database setup via 10g data guard for database DisasterRecovery.
• Implemented shell scripts to reduce the time for large code movements during cut over tasks.
• 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.
• Effective in gathering the statistics for pinning the objects. Resolving listener and tnsnames.ora issues.
• SQL Server production database support & Troubleshooting SQL Server 7.0, 2000, 2005,2008(R2), versions. Supporting high volume OLTP databases over 2TB; & OLAP 5TB
• SQL Server services Installation, applying Service pack and Patches/updates to fix bugs
• Created custom DBA script using DMVs, system tables for database management.

Environment: Oracle 10g/11g, IBM-AIX, HP-UX, Windows 2000, RMAN, PL/SQL, Shell Scripting, exp/imp, SQL, SQL/PLUS.

Confidential

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i and 10g databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
• 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.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refresh in 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 Table space point in time recovery (TSPITR) using RMAN.
• Implemented Streams replication between RAC and non RAC database environments.
• 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 10g Release 2.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack.
• 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.
• 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.
• Experienced on Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, SQL*Net and IMPORT/EXPORT
• Involved in development of Triggers and handled packages.
• Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Experience in 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.

Environment: Oracle 9i/10g, HP-UX 11, Red Hat Linux4, Windows 2000/2003, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.1.