Overview:
In this role you will provide ongoing DB2 UDB support for the CCTI/CCP data warehouse, ensure data replication to the DR site, and assist with performance testing of CAE and CCP applications. You will troubleshoot performance issues and implement fixes, collaborating in a project-driven environment serving government clients. This position offers hands-on work in a dynamic, Change-ready setting with opportunities to influence database reliability and efficiency.
Responsibilities:
Provide day-to-day DB2 UDB support for the CCTI/CCP data warehouse environment Support data replication between production site and disaster recovery site Assist with performance testing of the CAE and CCP applications Troubleshoot system and application performance issues and recommend fixes Other duties as assigned
Key requirements:
3–5 years of hands-on DB2 UDB experience in an AIX environment Strong Unix skills (command line, scripting) Ability to work under project manager supervision and independently with minimal supervision Willingness to work off-hours and weekends when necessary Experience with WebSphere Application Server, HTTP Server, MQSeries and Cognos from a database perspective Experience with Q-Replication Experience with performance monitoring/testing Cognos and SQL performance optimization MS Office experience (Outlook, Word, Excel) Experience with DPF (Data Partitioning Facility) and HADR setup Self-starter with high initiative Sense of urgency Open to feedback DB2 LUW on AIX Unix scripting WebSphere Application Server