DB2 UDB LUW DBA (Database Administrator)

Net2Source - Cary, NC

Full-time - Mid Level

Cary, NC

5,001-10,000 employees

Administrative and Support Services

About the position

The DB2 UDB LUW DBA (Database Administrator) role at Net2Source Inc. involves managing and upgrading DB2 databases, ensuring their optimal performance and compatibility with new environments. The position requires extensive experience in database migration, maintenance, and support, particularly during upgrades from older versions to newer ones. The DBA will collaborate with developers and system administrators to ensure seamless integration and performance post-upgrade, while also adhering to change management processes and ensuring robust backup and recovery plans.

Responsibilities

• Plan, implement, and support the migration of DB2 databases to newer versions.
• Analyze the current database environment and assess compatibility with the target version.
• Develop and execute upgrade strategies, including patching, testing, and fallback procedures.
• Perform pre-upgrade and post-upgrade testing to ensure application and system integration with the upgraded DB2 version.
• Coordinate and execute database migration in production, test, and development environments.
• Optimize and adjust database settings post-upgrade for performance and stability.
• Monitor and tune the database during the upgrade process to ensure optimal performance.
• Apply patches and updates while adhering to change management processes.
• Ensure backup and recovery plans are functional and test backup restore procedures after the upgrade.
• Troubleshoot and resolve issues that arise during and after the upgrade process.
• Collaborate with application developers and system administrators for seamless database and application performance post-upgrade.

Requirements

• 10 years of experience in DB2 UDB DBA roles.
• Experience with DB2 9.7 for Linux, UNIX, and Windows.
• Strong knowledge of database upgrade, maintenance, and support processes.
• Ability to analyze and assess database environments for compatibility with target versions.

Nice-to-haves

• Experience with OS migration from AIX to Linux or RHEL7 to RHEL9.
• Familiarity with database performance tuning and optimization techniques.

Benefits

• Inclusive culture that promotes work-life fit and well-being.
• Opportunities for strategic impact and innovation.
• Supportive and connected work environment.