SME - Mainframe Automation Tools

Teknik, data och digitalt · IT-infrastruktur och säkerhet · Databasadministration

I korthet

We are seeking an experienced DB2 DBA for Mainframe Automation Tools. Responsibilities include database administration, storage management, backup/recovery, performance tuning, security, and replication across development, test, and production environments. The role requires strong technical skills in IBM DB2, SQL, and Mainframe utilities.

Ansvarsområden

  • Perform IBM DB2 Database Administration on Mainframe and/or Distributed platforms.
  • Manage database creation, modification, and schema management.
  • Support application teams with database design and structural changes.
  • Allocate database storage and manage space.
  • Plan capacity and forecast future database growth.
  • Optimize performance of tablespaces, indexes, and storage resources.
  • Manage database backup, restore, and recovery.
  • Plan and implement disaster recovery.
  • Administer archive management and data retention.
  • Monitor database health, availability, and performance.
  • Tune SQL, optimize queries, and analyze resource utilization.
  • Identify and resolve performance bottlenecks.
  • Manage user provisioning and access.
  • Perform database security administration and auditing.
  • Ensure compliance with policies and licensing.
  • Manage and monitor data replication environments.
  • Perform database refresh activities.
  • Ensure data consistency and synchronization.
  • Troubleshoot database issues and perform root cause analysis.
  • Support critical incidents and production outages.
  • Engage with IBM/vendor support for complex issues.
  • Generate operational and management reports.
  • Support business and application teams with data extraction and analysis.

Krav

  • Strong experience in IBM DB2 Database Administration on Mainframe and/or Distributed platforms.
  • Expertise in database creation, modification, and schema management.
  • Ability to support application teams with database design and structural changes.
  • Experience with database storage allocation and space management.
  • Experience with capacity planning and forecasting future database growth.
  • Experience with performance optimization of tablespaces, indexes, and storage resources.
  • Experience with database backup, restore, and recovery management.
  • Experience with disaster recovery planning and implementation.
  • Experience with archive management and data retention administration.
  • Experience monitoring database health, availability, and performance.
  • Experience with SQL tuning, query optimization, and resource utilization analysis.
  • Experience identifying and resolving performance bottlenecks.
  • Experience with user provisioning and access management.
  • Experience with database security administration and auditing.
  • Experience ensuring compliance with organizational policies and vendor licensing requirements.
  • Experience managing and monitoring data replication environments.
  • Experience performing database refresh activities across development, test, and production environments.
  • Experience ensuring data consistency and synchronization.
  • Experience troubleshooting database issues and performing root cause analysis (RCA).
  • Experience supporting critical incidents and production outages.
  • Experience engaging with IBM/vendor support for complex technical issues.
  • Experience generating operational and management reports through database queries.
  • Experience supporting business and application teams with data extraction and analysis requests.
  • IBM DB2 Administration
  • SQL and Query Performance Tuning
  • Data Replication Technologies
  • Backup & Recovery Utilities
  • Database Security Administration
  • Capacity Planning
  • Performance Monitoring Tools
  • z/OS, JCL, TSO/ISPF (for Mainframe DB2 environments)

Förmåner

  • Supercharge your potential.
  • Find your career.
  • Find your spark.
  • A place that knows that helping its customers stay on top starts by putting its people first.
#DB2#Database Administration#Mainframe#Automation Tools
HCLTech Logo

Företag

HCLTech

Publicerade jobb

för 1 månad sedan

Anställningstyp

Heltid

Arbetsform

På plats

Erfarenhetsnivå

Mellannivå

Platser

Bengaluru, India

Sökande

Ansök tidigt