DB2 UDB/LUW Application Database Administrator (ADBA) - Dallas, TX

Responsibilities:

· Responsibility for constructing and/or optimizing physical database designs tailored for the DB2 UDB/LUW database environment in support of various strategic application development initiatives (database/table/object/index/view/trigger/package/procedure etc).

· Supporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.

· Design & development Services - Physical database design and creation, partitioning, capacity planning, DDL creation update etc., view design and creation, stored procedure, trigger and query coding and tuning

· Data Services - Data replication, reporting, adhoc query support, data correction, CDC/IIDR change tracking

· Performance and Tuning Services - Performance Profile baseline, database tuning, index reviews, query tuning.

· Data backup & management services – Backup requirements, backup plan, recovery plan, disaster recovery backup plan, data archiving & purge, utilities and SSIS support, reorganization strategy and maintenance plan

· Database and OS Upgrade Services - Transition to different DBMS or operating system, support upgrade-related issues per application

· Security Services - Non-standard Security role setup

· HOTS turnover plan

· Database connectivity support activities

· Undertaking the planning and carrying out of system upgrade initiatives and database recovery actions as required and generally contributing toward the overall online availability goals of the organization.

· Perform feasibility studies and cost estimates in response to user requests.

· Query performance monitoring, tuning and recommendation.

· Position requires the individual to carry a cell phone and be available at all times