Summary:

**+ Years experience in IT including Production Database Administration and Oracle Database Administration in several environments like Windows, HP-UX, and IBM Advanced Interactive executive (AIX), SUN SOLARIS and RedHat Linux.

Experience in data replication in the oracle database environment using Golden Gate software.

Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues

Measured and implemented availability solutions using Oracle 19c,18c/12c/11G/10g Real Application Clusters (RAC), Standby Database using Oracle Data Guard

Enough knowledge in monitoring and troubleshooting RAC cluster using Transparent Application failure (TAF), Server control utility (svrctl), and oradebug.

Skilled in concepts like Performance tuning, backuping database and recovery of database, installing and configuration of database, cloning the database.

Expertise in Database administration and production support, upgrading the database, Patching, Space management, Database security, Auditing, Troubleshooting any issues, Database design, UNIX shell scripting and documentation.

Experience in using 11g,12c,18,19c new features Real Application Testing (RAT) and Database Replay (DB Replay) to validate database performance.

Experience on Oracle monitoring tool including Oracle Application Server monitoring and Oracle Linux monitoring using SAR and TOP.

Hadns on experience in installation and configuration of release 12c/11G/10g

Knowing about Migration and Upgrading the Databases in different environments and versions.

Proficient knowledge in configuring ASM for RAC databases.

Good experience in implemention and monitoring of Physical Standby Database for Data Guard disaster recovery technique.

Indepth knowledge in Data Guard Command-line Interface (DGMGRL).

Heavily worked on Utilities like RMAN, Data Guard, Data Pump, Flash Back and SQL Loader.

Done backups and tested crash recoveries using hot & cold backups and RMAN.

Done operations with EXP/IMP, EXPDP/IMPDP to restore the Dev, Test databases.

Experience in High Availability Concepts like RAC, Oracle streams, Database Cloning.

Knowledge in SQL, PL/SQL, Data Modeling and desiging of database physically and logically.

Worked on Proof of Concept (POC) on OEM 12c,18c19c, Cloud, have good knowledge on 12c.

Expertised in maintaining Oracle large databases (VLDB), ETL, DSS, Data Warehousing and OLTP.

Exceptional knowledge in DSS/OLPT database systems, implementing and managing large Oracle databases (VLDB) of size 4 TB.

Did Oracle 11g Active Data guard for Disaster Recovery Solution.

Well expertise in applying Critical Patch Update (CPU Patches) on Databases.

Experience in Data transfer between SQL Server and Oracle.

Skilled in Quest Software to resolve issues with Shareplex.

Knowing how to maintain of schemas, objects & partitioning the tables & indexes.

Performance Tuned for Optimized results using SQL-Trace, AWR, TKPROF, and ADDMreports Explain-Plan.

Experienced the nodes ranging from 2 to 8 and incorporating Dataguarded Exadata clusters for maximum availability.

Experience in Working DB2, and SyBase on AIX Platforms.

Expertise in working with Oracle Architecture, Networking, I/O tuning, Memory tuning, Capacity planning, space management, Performance tuning and optimization.

Schema design experience using ERwin, expert scripting experience in Perl and all UNIX shell scripting variations.

Performed numerous tasks tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.

Expertise in Replication of Oracle Databases using Logical Standby and Shareplex and Streams.

Well experienced in PL/SQL, Shell Scripting, SQL, Data Modeling, Partitioning, OLAP, and Creation of database logically and physically.

Technogical Skills

Languages : PL/SQL, T-SQL, Perl, HTML, XML, UNIX Shell, Scripting, C, C++.

ETL Tools : Apache Tomcat, Data modeling, Informatica, Erwin.

Databases : Oracle 18c/12c/11g/10g/9i, MS Access, MS-SQL Server 2000/2005/2008, OEM 12c Grid Control.

DBA Tools : SQL plus, SQL Loader, RMAN, DBUS, Toad, EXP/IMP, OEM, TKPROF

Platforms : Linux, HP-UX, Windows NT, XP, Sun Solaris, AIX, OS X0/OS2.

NETWORKING : ISO 8583, TCP/IP, LAN, SPI, NFS, DHCP.

Other Tools : Golden Gate EMC, NetApp, Streams.

Education

Bachelor of Computer Science from University of the Pacific

Professional Experience

E&J GALLO, Modesto, CA 02/2018- Present

Lead Senior Oracle DBA Could Architect/SAP HANA Security DBA

Implemented OEM cloud control 13c and migrated over 200 Oracle non-production and production databases to 13c OEM cloud control. And made sure monitoring exists for all Production databases.

