Job Title: DB2 DBA

Job ID: 2024-13155

Job Location: Omaha, NE (100% Onsite)

Job Travel Location(s):

# Positions: 1

Employment Type: W2

Duration: Long Term

# of Layers: 0

Work Eligibility: All Work Authorizations are permitted – No OPTs, No H-1s

Key Technology: DB2, AIX, Linux, Windows 

Job Responsibilities:

• Install, configure, and upgrade DB2 database systems on AIX, Linux, and Windows platforms.
• Monitor and manage database performance, capacity, and health to ensure optimal functionality and availability.
• Perform regular backups, recovery, and disaster recovery planning to safeguard critical data.
• Implement and maintain database security measures, including user access controls and data encryption, to protect sensitive information.
• Monitor database access and audit logs to detect and address potential security breaches.
• Identify and resolve performance bottlenecks, optimize SQL queries, and tuning database configurations to enhance system performance.
• Analyze database performance metrics and provide recommendations for improvements.
• Diagnose and resolve database-related problems, ensuring minimal downtime and disruptions.
• Collaborate with application developers and other IT teams to investigate and resolve database-related issues.
• Collaborate with application developers to design and implement efficient database structures and schemas.
• Participate in database schema changes and version upgrades, ensuring compatibility and data migration.
• Maintain detailed documentation of database configurations, changes, and troubleshooting procedures.
• Prepare regular reports on database performance, growth, and capacity planning.
• Design and implement backup and recovery strategies to ensure data integrity and availability in case of failures.
• Enforce security policies and standards to comply with relevant regulations and best practices.
• Conduct regular security audits and vulnerability assessments.

Skills and Experience Required:

Required

• Proven experience as a Database Administrator, with specific expertise in DB2 on AIX, Linux, and Windows platforms.
• Strong knowledge of database administration, backup and recovery, and performance tuning.
• Familiarity with scripting languages for automation and monitoring tasks.
• Understanding of database security principles and best practices.
• Excellent analytical and problem-solving skills.
• Effective communication and collaboration abilities; work closely with other IT teams and stakeholders.

Desired:

• Certification in DB2 database administration.
• Knowledge of cloud-based database solutions (e.g., AWS RDS, Azure SQL Database).
• Familiarity with virtualization technologies (e.g., VMware).
• Experience with database clustering and high availability solutions.

Education:

• Bachelor’s degree in computer science, business, or information technology or equivalent work experience