Database Administrator - Oracle

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

Keywords

Description

Responsible for database infrastructure management, and monitoring and optimizing the overall performance of Oracle databases. Will also include work as a Development DBA together with the Application Development teams.

RESPONSIBILITIES:
  • Ensures the database environment is highly reliable, provides the required functionality, is efficient, and cost effective.
  • Accountable for the creation of the logical and physical data models.
  • Troubleshoots daily program problems to assist program users in accessing and manipulating computerized data.
  • Analyzes and creates programs to streamline production jobs.
COMPETENCIES:
  • Establish and maintain data bases for user testing purposes and production; consult with business analysts, data modelers and designers on procedures pertaining to new and existing files; provide input to the data models (functionality, efficiency and usability); responsible for the technical aspects of one or more databases including availability/reliability; assist in the definition of the database requirements; analyze existing databases and their interfaces looking for opportunities to improve their efficiency; and resolve technical problems.
SKILLS:

QUALIFICATIONS:
  • Bachelors degree or equivalent training or work experience; understanding of customer's business operations and products produced; knowledge of systems applications delivery tools and techniques.
  • Four to six years of applications programming experience or equivalent; three to five years of experience in respective database area; experience in more than one database structure (hierarchical, network or relational); understands the pros and cons of each; experience with tools and utilities for platform; and understand the pros and cons of different designs with respect to storage, system performance and user flexibility.
  • Oracle DBA with Oracle 10g &11g experience in Unix environment (Linux is preferred), RMAN, OEM, Shell Scripting, database upgrades and software installations.
  • Experience with OAS is a plus.
  • Should have working knowledge of PL/SQL and Oracle replication. Must have Strong working knowledge of PL/SQL.
  • Thorough understanding of Data Warehousing Concept, Design and Architecture.
  • Understanding Star Schema, Fact, and Dimension concepts.
  • Experience and understanding of Extract Transformation Loading (ETL) concept and process.
  • Working knowledge of replication.
  • Understanding of software development life cycle.
  • Candidates local to Chicago only
Start date
n.a
From
Synectics
Published at
07.05.2014
Project ID:
704003
Contract type
Freelance
To apply to this project you must log in.
Register