📍 Job Overview

Job Title: TERADATA DBA (Database Administrator/Lead)
Company: Capgemini
Location: Pune, Maharashtra, India
Job Type: On-site
Category: Database Administrator
Date Posted: June 30, 2025
Experience Level: 5-10 years
Remote Status: On-site

🚀 Role Summary

Lead the management and administration of Teradata databases, ensuring optimal performance and data security.
Collaborate with cross-functional teams to implement data-driven solutions and improve system efficiency.
Mentor junior team members and contribute to the development of best practices for database administration.
Contribute to the modernization of database infrastructure, migrating from VantageCloud Enterprise to VantageCloud Lake.

📝 Enhancement Note: This role requires a strong understanding of Teradata architecture, including PDE (Parallel Database Extensions), and experience leading on-call support teams.

💻 Primary Responsibilities

Database Management: Create and manage users, roles, and databases within the Teradata environment, including granting and revoking permissions.
Security & Access Control: Implement and enforce security policies, manage user access, and protect sensitive data.
Performance Tuning: Monitor system performance, identify bottlenecks, and optimize queries and system configuration for optimal performance.
Backup & Recovery: Implement and manage backup and recovery procedures to protect data from loss or corruption.
Data Loading & Administration: Utilize Teradata utilities like BTEQ, FastLoad, and TPump for data loading, unloading, and other administrative tasks.
Incident Handling: Lead incident response and follow-up, ensuring minimal impact on business operations.
Workload Tuning & Optimization: Utilize TASM (Teradata Active System Management) for workload tuning and SQL optimization, contributing to System Improvement Plans.

📝 Enhancement Note: This role involves a significant amount of incident handling and on-call support, requiring strong problem-solving skills and the ability to work under pressure.

🎓 Skills & Qualifications

Education: Bachelor's degree in Computer Science, Information Technology, or a related field.

Experience: 4-12 years of experience in Teradata DBA roles, with a focus on SQL, scripting (Python), and Datastage. Familiarity with Agile methodologies and Gitlab/Github is also required.

Required Skills:

Proven experience in Teradata DBA roles, with a strong focus on database configuration and DDL operations.
Expertise in SQL and scripting languages, with a solid understanding of Teradata-specific SQL extensions.
Experience with incident handling and non-automated access requests.
Strong monitoring and workload tuning skills, with experience using TASM and optimizing SQL queries.
Familiarity with backup and recovery procedures, and experience with modernizing database infrastructure.
Ability to work in a 24/7 on-call rotation, with a commitment to working 5 days from the On-Demand Center (ODC) in Hinjewadi, Pune.

Preferred Skills:

Experience with VantageCloud Lake and its migration process from VantageCloud Enterprise.
Familiarity with data security best practices and compliance standards.
Strong leadership skills and experience mentoring junior team members.
Knowledge of data modeling and data warehousing concepts.

📝 Enhancement Note: While not explicitly stated, experience with data modeling and data warehousing concepts would be beneficial for this role, as they are essential for understanding and optimizing database structures and performance.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

A comprehensive portfolio showcasing your experience with Teradata DBA tasks, including configuration and DDL operations.
Examples of incident handling and access request management, demonstrating your problem-solving skills and attention to detail.
Case studies or projects demonstrating your experience with workload tuning, SQL optimization, and system improvement plans.
Documentation of your experience with backup and recovery procedures, and any involvement in database modernization projects.

Technical Documentation:

Detailed documentation of your experience with Teradata utilities, including BTEQ, FastLoad, and TPump.
Examples of your SQL queries and scripts, demonstrating your proficiency in SQL and scripting languages.
Documentation of your experience with TASM and other Teradata-specific tools and utilities.
Case studies or projects demonstrating your understanding of data security best practices and compliance standards.

📝 Enhancement Note: As this role involves leading on-call support, it is essential to highlight your experience with incident handling and problem-solving in your portfolio and technical documentation.

💵 Compensation & Benefits

Salary Range: INR 1,500,000 - 2,500,000 per annum (Based on experience and market standards for Teradata DBA roles in Pune, Maharashtra)

Benefits:

Competitive salary and performance-based bonuses.
Comprehensive health insurance and retirement plans.
Opportunities for professional development and career growth within Capgemini's global organization.
A diverse and inclusive work environment that values collaboration and innovation.

Working Hours: Full-time (40 hours/week), with a commitment to working 5 days from the On-Demand Center (ODC) in Hinjewadi, Pune, as part of a 24/7 on-call rotation.

📝 Enhancement Note: The salary range provided is an estimate based on market research for Teradata DBA roles in Pune, Maharashtra. Actual compensation may vary depending on the candidate's experience and skills.

🎯 Team & Company Context

🏢 Company Culture

Industry: Capgemini is a global leader in consulting, technology services, and digital transformation, with a strong focus on data and analytics, cloud, and infrastructure services.

Company Size: Capgemini employs over 340,000 team members across more than 50 countries, providing a large and diverse pool of resources and expertise.

Founded: Capgemini was founded in 1967 and has since grown to become one of the world's leading technology and business transformation partners.

Team Structure: The Teradata DBA team at Capgemini is part of the broader Data & Analytics practice, working closely with data engineers, data scientists, and other technology professionals to deliver innovative solutions to clients. The team is structured to provide 24/7 support and maintenance, with on-call rotations and dedicated support personnel.

Development Methodology: Capgemini follows Agile methodologies for software development and project management, with a focus on iterative development, continuous improvement, and collaboration.

Company Website: Capgemini

📝 Enhancement Note: Capgemini's global presence and diverse team structure provide ample opportunities for career growth and professional development within the organization.

📈 Career & Growth Analysis

Teradata DBA Career Level: This role is a senior-level position, requiring a deep understanding of Teradata architecture and extensive experience in database administration and management. The role involves leading on-call support and contributing to the development of best practices for database administration.

Reporting Structure: The Teradata DBA will report directly to the Data & Analytics Practice Lead and work closely with other technology professionals, including data engineers, data scientists, and software developers.

Technical Impact: The Teradata DBA will play a critical role in ensuring the performance, security, and availability of Capgemini's clients' databases, contributing to the overall success of their data and analytics initiatives.

Growth Opportunities:

Technical Specialization: Deepen your expertise in Teradata administration and related technologies, such as data warehousing, data modeling, and data security.
Leadership & Mentoring: Mentor junior team members and contribute to the development of best practices for database administration, with opportunities to lead and manage teams.
Architecture & Consulting: Transition into architecture or consulting roles, providing strategic guidance and expertise to Capgemini's clients on data and analytics initiatives.

📝 Enhancement Note: Capgemini's strong focus on career progression and professional development provides numerous opportunities for growth and advancement within the organization.

🌐 Work Environment

Office Type: Capgemini's Pune office is a modern, collaborative workspace designed to foster innovation and teamwork. The office features state-of-the-art technology, comfortable workspaces, and a range of amenities to support employee well-being and productivity.

Office Location(s): Capgemini's Pune office is located in Hinjewadi, a major IT hub in the city, with easy access to public transportation and nearby amenities.

Workspace Context:

Collaboration: The office features open-plan workspaces, encouraging collaboration and communication among team members.
Technology & Tools: Capgemini provides state-of-the-art technology and tools to support its team members' work, including high-speed internet, multiple monitors, and access to relevant software and applications.
Flexibility: The office offers flexible work arrangements, with opportunities to work remotely or from alternative workspaces, such as co-working spaces or client sites.

Work Schedule: The Teradata DBA role requires a commitment to working 5 days from the On-Demand Center (ODC) in Hinjewadi, Pune, as part of a 24/7 on-call rotation. The role involves regular working hours (40 hours/week), with the potential for additional hours during peak periods or incidents.

📝 Enhancement Note: Capgemini's flexible work arrangements and commitment to employee well-being make it an attractive workplace for technology professionals seeking a balance between work and personal life.

📄 Application & Technical Interview Process

Interview Process:

Phone Screen: A brief phone call to discuss your experience and qualifications for the role, as well as your availability for on-site interviews.
On-Site Interview: A series of face-to-face interviews with members of the Data & Analytics practice, including technical assessments and behavioral questions.
Final Interview: A final interview with the Data & Analytics Practice Lead to discuss your fit for the role and the team's long-term goals.

Portfolio Review Tips:

Highlight your experience with Teradata DBA tasks, including configuration and DDL operations.
Demonstrate your problem-solving skills and attention to detail through examples of incident handling and access request management.
Showcase your understanding of workload tuning, SQL optimization, and system improvement plans through case studies or projects.
Emphasize your experience with backup and recovery procedures and any involvement in database modernization projects.

Technical Challenge Preparation:

Brush up on your SQL skills, with a focus on Teradata-specific SQL extensions and optimization techniques.
Familiarize yourself with Teradata utilities, such as BTEQ, FastLoad, and TPump, and be prepared to discuss their usage in administrative tasks.
Review your experience with TASM and other Teradata-specific tools and utilities, and be prepared to discuss their application in workload tuning and performance optimization.

ATS Keywords: [Provided in the "Key Skills" section above]

📝 Enhancement Note: Capgemini's interview process is designed to assess your technical skills and cultural fit for the role and the team. Be prepared to discuss your experience with Teradata DBA tasks and your approach to problem-solving and incident handling.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

Teradata: Expertise in Teradata database administration and management, including configuration, DDL operations, and performance tuning.
SQL: Proficiency in SQL and Teradata-specific SQL extensions, with a strong understanding of SQL optimization techniques.
Data Modeling & Warehousing: Familiarity with data modeling and data warehousing concepts, and experience designing and optimizing database structures.

Infrastructure Tools:

Datastage: Experience with Datastage, a data integration and transformation tool used for ETL (Extract, Transform, Load) processes.
Gitlab/Github: Familiarity with version control systems and collaborative development practices, with experience using Gitlab or Github.
Agile Methodologies: Experience working in Agile environments, with a strong understanding of Agile principles and practices.

