OBJECTIVE:

Seeking a challenging position in database administration or Datawarehousing in Oracle 9i/10g/11g/12c with an opportunity for professional growth.

PROFESSIONAL SUMMARY:

• More than 21 years of IT experience in software development out of which 19 1/2 years as Oracle DBA. RAC expert (installations, upgrades, performance issues, resolving RAC specific issues). 6 years experience in Goldengate administration and configuration
• Worked as Oracle consultant ( Advanced Customer Services)
• Database administration of Oracle 8.x/9i,10g,11g,12c on Sun Solaris, AIX, HP - UX, Linux, TRU-64 and Windows
• Database Design, Database backups, Performance tuning (OLTP as well as DSS)
• Configured Real Application clusters both on Oracle 9i/10g/11g and 12c including RAC-ONE databases
• Extensive SQL tuning. Very much familiar with all the new features of SQL for 9i/10gR2/11gR2/12c
• Explain plan,Tkprof, PL/SQL(stored procedures, functions, triggers, ref cursors, object tables etc)
• Provided 24X7 production support for all database operations including ETL
• Configured Oracle streams both in Oracle 9i, 10g and 11g and administered using Oracle Enterprise Manager on RedHat Linux
• Configured Standby database in Oracle8i and Dataguard in Oracle 9i,10g, 11g and 12c and administered including on real application clusters
• Compressed tables, partitions and indexes to improve the performance as well as save the storage
• Implemented oracle security using Virtual Private database, Label security,OID
• Upgraded Oracle databases from 9iR1/9iR2/10gR2 to 11gR 2/ 11.2.0.2/11.2.0.3 /12 c with dbua and manual upgrade
• Very much comfortable with Oracle 10g/11g/12c new enhancements like Automatic Storage Management, Automatic database diagnostic Monitor and SQL Tuning Advisor, Automatic Workload repository, Automatic Segment Management, Automatic shared memory Management, Scheduler, Flashback Table, Flashback Versions query, Cluster Synchronization Services etc.
• Using new RMAN enhancements to optimize Oracle backup and recovery at all levels
• Used Oracle 10g/11g Datapump for data transportation at various levels
• Upgraded the Oracle portal from 9iR2 to 10gR2
• Developed strategy to encrypt secure data
• Involved in Oracle applications administration
• Extensive experience with Disaster recovery of database in various scenarios
• Oracle application server 9AS/10AS
• Tuning .NET applications like SQL, stored procedures, database connections
• Followed SOX security standards
• Analyzing the various wait events and tuning them
• Developed testing strategy for load balancing, data loads, failover etc
• Implemented Advanced security Options(Transparent data encryption, Data masking, FGAC, Roles etc)
• Implemented Fine grain auditing
• Managed Oracle change Data Capture
• Configured Oracle name servers for Oracle net
• Managing multiple databases using Grid Control
• Installation of Grid Control on OMS servers and Database servers
• Installed and configured Oracle internet directory(OID)
• Monitored SQL Server, VMware, F5, netapp from OEM grid control
• Configured Oracle net with OID integration
• Developed scripts to archive various log and trace files( Database and Informatica)
• Developed online table and index reorganizations with minimal downtime and minimal impact on database
• Developed very efficient database statistics collection process (database, dictionary, system)
• Applying all quarterly CPU(critical patch update)s and psu(Patch set update)s
• Installed and created 12c databases and configured container databases and managed them
• Enhanced database stats collection with 11g/12c new enhancements
• Improved data migration performance with 12c datapump enhancements
• Configured 12c in database archiving and resource managers for pluggable databases
• Restored individual tables/partitions with 12c RMAN
• Configured OLS
• Developed provisioning process using 12c OEM for installing 12c GI, RAC-ONE RDBMS and create CDB/PDBs
• Extended the existing clusters to add third node and resolved the issues
• Explored 12c features like dbms radact and flashback of pluggable databases
• Developed provisioning process using 12c OEM for installing 12c GI, RAC-ONE RDBMS and create CDB/PDBs
• Extended the existing clusters to add third node and resolved the issues
• Upgrading 12c OEM(12.1.0.5)
• Installed Goldengate on ACFS/DBFS(Exadata) in cluster environment
• Configured HA for goldengate both with crsctl script and bundled agent(agctl)
• Configured HA for goldengate in RAC-One and dataguard with agctl
• Installed and configured jagent for monitoring Goldengate with OEM
• Installed Goldengate plug-in in OEM and configured notification for alerts
• Patched Goldengate and monitoring agent
• Installed Goldengate plug-in on 12c OEM and patched it
• Configured VIP for Goldengate high availability
• Installed and configured Goldengate for Oracle, SQL Server and DB2
• Configured the goldengate Replication from Oracle to Oracle, SQL server to Oracle and Oracle to DB2
• Implemented the best practices for Goldengate configuration and error handling
• Tuned the Goldengate replication both on source and target databases
• Developed very efficient conflict resolution strategies in active-active Goldengate replication
• Configured application segregation, appropriate primary key generation for both sides of Goldengate replication to resolve the uniqueness conflicts
• Resolved insert and update conflicts with setup before image/Timestamp resolution and setup before image/Trusted resource
• Resolved delete and update conflicts with setup before image/QuantitativeConflict resolution
• Configured integrated capture, Co-Ordinated/multi threaded replicat, native DDL and integrated replicat
• Configured Goldengate in active-active environment
• Configured Goldengate for 12c PDBs
• Configuring Goldengate replication from Peoplesoft production database to reporting database
• Created exceptions tables for conflict resolution alerts and notifications
• Upgraded 10g databases to 11g using Goldengate with zero-down time(RMAN,TTS and Datapump)
• Configured Goldengate montoring with OEM
• Developed shell scripts for lag monitoring
• Configured Goldengate HA in RAC-One and also in dataguard
• Installed 10gR1/R2,11gR1/R2/12C CRS on AIX, Linux, HP - UX, Solaris and Windows
• Configured SCAN for 11gR2/12c RAC on AIX and Linux servers
• Upgraded Databases from 10gR2 (RAC) to 11.1.0.7, 11.2.0.1, 11.2.0.2,11.2.0.4,12.1.0.2
• Resolved the issues with interconnect setup for 11.2.0.2 install and upgrade, by configuring multicasting and applying one off patch
• Configured multiple dataguards for RAC/RAC-ONE databases for zero-time or near zero - time maintenance, disaster recovery and crs and database upgrades
• Resolved the database performance issues in RAC databases (Global cache and inter instance parallelization)
• Configured Dataguard broker in RAC/RAC-ONE databases
• Applied PSUs and one-off patches to RAC database in rolling fashion with very minimal downtime
• Configured RAC listeners properly
• Prepared RAC database standards and implemented them
• Configured ONS
• Installed Grid Control with RAC repository and configured cloning of agent installations
• Resolved the crs issues in RAC database in different scenarios ( time synchronization, kernel parameters, inter instance communication bugs, ASM monitoring from OEM, SAN modifications, network modifications, cluster hung, temporary tablespaces)
• Modified network interface for RAC public and private interconnects
• Analyzing P7 servers NIC card configuration for 11gR2 RAC installation for Siebel
• Analyzing extended RAC with Hitachi storage
• Created CDB/PDBs in 12c RAC/RAC-One databases
• Resolved the issues with datapump in RAC database (parallelization and index creation)
• Tuning database at various levels using AWR and ADDM particularly RAC related
• Installed and upgraded O/S on Unix( Solaris, Linux, AIX, HP-UX) and Windows for RAC installations on new servers
• Created users(with appropriate groups) with SSH and established equivalency for RAC installation
• Set appropriate Kernel and network(public, private and vip) parameters for RAC as per O/S ( Solaris, Linux, AIX, HP-UX, Windows)
• Installed and configure Veritas cluster(Veritas storage foundation) for RAC database installation an configuration and upgraded it from 10g to 11gR2
• Migrated OCR and Voting disk from GPFS to ASM
• Explored 12c RAC features like Flex cluster etc
• Configured dataguard and Dgbroker in RAC environment with high availability on standby side
• Configured ACFS on ASM both in RAC and NON-RAC databases
• Configured streams in RAC environment with high availability for capture and apply
• Involved in System administration both on Unix( Solaris, Linux, AIX, HP-UX) and Windows.
• Involved in the configuration of LPARS, CPUs, memory
• Configured etherchanneling for NIC high availability (public and private networks) in AIX
• Configured bonding for NIC high availability (public and private networks) in Linux
• Very much proficient in Shell scripting(BASH, KORN, C Shell and Bourne Shell) and PERL scripting
• Created File systems and users and Groups in AIX and Linux
• Involved in creating raw devices on SAN (Hitachi, EVA, EMC and IBM storage) both in AIX and Linux
• Created shared raw logical volumes for OCR, Voting disk, ASM and database files both in AIX and Linux
• Converted OCR and Voting disk from GPFS to shared raw logical volumes
• Converted GPFS to ASM for RAC database tablespaces
• Involved in configuring HACMP on AIX for high availability of systems
• Involved in high availability configuration of switches for public, private and SAN storage networks
• Applied patches, APARS on AIX servers and applied patches to Linux
• Involved in O/S installation and upgradation of AIX and Linux
• Trained Windows admins and other DBAs in Linux

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, Java J2EE, JSP, EJB, C, Shell Scripting, HTML, Visual Basic, PERL

