Database Administrator

Responsibilities

• Administer DB2 databases across AIX/Linux environments.
• Manage DB2 on IBM Power Systems (PowerVM LPARs).
• Perform installation, configuration, patching, and upgrades.
• Manage schemas, tablespaces, indexes.
• Ensure high availability and adherence to SLA compliance.
• Performance & Tuning
• Optimize SQL, buffer pools, memory, I/O, and locking mechanisms.
• Execute RUNSTATS and analyze EXPLAIN plans for performance improvements.
• Monitoring & SIEM
• Implement and manage monitoring tools (PRTG, Rapid7, and native DB2 tools).
• Integrate database logs with SIEM platforms (Rapid7).
• Maintain system health: CPU, memory, disk, locking, and query performance.
• Capacity Management
• Manage storage utilization and tablespace growth.
• Perform capacity planning and forecasting.
• Optimize memory structures (e.g., buffer pools, sort heap).
• Manage PowerVM resource allocation.
• Backup & Recovery
• Manage backup and restore processes.
• Ensure disaster recovery readiness and conduct regular testing.
• Security & Compliance
• Implement RBAC, encryption, and auditing controls.
• Support compliance efforts (HITRUST, NIST, SOC2).
• Modernization
• Support migrations (AIX → Linux, cloud environments).
• Work with OpenShift and container platforms.
• Contribute to ongoing database modernization efforts.
• SQL Server Support
• Provide performance tuning, backups, and routine maintenance for SQL server.

Requirements

• 7+ years of experience with DB2.
• Hands-on experience with DB2 on IBM Power Systems (PowerVM LPARs).
• Strong expertise in SQL performance tuning and optimization.
• Experience with shell scripting (Bash and/or KornShell).
• Working knowledge of Microsoft SQL Server.
• Familiarity with Red Hat Enterprise Linux (RHEL).
• Exposure to OpenShift and/or Kubernetes.
• Experience supporting or integrating with SIEM solutions.
• Background in platform modernization initiatives.
• Experience working in healthcare or other regulated environments.
• Strong problem-solving and analytical thinking.
• Proven performance troubleshooting expertise.
• High level of attention to detail.
• Excellent communication skills.
• Ability to perform effectively in critical, high-pressure environments.

Benefits

This position offers a benefits package that includes medical, dental, vision, 401(k) with match, life insurance, STD, LTD, 5 weeks PTO, and paid Holidays for a full-time employee. Contracted employees would not be eligible for benefits.