📝 Enhancement Note: This role requires a strong understanding of Teradata architecture and extensive experience in database administration and management. Familiarity with related technologies, such as data modeling, data warehousing, and version control systems, is also beneficial.

👥 Team Culture & Values

Capgemini Values:

Collaboration: Capgemini fosters a culture of collaboration and teamwork, with a strong emphasis on cross-functional collaboration and knowledge sharing.
Innovation: Capgemini encourages innovation and continuous learning, providing opportunities for professional development and growth.
Respect: Capgemini values diversity and inclusion, fostering a respectful and inclusive work environment that celebrates individual differences and perspectives.
Integrity: Capgemini is committed to acting with integrity and ethical conduct in all aspects of its business, upholding the highest standards of professionalism and responsibility.

Team Culture:

Technical Expertise: The Teradata DBA team at Capgemini is composed of highly skilled and experienced professionals, with a strong focus on technical excellence and continuous learning.
Mentoring & Knowledge Sharing: The team encourages mentoring and knowledge sharing, with opportunities to learn from and collaborate with experienced team members.
Work-Life Balance: Capgemini is committed to supporting the well-being of its team members, offering flexible work arrangements and a range of benefits to support work-life balance.

📝 Enhancement Note: Capgemini's strong focus on collaboration, innovation, and professional development makes it an attractive workplace for technology professionals seeking a challenging and rewarding career in a dynamic and inclusive environment.

⚡ Challenges & Growth Opportunities

Technical Challenges:

Performance Tuning: Optimize Teradata database performance, identifying and addressing bottlenecks and inefficiencies in SQL queries and system configuration.
Incident Handling: Lead incident response and follow-up, ensuring minimal impact on business operations and maintaining high levels of system availability and reliability.
Database Modernization: Contribute to the modernization of database infrastructure, migrating from VantageCloud Enterprise to VantageCloud Lake and ensuring the smooth transition of data and applications.
Data Security: Implement and enforce security policies, managing user access, and protecting sensitive data from unauthorized access or misuse.

Learning & Development Opportunities:

Technical Skills: Deepen your expertise in Teradata administration and related technologies, such as data warehousing, data modeling, and data security.
Leadership & Mentoring: Mentor junior team members and contribute to the development of best practices for database administration, with opportunities to lead and manage teams.
Architecture & Consulting: Transition into architecture or consulting roles, providing strategic guidance and expertise to Capgemini's clients on data and analytics initiatives.

📝 Enhancement Note: Capgemini's diverse and challenging workload provides ample opportunities for technical growth and professional development, with a strong focus on collaboration, innovation, and continuous learning.

💡 Interview Preparation

Technical Questions:

Teradata Architecture: Demonstrate your understanding of Teradata architecture, including PDE (Parallel Database Extensions) and its components.
SQL Optimization: Explain your approach to SQL optimization and performance tuning, with examples of complex SQL queries and optimization techniques.
Incident Handling: Describe your experience with incident handling and problem-solving, with a focus on Teradata-specific challenges and best practices.
Backup & Recovery: Discuss your experience with backup and recovery procedures, and your approach to ensuring the availability and integrity of critical data.

Company & Culture Questions:

Capgemini Values: Explain how you align with Capgemini's values, including collaboration, innovation, respect, and integrity.
Team Dynamics: Describe your experience working in a team environment and your approach to collaboration and knowledge sharing.
Professional Development: Discuss your long-term career goals and how you plan to continue growing and developing your skills within Capgemini.

Portfolio Presentation Strategy:

Technical Walkthrough: Provide a detailed walkthrough of your portfolio, highlighting your experience with Teradata DBA tasks, incident handling, and performance tuning.
Case Studies: Present case studies or projects demonstrating your understanding of workload tuning, SQL optimization, and system improvement plans.
Best Practices: Discuss your approach to database administration and management, including your experience with backup and recovery procedures and data security best practices.

📝 Enhancement Note: Capgemini's interview process is designed to assess your technical skills and cultural fit for the role and the team. Be prepared to discuss your experience with Teradata DBA tasks and your approach to problem-solving and incident handling.

📌 Application Steps

To apply for this Teradata DBA (Database Administrator/Lead) position at Capgemini:

Submit your application through the application link provided in the job listing.
Customize your portfolio to highlight your experience with Teradata DBA tasks, incident handling, and performance tuning, with a focus on live demos and responsive examples.
Optimize your resume for web technology roles, emphasizing your project highlights and technical skills, with a focus on Teradata-specific keywords and industry-relevant terminology.
Prepare for the technical interview by reviewing your experience with Teradata utilities, SQL optimization techniques, and incident handling best practices.
Research Capgemini's web technology focus and user experience understanding, ensuring a strong fit for the role and the team's long-term goals.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and web technology industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.

TERADATA DBA (Database Administrator/Lead)