Oracle Manager

Location:

Cumming, GA, 30041

Posted:

June 13, 2018

Contact this candidate

Resume:

SISIRA

865-***-****

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

PROFESSIONAL SUMMARY

An astute Oracle DBA with around 7 years IT experience in Oracle products, both production and development environments spanning several industries: Telecom and high- tech. Hands on experience in administering 24X7 mission critical production environments on UNIX based HA systems with SLA’s of 99.999% availability.

Expertise in Oracle Database Administration for Oracle 12c, 11g and 10g, with experience in very large-scale database environment (VLDB) and mission critical large OLTP and OLAP systems.

Experience in Real Application Cluster (RAC) administration with Auto Storage Management (ASM) on Oracle 11g&12c RAC Grid infrastructure and standalone 12c new features.

Hands on experience with managing ORACLE rdbms on various flavors of UNIX such as Oracle Enterprise Linux 6.x, 5.5, IBM AIX 5.3 & 6.1 and REDHAT LINUX 5.7, 6, 6.5, 7.

Experience with SUN ORACLE DATABASE MACHINE (EXADATA) Half Rack / Full Rack with 8 Database Nodes & 14 Storage cell nodes using Infiband Connectivity.

Experience in managing SUN ORACLE EXADATA FLASH CACHE, GRID DISK, CELL DISK and ILOM.

Successfully implemented Physical Standby Database using Oracle DATAGUARD feature for High availability and DR configuration.

Configured and implemented Oracle Goldengate at Schema Level and Table Level Local capture unidirectional for high availability.

Experience with Oracle Golden Gate and its components. Performed schema level unidirectional hetrogeneous oracle-to-DB2 rdbms replication.

Administration and support of Oracle databases together on separate servers using [OEM] Oracle Grid Control 12c. Installed Oracle Grid control 12c and configured agents on all remote Hosts.

Extensive experience designing and implementing backup and recovery strategy using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.

Experience with various database Recovery methods like PITR, TSPITR, Export/Import, Datapump and Flashback Technologies.

Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, Transportable Tablespace (TTS).

Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch and runinstaller.

Troubleshoot Database performance issues and Tuning of Database, Application, System Global Area, I/O, Rollback segments using self-developed scripts, Oracle Enterprise Manager, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) engine and Active Session History Reports (ASH).

Experience with Database SQL tuning and query optimization tools like SQL Tuning Advisor, SQL Profiles, SQL Plan Management, TKPROF, EXPLAIN PLAN, SQL TRACE, UTLBSTAT and UTLESTAT.

Hands on Experience in Memory / Instance Tuning using Automatic Shared Memory Management (ASSM), 11g Automatic Memory Management (AMM) and V$ advisory Views.

Manages Locally and Dictionary Managed Tablespaces, Database files, Redo log files, Control files, Spfile, Parameter file, Rollback Segments, Temp segments, Views, Sequences and other database objects.

Partitioning of large tables using Range, List, Hash, Split, Exchange and Composite partitioning techniques and creation of Indexes on large tables to improve the Performance and Experience in creating SR’s in METALINK, escalating issues to Oracle support and working closely with Oracle support.

