Sr. Oracle Database Administrator

Ajay Bollu

*********.***@*****.***

Mobile: 913-***-****

Sr. Oracle Database Administrator

* ***** ** ************ ********** as Oracle Database Administrator having good experience in Database Administration, Database Installation, Upgradation, Migration, Patching, Performance Tuning, RAC installation and Maintenance, OEM, setting up and Configuring DataGuard, performing all kinds of backups and recoveries, Cloning Databases, Automated RMAN backups, replicated using GoldenGate, Advanced Security, Auditing and Production Support.

Professional Summary:

Extensive knowledge on database administration for ORACLE 12c/11g/10g/9i with experience within very large scale database environment and mission critical large OLTP and OLAP systems.

Expert with planning, creation, administration and troubleshooting of ORACLE 12c/11g/10g OLTP (multiple instances)/OLAP databases in production.

Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies.

Worked on Exadata Database Machine X4-2 Half Rack, X3-2.

Implemented new Exadata Machine features like Exadata smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases.

Migrated databases into Exadata Machine with minimal downtime using Dataguard.

Worked on HP-UX, AIX, and Sun Solaris, RED HAT Linux and Oracle Linux and Windows environments.

Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation.).

RAC Clusterware administration, Configuration, Patching, RAC Backup and Recovery.

Applied Patches in rolling fashion and Upgrading Oracle GRID infrastructure 11g, 12c.

Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs.

Installed 11g 3 node production RAC Grid Infrastructure and DATABASE on Linux.

Experienced in installation and maintenance of ORACLE 10g and 11gr2 RAC 2 node and adding a node to this cluster database for high availability.

Used RAC Tool orachk to scan different stack of layers and finding potential risk and reconfiguring RAC cluster and Creating and Managing services using RAC Tools Srvctl and clusterware resources using crsctl.

Good experience in Planning and Implementing Disaster Recovery databases using DataGuard and configuring, managing, troubleshooting and monitoring Physical standby using DataGuard 10g/11g/12c.

Switchover, Failover, Switching Standby to Primary and Primary to Standby on scheduled basis.

Have hands on experience in 11g new features Active Data-guard & snapshot standby.

Troubleshooting Dataguard using Views, troubleshooting missing archive log scenario, patching Dataguard environment, Applied logs with delay.

Configured DataGuard Broker and managed standby databases using DG broker.

Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and Handy in upgrading GoldenGate from v11 to 12c.

Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied Patches to GoldenGate environment 12.1.0.2.

Migrated 11g databases to different server using goldengate with minimal Down time.

Configured ACTIVE-ACTIVE Goldengate setup for the databases in different data centers.

Installed and upgraded oracle GOLDENGATE 11.2.1.0.x one-way and Bi-directional replication on Oracle database 11gr2.

Hands on experience in Grid control, Streams, Goldengate Replication.

Sending oracle Goldengate Trail files from Linux to AIX server for reporting purpose.

Configured oracle Goldengate classic and Integrated capture modes on Linux servers.

Installed VERIDATA agents for comparing data for Goldengate replication databases

Installed Goldengate Monitor and agents for monitoring GG databases

Configured HEART BEAT table on source and target to find goldengate LAG

Encrypted Goldengate TRAIL files at Source and Target side

GoldenGate utility like ggsci, logdump, defgen for troubleshooting issues and Performed Homogeneous and Heterogeneous data replication from SQL server database to Oracle database using GoldenGate 11g

Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c.

Monitored the blocking sessions using AWR and ASH reports and resolved the issue by performance tuning.

Performed Mass deployment of OEM agents on different hosts and registered the databases on those hosts to the OEM for monitoring.

Improved the security feature of the data in a schema with the database vault feature, Data redaction and created realm using 12C Oracle Enterprise Manager.

Installed GoldenGate plugin on Oracle Enterprise Manager and monitored database performance.

Created Black Out during the patch installation and database upgradations.

Expertise in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.

Experience in logical backups and Database migration tools with Data Pump, Export/Import and Transportable Table-spaces.

Experience in implementing Flash-Back Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database.

Extensively used Flashback for Supporting DML and DDL changes and Handled daily production problems/change requests(DBCRS) with Oracle Patching.

Experience in applying CPU and PSU Patches Quarterly and Upgrading of databases from versions 10g,11g to 12c.

