Oracle DBA

Vipin Voore

*************@*****.*** 510-***-****

Summary:

●9+ years of IT experience as an Oracle database administrator on RAC, streams, data guard, golden gate installation, migration, designing, backup, recovery, scripting, performance tuning etc. spanning in various industries like Banking, Financial sector, Retail, Wireless & Telecommunication sector, Medical sector in production as well as development databases.

●Excellent experience in Installation and configuration of 11g, 12c on Operating Systems UNIX, Linux and Windows platforms.

●Expertise in upgrading the databases from Oracle 10g to 11g /12c.

●Worked on Golden Gate high availability like installing and configuring DBFS and ACFS.

●Installed Golden Gate 12c on IBM-AIX Platform.

●Installed, upgraded Golden gate for Oracle database 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.

●Expertise in RAC 11g, 10g installation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, UNIX shell scripting and documentation.

●Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin and Visio.

●Worked with Oracle12c OEM.

●Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, & IBM TSM Storage Manager

●Proficient with Oracle Real Application Testing (RAT), SDLC.

●Worked on Migration of databases across platforms using expdp and impdp.

●Worked on Cross platform migration using RMAN & Goldengate.

●Worked on database migration using Dataguard using Switchover method.

●Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).

●Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.

●Implemented automated backup strategy using the UNIX shell script CRON UTILITY

●Expert in SQL* Loader, export/import and data pump to load data in to tables.

●Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

●Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.

●Expert in implementing oracle streams, and two types of standby databases supported by data guard, logical standby and physical standby databases

●Expert in implementing development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

●Worked on very large database (VLDB) of 2TB with 23 servers including 5 productions, 12 development databases.

●Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

●Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.

●Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.

●Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.

●Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery. Installation, configuration of OEM Cloud Control 13C. Upgrade OEM Cloud Control from 12C to 13C and applying patches when required.

●Installation, Upgrade, Configuration, performance tuning of Oracle Golden Gate 11g/12C

● Implemented development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise

●Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.

●Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and other Support Procedures

●UNIX shell scripts for hot backups, SQL*Loader, export and import of database.

●Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.

●A very good team player, self-motivated, dedicated in any work environment.

Technical Experience:

Databases: OLTP, Data warehouse, Oracle Databases 12c/11g/10g/9i, RAT, SQL Server 2000

Languages: SQL, PL/SQL, UNIX Shell, Perl, XML

Tools/Utilities: RMAN, OEM, TOAD, Oracle Management Server, SQL*Loader, SQL Server, Data pump Export/Import, Query builder, Net Backup, Ignite, Crystal Report, Data Guard.

Tuning Tools: TOAD, OEM, DBArtisan, OEM Grid Control.

Shell Scripting: UNIX Shell Scripts on Sun Solaris, HP-UX and Linux platform

Operating Systems: RHEL 5/6, HP-UX 10/11.21, 11.31, AIX 4.3, Solaris 8/7, SunOS 5.10, Oracle Linux, Windows 2000/NT/7

Professional Experience:

Wells Fargo, Charlotte NC Oct ’19 –Pressent

Role: Oracle DBA

Wells Fargo & Company is an American multinational banking and financial services holding company which is headquartered in San Francisco, California, with "hub quarters" throughout the country. It is the fourth largest bank in the U.S. by assets and the largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit cards. In 2011, Wells Fargo was the 23rd largest company in the United States

Responsibilities:

●Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.

●Installation, Cloning, Configuration and Administration of Oracle 12gR2 RAC.

●Installed RAC on Oracle 12gR2 and worked on ASM feature of Oracle.

●Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

●Support RAC to EXADATA migration projects and database upgrades to 19c

●Develop SQL statements and Oracle PL/SQL stored procedures, database packages, and triggers

●Experience developing Oracle PL/SQL using advanced PL/SQL programming techniques

●24*7 production database support with Support to developers & end-users

●Managing multi-terabyte databases like more than 25 terabytes in this project.

●Upgraded Oracle Database from 12c to 19c.

●Successfully installed, validated and deployed Exadata X2-2, X3-2 and X4-2 quarter, half and full rack as POC.

●Installation and configuration of Oracle Golden gate (GG) (both unidirectional and bidirectional).

●Worked upon Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

●Implemented Golden Gate for data recovery and data migration for Oracle 12c RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate, rebuild and abend.

●Used Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.

●Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.

●Installed and configured xag 7.1, 8.1.0 and Golden Gate resource was added to the cluster resource and maintained by bundle agent with agctl utility.

●Installed monitor agent 12.2.1.2 for Golden Gate and Configured Golden Gate extracts, replicates targets in 13c OEM

Ellucian, Orlando FL Sep ’18 –Oct’19

Role: Oracle DBA

Ellucian works with more than 2,500 institutions in nearly 50 countries—enhancing operations and enriching the experience for over 20 million students. As the market leader in higher education technology, the Ellucian portfolio is comprehensive and built off of best practices from the community of schools as well as its 50 years of experience transforming the industry landscape.