Written PL/SQL on demand and help developer tune SQL.

Installed 4 sets of 3 node 12cR2,18c,19c RAC cluster on Redhat Linux with data guard implementation and SRDF. Configured Active Active 11g/12c Data Guard for reporting database.

Upgraded 12, 3-Node RAC environments from 10gR2 databases to 11gR2 and eventually to 12.2

Upgraded 18c,19c, 2-Node RAC environments from 12.2

Worked on building large Exadata system to create internal cloud system to service different departs database needs.

Once 12.2 was setup, created CDBs for different line of businesses with many PDBs within the CDBs.

Implemented central grid control to monitor all production environments.

Installed 4 sets of 3 node 12cR2 RAC cluster on Redhat Linux with data guard implementation and SRDF.

Configured Active Active 11g/12c Data Guard for reporting database.

Worked with UNIX admins to implement Huge Pages for maximum benefit of 500Gig SGA

Created Standard for Oracle 11g/12c Data Guard implementation.

Moved a 3 Node cluster to a 2 Node Redhat Cluster (non – RAC) database after upgrading to Redhat Cluster

Wrote refresh scripts for development database refreshes.

Implemented Advance compression to save 70% space while increasing select query responses. In exadata did HCC.

Implemented Secure Files with advance compression for LOB compression to save storage.

Setup jobs via Autosys for rman backups, monitoring, and various maintenance scripts.

Worked with UNIX admins to implement Huge Pages for maximum benefit of 500Gig SGA. Created Standard for Oracle 11g/12c/18c Data Guard implementation.

Designed and developed NoSQL solutions for all users. Analyzed and resolved issues relating to database application performance.

Managed and administered all NoSQL database systems. Prepared formal queries for various reporting requirements.

Created and executed database solutions in distributed and clustered forms. Monitored database performance and developed new AWS solutions.

Suggested latest upgrades and technologies for NoSQL databases. Evaluated system performance and validated NoSQL solutions.

Managed and maintained Oracle and NoSQL databases in production domain. Supported operation tasks such as backup, replication and schema modifications.

Monitored, analyzed, and all production databases for performance issues and Worked with LIMS application team to enhance application functionality, optimized limsprd1 by tuning numinous SQL by creating Indexes, creating SQL profiles, by updating database parameters and reduced database I/O by 50% and reduced SQL execution timing by 90%.

Oracle Infrastructure and Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers

Installed OEM 13C, registering databases, creating OEM users, deploying agents, monitoring databases, registered Databases in OEM Administering Oracle Database 10g, 11g and 12c using Enterprise Manager

Implemented Monitoring Templates and Incident Rule notifications using OEM cloud control 12C/13c for database alerting.

