Database Administrator (DBA)

6 - 10 years

7 - 11 Lacs

Posted:23 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Who are we looking for

We are seeking for 6+ years of administrator experienced and detail-oriented

DB2 and IMS Database Administrator (DBA)

to join our production support team. In this role, you will be responsible for maintaining the stability, availability, and performance of DB2 and IMS databases on IBM mainframe (z/OS) environments. The role requires strong problem-solving skills, a solid understanding of mainframe database internals, and a proactive approach to system health monitoring, incident response, and database maintenance. You will provide 24/7 production support, troubleshoot issues, monitor system health, optimize performance .

Technical Skills:

Proven experience as a

DB2/IMS

Databases Administrator or similar role in production support environments.
6+ years of hands-on experience supporting

DB2 for z/OS

and

IMS (Information Management System)

in a production environment.
Strong knowledge of mainframe tools such as SPUFI, QMF, BMC, CA-DB2/IMS tools, and IBM utilities.
Deep understanding of DB2 database internals, logs, buffer pools, catalog/directory, and utilities.
Proficient in IMS Full-Function and Fast Path databases, DL/I calls, PSB/DBD maintenance.
Solid experience with JCL, TSO/ISPF, SDSF, and mainframe batch job troubleshooting
Experience with modern mainframe automation tools and schedulers (e.g., Control-M, CA-7).
Knowledge of COBOL, CICS, and batch job data flows.
Understanding of DB2 Data Sharing and IMS Sysplex environments.
Experience with backup and recovery solutions
Solid knowledge of Linux/Unix systems and scripting (Shell, Python, or similar).
Proficiency in troubleshooting performance tuning, and capacity planning.
In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Strong troubleshooting and problem-solving skills.
Excellent communication and collaboration abilities.
Ability to work in a 24/7 support rotation and handle urgent production issues.
Familiarity with data security is the best practice and backup procedures.

Production Support & Monitoring:

o Provide 24x7 support for DB2 and IMS database environments, including on-call rotation.
o Monitor database performance, availability, and integrity using mainframe tools and utilities.
o Respond to incidents, troubleshoot issues, and resolve problems related to DB2/IMS systems.

Database Maintenance & Administration:

o Perform database backup and recovery procedures for DB2 and IMS databases.
o Conduct regular reorgs, image copies, and utilities execution (RUNSTATS, REORG, CHECK).
o Support DB2 and IMS subsystem maintenance, upgrades, and patching.

Performance Tuning & Optimization:

o Analyze and tune SQL queries, buffer pools, and access paths in DB2.
o Optimize IMS database segments, DBDs, PSBs, and access methods.

o

Work with developers to design efficient data access strategies

.

Change Management & Deployments:

o Review and implement database schema changes via Change Control processes.
o Participate in software releases, ensuring database readiness and minimal impact on production.

Security & Compliance:

o Manage user access, RACF integration, and permissions in DB2/IMS environments.
o Ensure compliance with enterprise security standards and data privacy regulations.

Documentation & Collaboration:

o Maintain accurate and up-to-date documentation, including runbooks, architecture diagrams, and operational procedures.
o Collaborate with application teams, infrastructure, and middleware teams to support business applications
Database Admin

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Rarr Technologies logo
Rarr Technologies

Information Technology

San Francisco

RecommendedJobs for You

Madhapur, Hyderabad, Telangana

Kalyani Nagar, Pune, Maharashtra

Mumbai, Maharashtra, India