Database Administrator - Oracle, PL/SQL - Netezza or Teradata (job3189

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

Keywords

Description

Database Administrator

Skills: Oracle, PL/SQL, Datawarehouse platform such as Netezza or Teradata

Our client is a leading high volume consumer information website organization, headquartered in Atlanta. This fast paced, high energy organization fosters the ultimate work/play environment for out-of-the-box thinkers. You'll utilize the latest technologies in a collaborative environment and enjoy working with this well-known brand!

Summary
This is a 6 month+ contract opportunity. The Database Administrator is responsible for designing, developing and implementing new technologies, as required, to support the technical capabilities at AutoTrader.com. To be successful in this role one must be able to work effectively in a fluid, fast-paced environment. This role requires good communication skills, both with team members and business contacts. In addition, the successful Database Administrator must be able to work with minimal supervision on multiple concurrent projects.

Responsibilities

  • Develop new or maintain existing programs based on specifications
  • Respond quickly and effectively to production issues and taking responsibility for seeing those issues through resolution.
  • Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
  • Install and maintain database software.
  • Implement data models and database designs into physical databases.
  • Manage backup and recovery of databases using RMAN and/or Network Appliance Snapshots.
  • Manage security of database structures and corporate data held within databases.
  • Develop database procedures, triggers and SQL scripts for development teams.
  • Assist in the definition and implementation of database standards.
  • Review scripts submitted by the Development team to ensure that all standards are met.
  • Monitor databases for errors and perform problem determination when necessary.
  • Design and implement highly available production systems using the following technologies: Hot Standby/Data Guard, Advanced Replication, Advanced Queuing, Oracle Streams, Real Application Cluster (RAC) and Oracle Enterprise Manager

Qualifications

  • 5-7 years experience in Oracle database technologies, as well as Massively Parallel Processing (MPP) systems
  • Prior experience writing PL/SQL triggers and/or procedures.
  • Experience with configuring and managing Advanced Queues (AQ), multimaster replication or Oracle Streams.
  • Experience with configuring and managing Snapshot Replication.
  • Working knowledge of Linux and Shell Scripting.
  • Experience configuring database network connectivity.
  • Understanding of database backup and recovery techniques using RMAN and Network Appliance filers.
  • Experience with high volume websites that use multi-tier architectures a significant plus.
  • Understanding or experience using Oracle Real Application Cluster's and implementation best-practices.
  • Ability to analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, Disaster Recovery or high performance.

Benefits
As an Agile consultant, you'll gain many of the advantages and benefits of being a direct hire, while experiencing the flexibility of consulting. It's the best of both worlds! Our IT consultants enjoy a wide array of benefits including: medical, dental, 401K, life insurance, Employee Assistance Program and more.

Start date
ASAP
Duration
6 month+
(extension possible)
From
Generic Network
Published at
25.11.2011
Project ID:
273325
Contract type
Freelance
To apply to this project you must log in.
Register