DB2 zOS database administration

Required Skills & Knowledge

* More than 6+ years hands-on experience in DB2 zOS database administration 

* Hands on experience in DB2 Database Management area (DB2 apps DBA) with Medium to Advanced knowledge of JCL, VSAM and preferred if knowledge of SAS or Rex for automation

* Exposure to IMS DBA would be a value add 

* Good analytical skills and ability to troubleshoot

* Familiar with change management processes- Service Now

* Good Communication Skills

Relevant Work Experience

* Analyzing Database State (both Space and Performance wise)

* DB2 utility (Load, Unload, Image copy, Reorg etc.)

* Analyzing tablespaces for space and Performance

* Writing queries

* Database Refresh from one system to another

* Good understanding of Agile

* Weekly maintenance support and incident handling

Primary Position Responsibilities & Duties

Works closely with the business and other Information Technology (IT) teams focusing on the processes of gathering, analyzing and documenting information requirements using standard data management tools and techniques for the creating, support and administration of databases. Help the global team in execution of projects and support of DB2 zOS databases/tables .

This position will work on

1. Small infrastructure type of projects in databases.

2. Ensuring round the clock availability of databases and tables.

2. Work on user requests and tickets.

3. Weekly maintenance process for backup and recovery.

4. DDL and DML

5. Performance tuning.