Text copied to clipboard!
Title
Text copied to clipboard!DB2 Database Administrator
Description
Text copied to clipboard!
We are looking for a skilled and experienced DB2 Database Administrator to join our IT team. The ideal candidate will be responsible for the installation, configuration, maintenance, and performance tuning of DB2 databases across various environments. You will work closely with developers, system administrators, and other stakeholders to ensure the integrity, availability, and security of our data assets.
As a DB2 Database Administrator, you will be expected to monitor database performance, implement changes, and apply new patches and versions when required. You will also be responsible for backup and recovery strategies, disaster recovery planning, and ensuring compliance with data governance and security policies. Your role will involve troubleshooting database issues, optimizing queries, and supporting application development teams with database-related tasks.
You should have a strong understanding of database architecture, indexing, partitioning, and replication. Experience with DB2 on both LUW (Linux, Unix, Windows) and z/OS platforms is highly desirable. Familiarity with scripting languages, automation tools, and monitoring solutions will be considered a plus.
This position requires excellent problem-solving skills, attention to detail, and the ability to work independently as well as part of a team. Strong communication skills are essential, as you will be interacting with both technical and non-technical stakeholders.
If you are passionate about database administration and want to work in a dynamic and collaborative environment, we encourage you to apply.
Responsibilities
Text copied to clipboard!- Install, configure, and upgrade DB2 database software
- Monitor database performance and implement tuning measures
- Perform regular backups and ensure data recovery procedures
- Manage database security and user access controls
- Collaborate with development teams to optimize SQL queries
- Implement and maintain high availability and disaster recovery solutions
- Troubleshoot and resolve database-related issues
- Document database configurations, procedures, and policies
- Automate routine database tasks using scripts and tools
- Ensure compliance with data governance and security standards
Requirements
Text copied to clipboard!- Bachelor’s degree in Computer Science or related field
- Proven experience as a DB2 Database Administrator
- Strong knowledge of DB2 LUW and/or z/OS platforms
- Experience with database performance tuning and optimization
- Familiarity with backup and recovery strategies
- Understanding of database security and access control
- Proficiency in SQL and scripting languages (e.g., Shell, Python)
- Experience with monitoring and automation tools
- Excellent problem-solving and analytical skills
- Strong communication and teamwork abilities
Potential interview questions
Text copied to clipboard!- How many years of experience do you have with DB2 administration?
- Have you worked with both DB2 LUW and z/OS platforms?
- Can you describe a challenging database issue you resolved?
- What tools do you use for monitoring and performance tuning?
- How do you ensure database security and compliance?
- What is your experience with disaster recovery planning?
- Have you automated any database tasks? If so, how?
- How do you handle database upgrades and patching?
- What scripting languages are you proficient in?
- How do you collaborate with development and operations teams?
