3+ IBM DB2 DBA Jobs in India

• 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).

 

 

 

As a DB2 Administrator, candidate would involve in  activities, troubleshooting database & key responsible for Migration, Upgrading activities including DB2 replication suite and services.

• 6+ years of relevant experience in DB2 LUW Administration
• Good experience with
  • Performance tuning and troubleshooting
  • High availability solutions HACMP, TSA, MSCS Cluster
  • Monitoring, backup, recovery, IBM Data Server Manager, TSM , Commvault
  • Data replication, Q-replication & CDC
  • Implementing DB2 key features
  • Desirable experience with Db2 Pure scale
• Experience with tools i.e. ITM, Nagios, Service Now
• Experience with automation and scripting such as CRON, PowerShell, Shell Scripting
• Experience with configuring and usage of Clustering, db2diag and notification logs, snapshot and event monitor
• Experience with use of problem and change management tools

As a DB2 Administrator, candidate would involve in L2 activities, troubleshooting database & key responsible for Migration, Upgrading activities including DB2 replication suite and services.

Responsibilities -

·         Product lifecycle Management of DB2 LUW Product including replication suite

·         Perform Health check activities, monitoring, backup, space management, Maintenance i.e. Reorg / Run stat utilities

·         Follow-up CIRATS i.e. Compliance, Issue, Risk and APAR (Authorized Program Analysis Report) Tracking System

·         User management and BAU activities

·         Setup and maintenance of Data replication services

·         Disaster recovery and business continuity planning

·         Backup and recovery methods including point in time recovery

·         DB2 node directory / catalog configuration

·         Database performance tuning and troubleshooting

·         24*7 on call support for DB2 portfolio and applications

·         Provide best in class solutions for all business needs

·         Explore and help organization to implement best technical practises / recommendations to reduce technical debt and cost

·         Managing and maintaining physical databases including database storage management, procedures and tools for access, database security, monitoring and tuning the database

·         Analysing system storage capacity and recommending improvements to ensure efficiency

·         Assisting in the design and implementation of the physical framework of the database

Required Skillset -

• 6+ years of relevant experience in DB2 LUW Administration
• Good experience with
  • Performance tuning and troubleshooting
  • High availability solutions HACMP, TSA, MSCS Cluster
  • Monitoring, backup, recovery, IBM Data Server Manager, TSM , Commvault
  • Data replication, Q-replication & CDC
  • Implementing DB2 key features
  • Desirable experience with Db2 Pure scale
• Experience with tools i.e. ITM, Nagios, Service Now
• Experience with automation and scripting such as CRON, PowerShell, Shell Scripting
• Experience with configuring and usage of Clustering, db2diag and notification logs, snapshot and event monitor
• Experience with use of problem and change management tools

Other desired traits -

• Technical agility
• Good Team player, Self-starter
• Willing to take accountability and drive projects/tasks to completion
• Good written, verbal communication and interpersonal skills
• Ability to relate technical issues to non-technical personnel