Oracle DBA

Sai Theja Email ID: *****.*****@*****.***

Oracle Database Administrator Mobile: 781-***-****

PROFESSIONAL SUMMARY:

Over 8 years of experience as an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, performance tuning, backup and recovery, space management, database security, migration, schema maintenance in platforms include UNIX, LINUX and Windows .

Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.

Proficient in performance tuning using Explain Plan, AWR, ASH, SQL TRACE, ADDM.

Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Extensively involved in Developing Stored Procedures, Functions and Triggers using T-SQL.

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

Worked on issues raised while replicating the data using GoldenGate.

Experience in database maintenance and deletions of table spaces, data-files, rollback segments and schema's, Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and users).

Good experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.

Experienced in application development support activities including database design, optimizing SQL queries, building complex SQLs, dynamic SQLs and triggers, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.

Competent and experienced in using IBM utilities, Omegamon and other third party tools like CA/DB2 tools.

Experience in Auditing and Capacity Planning, Configuring & Managing physical Standby Databases (Data Guard).

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

Enforcing security by creating Roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.

Has mentored Users and IT Staff in Application development in Db2 Database Technologies.

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

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

Experience in using 10g/11g DATAPUMP, AWR, ASM, ADDM, and Grid Monitoring & Oracle Enterprise Manager (OEM).

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

Experience in database migration using export & import data pump.

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:

RDBMS

Oracle 10g /11g,

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 10, Red Hat Linux RHEL 6.x, 5.11 and Windows /2003/XP/2008

Languages

C, C++, PL/SQL, SQL

Utilities & Tools:

Oracle Enterprise Manager/Grid Control, SQL Trace, SQL Developer, Putty, DBCA, Oracle Data Guard, RMAN, SQL*PLUS, SQL*LOADER, EXP, ASM, IMP, Data Pump (expdp, impdp), TOAD,SQL TRACE, EXPLAIN PLAN, RMAN AWR, and ADDM.

High Availability.

Real Application Clusters (RAC), Active Data Guard, SQL*Loader, Export/Import, Golden Gate setup, Data Pump.

PROFESSIONAL EXPERIENCE:

HP, Rocky Hill, CT Sep 2014 – Till Date

Sr. Oracle DBA

Responsibilities:

Responsible for Oracle 11gR2 installation, configuration the application, responsible to install, create database

Installation and configuration of Oracle RDBMS 11gR2 on Oracle Enterprise Linux.

Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager Grid Control, monitor users, table spaces, memory structures, rollback segments, logs and alerts.

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

Experience in fulfilling DBA daily activities, including schema management, user management (creating users, privileges, roles, quotas, tables, indexes, and sequence), monitoring, scheduling jobs, UNIX Shell Scripting. Performance tuning which includes creating indexes, analyze tables and indexes, explain plan.

Knowledge in handling Distributed database and replication environment issues with Mviews, Streams, Golden Gate and Advanced Replication

Managing, troubleshooting and resolving oracle database and applications issues.

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

Responsible to monitor 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.

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

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

Experienced in creating duplicate databases using RMAN.

Performed applying latest Oracle patches and security patches for Oracle databases.

Responsible for database performance tuning for memory (SGA), disk I/O contentions, rollback segment contention and application tuning.

Creating and Managing tablespaces, roles, quotas & tables.

Responsible to develop UNIX shell scripts to automate support tasks.

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

Enhancement of the existing PL/SQL objects like Procedures, Functions, Packages, views, materialized views.

Database & Instance configuration using Grid control, ADDM, ASMM, etc.

Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v$session and checking the space for normal segments, rollback segments.

Environment: Oracle 11g, RMAN, OEM, DATAGUARD, Oracle 11g RAC, ASM, GOLDN GATE Replication, DATAPUMP, TOAD, SQL, PL/SQL, UNIX.

Sears Holding Corporation, Chicago-IL Feb 2013 - Aug 2014

Role: Sr. Oracle DBA

Responsibilities:

Worked on import/export, export data pump/import data pump and SQL* loader.

Performed the Upgrading of databases from 11.2.0.1 to 11.2.0.3.

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

Upgrading Databases from 11.2.0.1 to 11.2.0.3 and applying patches as per requirements.

Performing 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.

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

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

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

Performed FLASHBACK features to handle efficient database recovery.

Created Shell scripts and scheduled for monitoring Oracle Databases.

Responsible for applying Oracle security patches, CPU patches, and release patches on all Oracle 11g and RAC databases. Responsible to create SR and work with Oracle support to resolve issues and apply recommended patches.

Management of table space growth, monitoring data files additions, extent growth.

Researching errors/issues/bugs which were impacting the performance of the database and recommended permanent solution without losing the performance.

Installation, configuration and creating new test databases for production and development databases.

Performed hot, cold, tablespace level backups.

Applied High priority, security patches downloaded from Metalink.

Implemented database auditing, data security and Remediate high-risk violation in production environment.

Implementing automated backups with RMAN using crontabs.

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

Developing Hot, cold and logical backup scripts to automate the backup procedures.

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

K12 Inc, Herndon VA Oct 2010 – Jan 2013

Role: Sr. Oracle DBA

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.

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.

Implemented ASM on RAC and stand-alone databases. Managing 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.

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.

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

Extensively worked, implemented Oracle Partition strategy on the tables and indexes.

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, OEM, Oracle 11g RAC, ASM, PL/SQL, Korn shell, Toad, Win SCP.

Dr. Reddy’s Laboratories Ltd., 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, TOAD, OEM, EXPALIN PLAN, EXPORT/IMPORT, RMAN, 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.

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.

Responsible for setting and managing user accounts, granting required privileges to users.

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, TOAD, OEM, EXPALIN PLAN, EXPORT/IMPORT, SQLLDR, RMAN, NETCA.

ACADEMIC PROFILE:

Bachelors in Electrical Engineering from JNTU Anantapur, India

Contact this candidate