Data Manager

Oracle Database Administrator

Theja K

Email ID: ******.*****@*****.***

Mobile: 571-***-****

PROFESSIONAL SUMMARY:

Over 8 years of professional experience as Oracle Database Administrator having good experience in Database administration, Database Installation in different platforms include Linux,Windows,Unix up-gradation, Migration, Installing patches, Performance Tuning, RAC Installation and Maintenance, setting up and configuring Data-guard, Performing all kinds of Backups and Recoveries, Cloning Databases, replications using Golden Gate and Auditing in Development and Production Environment.

Hands on experience on Oracle (10g/11g/12C), Installing and configuring, maintaining Oracle databases on different operating systems like Oracle Linux, Red Hat Enterprise Linux (RHEL) 4.x,5.x, 6.x, AIX 6.1, Sun Solaris 5.8,5.9, Windows 2008 for OLTP & OLAP environment.

Experienced in Installing, Configuring and Maintaining Real Application Cluster (10g RAC/11g RAC).

Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), Toad, Expdp, Impdp.

Expert in Performance Tuning regarding Tuning applications, Shared pool, I/O Distribution, rollback segments, buffer cache, redo mechanisms.

Experience in working on large database size greater than 12TB and Handling 50+ Production and 100+ Dev Databases.

Involved in Golden Gate Installation, configuration and testing on Dev and Test environments.

Created user accounts on the database for the Golden Gate and granting privileges & troubleshooting the issues while replicating the data.

Installed patches using Opatch utility and upgraded databases on 10g/ 11gR2 and expertise in applying Oracle PSU and CPU patches Up-gradation and migration.

Experience in Capacity Planning, Security Audits and made architecture recommendations that lead to a successful implementation.

Experience in Configuring & managing Physical Standby Database using Data Guard Broker.

Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL.

Excellent experience in Hot/Cold Backup and Recovery, Materialized Views, Export/Import, Data Pump, Data Guard and Cloning of databases using RMAN.

Experience in Working with Oracle on Exadata related Issues/Investigations & Troubleshooting Exadata

Good knowledge on Oracle support process for technical requests using Metal link and other support features.

Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

Good written and verbal communication skills, self-motivated team player and good analytical thinking.

Experience in Database Migration using Golden Gate, Export & Import data pump utility.

Experience in providing accurate and timely problem resolution with root cause analysis.

Used Oracle scheduler and Unix Cron utility for automating jobs.

Experience in using SQL* LOADER to load data into oracle database.

Proficient in PL/SQL, SQL and UNIX Scripting.

TECHNICAL SKILL SET:

Databases

Oracle 12C/11gR2/10g.

Operating Systems

Oracle Linux, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, AIX 6.1, Sun Solaris 5.8, 5.9, Windows 2003/2008

Languages

C, C++, PL/SQL, SQL, Unix shell scripting

Utilities & Tools:

Oracle Enterprise Manager/Grid Control, SQL Developer, Putty, DBCA, Oracle Data Guard, Data Pump (expdp, impdp), Toad, RMAN

Oracle Products

Oracle RAC11g,GoldenGate,Data-guard,Import and Export, Data pump, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c (Grid Control), RMAN.

PROFESSIONAL EXPERIENCE:

K12 Inc., Herndon VA Sep 2014 – Till Date

Role: SR. Oracle DBA

K12 Inc. is a profit education company that sells online schooling and curriculum to state and local governments. Its educational products and services are designed as alternatives to traditional "bricks and mortar" education for public school students from kindergarten to 12th grade. K12 is a publicly traded education management organization (EMO) that provides online education services to charter school students. It is paid for from taxes. K12 is the largest EMO in terms of enrollment.

Responsibilities:

Involved in upgradation of databases from 11.2.0.4 to 12C in QA and DEV environments.

Created users, roles and granted privileges according to the business requirements.

Responsible for UNIX system administration routines such as user security, disk space allocation, RAID configuration and system backup and recovery.

Monitored the data files, log file space issues, blockings, and Tempdb space issues.

Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

Executed DDL changes Capacity planning and forecasting Query tuning and optimization.

Responsible in Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.

Implemented Golden Gate Bi-directional replication on couple of schemas by analyzing the requirement.

Responsible for creating the disk groups and adding disks to diskgroups in ASM filesystem. Also, used v$ views and ASMCMD utility to maintain and monitor ASM.

Implemented procedures for performance optimization and development of database applications.

Supported SQL queries and databases by updating and tuning in proper manner.

Created a disaster recovery (DR) document that recommended five different approaches to managing Disaster Recovery, implemented, tested and supporting resulting strategy.

