Oracle Data

DEEPTHI M.D.

Senior Oracle Database Administrator

SUMMARY:

•10 years of experience as Oracle Database Administrator in (24x7) Production Support Environment.

•Expert Database Machine Administrator managing Oracle X5/X3 Exadata Appliance, handling Exadata machine by managing all components – compute nodes, storage nodes, IB switches, PDUs, and ILOMs.

•Proficient in core database administration tasks like Installation, Configuration, Database Creation and Patching of Oracle databases on different environments like Oracle Exadata Machine, Sun Solaris, RHEL, HP-UX, IBM-AIX and Windows Server 2016/2012/2005/2003

•Experienced in 12c Multi-Tenant Architecture, provisioning, patching, consolidation and efficient resource utilization of 12c databases on RAC and Exadata

•Experience with Database Backup (RMAN) and Recovery procedures to DataDomain Appliance and NetApp AltaVault

•Experience in Performance Tuning such as tuning of memory, CPU, I/O distribution, shared memory segments using utilities like Exachk, Exawatcher, tfactl, Sundiag, sosreport, Explain Plan, Statspack, OEM, AWR, ADDM, ASMM, TKPROF

•Experience in modifying existing shell scripts and writing new shell scripts as per environment and database version requirements

•Experience handling corruption issues (physical/logical) in Oracle databases

•Experience in installing, configuring, patching, and managing Oracle 12c/11g/10g RAC with ASM and SAN storage systems

•Experience in resolving Peregrine Tickets (Service Centre), BMC Remedy, Maximo.

•Experience in working a team-oriented, collaborative environment. Good interpersonal, written, and oral communication skills.

•Experience in setting up, monitoring and maintaining table and schema level replication using Oracle Golden Gate.

•Extensive experience in maintaining Disaster Recovery sites with physical standby databases using Data Guard Broker

•Adept in OEM Cloud Control 13c/12c, Database Control 11g/10g, Grid Control 10g, SQL*plus, iSQL*Plus, Data Pump, DBVERIFY and SQL*Loader.

•Designed and implemented Backup and Recovery strategies. Also used methods like PITR, full/partial export/import, and Flashback Technologies

•Experience in interacting with Oracle MOS for incidents to resolve issues

•24 X 7 Production Support for Oracle databases

EDUCATION, CERTIFICATIONS & APPRECIATIONS:

•Bachelor of Engineering in Computer Science - SRM Valliammai, India.

•AWS Certified Cloud Practitioner

•Oracle 10g Certified Associate

•Received appreciation from World Bank Group for supporting Oracle 12.2 Grid Home upgrade,

Exadata QFSDP patching cycle.

•Won BRAVO award from IBM for Process adherence and Quality work.

•Won YASHAS award from IBM for Excellent Performer in Delivery Center.

TECHNICAL SKILLS:

Appliance

Oracle Exadata X5-2, X3 Machines, ODA, Data Domain

Relational Databases

Oracle 12c/11g/10g/9i, MySQL 5.0, MS Access 2003

Programming Languages

SQL, PL/SQL, UNIX Shell Scripts, HTML, C#, Java, C

Tools

Oracle Enterprise Manager Cloud Control, Grid Control, Toad DBA Suite for Oracle 9.7, 10.6, 12.6, SQL Developer, IBM Rational Team Concert (RTC), SQL Navigator 5.5, 6.0, WinSCP, Cygwin, Core FTP Lite, Xmanager 3.0/2.0, MobaXterm Personal 6.0, SQL Developer 1.1/1.2/1.5, PL/SQL Developer 5.0/8.0.4, Putty, Exceed 2007 Hummingbird (12.00), Splunk, BMC Remedy IT Service Management, NoteTab Light, Foglight 5.2.6.10/5.5.8

Backup Utilities

RMAN, Data Pump, import/export, Data Domain, Commvault, TSM client, NetApp AltaVault, Netbackup for tapes

Replication

Oracle Golden Gate 11.2.1.0.5/11.1, Oracle 11g/10g Streams Replication, STRMMON Monitoring Utility, Streams Performance Advisor, Materialized Views

Disaster Recovery

Physical Standby (Data Guard), Logical Standby, Active Data Guard, Snapshot Standby, Data Guard Broker

Tuning Tools

OEM 13c/12c/11g, AWR, ADDM, Statspack, Explain Plan, TKPROF, Exachk, Exawatcher, tfactl

