Db2 Dba Administrator

1 week ago

Bengaluru, India Quess IT Staffing Full time

**About Us**

“Magna Infotech, now Quess IT Staffing, is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names across industried. Quess IT Staffing is a division of Quess Corp Limited, India’s leading business services provider and largest domestic private sector employer. Quess Corp Limited is - ‘A Great Place to Work’ certified - a testament to our excellent culture, people, and processes.”

**About Company**

**Roles and Responsibility**

DB2 DBA Administrator

Physical DB2 DBA JD:
General:
This role is performed by technical professionals responsible for the physical and technical aspects of a database systems. Responsibilities for this job role include, but are not limited to, installation and maintenance of the databases, DB2 upgrades and patches checkouts, performance and capacity monitoring & management, and security compliance. Potential interaction with clients (internal or external) in order to understand and meet requirements for the delivery of services related to database products.

JD as per experienceLevel 2

Monitory DB2 Dialogue/Instant notification logs

1. Monitoring of Transactio logs

2. Monitoring Archive log destinations

3. Monitoring of Life systems owned by DB2 database

4. Monitoring Tablespace

5. Starting up Instance

6. Shutting down Instance

7. Activate/Deactivate

8. Quiesce/Unquiesce

9. Running scripts to prepare capacity planning reports.

Level3

House keeping and Maintenance of files owned by DB2 Database

1. Creating tablespace - System and Database managed

2. Altering Tablespace

3. Reorganizing tables and Indexes

4. Recover Database

5. Binding of packages to DB2 databases

6. Ondemand backup of Database

7. Runstats of tablspace and Index

8. Creation of new DB2 objects

Level 4

Tablespace Migration

1. RCA for recurring issues

2. Tuning of Databases and DB parameters

3. Tuning of Memory parameters, Buffer pool and registry variables.

4. Taking snapshot of database

5. Participate in DR test

6. Synchronize primary and HADR databases

7. Gather periodic database statisctics

  • Mainframe DB2 DBA

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role:Mainframe DB2 DBA Experience:7-15 Years Locations:Bangalore/Mumbai Must have & good to have: Skills:z/OS Db2 v13 Database Administration Desired Competencies (Technical/Behavioral Competency) Must-Have - Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS - DB2 installation, upgrade, patching, configuration and operations -...

  • Mainframe DB2 DBA

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role: Mainframe DB2 DBA Experience :7-15 Years Locations :Bangalore/Mumbai Must have & good to have : Skills: z/OS Db2 v13 Database Administration Desired Competencies (Technical/Behavioral Competency) Must-Have Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS DB2 installation, upgrade, patching, configuration and operations...

  • Mainframe DB2 DBA

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role: Mainframe DB2 DBA Experience :7-15 Years Locations :Bangalore/Mumbai Must have & good to have : Skills: z/OS Db2 v13 Database Administration Desired Competencies (Technical/Behavioral Competency) Must-Have Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS DB2 installation, upgrade, patching, configuration and operations...

  • Mainframe DB2 DBA

    3 days ago

    Bengaluru, Karnataka, India Tata Consultancy Services (TCS) Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Role: Mainframe DB2 DBAExperience Range: 7 – 15 YearsLocation : Bangalore/MumbaiMust Have:Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningGood to Have:Database DR, Cloning, Backup/Recovery, HA...

  • IMS DB2 DBA

    2 weeks ago

    Bengaluru, Chennai, Hyderabad, India Golden Opportunities Pvt Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Title : IMS DB2 Database Administrator (DBA)Location : Chennai, Bangalore, Pune, HyderabadExperience : 8+ YearsJob SummaryWe are seeking an experienced IMS DB2 DBA to manage, support, and optimize IMS (Information Management System) and DB2 databases in a mainframe environment.The ideal candidate must have strong mainframe skills, hands-on IMS database...

  • Hiring for core oracle dba with db2 luw dba

    3 weeks ago

    Bengaluru, India Atos Full time

    Location: Pune, Mumbai, Bangalore & Chennai Expereince: 8+ years Max CTC: 25 LPA Primary Skills : Core Oracle DBA, RAC, Dataguard & DB2 LUW DBA Interested candidates share the resume to Primary – Oracle DBA: Design, install, configure, and maintain Oracle 12c/19c/21c environments in production and non-production. Set up and manage high availability and...

  • AS400 DB2 DBA Administrator

    5 days ago

    Bengaluru, Karnataka, India Growel Softech Pvt. Ltd. Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    :- Job Summary:The AS400 DB2 DBA Administrator is responsible for the administration, maintenance, and performance tuning of DB2 databases on AS400 systems. This role ensures the reliability, security, and efficiency of the database environment, supporting business-critical applications and data management processes. Key Responsibilities: Install, configure,...

  • Hiring for core oracle dba with db2 luw dba

    1 week ago

    Bengaluru, India Atos Full time

    Location: Pune, Mumbai, Bangalore & ChennaiExpereince: 8+ yearsMax CTC: 25 LPAPrimary Skills : Core Oracle DBA, RAC, Dataguard & DB2 LUW DBAInterested candidates share the resume to Primary – Oracle DBA: Design, install, configure, and maintain Oracle 12c/19c/21c environments in production and non-production. Set up and manage high availability and...

  • Db2 Dba for Zos

    2 days ago

    Bengaluru, India Cranium IT Inc Full time

    Skill**:DB2 DBA for zOS** **Experience: 3+ years** **JD**: a. SAP on DB2 for z/OS - DBA (need to understand SAP DBA cockpit etc.) 1. DB Parameter changes 2. Table States update 3. Table Reorg 4. DB Config (Disk Space, Temp Space etc.) 5. Tablespace increase on Source 6. DB Monitoring during migration 7. DB Upgrade (if required) 8. DB Patching (if...

  • Mainframe DB2 DBA

    3 weeks ago

    Bengaluru, India Tata Consultancy Services Full time

    Role:Mainframe DB2 DBAExperience:7-15 YearsLocations:Bangalore/MumbaiMust have & good to have:Skills:z/OS Db2 v13 Database AdministrationDesired Competencies (Technical/Behavioral Competency)Must-Have- Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS- DB2 installation, upgrade, patching, configuration and operations- Proficiency in...