Database & Middleware Engineer - Part-Time

Role Overview

We are seeking a DB2 Administrator (L2) with hands-on experience in managing database and middleware environments. The role involves end-to-end database lifecycle management including provisioning, patching, performance tuning, access management, backup/recovery, and high availability.

The candidate will also support middleware platforms, ensuring consistent, secure, and automated infrastructure operations across on-premises and cloud environments.

Key Responsibilities

DB2 Database Administration

• Install, configure, and manage IBM DB2 databases across environments.
• Provision database instances with standardized configurations for on-premises and cloud.
• Perform database patching, upgrades, and CVE remediation.
• Monitor database health including performance, capacity utilization, and availability.
• Analyze and optimize queries, execution plans, and indexing strategies.

Database Operations & Governance

• Manage schemas, database objects, and lifecycle changes.
• Administer user access, roles, and permissions (RBAC) with governance controls.
• Implement and manage backup and restore procedures, including validation testing.
• Configure and maintain high availability (HADR), replication, and failover mechanisms.
• Ensure compliance through audit logging, access monitoring, and reporting.

Monitoring & Performance

• Track key performance metrics and ensure SLAs are met.
• Proactively identify and resolve performance bottlenecks.
• Manage alerts, thresholds, and trend analysis for capacity planning.

Middleware Administration

• Install, configure, and maintain middleware platforms including: Apache HTTP ServerNginxMicrosoft IIS
• Perform middleware patching, configuration tuning, and lifecycle management.
• Support integration between database and application layers.

Automation & DevOps

• Use Ansible (or similar tools) for configuration management and automation.
• Support repeatable deployments and standardized infrastructure builds.
• Maintain scripts and automation for DB and middleware operations.

Disaster Recovery & Documentation

• Participate in DR drills and recovery validation exercises.
• Maintain runbooks, SOPs, and operational documentation.
• Ensure documentation is updated for configurations, procedures, and changes.

Required Skills & Competencies

• 2–5 years of experience in database administration (DB2 preferred)
• Hands-on experience with IBM DB2 database management
• Knowledge of SQL and query optimization techniques
• Experience with database backup, recovery, and high availability (HADR)
• Understanding of database security, access control, and auditing
• Exposure to middleware platforms (Apache, Nginx, IIS)
• Familiarity with Linux/Windows server environments
• Experience with automation tools (Ansible or equivalent)
• Strong troubleshooting and performance tuning skills

Preferred Skills

• Exposure to other RDBMS (Oracle, SQL Server, PostgreSQL)
• Experience with cloud databases (AWS RDS, Azure SQL)
• Knowledge of DevOps practices and CI/CD integration
• Basic scripting skills (Shell, Python)