Involved in designing and deploying a multitude application utilizing almost all of the AWS stack (Including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, and auto-scaling.

Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature.

Install and configure chef server / workstation and nodes via CLI tools to AWS nodes.

Increasing EBS backed volume storage capacity when the root volume is full using AWS EBS Volume feature.

Created AWS Route53 to route traffic between different regions and Deployed and supported Memcache-AWS ElastiCache.

Working with GitHub private repositories and Created S3 backups using versioning enable and moved objects to Amazon Glacier for archiving purpose.

Handling service requests within Service line agreement and Assisting in implementation of change control process in production and Handled daily production problems/change requests (DBCRS) with Oracle

Installed and supported the Clean Address add-on product for Banner.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Configured and Installed Oracle-Wallet-Management (OWM) for Data Security.

Used Service Now tool for all change management process

On-Call 24x7 production DBA support and Worked with off-shore and coordinating work with prod support for managing databases

Migrated to Oracle exadata Machine with Dataguard RAC.

Responsible for installation and maintenance of Oracle 9I/10g Data Guard.

Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, 9i databases and E-business Suites (11i/R12)

Implemented OEM 13c and configure mointoring for over 400 databases.

Responsible for configuration of 11gRAC, 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.

Helping install and configure ODBC for excel.

Mointored MS SQL server database and supported oncall.

Migrated SQLServer database to Oracle.

Upgrade Oracle SAP application database from 10G – 11G and 11.2.0.2 – 11.2.0.3 – 11.2.0.4 – 12c- 18c and Install and applied SAP Bundle Patch for GI and RDBMS home.

Install, configure and troubleshoot Oracle 12c/11G R2 RAC databases.

Implemented Oracle Advanced Security - Created Oracle Wallet for user authentication logins.Uploading Wallets to an LDAP directory.

Managing Oracle Databases on AWS on EC2 and RDS services.

Provision and Support Databases on AWS RDS cloud environment.

Migrating databases to AWS Cloud Environment.

Install, configure and support Oracle Internet Directory (OID) for user authentication to Active Directory and Tnsnames resolution.

Responsible for installation and maintenance of Oracle 9I/10g Data Guard.

Created SQL profile for bad execution plan SQL queries to use right plan all the time.

Tuning Oracle SQL queries adding indexes if SQL is not using proper indexes for better plan.

Setup, configure support Oracle standby databases on multiple locations.

Refreshing production databases to Virtual databases for testing using RMAN/EX/IMPORT.

Upgrading Oracle 10g to 11g R2 databases.

Applying Oracle Security PSU patches.

Tuned numerous long running SQL statements to avoid full table scans and to use indexes & statistics. Improved the performance of many statements from over 1 hour to 3 seconds. Modified statements to use hints and indexes.

Build Oracle database environment for SAP application and refresh Oracle database for SAP application and configured backup and monitoring and Moving Weekly/Monthly transports.

Restored/Recovered databases using RMAN hot and cold backup.

Tuned Databases using (v$ tables, AWR Report, ASH and ADDM Reports)

Tuned SGA by Tuning Library Cache, Dictionary Cache, and Buffer Cache. Tuned Applications using EXPLAIN PLAN, SQL TRACE and HINTS.

HANA Security – Configured Standard, Technical and Restricted Users. Worked on System, Object, Analytic and Package Privileges. Knowledge in SAP Studio.

Design and Implement HANA-BI Security. Created custom roles in HANA DB for Developers, Modelers, Data Base Administrators and Business End user Roles. Worked on System, Object, Analytic, Package and Application Privileges

Worked on both Catalog (Run Time) and Repository Roles (Design Time). Worked on License Check Properties and Activating Audit Policy. Strong Experience in working on HANA Studio and Development perspective.

Experience in HANA Life cycle Manager and Transport Mechanism. Ability to Drive Security support process and ensure compliance of project standards and deliverables.

Worked on end to end implementation on HANA Security (HANA Database and Analytics). Strong understanding of all administrative tasks related to HANA Security. Strong knowledge of designing of roles & authorizations and implementation of complex security framework and role matrix for SAP HANA Enterprise platform

Able to create schema level access control on HANA DB. Worked with team for development of security design document, creation of new roles, modification of existing roles, resolution of security-related issues, coordination with analyst and Basis team members.

Wells Fargo, San Francisco, CA 04/2007- 02/2018

Senior Oracle DBA Architect

Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, 9i databases and E-business Suites (11i/R12)

Implemented OEM 13c and configure mointoring for over 400 databases.

Responsible for configuration of 11gRAC, 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.

Managed and maintained Oracle and NoSQL databases in production domain. Supported operation tasks such as backup, replication and schema modifications.

Created and executed database solutions in distributed and clustered forms. Monitored database performance and developed new AWS solutions.

Migrated SQLServer database to Oracle.

Upgrade Oracle SAP application database from 10G – 11G and 11.2.0.2 – 11.2.0.3 – 11.2.0.4 and Install and applied SAP Bundle Patch for GI and RDBMS home.

Build Oracle database environment for SAP application and refresh Oracle database for SAP application and configured backup and monitoring and Moving Weekly/Monthly transports.

Worked with developers to develop reports.

Maintained and configured database on MS windows.

Installing Oracle Golden Gate in SQL Server and in Linux.

Creates Extract/Replicates and moving the trail files from one position to another position.

Setting up monitoring for oracle Golden Gate.

Pulling History Loads for extract and pump in oracle Golden Gate.

Checking for bad data by using Log Dump and alter ER to skip Header and start from exact location

Setting up the transactional Extraction and transactional Replication

Monitoring and solving Performance Issues like sudden errors of ER by using report file.

Checking log files and manage the issues

Classification of data by using timestamp and replicating that data from source to destination.

Updating the Version of Oracle Golden Gate.

Knowing the capture of database and unregister and registering that particular ER to that database as a user.

Solving Golden Gate Errors caused by database like database vaults.

Migrated databases to Oracle Exadata database Machine for different applications.

Migrated to Oracle exadata Machine with Dataguard RAC.

Migrated two node RAC ASM database to Exadata.

In-depth and working knowledge of Exadata, Smart Scan, Flashcache, Flashlog

Installed and configured Redhat Linux OS, Oracle Linux OS and Oracle VM and Installed and configured 5 Node 11gR2 on 6 different environments.

Used OCFS/ASM and RAW devices for RAC.

Review and provide effort estimate to upgrade Oracle 9i DB to Oracle 11g including 3 D/W databases refresh from PROD DB Server through Perl/Unix shell scripts.

Designed and executed a plan to upgrade databases to Oracle 11G including standby and Data Warehouse environment for online banking application.

Upgraded 6TB database from 10G RAC to 11G RAC.

Partitioned and Reorg objects online using DBMS_REDEFINITION

Migrated Oracle9i RAC Database to Oracle10g, and Migrated Oracle10g to Oracle11G ASM and NON-ASM Single Instance.

Migrated PeopleSoft CRM from 9i/10G single node to 10G/11G 6 node cluster and migrated the same application 6 nodes to 4 nodes.

Reorganized 3 TB table from BIG file table to normal tablespace using range partition.

Tested standby databases using flashback and switchover.

Supported over 40 production RAC/ASM databases on HP/Solaris/Linux and plus development and testing databases. Participated in planning and implementation of off-site Disaster Recovery planning and testing. Monitor databases for performance and tune accordingly.

Installation of ORACLE 10G and ORACLE 11G RAC databases, Managed ORACLE 11G databases. Also performed rolling and non-rolling Cluster upgrades

Performed ORACLE10G CLUSTER upgrade to ORACLE11G CLUSTER.

Managed over 5 SQL servers 2005.

Migrated 10G non ASM to ASM database and used Flashback on the standby for testing before the cutover period.

Restored/Recovered databases using RMAN hot and cold backup.

Tuned Databases using (v$ tables, STATSPACK,AWR Report, ASH and ADDM Reports)

Tuned SGA by Tuning Library Cache, Dictionary Cache, and Buffer Cache. Tuned Applications using EXPLAIN PLAN, SQL TRACE and HINTS.

Tuned numerous long running SQL statements to avoid full table scans and to use indexes & statistics. Improved the performance of many statements from over 1 hour to 3 seconds. Modified statements to use hints and indexes

Managing tablespaces and performing general system diagnostics, system troubleshooting and resolving problems in oracle database.

Documented the database system for future references, upgrades of the system. And Making necessary software

Redenvelope Inc., San Francisco, CA 08/2005 - 04/2007

Oracle DBA

Experienced in installing and setting up Oracle 10g, 9i, 8i databases.

Responsible for configuration of 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.

Controlled migrations of programs, database changes, reference data changes and menu changes through the development life cycle.

Responsible for installation and maintenance of Oracle 9I/10g Data Guard.

Created Standby database setup via Data guard for Database Disaster Recovery.

Enforced and maintained database constraints to ensure integrity of the database.

Performing Backup/Recovery of all the Oracle databases using RMAN.

Managing, troubleshooting and resolving oracle database, RAC and applications issues.

Created Physical Standby Database for Active Production Database.

Validating Databases Backup and Restore periodically and Data refreshes from Production to Non-Production environment.

Creation of Duplicate Databases using RMAN.

Done Golden Gate Databases and worked with application team/Development Team in Trobleshooting Issues

Checking and Reading GSS Error Logs, Alert Logs and User trace Files for any issues to solve.

Experience with Replication concepts and used Golden Gate Software to do the replication.

Implemented Oracle Patches (Critical patch updates, Patch set updates) on the adherence databases Device.

Was involved in developing Disaster Recovery (DR) plan.

Good knowledge in Perl and all UNIX shell scripting variation.

Performance tuning for advanced results using Explain-Plan, SQL-Trace and AWR Reports.

Build and supported 45 RAC Databases with cluster.

Experience in Oracle OEM Grid Control 10g and OEM.

Installed and configures DATAGUARD for 23 databases on file-system and ASM in production Environment.

Created Data Guard using physical standby database, Implemented log miner, Data guard / Standby both physical and logical standby, performed switch/failover and monitored using Data Guard manager command line and GUI.

Refresh/Cloning of Database and applications for development and testing purpose.

Writing documentation for RAC Database creation, RAC RDMS installation, Cluster ware installation.

Experience all kind of DB MONITORING including status and performance.

Installing ASM environment and transferring database to Non-ASM to ASM.

Know how to used Logical volume manager (LVM) for configuring local volume.

Knowledge on Distributed Database Configuration, Creation of Database links and Snapshots using Streams for replication of data.

Worked with SRVCTL for observing and configuring RAC Environment.

Environment: RHEL RedHat Linux, Sun Solaris, Oracle 8i/9i/10g, RAC, ASM, Dataguard, Streams, RMAN Duplication, SQL, PL/SQL, UNIX Scripting, OEM Grid Control, Toad.

Contact this candidate