Sr. DB2 DBA (AIX platform)

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

Keywords

Description

DB2 DBA
This position requires experience to install, administer, troubleshoot and tune multiple production and non-production DB2 environments running on AIX.

This DB2 DBA will also work closely with multiple product development and testing teams and support them through the system development life cycle. The candidate should possess excellent organization and communication skills and be able to produce various technical artifacts.

Responsibilities:
Install, configure and validate DB2 database across multiple environments.
Proactively monitor server and database process health to ensure availability and performance.
Security management and user provisioning.
Implement proactive capacity planning processes.
Support DB2 high-availability and disaster recovery solutions.
Automate DBA processes and create Shell Scripts to streamline and improve efficiency.
Create and maintain database standards.
Provide support for reviewing and approving schema changes.
Produce technical documentation.
Develops and modifies database definitions including entities, attributes, relationships, and referential integrity triggers
Participate in on-call DBA support and provide off hours production deployment support.
Implement Database Change Controls
Completes other duties as assigned

Requirements:
Proven hands on 10+ years of experience in DB2 Database Administration of medium to large DB2 databases with sound knowledge of 64-bit DB2 v9.7 or v10.1 databases in a 24x7 enterprise SAN based multi-data center environment, including installation, configuration, backup, recovery, and tuning.
Proven DB2 replication setup and administration experience. Knowledge of Q or SQL Replication.
Sound experience in Linux, Solaris and AIX, including Shell Scripting.
Deep understanding of SQL statement tuning.
Resourceful, responsible, flexible, able to work unsupervised and dedicated to quality of work.
Experience with open source ETL and DB tools.
Experience with Data Transformation Tools.
Knowledge of MySQL  database a plus

Start date
n.a
Duration
1 year (6 month increments)
From
Correlation Point
Published at
17.08.2013
Project ID:
585126
Contract type
Freelance
To apply to this project you must log in.
Register