Senior Mainframe (MF) DB2 Technician

Position Description:

Company Profile:

At CGI were a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72000 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 were a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72000 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 .
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

. Bachelors degree in computer science Information Technology Engineering or a related discipline.
. Minimum 510 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.

Skills:

• English
• Linux
• Windows
• IBM MQ
• JCL

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll 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.

Youll shape your career by joining a company built to grow and last. Youll 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 teamone of the largest IT and business consulting services firms in the world.