DB2 Database Administrator

As a Database Administrator: RDBMS, you are responsible for developing application designs and providing regular support/guidance to project teams on complex coding, issue resolution, and execution.

Your primary responsibilities include:

1. Lead the design and construction of new mobile solutions using the latest technologies, always looking to add business value and meet user requirements.

2. Strive for continuous improvements by testing the build solution and working under an agile framework.

3. Discover and implement the latest technologies and trends to maximize and build creative solutions.

4. Run multiple production DB2 databases with High Availability (HA) and Disaster Recovery (DR) enabled across data centres.

5. Troubleshoot DB slowness and disk/Memory/CPU utilisation and suggest resolutions.

6. Troubleshoot CDC and SQL replication issues.

7. Participate in PagerDuty On-Call rotation.

8. Perform database patches and upgrades without downtime.

9. Linux Red Hat System Administration.

10. Ensure technical modifications do not adversely affect database integrity, stability, and availability.

11. Implement solutions for DB2 database backup and recovery infrastructure.

12. Monitor/maintain/upgrade the DB2 database and assist the application team with performance-tuning initiatives and builds.

13. Assisted in backup and recovery operations, including disaster recovery planning.

14. Ability to design, build and address Continuous Improvement Culture across the environment.

15. Perform database patches and upgrades, avoiding disruption of availability.

16. DBA On-Call: Respond to, diagnose, and resolve DBA pages, including but not limited to Replication failuresCDC and SQL replication (DPROP), disk space thresholds and shortages, system connectivity issues, system issues, DB crashes, DB performance issues, DB Lock issues, and other DB/System failures, i.e., DB2 backup.