DB2 DBA- Remote (XIN001_JDG5)

Client is looking for a highly-skilled DB2 and Cloudant Database Administrator (DBA). Responsibilities include DB2 administration, Cloudant administration, DataStage administration, DataStage job creation and scheduling, Structured Query Language (SQL) creation, DB2 performance tuning, physical Database Definition (DDL) and understanding of logical database design (i.e. data models and dictionary). Ability to update Logical Data Model and Dictionary, update Physical Database, and create Database Scripts. This role is responsible for designing and implementing application solutions that support Worldwide Software Technical Sales and Deployment. 

Primary duties include:

• Designing and implementing complex database environments and developing creative solutions to meet performance objectives

• Developing technical standards and reviewing the environment to ensure compliance with standards, 

• Reviewing and validating database architecture

• Resolving highly complex problems and implementing systemic changes, including designing new solutions and/or deciding which solutions to adopt

• Analyzing internal customer needs, including participating in strategic planning and ensuring solutions adopted are appropriate to meet such needs

Required Technical and Professional Expertise:

• Identifying database requirements by analyzing applications, programming, and operations; evaluating existing systems and designing proposed systems.

• Recommending solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.

• SQL Creation, DB2 command line creation and execution, Database view creation

• DB2 performance tuning

• Physical database definition (DDL) and understanding of logical database design (i.e. data models and dictionary)

• Ability to update logical data model and dictionary

• Updating physical database

• Creating database scripts and stored procedures

• Strong understanding of database architecture concepts in both DB2 and Cloudant

• Knowledge and experience with back-up and recovery methods, including point in time recovery

• Knowledge and experience with back-up and recovery using DB2 backup and restore commands

Additional Information

All your information will be kept confidential according to EEO guidelines.