Enterprise Datawarehouse Oracle DBA

Georgia  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

In this role, the Oracle DBA Consultant will:

  • Manage all aspects of physical database administration including schema management; security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning and capacity planning for Oracle 10g and 11g.
  • Support application teams and their projects to enhance, troubleshoot and performance tune while exploring SQL programming for query performance improvements
  • Support Oracle Databases in Production, Test and Development environments
  • Install, upgrade and test complex database software
  • Develop and implement Database Recovery plans and procedure
  • Analyzes the performance of Databases and recommends tuning and application changes

The appropriate individual will have demonstrated experience in the following:

  • 5+ years of hands-on experience as an Oracle DBA, working directly with Oracle 10g & 11g
  • 3+ years of hands-on experience in Oracle RAC, ASM environment
  • 3+ years of hands-on experience in Oracle Spatial
  • 3+ years of Oracle Gateway
  • Strong hands-on performance tuning skills
  • Strong SQL and UNIX Scripting skills
  • Oracle RDBMS concepts and fundamentals
  • Oracle Database Space Management & Capacity Planning
  • Oracle RMAN Backup and Recovery techniques
  • PL/SQL programming writing complex queries and stored procedures, functions, triggers, etc.
  • Advanced querying, T-SQL, PL/SQL, ANSI SQL
  • Advanced Programming for Data Transformation (Integration Services, DTS, and XML)
  • Provide 24x7 support as needed
  • Experience with Oracle OEM, and database monitoring tools
  • Experience with Oracle DataGuard, Oracle Streams, and Oracle GRID Control.
  • Experience with Solaris and Linux
  • Experience with data model tools such as ER-Studio, Oracle Designer, etc.
  • Proficient in business analysis, data modelling, logical and physical database design, data acquisition analysis and design, data access analysis and design.
  • Proficient in planning and management of scope of work and time estimation.
  • Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management.
  • Strong problem solving skills and strong desire to learn new technologies.
  • Oracle certification in 10g or 11g is a plus.
  • Experience with Quest Shareplex is a plus.
  • Ability to mentor others is a plus.
  • PMP certification is a plus.
Start date
08/27/2012
Duration
12months +
(extension possible)
From
Royal Offering Inc - Atlanta
Published at
08.08.2012
Project ID:
403890
Contract type
Freelance
To apply to this project you must log in.
Register