RDBMS: Oracle 7.x,8.x,9i,10g,11g, Sybase, SQL Server,Teradata, Db2, Netezza,Informix

Operating Systems: Unix (Sun Solaris, Linux, HP-UX, AIX,TRU-64), Windows, MVS/ESA, Open VMS

Oracle Tools/Utilities: Enterprise Manager, Oracle Datapump, Sql*Loader, Oracle Forms 5.0/6i, RMAN, Oracle Reports 3.0/6i, Stand By Sever(Data Guard), Advanced Replication, Toad, Streams Administration, Erwin, FTP, Foglight, Goldengate, Shraeplex

Other Tools/Utilities: Veritas Volume Manger, Veritas netbackup, OWB, Informatica(ETL). EMC SRDF, PowerMart/ powercenter, Oracle warehouse builder, Teradata Query Manager, SQL Server Enterprise Manager, NetApps,Cognos, Siebel Analytics, Business Objects (OLAP), Actuate,PVCS, Clearcase, Clearquest, VMware ESX, Cassandra

Hardware: SUN Enterprise System, IBM power 5 and power 6, HP-UX Itanium, Exadata

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Platform & Skills: Oracle 11g/12c, 12c Cloud Control, Veritas Cluster, Solaris 10, Linux 5/6, RAC/RAC-ONE(11gR2/12c), OID, 12c Goldengate, 12c/13c OEM, SQL server