Expertise in Upgrading databases from 10g to 11g and 11g to 12c and applied patches accordingly.

Experience in a variety of hardware and software platforms including; MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.

Installing and Configuring Oracle Retail 14.0 (ORMS, ORPM, ORESA).

Tested and Supported various Oracle RMS applications.

Upgraded current systems from Oracle Retail 8.0 to latest version.

Expertise in analyzing database objects, dblinks, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle.

Data transferring and Refreshing with export/import utilities, Data Pump (including Network links and DB links) and data loading using SQL*Loader and External tables.

Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and for full database backups using data pump.

Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM.

Extensively used USH, Ticketing Systems BMC Remedy and Service now and 24x7 production Support Database Maintenance and on-call Support.

Technical Skills:

Operating Systems

HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS

Oracle 12c/11g/10g, Oracle 11g Real Application Cluster (RAC), ASM

Tools& Utilities

RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, DataGuard, Cloning, Migrations

Languages

C, SQL, PL/SQL, UNIX/NT Shell Scripting, Awk Scripting, Perl.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Web Technology

Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console

Professional Experience

Client: International Medical Corps, Los Angeles, CA. Duration: Sept 15 – Feb 17

Role: Sr. Oracle Database Administrator.

Description:

International Medical Corps is based in Los Angeles with other offices in Washington, DC, London, England and Split, Croatia. They currently employ over 7,800 employees and thousands of volunteers in 30 countries. International Medical Corps is a global, humanitarian, nonprofit organization dedicated to saving lives and relieving suffering through health care training and relief and development programs.

Responsibilities:

Installed, configured and maintained Oracle 11GR2/12C Real Application Cluster (RAC) databases.

Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.

Performed health checks of Real Application Cluster instances using Crsctl and Srvctl utility and troubleshooting RAC using clusterware logs.

Used RAC Tool orachk to scan different stack of layers and finding potential risk and reconfiguring RAC cluster and Creating and Managing services using RAC Tools Srvctl and clusterware resources using crsctl.

Adding a New Node to 4th Node RAC cluster and Installed Oracle RDBMS software on new node of cluster and Created ASM Volume using ASMCA and Created ACFS for GoldenGate 12c.

Converted single Instance Databases to RAC databases Manually and expertise in troubleshooting RAC issues, very strong in using ocrconfig to backup OCR and Voting files.

Migrated Standalone databases to RAC 12c clusters and Supported Applications.

Upgraded RAC Cluster from 11.2.0.3 to 11.2.0.4 and Applied Patches.

Installed STANDALONE servers on ASM, Red hat LINUX and Installation and maintenance of Oracle 11g, 12c DataGuard.

Installation, configuration and maintenance of Oracle 11g/12C databases on Exadata boxes.

Configured Physical Standby for Production databases and converted Physical standby to snapshot Standby and ACTIVE data-guard.

Configured Active Dataguard 11g & 12c and worked on snapshot standby databases.

Implemented DataGuard Broker and performed various operations like Switchover, Stop and Start MRP.

Conducted analysis and feasibility studies for development of Oracle Exadata solutions.

Migrated databases to Exadata x4-2 by configuring physical standby and switchover.

Worked on EXADATA X4-2 and x3-2 machines and migrated application databases using Expdp, GoldenGate and Dataguard.

Installation, Upgradation, Configuration and Troubleshooting Goldengate 11g/12c software.

Installed GoldenGate for replication of database on 12c RAC environment and Configured parameters for the Bi-directional replication.

Configured Extract and Replicate pumps for goldengate replication 11g/12c and Troubleshooting issues in GoldenGate Environment using report files & logdump.

Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate and process improvement for GoldenGate by proactive monitoring using Shell scripts.

Generation of DDL scripts using Erwin Tools.

Replication of tables across cross platform using Goldengate and Creating Materialized Views.

Applying PSU Patches and interim patches whenever required to make the database software up to date.

Daily Health Check Up of the Database using AWR, ADDM.

Perform Daily Monitoring of Oracle Instances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS_SCHEDULER.

Oracle Enterprise Manager: Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of error notifications and adding to the grid control

Configured repository database for setting up OEM 12c, used 10g,11g for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc.

Extensively used Flashback for Supporting DML and DDL changes and Handled daily production problems/change requests(DBCRS) with Oracle Patching.

