Oracle Data

Taruj Ansari

SKILLS SUMMARY

An Oracle certified professional DBA with 7+ years of demonstrated success in managing databases and software solutions with improvements to business functionalities.

Software: Installation and administration of Oracle database software 10g/11g/12c. Installation & administration of Red Hat Linux RHEL 3/4/5/6/7 operating system. Proficient in Oracle database administration from version 8i through 11g. Extensive experience with different Unix/Linux operating systems. Proficient in SQL and PL/SQL coding (expert level) for various applications. SQL and database Tuning for high performance. I have worked with various Oracle applications like Pro*C, sqlplus, PL/SQL, SQL*Loader, Datapump, Oracle Enterprise Manager/Grid control, SQL Navigator, RAC, Data Guard, Unix/Linux tools: awk, sed, vi, grep, tr, crontab. ERP programming in SAP(ABAP/4).

Databases: Oracle

Operating Systems: Sun Solaris, Red Hat Linux AS, NT, HP-UX, AIX, OS/2.

Hardware: SUN Servers, Fujitsu M series, HP9000, IBM-RS6000/AIX, Windows

EXPERIENCE

Corelogic (Fulltime)

Sr. Oracle DBA

6/2012 – Present

Installation and configuration of Oracle clusterware/RAC version 10g/11g/12c

Installation and configuration of Oracle 10g/11g/12c databases

Install and configure OEM 12c agents and OMS

Setting up and managing RMAN backups and recoveries

Database sizes ranged from 4 Terabytes to 80 Terabytes

Production support of over 100 RAC and non-RAC databases on AIX/Linux/Sun/Windows platforms

Allocating space using raw, ASM and regular file systems

Performance tuning of databases/SQL using Oracle 10g/11g/12c tools like AWR/ADDM/Explain plan/SQLT

Performance tuning of RAC bottlenecks

Creating and syncing physical and logical standby databases including data guard setup

Upgrade of databases from 9i/10g to 11g and to 12c. Patching of software/databases

Monitoring of databases using grid control, OEM 11g and 12c

Installing Golden Gate and setting up Replicats and extracts for DML’s from source to target

Troubleshooting Golden Gate replication issues

Tools used: Oracle database versions 10g/11g(11gR1 and 11gR2)/12c. OS supported: AIX, Red hat Linux (RHEL 3/4/5/6/7), Sun Solaris, Windows. Oracle tools: RMAN, data pump/export., ASM.RAC, Data guard, Golden Gate, Oracle grid control (OEM)

Ericsson (Contract)

Oracle DBA (11g/10g)

3/2010 – 1/2012

Installation and configuration of Oracle 11g/10g RAC/ASM databases with raw partitioning. Installation of Oracle clusterware

Production support/on-call support

Database/SQL performance tuning using AWR/Statspack, tkprof, Analyze, SQL trace, Explain plan, dynamic views, parameter tuning

Database cloning using RMAN duplicate

Use of transportable tablespaces for data migration

Mentoring and managing a team of developers

OEM grid for database management

Table/index partitioning for efficient data retrieval

Working knowledge of the new features of 11g

Applying patches on Oracle databases

Exporting and importing data between databases using data pump

Performing Backup and recovery using RMAN./Flashback

Creation of stored procedures/packages, database triggers and SQL Scripts

Internet applications deployment using Oracle app server

Tools used: Oracle 10g(10.2.x), Oracle 11g(11.1.0.6), SQL*Plus, SQL*Loader, PL/SQL, Data pump, Linux RHEL 4/5, ER/Studio, Oracle designer, DataPump, EM grid, OEM/Toad, RMAN, RAC, ASM. Unix/Linux tools awk, sed, tr, grep, vi, crontab, sudo, dd

Enfora (Fulltime)

Jr. Oracle DBA (11g, 10g and 9i)

7/2008 – 9/2009

Production support/on-call support by monitoring of over 50 Oracle instances for errors/performance under RAC clustering and ASM

Working with multi-terabyte databases

Database/SQL performance tuning using AWR/Statspack, tkprof, Analyze, SQL trace, Explain plan, dynamic views, parameter tuning

Database cloning (refresh) using EMC BCV split and hot backups

Creation of compressed tables

OEM grid for database management

Database upgrade from 9i to 10g

Working knowledge of the new features of 11g

Applying patches on Oracle database

Installation & Configuration of Oracle 10g databases in Sun Solaris environment

Exporting and importing data between databases

Creating partitions for large tables and creation of global/local indexes

Performing Backup and recovery using RMAN/Veritas netbackup

Creation of stored procedures/packages, database triggers and SQL Scripts

Tools used: Oracle 9i(9.2.x), Oracle 10g(10.2.x), Oracle 11g(11.1.0.6), SQL*Plus, SQL*Loader, PL/SQL, Data pump, Sun Solaris servers, Erwin, DataPump, OEM/Toad, RMAN, Unix/Linux tools awk, sed, tr, grep, vi, crontab, sudo, dd, OID,LDAP

EDUCATION

University of North Texas

Bachelor of Science in Computer Science

Contact this candidate