Database Administrator - DB2/z/OS

Key Responsibilities : - Administer, maintain, and optimize IBM Db2 for z/OS databases. - Perform performance tuning using EXPLAIN, SQL analysis, catalog reviews, MainView, and Query Monitor. - Manage backup, recovery, disaster recovery, and high-availability solutions. - Troubleshoot database, SQL, locking, catalog, and performance issues. - Implement database security, access controls, authentication, and auditing. - Design schemas, indexing strategies, normalization, and capacity planning. - Support production, test, and development environments. - Collaborate with application teams and provide technical guidance. - Participate in 24x7 on-call support rotation. Required Skills : - Strong hands-on experience with IBM Db2 for z/OS administration. - Expertise in performance tuning, backup/recovery, and troubleshooting. - Knowledge of RACF, ACF2, Top Secret, database security, and auditing. - Experience with EXPLAIN plans, catalog analysis, MainView, and Query Monitor. - Strong database design, modeling, and capacity planning skills. - Experience supporting high-volume, highly available transactional systems. - Strong communication and problem-solving abilities. Preferred Skills : - Very Large Tables (VLTs) management. - IBM Q Replication (Db2z ? Db2z). - Db2 Data Sharing and Sysplex environments. - Db2 Connect and distributed access. - BMC tools (Catalog Manager, Utilities, MainView). - Payments/FinTech domain experience. Location : Bangalore / Hyderabad Work Mode : Hybrid