Senior Oracle DBA

Responsibilities:

• Developed a strategy to migrate 11g databases into 12c as PDB databases using datapump
• Installed and created 12c RAC - ONE databases on Linux
• Developed provisioning process using 12c OEM for installing 12c GI, RAC-ONE RDBMS and create CDB/PDBs
• Extended the existing clusters to add third node and resolved the issues
• Resolved the issues with OCR/Voting disks
• Installed Goldengate for SQL server and configure replication to Oracle
• Installed and configured 12c Goldengate on ACFS and configured high availability
• Stabdardized the Oracle Homes for GI/RDBMS and OEM installations
• Migrating 11g databases to 12c PDBs on Solaris and Linux
• Configured High availability Goldengate in RAC-One and dataguard with bundled agents/agctl
• Developed provisioning for patching process with 12c OEM
• Upgraded database to 12.2.0.1(RAC-One)
• Configured dataguard for 12c RAC-One databases
• Relocating RAC-ONE databases for maintenance operations to reduce downtime
• Configured Goldengate monitoring in OEM with high availability
• Configured Goldengate in active-active mode
• Tuned the regressed SQL statements from SQL performance analyzer using SQL tuning advisor, SQL access advisor and SQL plan management
• Created and managed wallets for RMAN backups and datapump
• Developed a strategy to migrate stats and strategy to collect stats in optimal way
• Upgrading OEM to 12c (12.1.0.5/13.2.0.1 )
• Upgraded 11g Oracle Restart databases with dataguard in place

Confidential, Piscataway, NJ

Platform & Skills: Oracle 9i/10g/11g/12c, 12c Cloud Control, Exadata V2/X2/X4, Veritas Cluster, Solaris 10, AIX 6.1, Linux, Autosys, RAC(11gR2/12c, Exadata), AWS, Cassandra, Goldengate, SQL server

Senior Oracle DBA

Responsibilities:

• Resolving the dataguard sync issues by creating incremental database backups
• Tuning dataguard log shipping process including tuning the network
• Vastly improved the database performance by correcting database stats collection process, changing init parameters appropriately and enabling sql plan baselines
• Resolving backup/recovery issues with RMAN, including the backups from dataguard database
• Administering Exadata databases in dev, UAT and production environments
• Upgrading/Patching the databases with minimal downtime
• Installed and configured Cassandra
• Configured Goldengate in active-active mode and developed conflict resolution strategy
• Developed best practices for Goldengate instantiation
• Configured Goldengate replication from SQL server to Oracle
• Analyzed Goldengate logdump and discard tables for issues
• Resolving Exadata issues( DB machine, storage cell, infiniband/network etc) and patching them
• Managing the databases and Exadata components with 12c OEM
• Migrating oracle databases to Exadata
• Upgraded the 11.2.0.2 RAC database on Linux to 11.2.0.4 RAC
• Upgraded/Patched database with Oracle best practices with minimal downtime
• Installed/configured orachk tools for diagnosing database issues and exchk for Exadata issues
• Resolved Oracle RAC issues including CRS failures/node reboots (including Exadata)
• Tuning the worse performing SQL, including by creating/copying sql profiles
• Explored 12c features by doing POC, including multi-tenant features
• OID integration with Active directory
• Creating the DML,DDL, PL/SQL for various applications and modifying existing as per best practices

