DB2 DBA

Highbrow LLC; Omaha (NE); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading technology company is seeking a skilled DB2 DBA based in Omaha, NE. The role involves installing, configuring, and managing DB2 databases across AIX, Linux, and Windows platforms. Candidates should have proven database administration experience, strong analytical skills, and an understanding of database security best practices. This is an onsite position with long-term employment opportunities and requires all work authorizations. Competitive salary and benefits offered.

Qualifications

• Proven experience as a Database Administrator with DB2 expertise.
• Strong knowledge of database administration and performance tuning.
• Familiarity with scripting languages for automation.

Responsibilities

• Install and configure DB2 database systems on multiple platforms.
• Monitor database performance and health for optimal functionality.
• Perform regular backups and disaster recovery planning.

Skills

DB2

AIX

Linux

Windows

Database Administration

Performance Tuning

Backup and Recovery

Scripting Languages

Database Security Principles

Analytical Skills

Communication Skills

Education

Bachelor’s degree in computer science, business or IT

Job description

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