Querying

SQL*plus, iSQL*Plus

Scripting

UNIX Shell Scripting

Data Modeling Tools

Microsoft Office Visio

Protocols

TCP, FTP, SCP

Storage System

ASM (Automatic Storage Management), EMC SAN, NFS, VNX, PURE, UCS, Data Domain

Cluster Database

Oracle 12c/11g/10g RAC

Operating System

Red Hat Enterprise Linux x86_64 7.4/7.5, Oracle Linux 6.4/6.7, Sun Solaris 5.8/5.10,HP-UX, IBM-AIX 7.1/3.5, Windows Server 2016/2012/2005/2003

EXPERIENCE:

Client: World Bank Group, Washington, D.C. Jan 2016 – Nov 2018

Artech Infosystems Private Limited

Senior Oracle Database Administrator/Database Machine Administrator

Team size -14 members

•Lead DBA for the migration of Oracle databases from AIX to Exadata X5-2 half rack database machine

•Received Client appreciation from World Bank Group for supporting Oracle 12.2 Grid Home upgrade, Exadata QFSDP patching cycle.

•Worked directly with Oracle ACS engineers and Platinum support engineers for Exadata QFSDP patching cycle to Test, Stage, Prod and DR Exadata machines

•Handled Exadata hardware issues like disk failure, motherboard failure on cell node, RAM issues

•Worked directly with Oracle ACS engineers to add storage nodes to existing configuration without downtime

•Identified Bug 28390273 for 12R2 production databases generating huge RMAN trace files filling up base /u01 directory and implemented fix to disable KRB trace files

•Primary DBA to upgrade databases for RISK applications from 11.2.0.4 to 12.2.0.1 and Financial applications ICRA and IPAR from 12.1.0.2 to 12.2.0.1

•Primary DBA for migration of existing production 11.2.0.4 databases to Exadata database machine

•Performance Tuning for unoptimized SQLs, long running BO reports, and ETL feeds running on Exadata and Linux servers

•Involved in benchmarking warehouse workload performance on Oracle Exadata vs AWS RedShift

•Troubleshoot performance issues during database upgrades and migration of databases to Exadata

•Primarily involved in ODS upgrade which is a complex environment that has huge inbound and outbound feeds that needed tremendous performance tuning analysis

•Worked with OIS team directly to fix vulnerabilities identified from periodic DB scans

•Worked with KPMG team for internal audit and risk evaluation tickets.

•Actively involved in performance tuning of feeds, Cognos reports and cubes

•Supported ETL Informatica PowerCenter team for daily and intraday ETL inbound and outbound feeds.

•Configured RMAN Backups to Alta Vault and modified existing scripts as well.

•Build DR standby databases and involved in load shift DR exercises and datacenter isolation for Production databases. Implemented Broker for Oracle Data Guard configuration.

•Refresh and restores of stage, dev and test environments when needed

•Handled hot and archivelog backups to tapes of Oracle databases using Simpana Commvault client and to DataDomain Appliance and NetApp AltaVault

•Primary DBA for CAPRI and SPARK upgrades and involved in a POC for GG implementation

•Implemented Exadata best practices (X5-2) based on exachk reports. Monitored alerts via ILOM monitoring for both compute and cell nodes.

•Involved in CAB meetings and supported deployment activities during releases on production databases

•Oracle 12c/11g client installation assistance to developers and AST teams

•Worked with Oracle via Service requests when required

•Provided DBA support for production deployments for application releases using approved JIRA and Remedy tickets

•Participated in 24x7 On-Call rotation for production databases support

Client: World Bank Group, Washington, D.C. Jun 2015 – Dec 2015

Polaris Financial Technology Limited

Sr. Oracle Database Administrator

Team size -14 members

•Primary DBA for a POC on ODA database machine (mini version of Oracle Exadata). This machine hardware is X3-2

•Involved in successful database upgrades of ODS, CAPRI, SPARK, CVAR, AML from Oracle 10.2.0.4 databases to 11.2.0.4 with latest SPU patches on AIX and Linux servers

•Worked with Primary DBAs to support legacy application databases

•Installed, created and configured 12.2.0.1 and 12.1.0.2 databases

•Involved in DR tests for switchover from Primary to Standby and switchback activities

•Created production Standby databases in new data center which successfully went live to production

•Monitored standby databases and did incremental RMAN backups from primary to resolve archive gaps when needed to sync with primary

