Job Description
Roles and Responsibilities
Responsible for ensuring all database system operations process are managed specifically the below listed must haves.
Must Have:
• 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 validate crash recovery.
• Experience in handling incidents & open 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 an special build DB2 version from db2 support
Good to have:
• Experience of handling application servers (WebSphere, WebLogic, Jboss etc.) in highly available Production environments.
• Experience in maintenance, patching and installing updates on WebSphere Servers in 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 global team (co-located staffing).
• Carries learning attitude, should be an individual contributor and must have excellent communication skill.
Support: 12/5 support is required (on rotational basis).