SUMMARY:
· Around 8 years of experience as an Oracle Database Administrator, working with prestigious organizations having hands on experience in database administration production, support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security & auditing.
· Proven Experience with 10g Release 2, 9.2.0.2 - 9.2.07, 8.1.7.4 and 8x versions.
· Experience in OLTP/DSS database systems, managing large Oracle databases.
· Proven experience with database performance and tuning techniques to enhance database optimization plans.
· Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
· Experience with Oracle 11g/10gRAC/9i/8i in Installation, Administration, Monitoring, Maintenance, Performance Tuning, Database Backup and Recovery.
· Knowledge of SQL analysis tools and database internal debuggers including ORADEBUG.
· Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.
· Installed Oracle 10g RAC with ASM and OCFS2 File systems.
· Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
· Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases.
· Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
· Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
· Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
· Expertise in maintaining Database Security using auditing.
· Worked on various projects involving Data warehousing using Informatica Power Center
· Experience in Data Migrations.
· Extensive knowledge in VMS and UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
· Experienced in Disaster Recovery setup.
· Skilled in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
· UNIX Systems Administration - Database and application integration efforts; CVS system installation experience; Heavy UNIX shell scripting, CRON jobs.
· Worked on STANDBY databases.
· SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.
· Experience in writing Perl Scripts in performing various processes like sending reports, fetching data from remote servers etc.
· Experienced in using tools like VSS, Smart SVN for preserving the source code.
· Hands on experience on SQL CLUSTERING.
· Possesses strong analytical and problem solving skills coupled with very good communication and interpersonal skills.
· Extensive experience in Data Warehousing, ETL (Extraction, Transformation, Loading) using Informatica 6.x/7.x/8.x.
· Implementing EDI X12, EDIFACT transaction sets, XML and flat files.
· Awareness on Oracle Support processes for technical requests through Metalink.
· Dealing with database security and auditing.
· Extensive knowledge in reporting tools like Business Objects and crystal reports.
· Implementing Storage Systems (SAN/NAS) operations.
TECHNICAL SKILLS
| Operating Systems | HP-UX 10.x, 11.x, VMS, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP. |
| RDBMS | Oracle 10g/9i/8i , SQL Server 2000/2005/2008 |
| Languages | SQL, PL/SQL, Delphi, VC++, UNIX Shell Scripting, Perl |
| Tools/Utilities | RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp, impdp, TOAD,VB |
| Tuning Tools | TKPROF, EXPLAIN PLAN, STATSPACK |
| Database Modeling | Erwin 4.0, Rational rose, Toad Data Modeller, Datanamic and start UML, ER/studio |
| Other | EMC, NetApp, Veritas NetBackup, TSM, HP Data Protector, IBM, VCS, MCSG |
CERTIFICATION
ü Oracle Certified Associate.
