**Job Title** : DBA Manager **Location** :Los Angeles, USA **Travel** :25% **Job description:** 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. Education: Bachelor’s degree in Computer Science, Information Technology, or a related field. Experience: Minimum of 3-5 years of experience in DB2 database administration and AS400 systems. **Key Responsibilities:** Performance Tuning and Optimization Continuously analyze and improve system and database performance. Monitor active jobs and identify long-running or resource-intensive queries, then optimize their SQL by working with Application Team. Pinpoint on queries which needs Indexes and Assist application team with Index creation for better Query performance. Proactive System Diagnostics Perform in-depth diagnostics to prevent system disruptions. Use tools like iDoctor to analyze real-time data about CPU, disk, memory, and job performance, identifying underperforming resources. Database Monitoring and Maintenance Monitor database health and take corrective action to ensure stability. Monitor job activity collects detailed metrics like CPU, memory, and I/O usage. Assist in pinpointing inefficient queries and database locks. Setup and Review SQL Plan Cache Ensure that frequently performed queries benefit from reusable execution plans. Diagnose and resolve performance problems caused by inefficient execution plans. Performance Data Collection and Reporting Gather performance metrics and deliver actionable insights. Schedule regular performance data collection and present findings to Application Teams, Admin Teams and provide recommendations for memory upgrades or workload redistribution. Capacity structuring Use historical and predictive data to plan for future growth. Generate forecasts to anticipate storage needs based on usage trends over the last 12 months. Incident Solve Work on Role based access controls for schemas across the Database.Protect sensitive data. Ensure database operations stay in sync with security requirements. **Required Skills:** Quickly diagnose and resolve performance issues. Perform root cause analysis on a sudden spike in CPU, Response Time and pinpoint application-level issue. Database and System Performance Audits Conduct audits to ensure optimal system performance and compliance. Conduct a detailed CPU utilization audit, ensuring the system meets performance standards. Security Administration **Desired Skills:** Proficiency in DB2 database administration. Strong knowledge of AS400 system administration. Experience with database performance tuning and optimization. Familiarity with backup and recovery processes. Excellent problem-solving skills. Good communication and documentation skills. **Life at Capgemini** Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: + Flexible work + Healthcare including dental, vision, mental health, and well-being programs + Financial well-being programs such as 401(k) and Employee Share Ownership Plan + Paid time off and paid holidays + Paid parental leave + Family building benefits like adoption assistance, surrogacy, and cryopreservation + Social well-being benefits like subsidized back-up child/elder care and tutoring + Mentoring, coaching and learning programs + Employee Resource Groups + Disaster Relief **About Capgemini** Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions using strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion. Get The Future You Want | www.capgemini.com **Disclaimer** Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law. This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship. Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please get in touch with your recruiting contact. Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process. Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini. **Job:** _Infrastructure_ **Organization:** _CIS US MS_ **Title:** _DBA Manager_ **Location:** _CA-Los Angeles_ **Requisition ID:** _077767_