•Monitoring space threshold levels at tablespace and augmented them when required

•Actively supported performance load test and aging test for any performance related issues

•Performance Tuning using Automatic workload repository (AWR), ADDM, Oracle Diagnostic and Tuning Advisors

•Tuned long running SQL queries using Explain Plan and Tuning Advisors for better performance.

•Managing database security by managing users, roles, and their privileges to database objects

•Monitoring tablespace threshold pro-actively for all the OLTP Productions DBs, Production Reporting DBs and augmenting tablespaces as and when needed.

•Monitored space at file system level for Production and DR sites and requested for re-size or new mount points as required.

•Scheduled RMAN incremental backups as cron job for the required Dev and Test databases.

•Create restore points and flashback databases to restore point as requested by the Test teams.

•Provided DBA support for production deployments for application releases using approved JIRA and Remedy tickets

•Participated in 24x7 On-Call rotation for production databases support

IBM Jan 2009 – Jun 2015

Clients: A.P. Moller – Maersk Group, Carlsberg Group, Spirit AeroSystems,

HealthNet Operations GR, Hertz

Oracle Database Administrator

Client: A.P. Moller – Maersk Group

Team size -18 members

•Installing, Upgrading Oracle Software.

•Regular meetings with the DBA group and working for the better performance of the applications environment and Database environment.

•Activities included allocation and maintenance of tablespaces, data files and redo log files.

•Support access control, development support, queries, data changes, implement and maintain database security (create and maintain users and roles, assign privileges)

•Applying PSU Patches and Bug fix patches.

•Creating and monitoring oracle backup scripts for periodic backup jobs and troubleshooting as required

•Create / Rename / Delete Database. Standby Rebuild, Resolving Log Gap Issues

•Database refresh of the Production & Test Database.

•Provide technical leadership to assigned tasks or projects

•Performing optimization tasks on the database such as rebuilding the indexes whenever required to increase the performance.

•Working closely with multiple teams and providing golden gate solutions as and when needed. Trouble shooting in GG. Configure and build Golden Gate Extracts/replicate.

•Pro-actively assess and identify database server resource requirements and communicate needs to Management.

•Created Shell Scripts for startup and shutdown of the database.

•Plan growth and changes (capacity planning)

•Coordinate interaction with vendors/Oracle support in critical database problem situations. Work with cross project teams to resolve technical performance issues/bottlenecks

•Proactively monitor the database systems to ensure secure services with minimum downtime.

•Solving RAC related issues like Node Eviction.

•Recover database from Backup & Disaster Recovery.

•Successfully faced many internal and external audits like Corporate audit, KCO, KPMG successfully with ZERO or minor findings.

•Identify, prioritize, resolve incidents before SLA breach (Handled P2, P3, P4, P5 level tickets and P1 call in support) and/or escalate issues as they arise to delivering solution on time.

•Experience in performance tuning, trouble shooting.

•Monitor sync between the primary database and standby database

Clients: Carlsberg Group and Spirit AeroSystems

Team size -5 members

•Worked as Team Lead and managed Oracle DBA Support Project providing 24X7 support to the client environments comprising basic day-to-day Oracle administration. activities, Performance Tuning, backup and recovery.

•Activities included allocation and maintenance of tablespaces, data files and redo log files.

•Applying PSU Patches and Bug fix patches.

•Response and Resolution SLA Management.

•Multi master replication activities.

•Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.

•Troubleshoot backup failure

•Provide on-call support for any urgent performance issues in production environment

•Document technical details of known issues and assist the team with building and maintaining technical repositories.

Clients: HealthNet Operations GR and Hertz

Team size -6 members

•Provided AS400 - L2 support for the customers of HealthNet

•Monitored system status & controlling system ASP

•Monitored & controlled jobs, job queues & subsystems

•Monitoring & controlling out queues & spool files

•Transferring & retrieving data to & from AS/400 servers

•Working on ROBOT and Advanced job scheduling

•FTP the files as required

•Media management with BRMS

•Performing manual & automated backups as per requirements

•Console and Batch monitoring for AS400, MPE and TANDAM Servers

•Backup monitoring for Data Protector

•Taking daily, weekly and Pre-monthly and Monthly backup for ALPHA System

•Running the requestor jobs in TANDAM Servers

•Reassigning the issues to predefined groups for different Servers and Applications

Contact this candidate