DBA (Database Administrator)

$76,918 - $120,203/Yr

Capgemini - Cary, NC

Full-time - Mid Level

Cary, NC

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The DBA (Database Administrator) position involves managing and supporting DB2 databases, focusing on upgrades, maintenance, and migration processes. The role requires extensive experience in database management, particularly in transitioning databases from older to newer versions while ensuring compatibility and performance optimization. The DBA will collaborate with developers and system administrators to ensure seamless integration and functionality post-upgrade.

Responsibilities

• Plan, implement, and support the migration of DB2 databases to newer versions as part of OS migration.
• 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.
• Perform ongoing database monitoring and tuning during the upgrade process.
• 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.

Requirements

• 10 years of experience in DB2 UDB DBA roles.
• Experience with database upgrades and migrations, particularly from AIX to Linux or RHEL7 to RHEL9.
• Strong knowledge of DB2 9.7 DBA for Linux, UNIX, and Windows environments.
• Ability to analyze and assess database environments for compatibility with target versions.

Nice-to-haves

• Experience with database performance tuning and optimization.
• Familiarity with change management processes in database environments.

Benefits

• Dental insurance
• Vision insurance
• Medical insurance
• Retirement benefits