SUMMARY

• More than 11 years of professional work experience in the Software Industry as an Oracle Database Administrator, Golden gate Administrator and oracle application DBA (EBS).
• Installation and configuration of Oracle database 12c,11gr2, 10gR2, Oracle 9x, 8i and RAC
• Installation and configuration of grid infrastructure and database for Real Application Clusters (RAC) 11gr2
• Implemented cluster configuration on ASM, NFS, OCFS storage
• Writing shell scripts, database scripts, Awk scripts and PERL scripts required for database maintenance, database synchronization, database refresh, database reporting, system accounting statistics, security fixing, backup and restore jobs and automation jobs
• Implemented Golden Gate Unidirectional and bidirectional replication.
• Bidirectional Streams Replication setup and maintenance.
• Experience working in various domains to deliver new products, upgrades. Resolve application problems to maintain high level ofcustomer satisfaction.
• Experience in working with huge data centers and Worked on datacenter move projects
• Experience in Oracle Server installation, configuration, performance tuning, client/server connectivity, query optimization, applying patches and backup/recovery.
• Excellent experience in various migration techniques like export/import, Datapump, backup restore, cloning, data guard.
• Installed and configured Veridata for monitoring the Golden Gate replication during the upgrade from 10g to 11gR2.
• Handled out - of-sync from source to target and vice versa through veridata.
• Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Extensive experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Experience in Maintaining Oracle Data Guard & Standby Database and providing critical solutions with Strategic disaster recovery plans with different recovery procedures and methods.
• Automated many common tasks using Crontab including Backups, Exports/Imports, archiving old records and verification of such processes.
• Experience in writing scripts proactive monitoring like monitoring the disk usage and the memory usage of the server and monitoring tablespaces.
• Hands on experience in applying patches on Oracle 9.2.0.6 and 9.2.0.7, 10.2.0.1.0 and upgraded it to Oracle 11.2.0.3.
• Good understanding of Exadata features like smart scans, HCC, flash cache, Infiniband, ILOM
• Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM), Oracle Grid Control.
• Analyzed Automatic Workload Repository (AWR), Active Session History (ASH) reports.
• Experienced in generating statistics of database using ADDM.
• Tune the SGA components like buffer cache, shared pool to avoid paging & swapping.
• Hands on experience working with different FTP clients like Smart FTP, SFTP and SCP.
• Extensive experience in supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance.
• Managing Exadata database for non-prod/prod environment.
• Performeddataanalysisanddataprofilingusingcomplex SQLon various sources systems includingOracleandNetezza
• Experience working on Netezza
• Hands-on experience on implementing, upgrading and configuring the Golden Gate software for Oracle Database.
• Extensive experience on Classical, Integrated extract and replicat.
• Extensive experience on Golden Gate Heterogeneous replication using Golden gate
• Extensive experience on Golden Gate DDL Replication
• Troubleshooting golden gate extract/replicat issues like ORA-0001, ORA-1502, ORa-2291 etc.
• Analyzed Tables, Indexes periodically to optimize the SQL queries.
• Strong Knowledge and experience of Creating Users, Public Synonyms, Database Links, roles, profiles, privileges and assigning roles to users.
• Knowledge on Amazon web service(AWS) cloud.
• Experience in Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Month end activities and database capacity planning and space management
• Extensive experience in Creation, maintenance, location, size of tablespaces, rollback segments and retention time for the flashback files.
• Proficient in SQL, PL/SQL such as Triggers and Stored Procedures.
• Developing complex shell scripts for backup, rotating logs/files, etc.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies, Strong interpersonal and communication skills.
• Configuring and Deploying Oracle Virtual Machine 2.X and 3.x for Linux.
• Managing virtual machines, server pool, resources etc.

TECHNICAL SKILLS

RDBMS: Oracle database 9i, 10g, 11g and 12c

APPLICATIONS: Oracle 11i (11.5.8 to 11.5.10.2, R12.)

GOLDENATE: 11.x,12.x etc.

Languages: SQL, PL/SQL, UNIX Shell Scripting

Oracle Tools: Oracle Applications Manager, Oracle Enterprise Manager, TOAD, OUI, RMAN, ASMCMD, TKPROF, autoconfig, adadmin, adpatch, FNDLOAD,, STATSPACK, Logminer, SQL Loader, AWR report, Server control Command Line (SRVCTL), Data guard Broker Command line (DGMGRL), Golden Gate, Stream/Xstreams and ADE, GGSCI, Oracle Virtual Machine 2.X and 3.x, nodetool.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,ASH, AWR, ADDM

Operating Systems: Linux, RHEL, Windows x64, Solaris Sparc64, AIX, HP-UX IA

PROFESSIONAL EXPERIENCE

Senior oracle database administrator

Confidential, Oaks, Pennsylvania

Responsibilities:

• Administrated and created production, development, and testOracle 12c/11gdatabases hosted on Linux Server.
• Created Oracle Real Application Clusters RAC/Grid 11g on aix/Linux with SCAN and ASM
• Defined database migration strategy to relocate production database to new Linux servers.
• ConfiguredOEM 12cmonitoring .Created rules to send out mission critical alerts from production database.
• Backup and recovered test and development databases using RMAN and DataPump.
• DefinedOracle11gupgrade strategy for production, development, and test databases.
• Measured the performance of the shell scripts by getting the expected results.
• Installed and configured10g/ 11g RACdatabases withASM/non ASMon Linux servers
• Upgraded database from 11g to 12c bothRAC and Non RACincluding Standby databases.
• Supported failover and switchover ofStandby DatabasesduringDisaster Recovery
• Created and maintained Databases and their objects like tablespaces, tables, indexes, views.
• Experience in10g RAC and 11g RAC configuration, maintenance and support.
• Experience inOracle 11g/12c Real Application Clusters RAC, Oracle Data Guard, Oracle Automatic Storage Management ASM .
• Migrated Stand alone databases on file system toRAC databases on ASM.
• Appliedpatchesregularly on Oracle 11g/10g Clusterware and RAC databases.
• Installed, setup and configured Oracle Enterprise Manager Cloud Control 12c for administration, performance tuning, monitoring and alerts.
• Added and deleted RAC nodes as per the application requirement .
• Worked on major issues involving 10g/11g databases on 11g R2 Grid/RAC and 11g ASM.
• Configured ASM Cluster File System ACFS for 11gR2 Grid/RAC cluster.
• Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities.
• Configured RMAN backups on tape forTSMfor both test and production databases.
• CreatedRMANscripts for daily as well as monthly backup's using autosys.
• Worked on variousRmanscripts for taking full backup and incremental backup for production databases .
• Wrote several scripts to automate cloning of database from production to test throughrmanon weekly basis.
• Performed Database cloning usingDatapump, Rman Duplicate and Cold backup restore.
• Partitionedappropriate tables to optimize performance and simplified maintenance work.
• TunedandoptimizedSQL Query, SGA, Disk I/O using Oracle Enterprise Manager and by monitoring theAwrreport generated from snapshots taken at the peak business hours.
• Monitoredand tuned rollback segment, temporary tablespaces, redo log buffer, sort area size.
• Added a node at the RDBMS layer in aRACEnvironment
• Created multiplestandby databases and Set up Snap shot standby database using data guard broker.
• Supported disaster recovery by opening the standby databases inread writemode .
• Set up scripts to monitor log apply onStandby Database.
• RebuiltMultiple Standby databases 10G and 11G
• Created numerousMaterialized view groupsinvolving huge tables.
• Worked onPerformance tuningwith AWR, ADDM, SQL Tuning advisor, SQL Trace and TKProf.
• Experince in Database design on OLTP and OLAP databases and maintained database security create and maintain users and roles, assign privileges .
• CodedBASH,PERLscripts to maintain database change management and data management .
• Coded BASH,PERL scripts to automate backup and recovery procedures for various versions of database.
• WORKED ON Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports
• Tuned database/cluster/ASM according to application requirements.
• Tuned long running queries by tk prof and explain plan and hints.
• Worked on all types of partitions .Set up partition strategy involving tables with million of rows to improve performance.
• CreatedHash, Rangepartitions on huge tables and worked on Partition pruning on SQL.
• Worked onGoldenGate Replicationand Configured Extract, Replicate processes for GoldenGate.
• Installed database for Siebel replication usingGolden Gate11g

Environment: Oracle 11GR2, 10gR2, 9x, SQL, PL/SQL, Golden gate 11x, Sun Solaris, Red Hat(RHEL), OEM, and RMAN, RAC, OCFS, CRS,ASM, Shell Scripts, Net Backup, NAS, ZFS.

Senior oracle database administrator

Confidential, San Francisco, California

Responsibilities:

