Oracle Database Administrator Resume
3.00/5 (Submit Your Rating)
UsA
SUMMARY:
- Over 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation
- Experience in OLTP/DW database systems, managing large Oracle databases VLDB.
- Worked as a team member to provide 24x7on-call production database support.
- Oracle Database Administration experience in variety of different environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
- Skilled in Oracle Data ware House Tool CDC(Change Data Capture)
- Worked with Oracle Databases (10g/9i/8i,8,7) on Unix/Linux/Windows platforms.
- Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Data Guard).
- Knowledge of database recovery techniques and implementation of those recovery techniques to ensure business continuity.
- Experienced in using Automatic Workload Repository (AWR).
- Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods
- Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin
- Good experience in Oracle Streams, Golden Gate.
- Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning
- Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, OEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
- Experience in Upgrading databases, applying patches.
- Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures
- Experience is Capacity Planning and Benchmarking.
- Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and OEM Grid Monitoring
- Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
- Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools
- Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
- Proven ability to adapt to demanding schedules and changing priorities and ability to function successfully in a highly stressful and critical environment.
- Strong analytical and problem solving skills with ability to work within team environment and independently when needed.
TECHNICAL SKILLS:
- RDBMS :Oracle 11g /10g RAC/9i
- Operating Systems :HP-UX, Sun Solaris, IBM AIX, Linux and Windows
- Languages :SQL, PL/SQL, Java, C, UNIX Shell Scripting,.NET Technologies
- Tools :OEM, RMAN, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD
- Tuning :TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
- ETL :Informatica 5.1, External Tables
- Other : Oracle Streams, Golden Gate, EMC, NetApp, Veritas NetBackup, TSM, HP OmniBack, Data ware House.
EDUCATION:
Bachelor of Technology in Electrical and Electronics Engineering