We provide IT Staff Augmentation Services!

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.

Hire Now