• Supporting more than 4500 databases including development/production for 24/7.
• Worked on multiple client environment including Eikon, Tax & accounting, Financial, banking, Cobalt, Content and analytics, state and county health agencies and other home Confidential providers etc.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on Oracle Linux 6.
• Implemented Data guard, creating both Logical and Physical Standby databases in 11g RAC environment for the Production databases.
• Implemented golden gate bi-direction replication.
• Install, configure and provides technical support for Oracle 11g Release 2 RAC databases as well as non-RAC databases.
• Configured OEM 12c enterprise manager cloud control and upgraded various 10g agents to 12c agents.
• Involved in Applications 11i and R12(12.1 & 12.2) administration including 11i and R12(12.1 & 12.2) Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Worked on GIT to pushing the shell scripts/SQL scripts to the central repository.
• Capture, Propagation, Apply using Golden Gate and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Viewing the out-of-sync summary report from Oracle GoldenGate Veridata web interface and fixing the out-of-sync records
• Performing responsibility as Oracle Exadata Machine Administration.
• Oracle10g/11g Migration From Non exadata to Exadata DB with or without GoldenGate.
• Extensively developed PL/SQL Packages, Procedures, Functions, Triggers, and Sequences for implementing the business rules
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump. Used AWR reports to monitor the database performance.
• Perform Backup and Recovery thru RMAN.
• Tested the initial data load option of Golden Gate during the environment build.
• Refreshed multiple databases for Development and Testing upon short request.
• Oracle services have been used to configure Golden Gate high availability for the RAC nodes.
• High availability of Golden Gate is achieved by creating Golden Gate vips and services for RAC databases. If one node is failed Golden Gate automatically failovers to the other node.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 12c.
• Good understanding about histograms, cluster factor.
• Performed Export/Import through Data Pump.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 11g AWR & ADDM to monitor database activities and understand the db wait events, optimizer .
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases.
• Upgraded from 10g to 11gR2 with Golden Gate as the downtime is very less, also configured extract and replicat features.
• Installed and configured Veridata for monitoring the Golden Gate replication during the upgrade from 10g to 11gR2.
• Knowledge on Developer BI(business intelligence) & Analytics
• Viewing and generating report through Business intelligence.
• Closely worked with data services team in establishing backup, data retention, data archival policies and performance tuning ofNetezza
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Netezza
• Created Wallet on RAC databases.
• Configured Oracle Data Guard and Streams.
• Monitoring Cassandra database and identifying the Tombstones and fixing the issues.
• Providing the best performance tuning tips to Cassandra application team.
• Worked on GIT for updating the code changes and also knowledge on Jenkins, Puppet/Chef.

Environment: Oracle 11GR2, 10gR2, 9x, SQL, PL/SQL, Golden gate 11x, Sun Solaris, Red Hat(RHEL), OEM, and RMAN, RAC, OCFS, CRS,ASM, Shell Scripts, Net Backup, NAS, ZFS.

Senior oracle database administrator

Confidential, San Diego, California

Responsibilities:

• Installation, maintenance and tuning of RAC and standby databases OLTP,DSS and Data Warehousing using customized shell scripts .
• Creating ASM instance/maintaining ASM (adding, removing disk to disk group etc)
• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP, warehouse, and business object repositories.
• Applied patches to Oracle Databases.
• Upgrading development and production databases to Oracle 11gR2.
• Proactive database monitoring using 11g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
• Extensive Performance Tuning, Memory (SGA) Tuning.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• Setup Golden Gate parameter files for extraction and replication.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Recovering GoldenGate corruptions.
• Viewing the out-of-sync summary report from Oracle GoldenGate Veridata web interface and fixing the out-of-sync records
• Performed other DBA activities like including space management and performance monitoring.
• Analyzing the db wait events from the awr/ash report and take necessary action.
• Replicated Data using Golden data for encrypted columns (Wallet).
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.
• Experience in installation of Cassandra on 16-node cluster
• Good understanding of Cassandra architecture like gossip, snitch, seed node, anti entropy, partition key, hash value, etc.
• Experience in monitoring and tuning Cassandra clusters, performance and capacity
• Experience in nodetool for managing a Cassandra cluster

Environment: Oracle 11GR2, 10gR2, SQL, PL/SQL, Golden gate 11x, Red Hat Linux (RHEL), OEM, and RMAN, RAC, OCFS, CRS,ASM, Shell Scripts, Net Backup, NAS, Exadata, Cassandra

Senior database administrator

Confidential

Responsibilities:

