Job Description

Introduction
As an Engineer, your technical skills should be complemented by exceptional communication skills, translating technical requirements in well-established S/W Engg. ways for all to understand as well as be knowledgeable about the latest industry trends.
Your role and responsibilities
Required Professional and Technical Expertise: As a DB2 DBA, you will be focused on managing and optimizing IBM DB2 databases, including tasks like installation, configuration, maintenance, performance tuning, backup/recovery, security, and collaboration with application development teams. Additionally, you'll provide technical consulting in defining, designing, and creating DB2 database environments, reviewing DB2 project requests and estimates, and administering DB2 database organisations, standards, controls, procedures, and documentation. Maintain DB2 dictionaries and objects using SQL, Perl, shell scripts, and batch processes.
To categorise the set of activities:

• Installation and Configuration: Install, configure, and upgrade DB2 databases, including LUW (Linux/Unix/Windows) versions.
• Performance Tuning and Optimisation: Monitor database performance, identify bottlenecks, and implement performance tuning strategies using tools like db2top
• Backup/Recovery, Replication and Migration: Implement and manage robust backup and recovery procedures, including RTO (Recovery Time Objective) and RPO (Recovery Point Objective) considerations, while supporting data replication and migration between different DB2 environments
• SQL Development and Optimisation: Collaborate with developers to optimise SQL queries, create stored procedures, and ensure data integrity.
• High Availability and Disaster Recovery: Participate in HA and DR planning and testing, from inception to design and implementation, to ensure business continuity and data availability.
• Monitoring and Troubleshooting: Monitor database health, identify and resolve performance issues, and troubleshoot connectivity problems
• Security: Implement and manage database security measures, including user access control, auditing, and data encryption.
• Data Replication and Migration: Migration between different engines, or between different versions of DB2, as well as data restoration, maintenance and migration.
• Documentation and Procedures: Document database configurations, procedures, and troubleshooting steps with application development teams, system admins, and others.

Required education
Bachelor's Degree
Preferred education
Master's Degree
Required technical and professional expertise
Required Skills and Experience:

• DB2 Expertise: Extensive experience with DB2 LUW and/or z/OS DB administration
• SQL: Strong proficiency in SQL and stored procedures
• Operating Systems: Knowledge of Linux/Unix/Windows and similar
• Database Design: Understanding of database design principles and best practices
• Scripting: Experience with scripting languages like Bash, Python, or PowerShell for automation.
• Monitoring Tools: Familiarity with monitoring tools like db2top, IBM Data Server Manager
• Backup and Recovery Tools: Experience with DB2 backup and recovery utilities
• Problem Solving: Strong analytical and problem-solving skills for troubleshooting database issues.
• Communication: Excellent communication and collaboration skills

ABOUT BUSINESS UNIT
IBM Software infuses core business operations with intelligence-from machine learning to generative AI-to help make organizations more responsive, productive, and resilient. IBM Software helps clients put AI into action now to create real value with trust, speed, and confidence across digital labor, IT automation, application modernization, security, and sustainability. Critical to this is the ability to make use of all data, because AI is only as good as the data that fuels it. In most organizations data is spread across multiple clouds, on premises, in private datacenters, and at the edge. IBM's AI and data platform scales and accelerates the impact of AI with trusted data, and provides leading capabilities to train, tune and deploy AI across business. IBM's hybrid cloud platform is one of the most comprehensive and consistent approach to development, security, and operations across hybrid environments-a flexible foundation for leveraging data, wherever it resides, to extend AI deep into a business.
YOUR LIFE @ IBM
In a world where technology never stands still, we understand that, dedication to our clients success, innovation that matters, and trust and personal responsibility in all our relationships, lives in what we do as IBMers as we strive to be the catalyst that makes the world work better.
Being an IBMer means you'll be able to learn and develop yourself and your career, you'll be encouraged to be courageous and experiment everyday, all whilst having continuous trust and support in an environment where everyone can thrive whatever their personal or professional background.
Our IBMers are growth minded, always staying curious, open to feedback and learning new information and skills to constantly transform themselves and our company. They are trusted to provide on-going feedback to help other IBMers grow, as well as collaborate with colleagues keeping in mind a team focused approach to include different perspectives to drive exceptional outcomes for our customers. The courage our IBMers have to make critical decisions everyday is essential to IBM becoming the catalyst for progress, always embracing challenges with resources they have to hand, a can-do attitude and always striving for an outcome focused approach within everything that they do.
Are you ready to be an IBMer?
ABOUT IBM
IBM's greatest invention is the IBMer. We believe that through the application of intelligence, reason and science, we can improve business, society and the human condition, bringing the power of an open hybrid cloud and AI strategy to life for our clients and partners around the world.
Restlessly reinventing since 1911, we are not only one of the largest corporate organizations in the world, we're also one of the biggest technology and consulting employers, with many of the Fortune 50 companies relying on the IBM Cloud to run their business.
At IBM, we pride ourselves on being an early adopter of artificial intelligence, quantum computing and blockchain. Now it's time for you to join us on our journey to being a responsible technology innovator and a force for good in the world.
IBM is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, caste, genetics, pregnancy, disability, neurodivergence, age, veteran status, or other characteristics. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
OTHER RELEVANT JOB DETAILS
When applying to jobs of your interest, we recommend that you do so for those that match your experience and expertise. Our recruiters advise that you apply to not more than 3 roles in a year for the best candidate experience. For additional information about location requirements, please discuss with the recruiter following submission of your application.
Job Title
Data Administrator
Job ID
36897
City / Township / Village
Ahmedabad
State / Province
Gujarat
Country
India
Work arrangement
Hybrid
Area of work
Software Engineering
Employment type
Regular
Position type
Professional
Travel required
No Travel
Company
(0063) IBM India Private Limited
Shift
General (daytime)
Is this role a commissionable/sales incentive based position?
No