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)