Database Engineer

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)