Oracle Database Consultant Resume

SUMMARY

Over 7 years of experience as an Oracle DBA. Experience in Data Modeling, Design, Development & Production Support.
Experience in managing Very Large OLTP and Data warehouse databases of size multiple TB.
Experience widely in performance tuning, Memory Tuning and Application Tun
24 X 7 Production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
Knowledge on Install Configured and maintained IBM WebSphere Application Server 5.x/6.x on AIX Linux/Windows2003/Sun Solaris.
Knowledge on Web Sphere components such as Work Load Management (WLM), Servlet Engine, Session Manager, Admin Client
Experience in configuration, implementation of Oracle 10g RAC/oracle 11g RAC.
Experience in process improvement, Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Standby Database (Data Guard), Replication, Real Application Clusters, Automatic Storage Management (ASM)
Experience in Multi Node RAC cluster design, administration and support.
Experience in analyzing the Database Migration requirement and providing an efficient and workable solution. Worked with Project Managers to understand different client’s requirement and provide an efficient solution keeping in mind the methodology, duration and resources.
Experience in installing, configuring Oracle Fail safe
Good knowledge about the technical aspects of telecom Industry and Insurance sector
Experience in Oracle 9i, Oracle 10g, Oracle 11g software installation and configuration
Experience in upgrading databases to Oracle 10g, Oracle 11g
Installation and Maintenance of Standby (Dataguard) database.
Applied patches to Oracle Databases.
Cloned Oracle Databases for development and testing.
Proficient in SQL, PL/SQL programming and performing SQL tuning and assist developers with coding PL/SQL.
Experience in optimization and tuning SQL queries using SQL_TRACE, TKPROF,
EXPLAIN PLAN, STATS_PACK, AWR.
Experience in design and implementation of Backup & Recovery procedures
Experien in benchmarking
Experience in using RMAN for backup and recovery. Experience in designing and implementing Hot, Cold and Logical backup plans.
Customization and development of Korn shell scripts.
Experience in the management of schemas, de-fragmentation and partitioning the tables & indexes to improve the performance
Responsible for setting and managing user accounts, granting required privileges to users
Experience in ETL concepts and tools.
Excellent analytical and problem-solving skills
Knowledge on Oracle Support processes for technical requests with Metalink.
Result oriented, self-motivated, Team player, ability to work independently.
Excellent written and verbal communication skills.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship