Company Profile:
At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.
This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.
Job Title: Senior Mainframe (MF) DB2 Technician
Category: Mainframe Technician
Location: Bengaluru
Position ID: J0626-2082
Employment Type: Full Time
Experience Required: 8+ Years
Job Summary
We are seeking an experienced Senior Mainframe DB2 Technician to join our Mainframe Infrastructure and Database Services team. The successful candidate will be responsible for the administration, maintenance, monitoring, performance tuning, and operational support of IBM Db2 for z/OS environments supporting mission critical business applications.
The ideal candidate will possess deep technical expertise in Mainframe technologies, strong problem solving capabilities, and a proven track record of managing enterprise scale DB2 environments. This role requires close collaboration with application development teams, infrastructure teams, security teams, and business stakeholders to ensure high availability, optimal performance, and regulatory compliance.
Key Responsibilities
DB2 Administration and Support
. Administer and support IBM Db2 for z/OS databases in production, test, and development environments.
. Perform database creation, modification, maintenance, and lifecycle management activities.
. Manage DB2 subsystems, buffer pools, storage groups, tablespaces, indexes, and database objects.
. Support DB2 installations, upgrades, migrations, and maintenance activities.
Production Support
. Provide Level 2 and Level 3 support for DB2 related incidents and service requests.
. Troubleshoot complex database issues and restore services within agreed SLA targets.
. Participate in major incident management activities and provide technical expertise during critical situations.
. Conduct root cause analysis and implement corrective actions to prevent recurrence.
Performance Monitoring and Optimization
. Monitor database health, performance, and capacity utilization.
. Analyze SQL performance and recommend optimization strategies.
. Perform database tuning activities involving buffer pools, access paths, indexes, and system resources.
. Support workload management and capacity planning initiatives.
Backup, Recovery, and Disaster Recovery
. Manage database backup and recovery processes.
. Execute recovery procedures during incidents and planned testing activities.
. Support disaster recovery planning, testing, and execution.
. Ensure data integrity and business continuity requirements are met.
Security and Compliance
. Implement and maintain DB2 security controls and access management policies.
. Support audit, regulatory, and compliance requirements.
. Ensure adherence to organizational security standards and best practices.
. Monitor database access and investigate security related events.
Change and Release Management
. Implement approved changes in accordance with change management processes.
. Support application deployments and releases involving database modifications.
. Perform impact assessments and validation testing for database changes.
. Maintain accurate documentation for all database related changes.
Automation and Continuous Improvement
. Identify opportunities to automate routine database administration tasks.
. Develop and maintain operational procedures and support documentation.
. Contribute to process improvement and operational excellence initiatives.
. Participate in modernization and transformation programs involving Mainframe technologies.
Collaboration and Leadership
. Collaborate with application development, infrastructure, middleware, and security teams.
. Provide technical mentoring and knowledge sharing to junior team members.
. Participate in architecture discussions and technology roadmap planning.
. Support cross functional projects and enterprise initiatives.
Required Qualifications
. Bachelor's degree in computer science, Information Technology, Engineering, or a related discipline.
. Minimum 5–10 years of experience supporting IBM Db2 for z/OS environments.
. Experience working within large scale enterprise Mainframe environments.
Required Technical Skills
Mainframe Technologies
. IBM z/OS
. JCL (Job Control Language)
. TSO/ISPF
. SDSF
. JES2/JES3
. Mainframe Operations
Database Technologies
. IBM Db2 for z/OS
. Database Design and Administration
. SQL Development and Optimization
. Database Performance Tuning
. Backup and Recovery
. Capacity Planning
. Data Integrity Management
Supporting Technologies
. IBM Utilities and Tools
. Change Management Tools
. Monitoring and Performance Management Tools
. Scheduling and Automation Tools
Preferred Qualifications
. IBM Db2 for z/OS Certification.
. ITIL Foundation Certification.
. Experience with: IBM IMS IBM CICS IBM MQ RACF Security Administration Mainframe Automation Tools
. Experience supporting High Availability and Disaster Recovery environments.
Key Competencies
. Advanced analytical and troubleshooting skills.
. Strong understanding of enterprise database administration practices.
. Excellent verbal and written communication skills.
. Ability to manage multiple priorities in a fast paced environment.
. Strong customer and stakeholder management skills.
. Commitment to operational excellence and continuous improvement.
. Leadership and mentoring capabilities.
Working Conditions
. Participation in an on call support rotation may be required.
. Ability to support planned maintenance activities outside standard business hours.
. Support of global business operations across multiple time zones.
Success Measures
Success in this role will be measured through:
. DB2 system availability and reliability.
. Incident resolution effectiveness and SLA adherence.
. Database performance and optimization outcomes.
. Successful execution of upgrades, maintenance, and change activities.
. Compliance with security, audit, and regulatory requirements.
. Reduction in recurring incidents through proactive problem management.
. Positive stakeholder and customer feedback.
Your future duties and responsibilities
Required qualifications to be successful in this role
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
Come join our team—one of the largest IT and business consulting services firms in the world.