●Installed and administered Real Application Cluster (11g, 12c RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.

●Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.

●Worked on the database upgrades from 11g to 12.2.0 and 12.1 to 12.2.

●Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.

●Manage Banner ERP application update process and oversee patches and update process for Oracle Databases.

●Worked on various Banner 9 upgrade modules.

●Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).

●Experience in a Banner ERP environment, including cloning ERP instances and installing Banner updates for Oracle Databases.

●Worked on Oracle 13c OEM and Oracle APEX upgrade.

●Worked in upgrading Banner ODS from 8.1 to 8.4 and 8.5 to 9.

●Working and involved in a team on database migration to AWS cloud.

●Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication materialized views.

●Experience in XE applications configuration and migration.

●Worked on INB, SSB applications using Oracle Fusion Middleware.

●Worked on job submission application and Oracle discoverer.

●Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.

●Applied CPU/PSU patches for oracle database version 12.2.0.

●Utilized SQL*loader and data pump import to load data into tables.

●Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, set-tings privileges and user logins.

●Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

●Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR.

●A self-motivated, responsible and reliable team player with a set of strong technical skills.

●Excellent analytical, interpersonal and communication skills.

●Enthusiasm in learning new technologies.

Wells Fargo, Charlotte NC Oct ’16 – Sep’18

Role: Oracle DBA

Wells Fargo & Company is an American multinational banking and financial services holding company which is headquartered in San Francisco, California, with "hub quarters" throughout the country. It is the fourth largest bank in the U.S. by assets and the largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit cards. In 2011, Wells Fargo was the 23rd largest company in the United States

Responsibilities:

●Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.

●Installation, Cloning, Configuration and Administration of Oracle 12gR2 RAC.

●Installed RAC on Oracle 12gR2 and worked on ASM feature of Oracle.

●Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

●Managing multi-terabyte databases like more than 25 terabytes in this project.

●Upgraded Oracle Database from 11g to 12c.

●Successfully installed, validated and deployed Exadata X2-2, X3-2 and X4-2 quarter, half and full rack as POC.

●Installation and configuration of Oracle Golden gate (GG) (both unidirectional and bidirectional).

●Worked upon Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

●Implemented Golden Gate for data recovery and data migration for Oracle 12c RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate, rebuild and abend.

●Used Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.

●Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.

●Installed and configured xag 7.1, 8.1.0 and Golden Gate resource was added to the cluster resource and maintained by bundle agent with agctl utility.

●Installed monitor agent 12.2.1.2 for Golden Gate and Configured Golden Gate extracts, replicates targets in 13c OEM

●Worked on Golden Gate version 12.1, 12.2 and 12.3

●Applying patches to the Golden Gate version on quarterly basis.

●Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines. Provided support for OS upgrades on Exadata running on Linux.

●Data migration from Solaris to Linux.

●Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).

●Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication materialized views.

●Created and maintained immediate failover with up to the minute data to minimize the recovery time mission critical systems using oracle GOLDEN GATE (Testing Purpose).

●Cloning databases using scripts as well as RMAN.

Set up backup and recovery procedure using RMAN and setup Autosys jobs.

Installed and Implemented Backup & Recovery procedures.

Implement Hot, Cold and Logical backup plans.

Created duplicate databases using RMAN duplicate.

Worked on TSPITR using RMAN.

●Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces and Packages.

●Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.

●Applied CPU/PSU patches for Oracle database version 11g and 12c

●Utilized SQL*loader and data pump import to load data into tables.

●Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, set-tings privileges and user logins.

●Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

●Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR.

●Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespace.

●Solver the errors ORA-600, ORA-1555, ORA-7445.

●24x7 production database support.

●A self-motivated, responsible and reliable team player with a set of strong technical skills.

●Excellent analytical, interpersonal and communication skills.

●Enthusiasm in learning new technologies.

Environment: Oracle Server 12c/11g/10g, SQL, PL/SQL, RAC, RHEL6, AIX

Ascena Retail, Columbus OH Oct ‘14 – Sep’16

Role: Oracle DBA

Ascena Retail Group, Inc. is a leading national specialty retailer of apparel for women and tween girls, operating, through its wholly-owned subsidiaries, the dressbarn, maurices, Justice, Lane Bryant and Catherines brands. The Company operates through its subsidiaries over 3,800 stores throughout the United States and Canada, with annualized revenues of over $4.5 billion.

Responsibilities:

●Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Sun Solaris, Red Hat Linux.

●Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

●Performed 24/7 on call pager support.

