Experienced Oracle DBA with 7 years of experience in Oracle Database Administration in large-scale production environments across multiple platforms.
Proficient in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard
High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
Experienced in system Monitoring and Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, SQL, STATSPACK, TKPROF, AWR, ADDM and also Cluster Interconnect Tuning (RAC).
Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
Worked on large-scale databases with size around 10TB in large system environments.
Proficiency in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace.
Created indexes to facilitate easy user interface implementation and tuning.
Involved in construction of Disaster Recovery sites for all the Production and IST environments.
Performed Database Refresh from Production to IST, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.
Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
Cloned Database from Production to Test and Development.
Exporting and Importing of dumps using expdp and impdp.
Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
Database security using Oracle Security Features (roles, privileges), auditing, Transparent data encryption, DBMS CRYPTO.
Proficient in RMAN backups including full, incremental and cumulative.
Outstanding knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
Extensively worked on Import/Export and Data Pump Import/Export tools.
Knowledge in configuring ASM (Automatic Storage Management)
UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
Expertise in maintaining Database Security using auditing, TDE, data redaction, data masking, by creating users and assigning privileges and roles.
ORACLE DATABASE ADMINISTRATOR
Fidelity Investments - Durham, NC
August 2015 – april 2019
Oracle Database Administrator
Successfully installed and configured Oracle 188.8.131.52, Oracle 10.2.0.5 databases on AIX platforms.
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
Loading data from flat files to database using SQL*Loader, External Tables.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Optimized the performance of the database. Tuned SGA data dictionary and set database parameters
Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments.
Involved in construction of DR sites for all the Production environments.
Configure ORACLE unidirectional GOLDEN GATE for data integration, transaction data replication across heterogenous system.
Troubleshoot typical Oracle Golden Gate (OGG) technical problems, such as unique key violation and long transaction, by using GGSCI/ Log dump /discard file analysis etc
Installed 12c database
Worked on Multitenant databases.
Performed Database Refresh from Production to QA, UAT and Development databases.
Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
Extensive experience in RMAN recovery testing, RAC and standalone database
Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)
Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
Performing monthly and annual performance reports for trend analysis and capacity planning.
Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible, among others.
Worked on both VMS and UNIX environments.
Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB (very large databases) environments, Oracle OLTP.
Experience in writing UNIX/SHELL scripts for providing the reports.
Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
Environment: Oracle 10g/11g/12c VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
Weis Market Inc - Sunbury, PA
November 2013 – July 2015
Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
Performed up-gradation of 10g to 11g.
Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
Automated routine DBA tasks like backup's and stats by using Grid control job's
Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
Implement Oracle Golden Gate (OGG) to replicate data from front-end OLTP databases to back-end Data Warehouse systems.
Troubleshoot typical Oracle Golden Gate (OGG) technical problems, such as unique key violation and long transaction, by using GGSCI/ Log dump /discard file analysis etc.
Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
Setup RMAN solutions for all Oracle Databases -- created Rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
Adding and removing nodes to existing Oracle database RAC configurations
Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.
Performed activities like monitoring the database and provide maximum uptime.
Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
Created primary database objects (tables, views, indexes) once application developers have designed an application
Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.
Environment: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, ERWIN 7.2, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader
DexMedia - Dallas, TX
March 12 – November 13
Junior Oracle Database Administrator
Created primary database objects (tables, views, indexes) once application developers have designed an application
Reorganized datafiles, identified and eliminated contention factors like I/O, buffers and locks.
Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment
Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database
Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks
Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters
Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing
Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks
Environment: HP-UX, Windows, Oracle 8i, 10g,11g,12c, SQL, PL/SQL, SQL plus.
HIGH SCHOOL DEGREE in MATHEMATICAL and PHYSICAL SCIENCE July 2010.
BACHELOR’S DEGREE in computer science + 1 year master degree in COMPUTER SCIENCE 2010-2014.
CERTIFIED SCRUM MASTER
ORACLE 12C CERTIFIED ASSOCIATE
HP-UX, Sun Solaris, AIX, Linux Enterprise Server, Windows 2012
Oracle 10g, 11g, 12c
SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
PLSQL, Unified modeling language ( UML ), Information systems, modeling and programing mobile and web application
C, C++, JAVA