DB2 LUW DBA

Description

Operational
Provide operational shift support for the IBM DB2 Server database environment. Responsibilities include database backup/restores, daily checks, maintenance tasks and building new database instances and applying service packs. Manage and escalate problems as appropriate.
Investigate defects or problems, work with internal CLS Development team and external vendors to identify solutions and support any fixes that are required as part of service improvement.
Follow the CLS Change Management procedure and other standard practices in installing, configuring and supporting databases and related items in Test and Production environments.
Ensure that the BAU Service is prioritised and all faults, incidents and problems are responded to in an efficient manner without negatively impacting SLAs and reporting metrics in place.
IBM DB2 Performance tuning analysis and alerting.
Work with Security Analysts to develop new DB2 security policy, tablespace.
Install, upgrade or maintain software at a time when the impact to the business is minimised.
Execute the failover for the database and application services as required. Participate in regular Disaster Recovery testing activities.
Create, maintain and review operational process and support documentation.
Provide 24/7 oncall cover on a rotational shift basis.
Participate in planned weekend work as required.