TCS AS400 Admi

Position: TCS is Hiring for AS400 Admi
A DB2 Database Administrator (DBA) is responsible for designing, 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, table spaces, 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.