DB2 DBA

Workila; Washington (District of Columbia); On-site; USD 110,000 - 140,000; Full time

Job summary

A leading tech firm is seeking a database support specialist to assist with troubleshooting and performance testing within the CCTI/CCP data warehouse. The ideal candidate will have 3 – 5 years of hands-on experience with DB2 UDB in an AIX environment, demonstrated Unix skills, and the ability to work proactively. Responsibilities include data replication support and performance monitoring for applications like COGNOS. This is an excellent opportunity to advance your career in a dynamic environment.

Qualifications

• 3 – 5 years of hands-on DB2 UDB experience in an AIX environment.
• Realistic, practical, real world database administration skills/experience.
• Understanding of database backup and recovery processes.
• Strong Unix skills and command line processing
• Reading, writing, executing, troubleshooting user scripts
• Comfortable receiving instructions from lead DBA and then working independently
• Internal drive, curiosity, ability to learn, and desire to help customers succeed

Responsibilities

• Provide day-to-day database support for the CCTI/CCP data warehouse environment.
• Assist with troubleshooting of system and application performance related issues.
• Provide support for performance testing the CAE and CCP applications.
• Provide support for performance testing the CAE and CCP applications
• Other duties as assigned
• Projected Level of Effort

Skills

DB2 UDB experience

Unix skills

SQL performance review

Command line processing

Microsoft Office

Technical skills

Proactive work

Customer support

Proactive work style

Reading/writing scripts

Tools

DB2 LUW on AIX

Unix scripting

Microsoft Suite

EMC DDBoost familiarity

WebSphere Application Server

MQSeries

HTTP Server

DPF (Data Partitioning Facility)

EMC DDBoost

Job description

The sheer scale of our capabilities and client engagements and the way we collaborate, operate and deliver value provides an unparalleled opportunity to grow and advance. Choose Workila, and make delivering innovative work part of your extraordinary career.

Job Description

Responsibilities

• Provide day-to-day database support for the CCTI/CCP data warehouse environment
• Assist with troubleshooting of system and application performance related issues and recommend fixes
• Provide support for data replication between production site and disaster recovery site
• Provide support for performance testing the CAE and CCP applications
• Other duties as assigned
• Projected Level of Effort

Qualifications

• Ability to work off-hours and weekends when necessary
• 3 – 5 years of hands-on DB2 UDB experience in an AIX environment
• Realistic, practical, real world database administration skills/experience
• Experience reviewing SQL to address performance problems
• Strong Unix skills
• Command line processing
• Reading, writing, executing, troubleshooting user scripts
• Microsoft Office experience in, at a minimum, Outlook, Word, Excel
• Comfortable receiving instructions from lead DBA and then working independently
• The internal drive, intellectual curiosity, ability to learn, and desire to help the customers succeed
• Strong technical skills
• Comfortable working under Project Manager supervision
• Ability to work proactively
• Experience, from a database perspective, dealing with Websphere Application Server, HTTP Server, MQSeries and Cognos
• Understanding of database backup processes and recovery processes
• Experience with Q-Replication
• Experience in Performance monitoring/testing COGNOS applications
• Experience with DPF (Data Partitioning Facility). This is physical partitioning, not logical partitioning (Range Partitioning)

Software

• DB2 LUW on AIX
• Unix scripting
• Microsoft Suite
• EMC DDBoost familiarity