DB2 Database Administrator_1941 (IN)

Allianz
India
Workplace: OnsiteFull timeFunction: Administration & Executive AssistanceExperience: 8-10 yearsEducation: bachelorsSkills: ["Troubleshooting","Process improvement","Automation ownership","Performance optimization","Attention to database security and controls"]

Administer IBM DB2 databases, including creating schemas, managing backups/security, monitoring and tuning performance, and troubleshooting L3/L4 database incidents. Support DB2 PureScale/Purescale implementations with automation using Ansible roles and shell scripting, including backup/recovery procedures and database health monitoring. Optimize SQL performance using DB2 Explain, plan storage/I/O improvements, and handle restore actions and utilities across production and development environments.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Allianz
Allianz
1 day ago

DB2 Database Administrator_1941 (IN)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 11 hours agoStatus: Live

Job Summary

Administer IBM DB2 databases, including creating schemas, managing backups/security, monitoring and tuning performance, and troubleshooting L3/L4 database incidents. Support DB2 PureScale/Purescale implementations with automation using Ansible roles and shell scripting, including backup/recovery procedures and database health monitoring. Optimize SQL performance using DB2 Explain, plan storage/I/O improvements, and handle restore actions and utilities across production and development environments.
Location: India
Workplace: Onsite
Employment Type: Full time
Job Function: Administration & Executive Assistance
Seniority: Mid level

Key Responsibilities

  • •Create databases and tables based on application developer requirements.
  • •Manage database backups, security, controls, and user access; implement backup and recovery procedures including audit logs.
  • •Monitor and optimize database performance in production and development environments, including database tuning.
  • •Perform L3-L4 troubleshooting for database-related incidents and engage vendor support until resolution.
  • •Plan, document, and implement database system software and release upgrades; handle restore of databases and application servers when required.

Key Requirements

  • •University graduate degree (mandatory).
  • •8-10 years of relevant experience as a DB2 UDB DBA.
  • •Experience with relational database management systems, specifically DB2 Database Administration on Linux.
  • •Know-how in Ansible (intermediate-advanced preferred) and ability to customize existing playbooks.
  • •Expertise running DB2 utilities (e.g., reorg, runstats, rebind, export/import, load, backup/restore/recovery) and strong backup/recovery proficiency.
Experience:8-10 years
Education:Bachelor's
Skills:TroubleshootingProcess improvementAutomation ownershipPerformance optimizationAttention to database security and controls
Tech Stack:IBM DB2DB2 PureScalePureScaleAnsibleLinuxShell scriptingPL1PostgreSQLGPFSIBM Storage scaleSQLGrafanaDynatraceDB2 ExplainTable partitioningTable compressionEvent monitorsSnapshot monitors

Company Brief

Allianz
Global insurance and financial services group offering property-casualty insurance, life and health insurance, asset management, and corporate risk solutions to individuals, businesses, and institutions across more than 70 countries.
Industry: Insurance
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Munich, Germany
Founded: 1890
WebsiteLinkedIn