Oracle DBA Resume

SUMMARY

Over 7 Years of experience in full application life cycle development, testing and production in Information Technology - Software Industry.
Experience with Oracle 9i, 10g and 11g on Unix & Windows operating systems.
Experience with RMAN, Oracle Enterprise Manager (OEM), OEM Grid control, Oracle Automatic Storage Management (ASM), Data warehousing, Oracle Data Guard, Oracle Data pump.
Extensive knowledge of ORACLE Data Guard & Real Application Clusters (RAC).
Extensive DBA experience in supporting multiple instances of ORACLE database including Development, Reporting, Data Warehousing, User acceptance testing & Production.
Experience in cloning/replicating production database using RMAN & OEM Grid Control.
Job scheduling through crontab, O/S updates and upgrades, patches loading.
Experience in backup/restore, disaster recovery using RMAN & OEM Grid Control.
Experience in using data pump import/exposure utility of ORACLE.
Experience in database migration by designing and implementing database logical and physical storage structures.
Experience in optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
Developed database support processes and automated tasks through tools, PL/SQL and UNIX Shell Scripting.
Oracle SQL*Net, SQL, PL/SQL, writing triggers, functions and PL/SQL procedures.
Strong analytical and problem solving skills.
Expertise in data modeling and database designing.
Involved in data model design and database development including PL/SQL stored procedures, functions.
Strong Oracle PL/SQL development background besides DBA skills.
Experience in database security strategies by creating database users, user roles, profiles and audits.
Upgrading and Migrating Databases from lower versions to higher versions.
Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Trouble shooting & Tuning.
Experience in analyzing database & rebuilding indexes to improve database performance.
Experience in Leading, Motivating and coordinating team of developers.
Implemented & monitored daily, weekly and monthly batch jobs in database.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008.

DB Tools: Erwin, Toad, Export, Import, Data pump, RMAN, SQL Loader, Log Miner, Change Manager, Streams,AWR,ADDM,STATSTPACK,tkprof.,SQL developer.

Hardware: EMC Clarion with RAID5, Sun Sparc E15K/E4500/420, Sun-Fire v440/v890

Operating System: Windows 2003/2005/2008 server, Sun Solaris, RH Linux 2,3,4,5, HP-UX, AIX.

Oracle Tools: Oracle 9i IAS, Designer 6i, Discoverer 2000, Oracle Web Server, Oracle Enterprise Manager & Grid Control, Forms 4.5/5.0/6i, Reports 4.5/5.0/6i, AD Utility, SQL, PL/SQL.

Other Tools: AUTOSYS, Pac2000, Net meeting, VMware Server.

Languages: SQL, PL/SQL, UNIX Shell Programming, PERL Scripting.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship