Database Administrator | 6 to 9 Years | PAN India

Capgemini
Full_time•Bangalore, India

📍 Job Overview

  • Job Title: Database Administrator | 6 to 9 Years | PAN India
  • Company: Capgemini
  • Location: Bangalore, Karnataka, India
  • Job Type: On-site
  • Category: Database Administration
  • Date Posted: June 17, 2025
  • Experience Level: Mid-Senior level (5-10 years)

🚀 Role Summary

  • Manage and maintain DB2 on z/OS environments, ensuring optimal performance and high availability
  • Collaborate with operations and automation teams to define and implement procedures for DB2 environments
  • Provide technical recommendations and support for DB2 environments, ensuring security compliance in RACF/Top Secret/ACF2 environments

📝 Enhancement Note: This role requires a strong understanding of DB2 on z/OS and related technologies, with a focus on performance tuning, disaster recovery, and security compliance. Candidates should have experience working in a large-scale enterprise environment and be comfortable collaborating with cross-functional teams.

💻 Primary Responsibilities

  • Database Management: Install, upgrade, and maintain DB2 on z/OS and related ISV tools. Configure and manage DB2 subsystems in both data sharing and non-data sharing environments.
  • Disaster Recovery & Backup: Perform DB2 disaster recovery, backups, restores, and performance tuning. Build and relocate DB2 subsystem environments as needed.
  • Maintenance & Automation: Apply maintenance updates and patches using SMP/E. Develop and maintain REXX scripts for automation and DB2 interaction.
  • Performance Monitoring: Monitor DB2 performance using traces, utilities, and performance monitors. Ensure optimal CPU utilization and query optimization.
  • Security Compliance: Ensure security compliance in RACF/Top Secret/ACF2 environments. Collaborate with operations and automation teams to define and implement procedures.

📝 Enhancement Note: This role requires a proactive approach to database management, with a focus on preventing issues before they occur. Candidates should be comfortable working in a dynamic environment and be able to adapt to changing priorities and deadlines.

🎓 Skills & Qualifications

Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Relevant certifications (e.g., IBM DB2 Certified Database Administrator) are a plus.

Experience: 6 to 9 years of experience in database administration, with a strong focus on DB2 on z/OS. Experience in a mainframe environment is required.

Required Skills:

  • Strong knowledge of DB2 on z/OS and relational database concepts
  • Experience with DB2 utilities (COPY, REORG, LOAD, UNLOAD)
  • Proficiency in DB2 tools: SPUFI, QMF, IBM DB2 Admin Tool, Object Comparison Tool, Infosphere Optim, High Performance Unload
  • Expertise in DB2 performance tuning, query optimization, and CPU utilization analysis
  • Experience with DB2 stored procedures, recovery to PIT, and DBADM/SYSADM authority
  • Familiarity with SMP/E, REXX, Assembler, and JCL

Preferred Skills:

  • Experience with DB2 on Linux, Unix, or Windows
  • Knowledge of Agile methodologies and DevOps practices
  • Familiarity with containerization (e.g., Docker) and orchestration (e.g., Kubernetes) tools

📝 Enhancement Note: Candidates with experience in cloud-based database environments (e.g., AWS RDS, Azure SQL Database) may have an advantage, as Capgemini is expanding its cloud services offerings.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

  • A comprehensive portfolio demonstrating experience with DB2 on z/OS, including case studies of performance tuning, disaster recovery, and security projects
  • Examples of REXX scripts and automation tools developed for DB2 environments
  • Documentation showcasing DB2 environment configuration, maintenance processes, and best practices

Technical Documentation:

  • Detailed documentation of DB2 environment setup, including database schema, table structures, and indexes
  • Performance analysis reports, including query optimization strategies and CPU utilization analysis
  • Disaster recovery and backup procedures, including recovery to PIT and backup strategies

📝 Enhancement Note: Candidates should focus on demonstrating their technical expertise and problem-solving skills in their portfolio. Including before-and-after examples of performance tuning and disaster recovery projects can help illustrate the impact they've made in previous roles.

💵 Compensation & Benefits

Salary Range: ₹1,200,000 - ₹1,800,000 per annum (INR 12-18 LPA) for Bangalore, considering the mid-senior level experience required and the regional cost of living. This estimate is based on market research and industry standards for database administrators with 6 to 9 years of experience in the Bangalore area.

Benefits:

  • Competitive salary and performance-based bonuses
  • Comprehensive health insurance and retirement plans
  • Employee stock purchase plan (ESPP)
  • Generous time-off policies, including vacation, sick leave, and parental leave
  • Learning and development opportunities, including training programs, certifications, and tuition reimbursement
  • Employee assistance programs (EAP) for mental health and wellness support

Working Hours: Full-time position with standard office hours (Monday to Friday, 9:00 AM to 6:00 PM IST). Occasional overtime may be required to support maintenance windows and critical projects.

📝 Enhancement Note: The salary range provided is an estimate based on market research and industry standards. The actual salary offered may vary depending on the candidate's experience, skills, and negotiation.

🎯 Team & Company Context

🏢 Company Culture

Industry: Capgemini operates in the global business and technology transformation industry, helping organizations accelerate their digital and sustainable world transitions. They work with leading organizations across various sectors, including financial services, healthcare, retail, and public sector.

Company Size: Capgemini is a large, global organization with over 340,000 team members in more than 50 countries. This size allows for diverse career opportunities and exposure to various industries and technologies.

Founded: Capgemini was founded in 1967 and has since grown into a responsible and diverse group, trusted by its clients to unlock the value of technology and build a more sustainable, more inclusive world.

Team Structure:

  • The database administration team is part of Capgemini's Infrastructure Services division, working closely with other technical teams, such as application development, quality assurance, and project management.
  • The team consists of database administrators, database engineers, and database architects, each specializing in specific database technologies and environments.
  • The team follows a matrix organization structure, with team members reporting to both the database administration manager and the project or line manager, depending on the project they are working on.

Development Methodology:

  • Capgemini follows Agile and DevOps methodologies to deliver end-to-end services and solutions, focusing on continuous integration, continuous delivery, and continuous improvement.
  • The database administration team works closely with development and operations teams to ensure database environments are optimized for performance, scalability, and security.
  • Capgemini uses various tools and platforms to support its development methodologies, including Jira, Confluence, Jenkins, and Git.

Company Website: Capgemini

📝 Enhancement Note: Capgemini's large size and global presence offer database administrators the opportunity to work on diverse projects and gain exposure to various industries and technologies. The company's focus on digital transformation and sustainability provides a challenging and rewarding work environment.

📈 Career & Growth Analysis

Database Administrator Career Level: This role is at the mid-senior level, with a focus on managing and maintaining DB2 on z/OS environments. The ideal candidate will have 6 to 9 years of experience in database administration, with a strong background in DB2 on z/OS and related technologies.

Reporting Structure: The Database Administrator will report to the Database Administration Manager and work closely with other technical teams, such as application development, quality assurance, and project management.

Technical Impact: The Database Administrator will have a significant impact on the performance, availability, and security of DB2 on z/OS environments. They will work closely with other technical teams to ensure database environments are optimized for the applications and services they support.

Growth Opportunities:

  • Technical Specialization: Candidates can specialize in specific database technologies or environments, such as DB2 on Linux, Unix, or Windows, or cloud-based database environments.
  • Technical Leadership: With experience and strong performance, candidates can progress to technical lead or architecture roles, providing guidance and mentorship to other database administrators.
  • Project Management: Candidates can transition into project management roles, focusing on the delivery of database-related projects and initiatives.

📝 Enhancement Note: Capgemini's large size and diverse project portfolio provide ample opportunities for database administrators to specialize in specific technologies or environments, advance to technical leadership roles, or transition into project management.

🌐 Work Environment

Office Type: Capgemini's Bangalore office is a modern, collaborative workspace designed to foster innovation and creativity. The office features open-plan workspaces, meeting rooms, and breakout areas, as well as on-site amenities such as a cafeteria and recreational facilities.

Office Location(s): Capgemini's Bangalore office is located in the Prestige Tech Park, off the Outer Ring Road, providing easy access to public transportation and nearby amenities.

Workspace Context:

  • Collaborative Environment: The open-plan workspace encourages collaboration and knowledge-sharing among team members, with dedicated spaces for team meetings and brainstorming sessions.
  • Modern Infrastructure: The office is equipped with state-of-the-art infrastructure, including high-speed internet, powerful workstations, and large-format displays for presentations and workshops.
  • Flexible Work Arrangements: Capgemini offers flexible work arrangements, including remote work options and flexible hours, to support work-life balance.

Work Schedule: The standard work schedule is Monday to Friday, 9:00 AM to 6:00 PM IST, with occasional overtime required to support maintenance windows and critical projects. Capgemini offers flexible work arrangements, including remote work options and flexible hours, to support work-life balance.

📝 Enhancement Note: Capgemini's modern, collaborative work environment provides database administrators with the tools and resources they need to succeed, while also fostering a culture of innovation and creativity.

📄 Application & Technical Interview Process

Interview Process:

  1. Phone Screen: A brief phone or video call to discuss the candidate's experience, skills, and career goals. The interviewer may also ask technical questions to assess the candidate's knowledge of DB2 on z/OS and related technologies.
  2. Technical Assessment: A hands-on assessment to evaluate the candidate's technical skills, focusing on DB2 on z/OS administration, performance tuning, and disaster recovery. The assessment may include a combination of multiple-choice questions, true/false statements, and scenario-based questions.
  3. Behavioral Interview: A structured interview to assess the candidate's problem-solving skills, communication abilities, and cultural fit. The interviewer may use the STAR method (Situation, Task, Action, Result) to evaluate the candidate's responses.
  4. Final Interview: A meeting with the hiring manager or a panel of interviewers to discuss the candidate's technical skills, career goals, and fit within the team. The interviewer may also ask scenario-based questions to assess the candidate's ability to make strategic decisions in a real-world context.

Portfolio Review Tips:

  • Highlight projects that demonstrate the candidate's experience with DB2 on z/OS, including performance tuning, disaster recovery, and security projects.
  • Include before-and-after examples of performance tuning and disaster recovery projects to illustrate the candidate's impact in previous roles.
  • Provide detailed documentation of DB2 environment setup, including database schema, table structures, and indexes, as well as performance analysis reports and disaster recovery procedures.

Technical Challenge Preparation:

  • Brush up on DB2 on z/OS administration, performance tuning, and disaster recovery concepts, focusing on the latest best practices and industry trends.
  • Familiarize oneself with Capgemini's development methodologies, including Agile and DevOps, and be prepared to discuss how one's experience aligns with these methodologies.
  • Practice problem-solving and scenario-based questions, focusing on real-world examples and case studies.

ATS Keywords: [See the comprehensive list of ATS keywords at the end of this document]

📝 Enhancement Note: Capgemini's interview process is designed to evaluate the candidate's technical skills, problem-solving abilities, and cultural fit. Candidates should be prepared to discuss their experience with DB2 on z/OS and related technologies in detail, as well as their approach to performance tuning, disaster recovery, and security.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

  • DB2 on z/OS (primary technology)
  • DB2 on Linux, Unix, or Windows (secondary technologies)
  • Cloud-based database environments (e.g., AWS RDS, Azure SQL Database) (emerging technologies)

Infrastructure Tools:

  • SMP/E (mainframe software management and deployment tool)
  • REXX (mainframe programming language)
  • Assembler (low-level programming language for mainframe environments)
  • JCL (Job Control Language for mainframe environments)

Monitoring & Performance Tools:

  • DB2 Performance Monitor (DB2PM)
  • DB2 Health Checker (DB2HC)
  • DB2 Performance Analyzer (DB2PA)
  • DB2 Health Checker for z/OS (DB2HCZ)

📝 Enhancement Note: Capgemini's technology stack is focused on DB2 on z/OS, with experience in related technologies and emerging cloud-based database environments being a plus. Candidates should be comfortable working with mainframe-specific tools and languages, as well as modern monitoring and performance tools.

👥 Team Culture & Values

Database Administration Values:

  • Reliability: Ensuring high availability and minimal downtime for DB2 on z/OS environments
  • Performance: Optimizing database performance through query optimization, indexing, and hardware tuning
  • Security: Implementing and maintaining security best practices to protect data and prevent unauthorized access
  • Collaboration: Working closely with other technical teams to ensure database environments are optimized for the applications and services they support

Collaboration Style:

  • Cross-functional Collaboration: Database administrators work closely with application development, quality assurance, and project management teams to ensure database environments are optimized for the applications and services they support.
  • Knowledge Sharing: Database administrators share their expertise and best practices with other team members, fostering a culture of continuous learning and improvement.
  • Mentoring: Senior database administrators provide guidance and mentorship to junior team members, helping them develop their skills and advance their careers.

📝 Enhancement Note: Capgemini's database administration team values reliability, performance, security, and collaboration. Candidates should be comfortable working in a cross-functional environment and be willing to share their knowledge and expertise with other team members.

⚡ Challenges & Growth Opportunities

Technical Challenges:

  • Performance Tuning: Optimizing DB2 on z/OS environments for high performance and scalability, including query optimization, indexing, and hardware tuning.
  • Disaster Recovery: Developing and implementing disaster recovery strategies to minimize downtime and data loss in the event of a failure or outage.
  • Security Compliance: Ensuring security compliance in RACF/Top Secret/ACF2 environments, including access control, encryption, and auditing.
  • Mainframe Migration: Assisting with the migration of mainframe applications and databases to cloud-based environments, including the optimization of DB2 on z/OS for hybrid cloud deployments.

Learning & Development Opportunities:

  • Technical Training: Capgemini offers technical training and certification programs to help database administrators develop their skills and advance their careers.
  • Conferences & Events: Capgemini encourages database administrators to attend industry conferences and events to stay up-to-date with the latest best practices and trends in database administration.
  • Mentorship Programs: Capgemini offers mentorship programs to help database administrators develop their leadership and management skills.

📝 Enhancement Note: Capgemini's technical challenges and growth opportunities provide database administrators with the chance to develop their skills and advance their careers. Candidates should be proactive in seeking out learning and development opportunities and be willing to take on new challenges and responsibilities.

💡 Interview Preparation

Technical Questions:

  • DB2 on z/OS Administration: Describe the process of installing, upgrading, and maintaining DB2 on z/OS. What are the key considerations for managing DB2 subsystems in data sharing and non-data sharing environments?
  • Performance Tuning: How do you approach performance tuning for DB2 on z/OS environments? What tools and techniques do you use to identify and address performance bottlenecks?
  • Disaster Recovery: Walk us through your process for developing and implementing disaster recovery strategies for DB2 on z/OS environments. How do you ensure minimal downtime and data loss in the event of a failure or outage?
  • Security Compliance: How do you ensure security compliance in RACF/Top Secret/ACF2 environments? What are the key considerations for implementing and maintaining access control, encryption, and auditing?

Company & Culture Questions:

  • Capgemini's Approach to Digital Transformation: How do you see Capgemini's approach to digital transformation and sustainability in the context of the broader market? How can your experience and skills contribute to Capgemini's success in this area?
  • Agile Methodologies: How have you applied Agile methodologies in your previous roles? What are the key challenges and benefits of working in an Agile environment?
  • Collaboration & Teamwork: How do you approach collaboration and teamwork in a cross-functional environment? Can you provide an example of a successful cross-functional project you've worked on in the past?

Portfolio Presentation Strategy:

  • Live Demonstration: Prepare a live demonstration of your portfolio, focusing on projects that highlight your experience with DB2 on z/OS, performance tuning, disaster recovery, and security.
  • Case Studies: Develop detailed case studies of your most impactful projects, including before-and-after examples of performance tuning and disaster recovery.
  • Technical Deep Dive: Be prepared to discuss the technical details of your projects, including database schema, table structures, and indexes, as well as performance analysis reports and disaster recovery procedures.

📝 Enhancement Note: Capgemini's interview process is designed to evaluate the candidate's technical skills, problem-solving abilities, and cultural fit. Candidates should be prepared to discuss their experience with DB2 on z/OS and related technologies in detail, as well as their approach to performance tuning, disaster recovery, and security.

📌 Application Steps

To apply for this database administrator position at Capgemini:

  1. Submit Your Application: Visit the Capgemini careers website and submit your application through the application link provided.
  2. Tailor Your Resume: Highlight your experience with DB2 on z/OS, performance tuning, disaster recovery, and security in your resume. Include specific examples of your impact in previous roles and be sure to include relevant keywords to optimize your resume for applicant tracking systems (ATS).
  3. Prepare Your Portfolio: Focus on projects that demonstrate your experience with DB2 on z/OS, performance tuning, disaster recovery, and security. Include before-and-after examples of performance tuning and disaster recovery projects to illustrate your impact in previous roles.
  4. Research Capgemini: Familiarize yourself with Capgemini's approach to digital transformation and sustainability, as well as their development methodologies, including Agile and DevOps. Be prepared to discuss how your experience and skills align with Capgemini's goals and values.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and database administration industry-standard assumptions. All details should be verified directly with Capgemini before making application decisions.

ATS Keywords:

Programming Languages:

  • REXX
  • Assembler
  • JCL
  • SQL
  • PL/I
  • COBOL

Database Technologies:

  • DB2 on z/OS (primary technology)
  • DB2 on Linux, Unix, or Windows (secondary technologies)
  • Cloud-based database environments (e.g., AWS RDS, Azure SQL Database) (emerging technologies)

Infrastructure Tools:

  • SMP/E (mainframe software management and deployment tool)
  • DB2 Performance Monitor (DB2PM)
  • DB2 Health Checker (DB2HC)
  • DB2 Performance Analyzer (DB2PA)
  • DB2 Health Checker for z/OS (DB2HCZ)

Methodologies & Frameworks:

  • Agile
  • DevOps
  • ITIL
  • COBIT

Soft Skills:

  • Problem-solving
  • Communication
  • Collaboration
  • Leadership
  • Mentoring
  • Adaptability
  • Continuous learning

Industry Terms:

  • Mainframe
  • z/OS
  • RACF
  • Top Secret
  • ACF2
  • Disaster Recovery
  • Backup
  • Restore
  • Performance Tuning
  • Query Optimization
  • CPU Utilization Analysis
  • Security Compliance
  • Access Control
  • Encryption
  • Auditing
  • Hybrid Cloud
  • Digital Transformation
  • Sustainability

Application Requirements

Candidates should have strong knowledge of DB2 on z/OS and experience with DB2 utilities and tools. Proficiency in performance tuning and familiarity with REXX, Assembler, and JCL is also required.