Implemented 12c Oracle Advanced Security using TDE (Transparent Data Encryption) and Enabling Auto Login for the Keystore for cdb$root and Pluggable databases.

Document and mentor client DBA team on upgrade and management of EBS.

Good knowledge on reducing Oracle EBS upgrade cut over time.

Technically skilled in areas of Oracle Database and Applications Upgrade and maintenance, Upgrade Assessment, Technical Architecture solutions for ERP, DR, HA and Oracle Applications System.

EBS DBA on numerous Oracle E-business Suite(11i/R12) implementations.

Extensively used USH, Ticketing Systems BMC Remedy and Service now and 24x7 production Support Database Maintenance and on-call Support.

Environment:

Oracle12c/11g/10g, Oracle EXADATA X4-2 HALF RACK, Oracle 11GR2/12C RAC, GoldenGate, Linux 5.8, Sun Solaris, Red Hat Linux, RMAN, SQL server, DataGuard, OEM, Grid Control, STATSPACK, AWR, Explain Plan.

Client: Constar Financial services, Phoenix, AZ. August 2013 to July 2015

Role: Sr. Oracle Database Administrator.

Description:

Constar is a full-service accounts receivable management company delivering collection services to Fortune 100 and 500 companies globally. Specializing in servicing the consumer finance, consumer auto finance, telecommunication, entertainment media and direct lending industries

Responsibilities:

Worked in Cloud Migration project and Data center migration project, worked with VMWare team in building new servers, Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g,12c Dataguard Standby, Goldengate v11 and 12c.

Implementation of High Availability solutions with Oracle 11g RAC, Standby Database (Active DataGuard) to ensure high availability, data protection and disaster recovery for enterprise data.

Installation and configuration of Oracle 11gRAC using Cluster ware and ASM.

Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.

Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.

Extensive experience in RMAN recovery in RAC and standalone database.

Installation and configuration of oracle Goldengate on 12c & 11g.

Configuration and troubleshooting of GoldenGate EXTRACT, Unidirectional and BIDIRECTIONAL REPLICAT issues.

Migrated oracle databases using oracle11g GOLDENGATE, Performance tuning GoldenGate replication and used Log dump and report files for troubleshooting.

Configured Goldengate Data pump extract to move the trail files from source database server to target database server.

Monitoring all the databases using OEM 11G/12c cloud control, Performed Mass deployment of OEM agents on different hosts and registered the databases on those hosts to the OEM for monitoring.

Improved the security feature of the data in a schema with the database vault feature, Data redaction and created realm using 12C Oracle Enterprise Manager.

Involved in Design and implementation of oracle 11g DataGuard both physical/logical standby databases for high availability and disaster recovery.

Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases at the times of up gradation and migration.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Implemented Oracle database backup & recovery solutions using RMAN.

Implemented data transfer using Data Pumps and Export/Import utilities.

Implemented DRP (Disaster recovery plan) for critical databases using Streams.

Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Applying PSU Patches and interim patches whenever required to make the database software up to date.

Expertise in analyzing database objects, dblinks, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle.

Database performance problems analysis, diagnoses and optimum performance resolution - employing preventive measures to maintain high applications availability, performance monitoring, identifying and resolving database performance bottlenecks, SQL tuning, Explain SQL query, Indexing, MySQL and Linux OS level optimization.

Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Expertise in Upgrading databases from 11g to 12c and applied patches accordingly.

Extensive experience in providing 24x7 on call support for Test, development and production databases using Maximum Availability Architecture using RAC and Dataguard.

Environment: Oracle 11/10G, RAC, DataGuard, ASM, Oracle Enterprise Manager Grid Control 11G,12C GoldenGate, RMAN, Exadata, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, Solaris.

Client: State of Maine, Augusta, Maine. January 2012-July2013

Role: Oracle Database Administrator

Description:

The Office of Information Technology in State of Maine is responsible for the delivery of safe, secure, and high-performing networks and systems to State Agencies for daily performance of their missions for the citizens of Maine.

Responsibilities:

Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure.

Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.

Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.

Experience in Creating Physical and logical database design Data Models using Erwin Tool.

Programming in shell to create shell scripts that automate the database backups and maintenance.

Applied patches and CPU regularly to keep the databases in current version.

Work with oracle support to report and resolve issues in production databases.

Capacity planning and creating databases for development, staging and production.

Database and Data Migration using Export/Import, Migration Utility.

