DB2 Database Administrator

You will be responsible for Database Object Creation and Maintenance, including creating and altering various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes, etc. Additionally, you will need to have knowledge and expertise on DB2 utility execution. Your role will involve Data load and migration tasks, such as understanding the data migration process from VSAM to DB2, unloading data from DB2 tables using UNLOAD utility, loading data from files to Tables using LOAD utility, unloading data from Image copy using UNLOAD or other utilities, and migrating data from one environment to another. Database backup and Recovery will be a crucial part of your responsibilities. This includes setting up and maintaining Image Copy and other DB2 housekeeping jobs, as well as being able to recover data from Image Copy using RECOVER utility. You will also manage Database access and security control by following security and audit control procedures to GRANT/REVOKE permissions on database objects, and providing Group level access on DB2 objects to RACF user groups. Supporting the Application team will be a key aspect of your role, which involves monitoring and troubleshooting batch job failures, handling and resolving all DB2 package related consistency token issues, and assisting the application team in resolving performance issues for the SQLs and/or Stored procedures. As part of Performance monitoring and tuning, you will be required to monitor current active and historical threads using DB2 monitoring tools, identify potential bottlenecks and lock contention in the active or historical threads, troubleshoot them, check overall Mainframe CPU utilization using SYSVIEW online panels, and perform SQL tuning by rewriting the SQLs or designing appropriate indexes. This is a Full-time position with benefits such as Paid time off, Provident Fund, and a Yearly bonus. The work schedule is Day shift, Monday to Friday, with the work location being in person at Noida.,