DB2 Database Administrator

7 days ago

Bengaluru, Karnataka, India Kyndryl Full time

Who We AreAt Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day.

So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.

The RoleAn excellent opportunity for the right candidate. You will be exposed to exciting challenges and outstanding development opportunities within Kyndryl.
You will gain end-to-end execution technical knowledge,

get hands on experience in implementing end to end solutions for customers

, operational skills as well as industry best practices. Furthermore, you will work in a multi-cultural environment and engage with multiple internal and external stakeholders which will greatly enhance your communication, presentation and people skills.

Role and Responsibilities of the Job:

Installation and configuration:
Installing DB2 database software on the target environment and configuring it according to the organization's requirements

Database creation and management:
Creating and managing DB2 databases, including defining database schemas, tables, indexes, and other database objects

User management:
Creating and managing user accounts, roles, and permissions within DB2 to control access and security

Backup and recovery:
Implementing backup strategies for DB2 databases, performing regular backups, and ensuring the ability to restore databases in case of failures or data loss

Basic troubleshooting:
Identifying and resolving basic issues related to DB2 database operations, such as connectivity problems, performance issues, or data integrity concerns

SQL scripting:
Writing and executing SQL scripts to perform data manipulation, database administration tasks, and generate reports

Performance monitoring:
Monitoring database performance metrics, such as query response times, resource utilization, and transaction throughput, and reporting any anomalies or performance bottlenecks

Log analysis:
Reviewing and analyzing database logs to identify errors, warnings, or other issues that may affect the database operation or performance

Patch and fix management:
Applying patches, updates, and fixes to DB2 software as required to maintain security and stability

Database security:
Implementing security measures for DB2, including user authentication, authorization, and encryption of sensitive data

Database monitoring tools:
Configuring and utilizing monitoring tools for DB2 databases to track performance, diagnose issues, and generate alerts

Data integrity and recovery:
Ensuring data integrity and implementing recovery procedures in case of database corruption or data loss

Database optimization:
Analyzing query execution plans, identifying performance bottlenecks, and making recommendations for optimizing SQL queries and database performance

Database monitoring and alerting:
Setting up monitoring solutions to track database health, performance metrics, and disk space utilization. Configuring alerts to notify administrators of critical events or threshold breaches.

Database replication:
Configuring and managing database replication mechanisms, such as IBM's High Availability

Disaster Recovery (HADR)

, to ensure data redundancy, failover capabilities, and disaster recovery

Database version upgrades:
Planning and executing database version upgrades, including assessing compatibility, performing testing, and ensuring a smooth transition to the new version

Database security audits and compliance:
Conducting security audits, vulnerability assessments, and ensuring compliance with industry regulations and organizational security policies.
Performance tuning and query optimization
:
Collaborating with application developers and database performance teams to identify and resolve complex performance issues, optimize SQL queries, and improve overall database performance

Disaster recovery planning and testing:
Participating in the development and testing of disaster recovery plans for DB2 databases, including failover, backup, and recovery procedures

Troubleshooting and incident management:
Investigating and resolving database-related incidents, analyzing error messages, and providing timely resolution or escalation to higher-level support teams

Data migration and data loading:
Assisting with data migration tasks, such as importing/exporting data, transforming data formats, and loading data into DB2 databases

Database performance reporting:
Generating performance reports, capacity utilization reports, and other database-related metrics for management and stakeholders

Collaboration and knowledge sharing:
Collaborating with cross-functional teams, developers, and system administrators to troubleshoot issues, share best practices, and provide support and guidance

Data archival and purging:
Implementing strategies for archiving and purging old or unused data to optimize database storage and improve query performance

Database security hardening:
Applying security best practices and implementing security measures to harden the DB2 database environment against potential vulnerabilities and unauthorized access

Replication monitoring and troubleshooting:
Monitoring the status and health of database replication mechanisms, diagnosing and resolving replication issues, and ensuring data consistency across replicas

Database health checks:
Performing regular health checks to identify potential issues, such as database fragmentation or index fragmentation, and taking appropriate actions to optimize database performance

Disaster recovery drills:
Participating in disaster recovery drills to test the effectiveness of backup and recovery procedures and ensure the readiness of the DB2 environment in case of a disaster

Database auditing:
I

mplementing auditing mechanisms to track and log database activities, ensuring compliance with regulatory requirements and internal policies:
Proactively understand the latest information of database platform services.
  • Good operational experience of data administration, with data analyst and data science exposure.
  • Support database migration and deploy to its platform.
  • Manage platform changes through change request process & provide status reports to the relevant parties.
  • Respond promptly to incident, investigate & provide temporary &/or permanent resolution of incidents escalated. Provide timely status updates to relevant parties.
  • Monitor & measure the performance & availability of platform proactively, and implement corrective actions identified to improve performance & availability.
  • Monitor the agreed service level, document & maintain the configuration of platform; provide regular reporting to relevant parties.
  • Ensure service level meet requirement. Propose and implement action plan when required.
  • Monitor system according to standard operations procedures.
  • Support platform service continuity measures, i.e., backup/restore procedures & disaster recovery plan, to ensure continuous operation of the business.
  • Conduct root cause analysis & implement pro-active measures. Monitor effectiveness of implemented measures.
Provide 24x7 onsite Support.
Database server administration (DB2, ) and team management.
Good communication skills, Need to participate in client meetings.
Handle regular day to day IT Infra operations.
Break fixing of H/W and S/W issues .Working on Service Desk tickets.
Coordinating with IT stake holders to fix the issues.
Participate in internal/external audits to showcase the IT compliance status.
Perform the IT related task and update the status higher management on regularly.
Participating in Day/Weekly status review meetingsExcellent oral and written communication skillsExperience in db2 tuning and configurations.
Ability to obtain and maintain a Minimum Background Investigation (MBI)

Who You AreA minimum of 5+ years of overall experience in IT Database Domain with proveexperience in Database Operations.
Client Meetings, External Audit, Database Installation, Database Environment, Database Server Administration.
BE/ BTech/MCA/Diploma.


Being YouDiversity is a whole lot more than what we look like or where we come from, it's how we think and who we are.

We welcome people of all cultures, backgrounds, and experiences. But we're not doing it single-handily:

Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice.

This dedication to welcoming everyone into our company means that Kyndryl gives you – and everyone next to you – the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture.

That's the Kyndryl Way.


What You Can ExpectWith state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value.

Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter – wherever you are in your life journey.

Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more.

Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations.

At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed.

  • DB2 Database Administrator

    7 days ago

    Bengaluru, Karnataka, India Kyndryl Full time

    Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The...

  • Ibm Db2 Database Administrator

    7 days ago

    Bengaluru, Karnataka, India Doctorvi Full time

    IBM DB2 Database AdministratorExperience: 4-6 yearsLocation: Bengaluru/MumbaiImmediate Joiner Preferredwork type: HybridImplementation, maintenance, Upgrade, Patching, availability, HA, DR implementation and operation, troubleshooting, Security Compliance on IBM Mainframe DB2 -Should have good communication skills and Interact with Vendors for support and...

  • Db2 Database Admin

    7 days ago

    Bengaluru, Karnataka, India IBM Full time

    IntroductionAt IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most...

  • DB2 Database Administrator with Replication

    7 days ago

    Bengaluru, Karnataka, India Jobs for Humanity Full time

    Job Description Position Type : Full time Type Of Hire : Experienced (relevant combo of work and education) Education Desired : Bachelor's Degree Travel Percentage : 0% DB2 Database Administrator with Replication ( LUW DB2) Are you curious, motivated, and forward-thinking? At FIS you'll have the opportunity to work on some of the most challenging and...

  • DB2 Database Administrator with Replication

    7 days ago

    Bengaluru, Karnataka, India Jobs for Humanity Full time

    Job DescriptionPosition Type :Full timeType Of Hire :Experienced (relevant combo of work and education)Education Desired :Bachelor's DegreeTravel Percentage :0%DB2 Database Administrator with Replication( LUW DB2)Are you curious, motivated, and forward-thinking? At FIS you'll have the opportunity to work on some of the most challenging and relevant issues in...

  • DB2 administrator on LUW

    7 days ago

    Bengaluru, Karnataka, India N Consulting Ltd Full time

    We are looking for a highly skilled and experienced DB2 Administrator with over 10 years of experience to join our team in either Banglore or Pune. Job Description: 7 to 15 years of relevant experience as DB2 administrator on LUW (Linux-Unix-Windows) platform. Mandatory Skills: DB2 administration (LUW - Linux-Unix-Windows platform) QREP and CDC...

  • MainFrame DB2 DataBase Administrator

    7 days ago

    Bengaluru, Karnataka, India Tata Technologies Full time

    o Good experience in DB2 with§ Creation of new DB objects§ Providing access to Group id's in XDEV/IGRT/DEVE/ACPT/PROD§ Cleanup of existing individual id's§ Maintenance of objects in all Env.§ Environment Refresh§ Troubleshooting, incident resolution, change implementations§ Deployments related to PROD environment changes§ Application operations and...

  • SAP Database Administrator

    7 days ago

    Bengaluru, Karnataka, India Cranium IT Inc Full time

    Key responsibilitiesProvide logical and physical database design and implementation of physical DB structures into DB2 DBMS.Install & administer large scale DB2 (V10 onwards) in an SAP context.Perform DB2 database upgrades, patching and DB migration operations.Ensures acceptable database availability and response time by leading database problem diagnosis...

  • SAP Database Administrator

    7 days ago

    Bengaluru, Karnataka, India Cranium IT Inc Full time

    SAP Database AdministratorKey responsibilitiesMonitoring of all Databases supporting the SAP ecosystem and Perform regular Health Check-Up.Install & administer databases (HANA, SQL Server, IBM Db2) in an SAP context.Perform database (HANA, SQL Server, IBM Db2) upgrades and patching.Ensures acceptable database availability and response time by leading...

  • Principal - Database Administration

    7 days ago

    Bengaluru, Karnataka, India Fidelity Investments Full time

    Job Title : Principal - Database AdministrationThe Purpose of This Role Provide Database Administration to Mainframe DB2 systems. Work with senior level business and technology partners to define and implement database solutions. The person will be responsible in providing Database Administration to DB2 systems.The Value You DeliverThe Mainframe DBA group...

  • Ibm Db2 Database Administrator(Hybrid)

    7 days ago

    Bengaluru, Karnataka, India Covi-Sense Full time

    Experience: 4-6 yearsLocation: Bengaluru/MumbaiImmediate Joiner PreferredImplementation, maintenance, Upgrade, Patching, availability, HA, DR implementation and operation, troubleshooting, Security Compliance on IBM Mainframe DB2 -Should have good communication skills and Interact with Vendor for support and best practices guidance, troubleshooting, handle...

  • Db2 Dba

    7 days ago

    Bengaluru, Karnataka, India msg global solutions Full time

    What we doWhat you will do Design and implementation of architecture and operations processes Actively collaborate with the software development & quality assurance teams Implementation and administration of security solutions (incident management) Structured error/problem analysisWhat we are looking forRequirements Provision and operation of the z/OS...

  • Db2 Luw

    7 days ago

    Bengaluru, Karnataka, India Sage IT India Full time

    7+ years of experienced in DB2 LUW Need to know JCL since it is required for executing DBA tasks related to MF DB Awareness of supporting Federation Data privacy knowledge Past experience of upgrade & automation. Personal characteristics Willing learn, reasonable communication skills.Job Description:DB2-UDB-DB Administration Experience in DB2 UDB 10.5...

  • Db2 engineer

    7 days ago

    Bengaluru, Karnataka, India IBM Full time

    IntroductionSoftware Developers at IBM are the backbone of our strategic initiatives to design, code, test, and provide industry-leading solutions that make the world run today - planes and trains take off on time, bank transactions complete in the blink of an eye and the world remains safe because of the work our software developers do. Whether you are...

  • Db2 Dba

    7 days ago

    Bengaluru, Karnataka, India Cranium IT Inc Full time

    Skill: DB2 DBAExperience: 3 yearsJD:3 Yrs Skills : Powershell Developer, DB2 DBA onLUW JD : Experience with Windows PowerShell Programming/Coding experience Strong knowledge in Windows Batch Scripting Knowledge on DB2 database administration on windows is preferred Build scripts to automate DBA tasks on windows server via writing batch files, powershell...

  • Database Administrator

    7 days ago

    Bengaluru, Karnataka, India SAP Full time

    We help the world run betterOur company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...

  • DB2 DataBase Administrator

    7 days ago

    Bengaluru, Karnataka, India Tata Technologies Full time

    New/modify/delete of account in databasesCreate schema and/or database tablesHosting covers:Weekly schema object sizingDaily monitoring of data block organization, physical storage and contention, table space utilizationApplication is based on Development / ProjectsDownload file to diskNew or revised database designDatabase creation activities and changes as...

  • Database Administrator

    7 days ago

    Bengaluru, Karnataka, India SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...

  • IBM DB2, PostgreSQL, Cassandra Database Administrator

    7 days ago

    Bengaluru, Karnataka, India 5100 Kyndryl Solutions Private Limited Full time

    Who We AreAt Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.The RoleWithin...

  • Database Administrator

    7 days ago

    Bengaluru, Karnataka, India SAP Full time

    We help the world run better At SAP, we enable you to bring out your best. Our company culture is focused on collaboration and a shared passion to help the world run better. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and...