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 workHealthcare including dental, vision, mental health, and well-being programsFinancial well-being programs such as 401(k) and Employee Share Ownership PlanPaid time off and paid holidaysPaid parental leaveFamily building benefits like adoption assistance, surrogacy, and cryopreservationSocial well-being benefits like subsidized back-up child/elder care and tutoringMentoring, coaching and learning programsEmployee Resource GroupsDisaster ReliefAbout 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 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 workHealthcare including dental, vision, mental health, and well-being programsFinancial well-being programs such as 401(k) and Employee Share Ownership PlanPaid time off and paid holidaysPaid parental leaveFamily building benefits like adoption assistance, surrogacy, and cryopreservationSocial well-being benefits like subsidized back-up child/elder care and tutoringMentoring, coaching and learning programsEmployee Resource GroupsDisaster ReliefAbout 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.
Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority,performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $75,582 to $170,040..This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.