We provide IT Staff Augmentation Services!

Oracle Dba Consultant Resume

5.00/5 (Submit Your Rating)

Alameda, Ca

SUMMARY:

  • 8 years of Database experience serving the Information Technology needs of the software development industries. Oracle database administration experiences for various kinds of applications in UNIX and Windows environments. Proven background of technical trouble shooting, self motivated, responsible, and reliable team player with a set of very strong technical skills.

TECHNICAL SKILLS:

RDBMS versions: Oracle 9i, 10g

Database Utilities: SQL, PL/SQL, TOAD,Import, Export, RMAN, Explain Plan

Databases Tools: Oracle Enterprise Manager.

Operating Systems: REDHAT Enterprise Linux 4.0, 5.0, OEL 4.x. 5.x, Windows 2000 Server, Windows XP

Developer Tools: Oracle reports 6i, forms 6i, Discoverer

Applications: Oracle E Business Suite 11i (11.5.10.x)

Middleware: Oracle Fusion Middleware 11g

Scripting: UNIX Shell Scripting

WORK EXPERIENCE:

Confidential, Alameda CA.

Oracle DBA Consultant

Responsibilities:

  • Administer and Manage oracle Systems with large size databases (more than 1TB) and its routine maintenance.
  • Working closely with backup and recovery
  • Manage Oracle Application Suite 11.5.10.2 with DB Version 11gR2 under asm with 2 node RAC.
  • Having enough hands - on with RAC and maintenance.
  • Rapidclone refresh methods hands-on.
  • Other database administrations like Siebel CRM and OBI suite along with EBS 11.5.10.2.
  • CPU patches for all available versions of database and specific ERP modules in E-Business Suite.
  • Involved the E-Business suite patch process includes Analyze with pre, post installation steps using adpatch, adctrl.
  • Hands on in APPS admin tools like adadmin, adctrl, adpatch, admerge etc.

Confidential

Oracle database Administrator .

Environment: - Oracle ERP 11i, Oracle database Enterprise edition 9i,10g.

Responsibilities:

  • Upgrade oracle Database from 9i to 10gR2 that works under Oracle Application 11.5.9
  • Created RMAN Backup scripts and verification.
  • Cloning of production Instance for development and patch testing.
  • Performed periodic security patches on Database level.
  • Tuning database on Initialization parameters, I/O bottleneck, Memory usage
  • Planning for storage spaces requirements and placing them for optimum I/O performance

Confidential

Environment: - Oracle ERP 11i, Oracle Database Enterprise Edition 9i/10gR2.

Responsibilities:

  • Configured and maintained various databases of 9i and 10gR2.
  • Hotbackup/RMAN backup implementation.
  • Space optimization and Management
  • User Management and Security
  • Performance Tuning
  • SQL statement analyze and troubleshoot
  • Worked with Development team to implement all changes and new project plans and physical/logical designs.

Confidential

Environment: - Oracle ERP 11i with Oracle Database enterprise Edition 9i, 10gR2

Responsibilities:

  • Performed upgrade from 9i to 10gR2 Enterprise Edition.
  • Cloning of production Instance for development and patch testing.
  • Applying Oracle Patches & Critical patch updates.
  • Tuning database on Initialization parameters, I/O bottleneck, Memory usage
  • Planning for storage spaces requirements and placing them for optimum I/O performance
  • Develop Test and Implementing Sound backup and Recovery Strategy using RMAN.

Confidential

Environment: - Oracle ERP (11.5.8), 10g

Responsibilities:

  • 10g Database administration
  • User administration & Security Management.
  • Audit Management & Alert scripts
  • Database tier patch application
  • Analyze the Database performance using oracle utilities and scripts.
  • Fine tuning oracle Database parameters, I/O, Memory and kernel parameters
  • Planning for storage spaces requirements and placing them for optimum I/O performance
  • Troubleshoot all areas of the Oracle database environment
  • Implement Hot, cold and logical backup scripts to automate the backup procedures

We'd love your feedback!