Confidential, Wilson, NC

Platform & Skills: Oracle 11.2.0.1/11.2.0.3 / 11.2.0.4/12 .1.0.1 , Failsafe 4.1, 11g Grid Control/12c Cloud Control, JD Edwards 9.1.0.0, Windows 2008 R2, Microsoft Cluster 6.1,VMware ESX

Senior Oracle DBA

Responsibilities:

• Upgrading Oracle failafe 4.1 on two node Windows 2008 Cluster
• Upgrading 11.2.0.3 databases to 11.2.0.4/12 c database
• Configuring RMAN backup/recovery with Dataprotector and tuning them
• Recovering database to failsafe database on virtual host using RMAN
• Used 12c new feature to restore tables from RMAN backup
• Resolved RMAN backup issues to shared disk on Windows and configured backups
• Upgrading 12.1.0.1 OEM to 12.1.0.3 OEM
• Applying the PSUs to 11g/12c databases and 11g/12c OEM
• Installed and administered Oracle databases on VMware (Windows)
• Analyzed the impact of migrating databases to VMware from physical servers
• Diagnosed and tuned database performance issues
• Followed the 12c best practices for database maintenance jobs(stats collection, segment shrink etc)
• Database maintenance and changes with 12c syntax
• Developed efficient logical backup and recovery methods using exp/imp and datapump
• Created and modified SQL and PL/SQL( for DML, DDL, stored procedures, functions, packages, triggers etc)

Confidential, New York, NY

Platform & Skills: Oracle 11.2.0.2/11.2.0.3 , AIX, RAC, EMC SRDF, 12c Cloud, Shareplex

Senior Oracle DBA

Responsibilities:

• Prepared AIX servers 11.2.0.2 RAC installation (network, patches, users and file systems)
• Installed 11gR2 11.2.0.2) CRS on AIX
• Configured and tested database for high availability and load balancing
• Installed Oracle restart(11.2.0.3 GI and 11.2.0.2) on AIX and configured it
• Installed and configured 12c OEM
• Installed and configured shareplex including in RAC environment
• Configured SQL Performance Analyzer(SQLPA) both with OEM and DBMS SQLPA packages to test OS/database configuration changes, database upgrades, patches, init parameter changes,schema changes, stats gathering, sql profiles etc
• Configured database workload replay scale-up for capacity planning
• Tuned the regressed SQL statements from SQL performance analyzer using SQL tuning advisor, SQL access advisor and SQL plan management
• Identified and tuned database, Unix server, IO and storage issues
• Efficient configuration of RMAN restore
• Migrating Oracle database to ASM without any data loss
• Configured Unix servers, storage and network for Database/ASM installation
• Identified the issues in 12 cloud control and resolved them
• Partitioned and sub partitioned huge tables using efficient strategy using 11gr2 enhanced partition methodology
• Identified issues specific to RAC database and tuned them
• Installed OSWatcher and OSWBBA and analyzed server performance suchas topas,iostat and vmstat and tuned them
• Analyzed the database wait statistics and events and resolved and tuned them

Confidential, New York, NY

Platform & Skills: Oracle RAC 11.2.0.1/11.2.0.3 , Grid Control 11gR1/12c, AIX 5.3/6.1, Discoverer 10g/11g, Exadata, EMC, Netezza, Goldengate, VMware

Responsibilities:

• Managing RAC database on AIX with ASM storage on EMC luns
• Involved in applying the APARs and filesets
• Identified the bottlenecks and tuning the data load jobs
• Tuned the Discoverer reports
• Managed databases on VMware servers
• Managing the databases with 12c cloud control
• Configured database replay both with OEM and DBMS WORKLOAD packages to test OS upgrades, database upgrades, patches, init parameter changes,schema changes/consolidation(PDBs), RAC etc
• Configured SQL Performance Analyzer(SQLPA) both with OEM and DBMS SQLPA packages to test OS/database configuration changes, database upgrades, patches, init parameter changes,schema changes, stats gathering, sql profiles etc
• Tuning packages and procedures without losing the data integrity
• Upgrading the AIX from 5.3 to 6.1 and resolving the issues
• Upgrading the database from 11.2.0.1 to 11.2.0.3 and applied patches
• Upgrading the grid control from 11gR1 to 12c cloud control
• Upgraded/migrated 10g databases to 11g using Goldengate with zero - down time between different platforms(AIX and Windows to Linux including Exadata)
• Taking care of Database backups and restores to test databases
• Configured ACFS on ASM both in RAC and NON-RAC databases
• Dataguard configuration for RAC database
• Involved in shared disks configuration for ASM storage
• Resolving the public, public VIP, SCAN and private network on RAC database

