IBM DB2 Database Administrator

$80,000 - $100,000/Yr

Pragma Edge - Jacksonville, FL

Full-time

Jacksonville, FL

Professional, Scientific, and Technical Services

About the position

The IBM DB2 Database Administrator is responsible for the management, optimization, and overall administration of IBM DB2 databases. This role ensures the availability, reliability, and performance of databases that support business-critical applications, requiring expertise in various database management tasks across distributed and mainframe environments.

Responsibilities

• Install, configure, and maintain IBM DB2 databases on Linux, UNIX, and IBM Cloud platforms.
• Perform database upgrades and patches to ensure the environment is up to date and secure.
• Manage database objects (tables, indexes, views, etc.) and ensure proper data integrity and normalization.
• Handle database partitioning, clustering, and replication tasks.
• Monitor and analyze database performance, identifying bottlenecks and tuning SQL queries for optimal performance.
• Utilize tools such as IBM Data Studio or third-party software for performance monitoring.
• Conduct regular database health checks and make recommendations for improvements.
• Design and implement robust backup strategies, including automated backups, point-in-time recovery, and disaster recovery planning.
• Perform DB2 database restores and recoveries, ensuring minimal downtime.
• Manage database log files and ensure recovery capabilities.
• Perform regular maintenance tasks, including reorganization, compression, and data archiving.
• Manage large volumes of transactional data and optimize database performance for OLTP and OLAP systems.
• Troubleshoot and resolve database issues, including connectivity, performance, and corruption problems.
• Provide support to development teams for database design, query optimization, and performance tuning.
• Support high-availability environments and participate in on-call rotations for after-hours support.

Requirements

• Expertise in IBM DB2 database management and administration.
• Experience with database configuration, tuning, security, backup, recovery, and troubleshooting.
• Proficiency in managing databases on Linux, UNIX, and IBM Cloud platforms.
• Strong knowledge of performance tuning and optimization techniques.
• Experience with database health checks and improvement recommendations.
• Ability to design and implement backup and recovery strategies.
• Familiarity with managing large volumes of transactional data for OLTP and OLAP systems.

Nice-to-haves

• Experience with cloud platforms such as Google Cloud.
• Familiarity with AI tools for job description enhancement.