Sr. DB2 Database administrator

rjt1; Washington (District of Columbia); On-site; USD 75,000 - 95,000; Full time

Job summary

A leading tech company in Washington is seeking a Database Administrator with 3-5 years of experience in DB2 UDB, preferably in an AIX environment. Your role will involve supporting the CCTI/CCP data warehouse, troubleshooting performance issues, and ensuring efficient data replication. Familiarity with tools like Websphere and Cognos is essential. This position offers a great opportunity for hands-on experience in a dynamic environment.

Qualifications

• 3-5 years of hands-on DB2 UDB experience in an AIX environment.
• Strong Unix skills required for database support.
• Experience with physical partitioning and performance issues.

Responsibilities

• Provide day-to-day database support for CCTI/CCP data warehouse.
• Assist with troubleshooting system and application performance issues.
• Support data replication between production and disaster recovery sites.

Skills

DB2 UDB

Unix skills

Performance monitoring/testing

SQL troubleshooting

Microsoft Office

Tools

Websphere Application Server

MQSeries

Cognos

Q-Replication

HADR

Data Partitioning Facility (DPF)

Job description

• TSM (Tivoli Storage Manager) -The internal drive, intellectual curiosity, ability to learn, and desire to help the customers succeed

Responsibilities:

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

Qualifications

Description:

• 3 5 years of hands-on DB2 UDB experience in an AIX environment -Strong Unix skills
• Command line processing
• Reading, writing, executing, troubleshooting user scripts -Realistic, practical, real world database administration skills/experience -Experience, from a database perspective, dealing with Websphere Application Sever, HTTP Server, MQSeries and Cognos
• Experience with Q-Replication
• Experience in Performance monitoring/testing COGNOS applications
• Experience reviewing SQL to address performance problems
• Microsoft Office experience in, at a minimum, Outlook, WORD, Excel
• Experience with DPF (Data Partitioning Facility).
• This is physical partitioning, not logical partitioning (Range Partitioning)
• Experience with HADR setup
• Experience with WLM, DSM, Optim data growth
• Experience with TSA is a plus

Additional Information

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