Confidential, NY

Platform & Skills: Oracle RAC 11.2.0.3, Exadata, Linux 5, Peoplesoft 9.1 (Supply Chain Management)/Peopletools 8.52, Goldengate 11.2.1.0.0 , Cloud Control 12c, Goldengate Management pack, DBFS

Senior Oracle DBA

Responsibilities:

• Configuring Goldengate replication from Peoplesoft production database to reporting database
• Applied Bundle Patch 5 on Exadata (RAC 11.2.0.3) for Goldengate integrated capture
• Peoplesoft plug-in installation for grid control and configuration
• High availability setup with dataguard and Goldengate setup on Reporting database
• Configured DBFS for Goldengate trail files and checkpoint files High Availability
• Configured database replay both with OEM and DBMS WORKLOAD packages to test OS upgrades, database upgrades, patches, init parameter changes,schema changes/consolidation(PDBs), RAC etc
• Configured SQL Performance Analyzer(SQLPA) OEM to test OS/database configuration changes, database upgrades, patches, init parameter changes,schema changes, stats gathering, sql profiles etc
• High availability setup with dataguard and Goldengate setup on Dataguard database
• Upgraded/migrated 10g databases to 11g using Goldengate with zero-down time between different platforms(AIX and Windows to Linux including Exadata)
• Configured uni/bi-directional goldengate replication for zero-down time upgrade/migration of Oracle databases
• Registered Goldengate with CRS and developed agent script to start Goldengate and DBFS
• Configured process scheduler on Exadata and also Goldengate replicated database

Confidential, New York, NY

Platform & Skills: Oracle VM on Solaris 10 LDOMs, OID, OIM, RAC (11.2.0.1), EMC SAN storage, AIX 5.3/6.1, RAC (11.2.0.2), Veritas storage foundation 5.1 SP1, Veritas netbackup, Goldengate 11.1.1.1/11.1.1.2. UDB 9.7,Exadata, OracleVM

Senior Oracle DBA

Responsibilities:

• Analyzing and tuning the database from Database (parameters, tablespaces, schema), Operating system, I/O, storage level
• Identifying the performance issues with OBIEE reports and Tuning them
• Modifying SQL and PL/SQL for performance tuning
• Analyzing logical and physical datamodeling and enhancing for reports tuning
• Installed and configured Goldengate for Oracle and DB2
• Configured the goldengate Replication from Oracle to Oracle and Oracle to DB2
• Implemented the best practices for Goldengate configuration, error handling, monitoring and documented
• Tuned the Goldengate replication both on source and target databases
• Installed and administered databases on OracleVM
• Identified CRS issues with node evictions on Oracle VM on Solaris 10 Logical Domains and resolved them
• Made recommendations for storage patches, OS patches and Oracle Patches for CRS stabilization with minimal downtime identified the issues with network issues on NICs for IPMP configuration and reconfigured and applied required patches for latency during network failover resolved the IO issues for database performance tuning
• Corrected SCAN IP registration in DNS
• Resolving the issues on Exadata with various components
• Applying patches to Exadata components
• Managed OID, OIM on Oracle VM servers analyzed the AWR reports for performance issues and improvised performance ( including worse performing SQL, PL/SQL)
• Identified performance issues at OS level with IOSTAT,SAR, and VMSTAT identified the OS panicking issues with OSwatcher and GUDS and worked with Oracle support to resolve the issues
• Analyzed the ASM configurations and parameters and modified as per Oracle best practices
• Validated AIX servers 11.2.0.2 RAC upgrade (network, patches, users and file systems)
• Prepared the document for upgrade process from 11.2.0.1 to 11.2.0.2 and AIX 5.3 to 6.1, SFRAC to 5.1 SP1
• Applied the patches to Grid Infrastructure and database to resolve network and mutex performance issues in efficient way
• Analyzed and resolved many RAC configuration issues and resolved them
• Identified and resolved the streams issues in RAC environment
• Backup setup on RAC with Veritas netbackup