Note: The job is a remote job and is open to candidates in USA. RAM Health is seeking a Database Administrator (DBA) responsible for the design, implementation, and management of enterprise database platforms, primarily focusing on IBM DB2 environments. The DBA will ensure the performance, integrity, and security of mission-critical databases while also contributing to SQL Server environments and modernization initiatives.
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
- Optimize SQL, buffer pools, memory, I/O, and locking mechanisms
- Execute RUNSTATS and analyze EXPLAIN plans for performance improvements
- 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
- Manage storage utilization and tablespace growth
- Perform capacity planning and forecasting
- Optimize memory structures (e.g., buffer pools, sort heap)
- Manage PowerVM resource allocation
- Manage backup and restore processes
- Ensure disaster recovery readiness and conduct regular testing
- Implement RBAC, encryption, and auditing controls
- Support compliance efforts (HITRUST, NIST, SOC2)
- Support migrations (AIX → Linux, cloud environments)
- Work with OpenShift and container platforms
- Contribute to ongoing database modernization efforts
- Provide performance tuning, backups, and routine maintenance for SQL server
Skills
- 7+ years of experience with DB2
- Hands-on experience with DB2 on 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
- Medical
- Dental
- Vision
- 401(k) with match
- Life insurance
- STD
- LTD
- 5 weeks PTO
- Paid Holidays for a full-time employee
Company Overview
At RAM Health, our mission is to simplify the complexities of healthcare administration through innovative, technology-driven solutions. It was founded in 1981, and is headquartered in Fort Washington, Pennsylvania, USA, with a workforce of 51-200 employees. Its website is https://ramtechnologiesinc.com/.