Oracle Dba Resume
4.00/5 (Submit Your Rating)
St Louis, MissourI
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.