Database Administrator

The Database Administrator (DBA) is responsible for the design, implementation, performance optimization, monitoring, and operational management of enterprise database platforms, with a primary focus on IBM DB2 (AIX/Linux) environments. This role ensures the availability, integrity, security, and performance of mission-critical databases supporting core business applications. 
 
The DBA will also contribute to SQL Server environments and support modernization initiatives, compliance alignment (HITRUST, NIST, SOC2), and hybrid infrastructure evolution. 

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). 
• Monitor 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 DB2on Power Systems (PowerVMLPARs).
• 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.

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.