Db2 Database Administrator

2 weeks ago

Noida Uttar Pradesh, India BeeSolver Technology Pvt Ltd Full time

JOB TITLE: DB2 DBA

LOCATION: Noida

SKILL: DB2 DBA

WORK TIMING: Rotational Shifts

A. Database Object Creation and Maintenance:
1. Create, Alter various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes etc.

2. Knowledge and expertise on DB2 utility execution.

B. Data load and migration:
1. Knowledge and understanding of data migration process from VSAM to DB2.

2. Unload data from DB2 tables using UNLOAD utility.

3. Load data from files to Tables using LOAD utility.

4. Unload data from Image copy using UNLOAD or other utilities.

5. Migrate data from one environment to another.

C. Database backup and Recovery:
1. Setup and maintain Image Copy and other DB2 housekeeping jobs.

2. Able to recover data from Image Copy using RECOVER utility.

D. Database access and security control:
1. Follow the security and audit control procedures to GRANT/REVOLKE permissions on database objects.

2. Understand and provide Group level access on DB2 objects to RACF user groups.

E. Support to Application team:
1. Monitor and troubleshoot batch job failures.

2. Handle and resolve all DB2 package related consistency token issues.

F. Performance monitoring and tuning:
1. Monitor current active and historical threads using DB2 monitoring tool.

2. Identify potential bottleneck, lock contention in the active or historical threads and troubleshoot them.

3. Check overall Mainframe CPU utilization using SYSVIEW online panels.

4. SQL tuning by rewriting the SQLs or designing appropriate indexes.

Pay: ₹811,840.25 - ₹2,059,289.75 per year

**Benefits**:

- Paid time off
- Provident Fund

Schedule:

- Day shift
- Monday to Friday

Supplemental Pay:

- Yearly bonus

Work Location: In person

  • DB2 Database Administrator

    3 weeks ago

    Noida, Uttar Pradesh, India TECEZE Full time

    Job Title: DB2 Database Administrator (DBA) – z/OS PlatformCompany: TECEZELocation: Bangalore / Chennai / Noida (Hybrid)Experience: 5+ YearsRole SummaryWe are seeking an experienced DB2 Database Administrator (DBA) on the z/OS mainframe platform to join our team. The DBA will be responsible for the installation, configuration, performance tuning, security,...

  • Db2 systems

    2 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database Administrator Experience: 8–10 Years Location: Noida Job Type: Full-time Role Overview We are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable) ,...

  • DB2 Systems

    3 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database Administrator Experience: 8–10 Years Location: Noida Job Type: Full-time Role Overview We are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance...

  • DB2 Systems

    2 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: NoidaJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable) , performance tuning,...

  • DB2 Systems

    2 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: NoidaJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • DB2 Systems

    2 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: NoidaJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • Ibm Db2 Administrator

    2 weeks ago

    Noida, Uttar Pradesh, India CODERS BRAIN TECHNOLOGY PRIVATE LIMITED Full time

    **About the Role** You will be responsible for **database administration, monitoring, optimization, and troubleshooting** to ensure seamless performance of mission-critical systems. **Key Responsibilities** - Manage **DB2 LUW architecture**, installation, instance creation, and product setup. - Create and maintain **database objects** (tables, indexes,...

  • DB2 Systems

    3 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: NoidaJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • DB2 Systems

    3 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: NoidaJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...

  • DB2 Systems

    2 weeks ago

    Noida, India TECEZE Full time

    Job Title: DB2 Systems & Database AdministratorExperience: 8–10 YearsLocation: NoidaJob Type: Full-timeRole OverviewWe are seeking an experienced DB2 Systems & Database Administrator to manage, optimize, and support our DB2 database environments. The role requires strong expertise in DB2 administration (LUW/z/OS as applicable), performance tuning, high...