Database Administrator

Ampcus - Cary, NC

Full-time

Cary, NC

Professional, Scientific, and Technical Services

About the position

The Database Administrator at Ampcus, Inc. is responsible for managing and upgrading DB2 databases, ensuring their optimal performance and stability during and after migration processes. This role involves planning, implementing, and supporting database upgrades, as well as collaborating with application developers and system administrators to maintain seamless database operations.

Responsibilities

• Plan, implement, and support the migration of DB2 databases to newer versions.
• Upgrade DB2 databases as part of OS migration from AIX to Linux or RHEL7 to RHEL9.
• 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 DB upgrade, maintenance, and support.
• Proficiency in DB2 UDB LUV (Distributed) and DB2 9.7 for Linux, UNIX, and Windows.