●Installed and administered Real Application Cluster (10g, 11g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.

●Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; managed redo and undo in the RAC environment.

●Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.

●Worked on Golden gate and data guard setup and maintenance.

●Used Golden Gate in moving large volumes of transactional data without downtime.

●Maintenance of Golden Gate for Uni-Directional, Consolidation topologies.

●Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility. Wrote Shell scripts for Alerts for ORA-errors, backup and recovery, Import and export procedures

●Upgrade/Migration of Databases from Oracle 10g to 11g.

●Worked on Ignite DPA monitoring tool.

●Worked on IBM Netezza Striper and Twinfin 12 databases.

●Worked on Database creation of Netezza databases and performance activities.

●Worked and involved in refresh activity for Multi TB Netezza databases.

●Creating new user accounts, profiles, and roles and assigning them to users.

●Assigning users to groups and granted privileges and permissions to appropriate groups.

●Worked closely with developers in schema design and SQL tuning, performed database capacity planning, performance tuning at system level, database level, and SQL level.

●Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.

●Designed and built an additional system / database monitoring system to proactively detect potential performance problems and provide early warning.

●Reporting and resolving all serious Oracle alert log messages.

●Installed and Implemented Backup & Recovery procedures. Implemented Hot and Cold Backups, Exports, Imports, Data Guard, Flashbacks.

●Successfully developed and implemented monitoring scripts, health check scripts, Database backup scripts.

●Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, LOGICAL STANDBY and PHYSICAL STANDBY databases.

●Involved in I/O tuning by moving data files and redo log files to faster disks.

●Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.

●Ensured availability and performance of the databases.

●Proactively monitored the database systems to ensure secure services with minimum downtime.

●Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.

●Conducted impact analysis on upgrades, security.

●Rollout database builds in various production and non-production environments.

●Designing and managing logs, back-ups and recovery procedures using RMAN.

●Writing PL/SQL triggers, procedures, and functions.

●Creating and Managing Table Spaces, Tables, Views, Indexes, and Partitions.

●Optimized the query result cache for best performance.

●Perform logical and physical database design to support client customers.

●Ability to manage multiple instances in Dev/QA/Stage/Production.

●Prepare current database structure and configuration for high-performance/high-availability through analysis and optimization.

●Perform database monitoring utilizing a combination of Oracle Grid Control and UNIX shell scripts.

●Provided 24*7 Production Support

Environment: HP-UX 11.11, Oracle 11g, 10g and 11g RAC, Sun Solaris, Red Hat Linux, TOAD, ERWIN, RMAN, Data pump, SQL server, OEM, Grid Control, Data Guard,STREAMS, DBARTISAN,IGNITE,TKPROF, STATSPACK, Diagnostic and Tuning Advisors.

Wells Fargo, San Leandro CA Feb ’13 - Aug ‘14

Role: Oracle DBA

Wells Fargo & Company is an American multinational banking and financial services holding company which is headquartered in San Francisco, California, with "hub quarters" throughout the country. It is the fourth largest bank in the U.S. by assets and the largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit cards. In 2011, Wells Fargo was the 23rd largest company in the United States

Responsibilities:

●Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.

●Installation, Cloning, Configuration and Administration of Oracle 11gR2 RAC.

●Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle.

●Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

●I worked in managing multi-terabyte databases like more than 10 terabytes in this project.

●Upgraded Oracle Database from 10.2.0.4 to 11.2.0.3.

●Data migration from Solaris to Linux.

●Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).

●Extraction of data from different flat files into Oracle Database using SQL*Loader and automat-ed the process by using Basic Replication materialized views.

●Created and maintained immediate failover with up to the minute data to minimize the recovery time mission critical systems using oracle GOLDEN GATE (Testing Purpose).

●Cloning databases using scripts as well as RMAN.

Set up backup and recovery procedure using RMAN and setup Autosys jobs.

Installed and Implemented Backup & Recovery procedures.

Implement Hot, Cold and Logical backup plans.

Created duplicate databases using RMAN duplicate.

Worked on TSPITR using RMAN.

●Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaes and Packages.

●Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.

●Applied CPU/PSU patches for oracle database version 11.2.0.3.

●Utilized SQL*loader and data pump import to load data into tables.

●Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, set-tings privileges and user logins.

●Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

●Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR.

●Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespace.

●I know how to solve these errors ORA-600, ORA-1555, ORA-7445.

●24x7 production database support.

●A self-motivated, responsible and reliable team player with a set of strong technical skills.

●Excellent analytical, interpersonal and communication skills.

●Enthusiasm in learning new technologies.

Environment: Oracle Server 11g/10g, SQL, PL/SQL, RAC, RHEL6, AIX

Siemens India, Mumbai, India Jan 11 – Aug 2012

Role: Junior Database Administrator

Responsibilities:

●Responsible for managing production, development & test databases and applications.

●Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.

●Responsible for writing database programming to Store/Retrieve the information from the database using SQL

●Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.

●Creating databases, objects, roles and privileges.

●Partitioned large tables to increase the performance.

●Configured scripts to monitor activity with database. .

●Implement Hot, Cold and Logical backup plans.

●Used Oracle UTL file features to create flat files and Procedures for Data Extraction

●Oracle Configuration. Oracle Tuning. Oracle Patch Administration

●Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.

●Creation of Users and Granting them privileges and roles.

●Performed Database Tuning. Performed Database Security and Integrity. .

●Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.

●Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.

●Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i, SQL Server 2000, UNIX (Sun Solaris), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator

Educational Background and Certifications:

●Bachelor of Engineering, JNTU, India.

●Oracle Certified Professional (OCP) 10g.

●Oracle Certified Professional (OCP) 11g.

Contact this candidate