Text copied to clipboard!
Title
Text copied to clipboard!DB2 Database Administrator
Description
Text copied to clipboard!
We are looking for a skilled DB2 Database Administrator to join our IT team. The successful candidate will be responsible for the implementation, configuration, maintenance, and performance of critical DB2 systems, to ensure the availability and consistent performance of our corporate applications. This is a 'hands-on' position requiring solid technical skills, as well as excellent interpersonal and communication skills. The DB2 Database Administrator will be responsible for the development and sustainment of the DB2 Infrastructure, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The DB2 Database Administrator will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. They will work in tandem with the other teams, preparing documentations and specifications as required.
Responsibilities
Text copied to clipboard!- Manage DB2 databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes.
- Monitor system's health and performance.
- Ensure high levels of performance, availability, sustainability and security.
- Analyze, solve, and correct issues in real time.
- Provide suggestions for solutions.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with query tuning and schema refinement.
- Provide 24x7 support for critical production systems.
- Perform scheduled maintenance and support release deployment activities.
Requirements
Text copied to clipboard!- Bachelor's degree in a computer discipline or relevant certification.
- Must be certified as a DB2 DBA.
- Experience with backups, restores and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for DB2.
- Experience working with Windows server, including Active Directory.
- Excellent written and verbal communication.
- Flexible, team player, 'get-it-done' personality.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.
- Ability to multi-task and context-switch effectively between different activities and teams.
Potential interview questions
Text copied to clipboard!- What is your experience with DB2 database administration?
- Can you describe a time when you improved the performance of a DB2 database?
- How do you handle disaster recovery for DB2 databases?
- What methods do you use for ensuring the security of DB2 databases?
- Can you describe your experience with High Availability (HA) options for DB2?