CAREER SUMMARY:

• Over 8 years of experience of Oracle Database Administrator including 10g, 11g and 12c
• Managed databases on Linux, Solaris, Windows, AIX and HPUX.
• Refreshed data using exp/imp and data pump on a regular basis.
• Upgraded databases from 10g to 11g R2 to 12c
• 12c Cloud control / OEM / TOAD / SQL Developer
• Created documents to speed up future builds
• Database Patching
• Build RAC Clusters.
• Set up grid control alerts and thresholds
• Excellent troubleshooting skills and quick learner.
• Build Linux servers and build 12c standalone database server.
• Moved database from one data center to another using data guard.
• Configured / Managed ASM disks and disk groups
• Worked with Different teams to completed Build tasks
• Created documents to speed up future builds.
• Worked with Different teams to completed Build tasks
• Build Disaster Recovery sites using Oracle Data Guard.
• Installed and configured databases using silent install, OMF and via scripts.
• Has extensive knowledge in dynamic views and dictionary tables.
• Applied CPU and PSU patches.
• Extensive experience in OS space and tablespace management.
• Worked on database security and Fine Grain Auditing.
• Extensive work on shell scripting and documentation.
• Excellent Experience as Production DBA with 24X7 supports.
• Extensive experience in backup and restores using RMAN
• Database replication using snapshot, materialized views and advance replication methods
• Strong in writing shell scripts to setup cron jobs for checking Adaptive server's availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.
• Flexible and excellent team player. Ready to work in any shift.
• Set up grid control alerts and thresholds
• Excellent troubleshooting skills and quick learner.
• Build Linux servers and build 12c standalone database server.
• Moved database from one data center to another using data guard.

TECHNICAL SKILLS:

Operating Systems: RHEL, HPUX, AIX, Sun and Windows

RDBMS: Oracle 12c, 11/10g, SQL Server

Tuning Tools: ASH, AWR, ADDM, SQL Profile, SQL Baselines, Execution Plan, OEM

Languages: SQL, PL/SQL, UNIX Shell scripting, T - SQL

Tools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, TOAD, DBConsole, asmcmd

High Availability: RAC, Data Guard, ASM

PROFESSIONAL EXPERIENCE:

Confidential, ST Louis, Missouri

Oracle DBA

Responsibilities:

• Responsible for administration and supporting oracle 12c, 11g, 10g and 9i databases
• Performance tuning of applications and the databases Oracle 11g/10g
• Build 2-node RAC Cluster on Linux.
• Build Data Guard for RAC Cluster.
• Documented procedures.
• Proactive database monitoring using 11g grid monitoring tool.
• Install Oracle supplied tools to assist in database and SQL Tuning like SQLT
• Performing tuning of application with RBO, CBO, using Trace, tkprof, Explain plan, statspack, AWR, ASH and ADDM.
• Worked on slow running queries to optimize databases performance.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Worked on Performance Tuning tasks to reduce the query response time.
• Remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Performed tasks on setup users accounts, passwords, roles, profiles and quota
• Monitored data files, logical data storage and data growth activities
• Perform capacity planning required to create and maintain database environments.

Confidential

Oracle DBA

Responsibilities:

• This project pertains to installation of oracle 10g RAC and later converted to 11g upgrade.
• Responsible for administration and supporting Oracle 10g/11g.
• Provide ON-Call 24*7 Production Database Support having 5-6 TB in size.
• Implemented Data Guard for maximum availability.
• Responsible for restoring and recovering database as required for Oracle.
• Upgraded the database from Oracle 10g to 11g, configured on ASM, and applied oracle patches on need basis.
• Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installed, Configured, Upgraded and Performed Trouble Shooting for oracle Golden Gate 10g/11g Version.
• Proactively monitored the database and database access, and maintained the database security.
• Extensively worked under UNIX environment to provide DBA support.
• Ran the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Configured Oracle tools like SQL*Net to access the database from the network.
• Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
• Implementation of nightly logical backup. talink with Oracle Corporation and installation of patches
• Created Triggers for multi-master replication
• Worked with client on regular basis.
• Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
• Installed and configured database management system software.
• Developed and implemented backup and recovery strategies.