Role- AS400 Admin.

Experience-8 to 10 yrs.

Location-Chennai.

Job Requirements-

A DB2 Database Administrator (DBA) is responsible fordesigning, installing, maintaining, and securing IBM DB2 databases (LUW or z/OS), ensuring high performance, availability, and data integrity. Core duties include performance tuning (SQL optimization, indexing), backup/recovery (HADR), capacity planning, security management, and implementing database upgrades/patches.

- Database Design & Implementation: Designing, creating, and managing physical database structures, tablespaces, and schemas.
- Performance Tuning & Optimization: Monitoring database performance, analyzing SQL queries using tools like EXPLAIN, tuning database configuration parameters, and running maintenance utilities (REORG, RUNSTATS).
- Backup & Recovery: Developing and managing comprehensive backup/recovery, disaster recovery, and High Availability Disaster Recovery (HADR) strategies to ensure minimal downtime.
- Security & Compliance: Managing database users, roles, and permissions; ensuring data security, audit compliance, and implementing security frameworks.
- Maintenance & Upgrades: Performing patching, version upgrades, and migrations with minimal impact on production.
- Troubleshooting & Support: Resolving complex production issues, identifying bottlenecks, and providing 24/7 support.
- Automation & Scripting: Developing Shell or Python scripts to automate routine tasks, monitoring, and database management.
- Collaboration: Working with developers on schema changes, application design, and SQL optimization





Key Responsibilities- A DB2 Database Administrator (DBA) is responsible fordesigning, installing, maintaining, and securing IBM DB2 databases (LUW or z/OS), ensuring high performance, availability, and data integrity. Core duties include performance tuning (SQL optimization, indexing), backup/recovery (HADR), capacity planning, security management, and implementing database upgrades/patches.

- Database Design & Implementation: Designing, creating, and managing physical database structures, tablespaces, and schemas.
- Performance Tuning & Optimization: Monitoring database performance, analyzing SQL queries using tools like EXPLAIN, tuning database configuration parameters, and running maintenance utilities (REORG, RUNSTATS).
- Backup & Recovery: Developing and managing comprehensive backup/recovery, disaster recovery, and High Availability Disaster Recovery (HADR) strategies to ensure minimal downtime.
- Security & Compliance: Managing database users, roles, and permissions; ensuring data security, audit compliance, and implementing security frameworks.
- Maintenance & Upgrades: Performing patching, version upgrades, and migrations with minimal impact on production.
- Troubleshooting & Support: Resolving complex production issues, identifying bottlenecks, and providing 24/7 support.
- Automation & Scripting: Developing Shell or Python scripts to automate routine tasks, monitoring, and database management.
- Collaboration: Working with developers on schema changes, application design, and SQL optimization.

📌 Tcs is Hiring For As400 Administrator For Chennai location.
🏢 Tata Consultancy Services
📍 Chennai