Installed patches using Opatch utility and upgraded databases.

Developed new architecture components in collaboration with storage administrative teams.

Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.

Formulated strategies and plans for system backup services, recovery and availability schemas.

Created duplicate databases using RMAN.

Used Oracle Enterprise Manager (OEM) Cloud Control 12c for Database monitoring.

Recovery of Database using oracle recovery manager RMAN (Performed full recovery and point in time recovery).

Developed hot, cold and logical backup scripts to automate the backup procedures.

Written SQL, PL/SQL functions, procedures, packages and triggers.

Configured ASM and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.

Responsible to monitor database performance using AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control, generated reports as needed.

Implemented Oracle Partitioning, Advance Queuing and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience.

Responsible to develop UNIX shell scripts to automate support tasks.

Used Oracle scheduler and Unix Cron utility for automating jobs.

Maintained system documentation relating to application architecture, assembling and technical platforms.

Provided Oracle Database Performance tuning and SQL Tuning using SQL TRACE, AWR, ADDM, & EXPLAIN PLAN.

Environment: Oracle 11g/12c, RMAN, OEM, Data Guard, Oracle RAC, ASM, Golden Gate, Replication, Data pump, Performance tuning and UNIX.

Johnson & Johnson Health Care Systems, Piscataway, NJ Feb 2012 - Aug 2014

Role: Sr. Oracle DBA

Johnson & Johnson is an American multinational medical device, pharmaceutical and consumer packaged goods manufacturer. It is an organized on the principles of decentralized management group responsible for strategic operations and allocation of resources. Its operating companies are organized into three business segments: Consumer, Pharmaceutical and Medical Devices and Diagnostics. It’s a manufacture and sale of broad range of products in the health care field in many countries of the world.

Responsibilities:

Upgraded Databases from 11.2.0.1 to 11.2.0.3 and applying patches as per requirements

Involved in designing of Disaster Recovery using Data Guard and High Availability using 11gRAC.

Performed FLASHBACK features to handle efficient database recovery.

Successfully implemented ASM and streams replication.

Responsible in taking daily/weekly hot backups and cold backups using RMAN.

Installed Golden gate on source and target side for Replication and implemented load balancing topology using Golden Gate.

Developed Scripts for transferring data from production server to testing/development servers.

Configured Golden Gate Parameter files for Extract and Replicat process for replication.

Relocating services, using srvctl to stop start instance or database, create and drop services, node eviction issues.

Supporting Multi node 11g RAC database for HA and supporting Data Guard environment for HA.

Performed day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Responsible in refreshing the test and development databases from the source production databases on a regular basis using export/import utility.

Migrated the databases from NON-ASM to ASM filesystem and onto different server using RMAN backup and recovery.

Responsible for network configuration and involved in a Client-Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.

Provided technical assistance for establishment and tuning of database servers and migration processes.

Worked on installing the data guard on RAC databases for disaster recovery and setup the DataGuard broker. Tested the DataGuard switchover on the RAC databases manually and also using DataGuard broker.

Used Oracle Tools and utilities such as TOAD, SQL*Plus, SQL Developer.

Configured ASM and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.

Implemented Oracle Data ware house tool CDC (Change Data Capture), as a result of data corruption by successfully applying the archive redo log files.

Created Shell scripts and scheduled for monitoring Oracle Databases.

Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.

Performed hot, cold, tablespace level backups.

Applied High priority, security patches downloaded from Metalink.

Applied patch set and interim patches whenever required to make the database software up to date.

Written SQL, PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 11gR2, Oracle Enterprise Linux 5.2/6.4, RMAN, Oracle 11g RAC, ASM, OEM, Data Guard, OEM, SQL*Loader, Toad and SQL developer.

Sears Holding Corporation, Chicago-IL Oct 2010 – Jan 2012

Role: Sr. Oracle DBA

Sears Holding Corporation is an American holding company headquartered in Hoffman Estates, Illinois. It is the owner of retail store brands Sears and Kmart. Sears Holding owns the brands craftsman Kenmore and diehard Sears Holding operates 1725 retail locations under the mastheads of Sears, Kmart, and their subsidiaries, such as auto centers and pharmacies. Since 2013, the company is the 13th largest retailer by annual revenue in the United States.

Responsibilities:

Responsible for Installation, configuration and setup Oracle 11g databases.

Responsible to install, configure, and setup Oracle 11g Data Guard as High Availability. Implemented the Oracle 11g Data Guard between Primary database and standby database in production and test environments.

Performed the Upgrading of databases from 11.2.0.1 to 11.2.0.3.

