IBM DB2 DBA

• Expert knowledge of IBM DB2 V11.5 installations, configurations & administration in Linux systems.
• Expert level knowledge in Database restores including redirected restore & backup concepts.
• Excellent understanding of database performance monitoring techniques, fine-tuning, and able to perform performance checks & query optimization
• Good knowledge of utilities like import, load & export under high volume conditions.
• Ability to tune SQLs using db2advisor & db2explain.
• Ability to troubleshoot database issues using db2diag, db2pd, db2dart, db2top tec.
• Administration of database objects.
• Capability to review & assess features or upgrades to existing components.
• Experience in validating security aspects on a confidential database.
• Hands-on experience in SSL communication setup, strong access control, and database hardening.
• Experience in performing productive DB recovery and validating crash recovery.
• Experience in handling incidents & opening DB2 support tickets.
• Experience in deploying a special build DB2 version from DB2 support.
• Worked in environments such as 12x5 supports of production database services.
• Excellent problem-solving skills, analytical skills.
• Validate security aspects on a confidential database
• SSL communication setup, strong access control; database hardening
• Validate Crash recovery
• perform productive DB recovery
• On incidents open db2 support tickets
• Deploy a special build DB2 version from db2 support

Good to have:

• Experience in handling application servers (WebSphere, WebLogic, Jboss, etc.) in highly available Production environments.
• Experience in maintenance, patching, and installing updates on WebSphere Servers in the Production environment.
• Able to handle installation/deployment of the product (JAR/EAR/WAR) independently.
• Knowledge of ITIL concepts (Service operation & transition)

Soft skills:

• Ability to work with the global team (co-located staffing).
• Carries learning attitude, should be an individual contributor and must have excellent communication skills.
• Support: 12/5 support is required (on a rotational basis).