Strong Understanding of Oracle Internals (Memory, Dictionary, Optimizer etc and PL/SQL package, function, stored procedure, triggers, Materialized view, to implement business logics of oracle database and to interface application with Database system.

Experience in full software development life cycle (SDLC) of database administration.

Extensively worked on SQL*Loader, which loads data from flat files into Database tables, UNIX Crontab and writing Shell Scripts for automated monitoring, backup and data loading..

Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.

On call Rotation for 24x7 support.

CERTIFICATIONS:

Oracle Exadata 11g Implementation Certified.

Oracle Certified Professional (OCP) 10g.

EDUCATION:

Bachelors in Information Technology (B.Tech).

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS:

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, IBM-AIX 5.1, 5.2, RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/20003.

RDBMS:

Oracle 11g,10g/9i/8.x, Sql Server 2000, 2003, 2005, 2008

LANGUAGES:

SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting, PERL Scripting

SOFTWARE / APPLICATIONS/ TOOLS:

ORACLE 11g,10g,9i,8.x, (RMAN), AWR, ADDM, DBMS_STATS,STATSPACK, ERWIN, Clusters, VERITAS Net Backup, SQL Loader, TOAD, SHAREPLEX, PL/SQL DEVELOPER V6.0, SQL DEVELOPER 1.2,OEM, NETCA, DBCA, ASM, SRVCTL, CRSCTL.

WEB TOOLS

HTML, XML

PROFESSIONAL EXPERIENCE:

THE HOME DEPOT, ATLANTA, GA Jan ‘13 – May ‘18

Role: Oracle Database Administrator

Responsibilities:

Business Process Knowledge:

Provided Primary architectural and administrative support for new projects.

Experience with business process models for IT support such as HPSM, Change Control and Change Advisory Board (CAB).

Actively Participated in coordinating with Line of Business (LOB) and application team in moving the project “Go Live” without any unexpected issues.

Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.

Provided 24x7 on-call support for production systems during on-call rotation.

RAC Architecture in brief:

OEL 6.5, X86_64, EMC power path and fiber HBA for SAN/TAN connectivity, Gigabit Ethernet for cluster interconnects, Nutanix SAN storage, CRS configuration files on RAW and ASM for database files, 4 node cluster and oracle 11gr2 and 12c rdbms version.

Configured high availability services TAF, load balancing and SCAN features for clustered databases.

Extensively used SRVCTL, CRSCTL, CLUVFY, OCRCONFIG, ADRCI and ASMCMD control.

Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages.

Hand on experience in installing and managing ASM instance, diskgroups, asm disks, asm rebalancing and asm data dictionary views.

Design, Development & Implementation of large volume OLTP and large scale Data Warehouse/DSS environments.

Experience with oracle Golden Gate replication tool and its components.

Installed and Configured oracle Golden Gate unidirectional table level / schema level between homogenous oracle-to-oracle rdbms replication.

Good understanding of Golden Gate components like Integrated Extract, Replicat, Trail Files, GGSCI commands, Using AGCTL utility to manage the Golden gate Processes and Translog options etc.

Experience in handling large database up to 258 TB in size with 6 nodes cluster on various flavors of UNIX.

Hands on experience with 11g new features such as ADRCI, Duplicate from Active database, asmcmd, Memory parameters, Incidents etc

Configured Oracle 11g /12c Physical Standby Database for DR purpose using ORACLE Dataguard.

Experience in OS Patching on the Oracle RAC clusters like upgrading kernel versions, asm libraries and Sanity Reboot of the servers.

Worked on POC for Oracle Cloud 12c Cloud Databases and On Premises Databases.

Worked on POC for Upgrade, Patching and rollback of 12c Databases systems and Databases using both the Console and Using dbcli Utility.

Worked on the POC to Test Planned and Unplanned Instance Shutdown of ASM, Databases and Listener Failure with Shared servers on 12c.

Worked on Switchover and Failover of Hybrid On Premises Standby Database and Cloud Primary Databases.

Exadata Skill Set:

Experience with Exadata cell storage for extremely high performance data scans and Exadata Flash Cache, GRID DISK, CELL DISK, ILOM, INFIBAND, PDU & KVM SWITCH.

Experience in Patching / Upgrading SUN ORACLE EXADATA MACHINE (RDBMS / Grid infrastructure & Storage cells).

Experience in managing SUN ORACLE EXADATA using command line utilities such as CELLCLI & DCLI.

Experience with Exadata cell storage for extremely high performance data scans and Exadata Flash Cache using hot blocks.

Worked closely with oracle support to resolve EXADATA hardware / Flash Disk / Battery Replacement / Storage software issues.

Experience in recreating Flash Cache after replacing Flash cards as a part of Flash Disk Failure.

Experiencing in diagnosing EXADATA storage / firmware / Cell and Grid disk issues.

Hands on experience in patching EXADATA storage cells / RDBMS / GRID infrastructure.

Implemented Hybrid Columnar Compression based on the business requirements.

Implemented Cell offloading on EXADATA to push the sql’s to the storage and thus improving the I/O performance on the queries.

Experience in patching RAC databases in rolling fashion to maintain high availability.

Experience in cloning the GRID infrastructure binaries onto different server.

Experience in Installing and Extending the Infrastructure on New Exadata Racks.

Installed 12.2 agents on all remote databases to manage them using OEM grid control.

Manage Administration and Supported Databases using Grid Control (OEM).

Patching & Upgrading

Experience in Applying CPU / PSU / MLR and Bundle Patch to Oracle Server.

Applied Patches, Patch Set update and One-off Patch using OPatch and runinstaller.

Upgraded 11201 to 11203 using 11g “Out Place Upgrade” Method.

Applied one-off patches to various oracle rdbms versions.

Applied the Bundle patched on DB Systems every half yearly on the Exadata Machines.

Worked on Identifying and Fixing the IB Switch Failures.

Performance Tuning:

Tuning Heavy database loads at O/S level using commands such as top, sar, vmstat, i/o stat and glance commands to identify the CPU bottle necks and memory issues.

Tuning Application sql’s using SQL Tuning Advisor, SQL Profiler, SQL Baselines and 11g SQL Plan Management techniques along with Explain Plan, SQL Trace and TKPROF utilities.

Experience in tuning database and memory components for optimal performance using v$ performance views and command line skills to identify information about sessions, wait events, system performance etc...

Experience in enabling trace at session level and various trace events to find the root cause and hang analysis.

Monitoring databases and Performance tuning using diagnostic packages AWR, ADDM engine and ASH reports.

Experience in using packages like DBMS_STATS to gather the statistics.

Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.

Performed general DBA tasks, such as user privileges, monitor space usage, monitor physical resources (disk space, memory, CPU, etc.) set up database performance alerts, daily error checks, database health and trouble shoot database related issues.

Defragmented Database segments in Tablespaces by releasing space by Reorganizing application specific objects for large size database.

Exposure to working with Oracle Support to resolve ORA-0600 / 7445 related internal errors and raise priority tickets & using Oracle Web Conf.

Backup / Recovery and Refresh

Experience with RMAN utility with recovery catalog and without catalog.

Implemented RMAN full and incremental backups to schedule for off working hours for all Production, UAT and Development Databases.

Worked extensively on PITR, TSPITR and Flashback Table to recover the dropped tables.

Migrated Non-ASM to ASM file system using RMAN utility.

REFRESH/CLONING of Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.

Experience with Transportable Tablespace (TTS) method to move huge data at tablespace level.

Extremely proficient with RMAN, Restore and Recovery scenarios and planning Backups.

Experience in using packages like DBMS_JOBS, DBMS_SCHEDULER and CRONTAB to schedule tasks.

Experience in KSH, PERL, BASH scripting. Written various shell scripts to monitor database connectivity, Listener Connectivity, Tablespace and File system monitor.

Experience working with Oracle Enterprise Manager, working with ASH, AWR reports, ADDM, STATSPACK and gathering statistics.

Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.

Environment:

Oracle 11g, Oracle 12c, RHEL AS 6, OEL 6, Grid Control (OEM), RAC, Oracle Cluster, Oracle Clusterware, ASM, CRS, Materialized Views, RMAN, SQL PLUS, Shell Scripts, PERL Scripts, Putty, TOAD, Winscp, Psftp.

ORACLE CORPORATION Jul ‘12 - Dec ‘12

Role: Oracle Database Administrator

Project: RAC and DR Solution Implementation

Client: TCF GATEWAY

Responsibilities:

Provided and Implemented Clustered (RAC) architecture for the Tier-1 Mission critical application and migrated the data from the current standalone 10.2.0.5 production environment to 11.2.0.3 Grid Infrastructure with 10.2.0.5 RDBMS Version.

Installed and Configured 11.2.0.3 Oracle Clusterware with 10.2.0.5 RDBMS on Solaris version 10 with ASM file system from the scratch.

Performed de-installing the cluster and re-install after fixing failed root.sh script on other nodes in the cluster due to an issue with the jumbo frames on private interface.

Reviewed thoroughly and validated Network Requirements to Implement “JUMBO FRAMES” on Private Interface for Node connectivity.

Experience in using Network utilities to trace the data packets and hops using “tracert”.

Experience in Managing Clusterware using “CRSCTL” commands, IP Interfaces using “OIFCFG” commands and Database management using “SRVCTL” commands.

Created Various Disk groups for OCR, Vote Disk, C/R/D Files and archived logs with normal redundancy for High Availability.

Exposure to pin the nodes in the cluster using “OLSNODES” command for hybrid environment with 10.2.0.5 RDBMS using 11.2.0.3 Grid Infrastructure.

Experience with Attaching Oracle RAC RDBMS Home to the existing oraInventory using OUI in silent method.

Performed Cloning RAC database using RMAN to refresh the data from the Production database to the Lower Environment on demand.

Configured high availability services TAF, load balancing and SCAN features for clustered databases.

Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages.

Performed Various Destruction Testing scenarios to validate RAC cluster stability.

Created Reports and documented the 11g RAC health Check as well as implemented best practices.

Installed Physical Standby Database as a part of disaster recovery for RAC production system with Max Performance Mode, LGWR Async and Real Time Apply with ASM file system on Solaris 10.

Data guard Architecture: 2 Node RAC primaries with ASM file system having non-RAC database as physical standby database with ASM file system on standby site.

Performed Switchover, Failover, Network Failure Tests and well documented the steps for the customer’s DBA survival guide

Resolved GAP issues between primary and standby using Manual method by copying the missing archive logs and registering at the standby site.

Performed RMAN SCN incremental backup to roll forward the standby database to keep in sync with the primary database when there was huge Gap between primary and standby.

Implemented shell scripts to monitor data guard environment.

Integrated rman utility with Tivoli net backup by configuring tape libraries to communicate with the media server for various backup policies.

Implemented RMAN incremental backup and performance parameters for the faster backup.

Created DB console for the customer and implemented monitoring alerts and configuring targets and threshold values.

Actively participated and communicated with various Business, System Engineer, Network Admin and Sungard storage teams to make this project go live without unexpected issues.

Completed all the above Tasks within given timelines and conducted knowledge transfer to the client’s DBA team as well as provided documentation for reference as survival guide.

Environment / Tools:

Oracle 11g, Oracle 10g, SOLARIS 10, Grid Control (OEM), 11g RAC, 11.2.0.3 Oracle Clusterware, ASM, Grid Infrastructure, RMAN, Export / Import, SQL PLUS, Shell Scripts, PERL Scripts, Putty, TOAD, Winscp, Psftp.

COX COMMUNICATIONS, ATLANTA, GA Jan ‘11 – Jun ‘12

Role: Oracle Database Administrator

Responsibilities:

Business Process Knowledge:

Provided Primary architectural and administrative support for new projects.

Experience with business process models for IT support such as ITIL, Change Control and Change Advisory Board (CAB).

Actively Participated in coordinating with Line of Business (LOB) and application team in moving the project “Go Live” without any unexpected issues.

Experience in using various Ticketing systems Remedy, HP, Nexus and Home grown ticketing Applications.

Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.

Exposure to SOX, PCI and HIPAA security compliances.

Provided 24x7 on-call support for production systems during on-call rotation.

RAC Architecture in brief:

OEL 5.5, X86_64, EMC power path and fiber HBA for SAN/TAN connectivity, Gigabit Ethernet for cluster interconnects, EMC symmetric SAN storage, CRS configuration files on RAW and ASM for database files, 4 node cluster and oracle 11gr2 rdbms version.

Configured high availability services TAF, load balancing and SCAN features for clustered databases.

Extensively used SRVCTL, CRSCTL, CLUVFY, OCRCONFIG, ADRCI and ASMCMD control.

Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages.

Hand on experience in installing and managing ASM instance, diskgroups, asm disks, asm rebalancing and asm data dictionary views.

Design, Development & Implementation of large volume OLTP and large scale Data Warehouse/DSS environments.

Experience with oracle Golden Gate replication tool and its components.

Installed and Configured oracle Golden Gate unidirectional table level / schema level between homogenous oracle to oracle rdbms replication.

Good understanding of Golden Gate components like Extract, Replicat, Trail Files, GGSCI commands, Translog options etc ….

Performed replication between databases using Materialized Views and DB links from a remote database.

Experience in handling large database up to 6 TB in size with 4 nodes cluster on various flavors of UNIX.

Hands on experience with 11g new features such as ADRCI, Duplicate from Active database, asmcmd, Memory parameters, Incidents etc

Configured Oracle 11g /10g Physical Standby Database for DR purpose using ORACLE Dataguard.