Responsible to analyze and resolve, or recommend solutions to highly complex technical problems such as performance issues, reliability issues, and data quality issues, and also tuning the Oracle RDBMS (database initialization parameters, redo log files, archiving etc.)

Responsible for developing and scheduling jobs and UNIX crontab and its scripting to automate and scheduling various routine maintenance tasks.

Efficiently used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.

Implemented ASM on RAC and stand-alone databases and managed disks and disk groups with ASM.

Responsible for Data modeling, metadata management, database design, database administration and support throughout the system lifecycle for project.

Responsible for build database(s), maintain database baselines, support application requirements, testing and implementations.

Up-gradation / Migration of dev/test/prod databases from 10g to 11g.

Involved in the implementation of High Availability solutions with Oracle 11g RAC.

Worked with other DBA’s for Capacity planning of new Databases. Data replication between different Oracle databases using DB Links. Setup test environment to simulate the migration process.

Suggested improvement processes for increasing efficiency of applications and current processes.

Worked with backup support team to implemented hot/cold backups using RMAN and recovery using RMAN, Export/Import and Data Pump utilities.

Responsible to implement tablespace, table and indexes Oracle compression in dev/test and production.

Responsible to monitored database performance using AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control, generated reports as needed.

Responsible to work with system admin’s to server virtualization using VMware for Oracle database support.

Responsible to develop UNIX shell scripts to automate support tasks.

Extensively used Rational Clear case, clear quest, Toad, SQL developer, SharePoint tools to manage and maintain Oracle databases.

Environment: Oracle 11g, Toad, RMAN, UNIX, OEM, Data Guard, Data Pump, Oracle 11g RAC, ASM, PL/SQL, Korn shell, Toad, and Win SCP.

CAPITAL IQ, Hyderabad, India Sep 2009 – Sep 2010

Database Administrator

Responsibilities:

Managing databases using Oracle 10g Grid Control.

Created and Managed Standby Database. Installed and configured Data Guard.

Used Data Guard broker to monitor Data Guard configurations on standby database.

Good working and implementation knowledge on Data Guard and Stand-by databases for fail-over and recovery.

Responsible for network configuration and involved in a Client-Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.

Created and configured database manually using Oracle Database Configuration Assistant.

Implemented backup strategy using RMAN, Oracle Utilities (Export/Import) and OS methods.

Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.

Responsible for installation and administration of Oracle 10g on Linux and Solaris platforms.

Also implemented logical, cold and hot backups.

Partitioning Tables by determining the suitable methodology to improve performance and manageability.

Applied patches whenever necessary by downloading them from Metalink.

Involved in doing block recovery and backup validations using RMAN.

Rebuilt indexes for better performance of Oracle database.

Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.

Performance tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.

Performed database object sizing (performance tuning of database objects) and space allocation.

Environment: Oracle 10g, Windows 2007/XP, OEM, Data Guard, Performance Tuning, EXPALIN PLAN, EXPORT/IMPORT, RMAN, and NETCA.

Axis Bank, Bangalore, India Aug 2007 – July 2009

Database Administrator

Responsibilities:

The work involves overall Maintenance of ORACLE Database, Performance Tuning, Backup, Recovery and other database related activities.

Worked extensively on developing various data base objects like Tables, Views, Materialized Views, Stored procedures, Triggers and Packages.

Hands on experience on Installing oracle server 11g, creating, Maintaining and upgrading for different environments.

SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.

Generated PL/SQL blocks proficiently using dynamic reference cursors.

Skillfully used various built in packages like DBMS_OUTPUT, DBMS_SCHEDULER, DBMS_ALERTS and others.

Worked with Development team to fulfill the requirements of applications with Database design.

Involved in applying latest patches on the oracle database and also upgrading the database.

Responsible for modifying the database structure as required based on information given by the developers.

Performed code performance tuning (rule based and cost based) and optimization using Execute Plan, TK proof and Trace files generating indexes and providing hints.

Loaded data from flat file into the Oracle system developing SQL* LOADER scripts.

Configuring network components like TNSNAMES, Names Server etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.

Created and maintained Snapshot sites and Master site with Replication Groups.

Developed UNIX awk and sed scripts according to the user requirement.

Partitioning Tables by determining the suitable methodology to improve performance and manageability.

Involved in handling day to performance issues and keeping a track of alert logs etc for tracing any abnormal activity.

Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.

Environment: Oracle 10g, Windows 2007/XP, UNIX, EXPALIN PLAN, EXPORT/IMPORT, Performance Tuning, SQLLDR, and RMAN.

ACADEMIC PROFILE:

Bachelors in Electrical Engineering from JNTUA, India

Contact this candidate