Database refresh and schema refresh using Data pump activities on Application users request.

Worked with application teams and implemented conflict handlers in Oracle Goldengate.

Implemented High availability using GoldenGate replication. Implemented bi-directional replication using GoldenGate.

Regular database management on 10g and 11g OEM.

Performed Mass deployment of OEM agents on different hosts and registered the databases on those hosts to the OEM for monitoring.

Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.

Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.

Involved in Mass Agent Deployment using Oracle Enterprise Manager.

Implemented DataGuard with maximum availability and performance configurations for production databases.

Worked on Active dataguard, Fail over and Switch over cases.

Managing disk groups in ASM, partitioning Luns using fdisk as required, created disk groups with different redundancy levels and Installed databases on it.

Migration of databases from 10g to 11g using export/import and data pump export/import utilities.

Performed rolling patch upgrades on RAC environment for bug fixing.

Weekly Data Refresh from Production to Development and Test environments using data pump export/import.

Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.

Table space monitoring, Performance monitoring and tuning for performance improvement.

Creating batch files and automating the tasks.

Granting roles and privileges to end users.

Daily health checkup of the database using TKPROF, AWR, ADDM.

Coordinated with Oracle support for SR/Tar to resolve Oracle bugs and ORA-600 errors.

Ability to work effectively and can liaise as a part of team monitoring proactively.

Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 10g, 11g, RHEL 5/6, SOLARIS, OEM, RMAN, Grid, RAC, ASM, Dataguard, GoldenGate, Oracle Spatial, TOAD, TDE, SQL*LOADER, Performance Tuning, AWR, ADDM, ASH, Data pumps.

Client: Birla Sun Life Insurance, Mumbai, India. May 2010 - Nov 2011

Role: Oracle Database Administrator.

Description:

Birla Sun Life Insurance Company Limited was founded in 2000. The company is based in Mumbai, India. It is a joint venture between Indian Aditya Birla Group and Canadian Sun Life Financial Inc. BSLI has a customer base of over two and half million policy holders and has attained recognition as the 3rd Most Trusted Life Insurance Company. It has a distribution reach in over 500 cities through its network of over 550 branches, more than 1,05,000 empanelled advisors and over 100 partnerships with corporate agents, brokers and banks.

Responsibilities:

Provided Technical support and issue resolution to Enterprise applications, hardware, networks, and databases by root cause analysis, assessment, development, and implementation of solutions that meet the needs of users and kept them productive with minimal disruption.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Supported more than 130 production and development databases.

Upgraded the Oracle 10g database to 11g version and applied patch set and interim patches whenever required to make the database software up to date.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, monitoring and optimizing database performance.

Implemented Oracle database backup & recovery solutions using RMAN.

Identified and fixed the logical block corruption using RMAN & PERFORMED logical backup using Data pump Expdp and Impdp Utility.

Extensive use of Oracle Data pump utility for moving data among the servers.

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

Maintained 10g/11g RAC environment and troubleshooting issues.

Having good experience in Migrating Single Instance database to RAC Environment.

Performed Capacity Planning, Undo segments and Health check reviews in RAC.

Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.

Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.

Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of up gradation and migration.

Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.

Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.

Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.

Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports.

Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.

Configured Listener and TNSnames using NETCA for creating client-server environment.

Proficient in using Data pump.

Involved in the migration of huge databases of sizes ranging from 100GB to 7TB.

Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.

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

Experience in moving the data from one server to another server using SFTP, FTP and SCP.

Environment: Oracle 10g/11g, RAC on Sun Solaris, Linux, RMAN, Data Pump, ASM, AWR, ADDM, SFTP, FTP, SCP, MEMORY STRUCTURES, ROLLBACK.

Client: Industrial Development Bank of India, Mumbai, India. August 2008 to March 2010

Role: Jr. Database Administrator.

Description:

The Industrial Development Bank of India (IDBI) was established in 1964 under an Act of Parliament as a wholly owned subsidiary of the Reserve Bank of India. IDBI provided financial assistance, both in rupee and foreign currencies, for green-field projects as also for expansion, modernisation and diversification purposes.

Responsibilities:

Oracle Configuration. Oracle Tuning. Oracle Patch Administration.

Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.

Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.

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.

Planning, Installation and Configuration of Oracle Database on the Server.

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.

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

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

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 9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.

Contact this candidate