• Configuring Golden gate one-way, 2-way and multi-way replication across the cross version.
• Configuring Golden gate replication from consolidated database to NON-CDB.
• Configuring Golden gate replication from older version of database to 12c database.
• Reviewing Test results, Debugging, logging and closing bugs.
• Effectively coordinating with development teams for clarification on issues and supporting bugs.
• Architected created design plan for cross platform migration and upgrades for 10gR2 to 11gR2
• Installation of 11gR2, two node RAC cluster
• Installation and configuration of physical, snapshot, active data guard for DR
• Implemented process for large volume of data archived using data pump to external location
• Installed and configured 11gr1 Golden Gate, configured unidirectional reporting instance
• Implemented and applied required patch set to 11gR2 and 10gR2 databases
• Proactively monitors database system performance and availability across multiple platforms.
• Performed problem solving and troubleshooting on all database issues
• Implemented backup and recovery strategy using RMAN utility
• Developed and establishes policies and procedures governing the use and maintenance of company's database assets
• Developed sql, pl/sql and shell script for maintenance of databases
• Designing, developing and execution of Test cases.

Environment: Oracle 12x, 11GR2, 10gR2, SQL, PL/SQL, Golden gate 11x, Steams, Xsteams, Red Hat, Solaris, AIX, Windows, OEM, and RMAN, RAC, OCFS, CRS,ASM, Shell Scripts, Net Backup, NAS, Exadata.

Senior Member Technical Staff

Confidential

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installing 9i, 10g and 11g databases on SOLARIS and HP-UX
• Migration of Database from 9i to 10g and applying patches whenever required.
• Upgrade of Databases from 10g to 11g
• Installed and configured Oracle 10g/11g RAC high availability
• Installation of Oracle cluster ware, Configuring public and private network and VIP
• Experienced with SRVCTL, OCR and Voting Disk of 10g/11g RAC
• Developing and Implementing Disaster Recovery (DR) Plan.
• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose
• Monitored and effectively tuned the 11i database instances by utilizing own scripts,
• Precise In depth for Oracle and the Statspack utilities.
• Experience in ETL tools for extraction and data transformation.
• Daily Health Check Up of the Database
• Database cloning from Production to Test and Development environments
• Configured and maintained huge OLTP databases
• Monitoring Table spaces and extent Growth
• Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Monitoring and troubleshooting SAN related issues
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Job scheduling using crontab
• Creation of database maintenance plans, rebuild indexes and integrity checks
• Implemented RMAN Backups, Creation of catalog database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups using RMAN
• Ensure high availability of Databases at all time.
• Support migration and loading of data into oracle database using SQL*Loader
• Performed and scheduled re-orgs
• Generated out-of-sync summary report from Oracle GoldenGate Veridata web interface and fixing the out-of-sync records
• Provided support on performance issues during project development resulting in improved response times and reduced contention
• Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management
• Created Users, Roles and Managing Security & Concurrent Managers administration.
• Fixing Printer Issues, Setting Profile Options, Creating &Assigning Responsibilities.
• Writing UNIX shell scripts for backup and recovery, Import and export procedures

Environment: Oracle 9i/10g/11g RAC, OEM, RMAN, HP-UX, Sun Solaris

Oracle Application Database Administrator

Confidential

Responsibilities:

• Installation of 11.5.9 applications
• Cloning of 11.5.9 using hot backup and cold backup.
• Applied 11.5.9 Oracle E-Business Suite Consolidated Update 2
• Applied India Localization patch(IN60107), Applied Form personalization patch(3358850),Applied AD.I.6 patch
• Upgrading database from 9.2.03 to 9.2.0.7
• Created Additional customization Tops
• Registered Custom Applications, Compilation of Forms.
• Registered Custom forms, Menus.
• Created Concurrent Request Groups.
• Export and import of database objects( China ERP to India ERP)
• Installation of Report Designer.
• Load the Concurrent programs, Request Groups, Menus from China ERP to India ERP using FNDLOAD
• Installed oracle 9.2.0.1 on Windows server 2003 sp2
• Monitoring database and applications (Tablespace growths, table lock, kill the locking session, Analyzing tables & index, concurrent managers etc…)
• Applied patch bugs fixes
• Schedule the automatic hot backup of database using Crontab.
• Managing cold backup, hot backup &Archive log files.
• Configured work flow notification mailer
• Created database link from oracle database to Anyware SQL and Ms Access
• Created database link from India ERP to Korea ERP
• Monitoring database using TOAD
• Registering Concurrent programs to Request group using DATALOADER
• Co-ordinate with functional Consultant, Developers, IT support Team and End users

Environment: 11GR2, 10gR2, SQL, PL/SQL, EBS (Oracle Applications) 11x, Red Hat, Solaris, AIX, Windows, OEM, and RMAN, OCFS, Shell Scripts.