DB2 Database Administrator

1 month ago


Bengaluru, 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.

  • Bengaluru, India Cranium IT Inc Full time

    **Key responsibilities** Provide 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...


  • 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 Role You...


  • Bengaluru, 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...


  • Bengaluru, India Doctorvi Full time

    **IBM DB2 Database Administrator** Experience: 4-6 years Location: Bengaluru/Mumbai Immediate Joiner Preferred work type: Hybrid Implementation, 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...


  • Bengaluru, Karnataka, India FIS Global Full time

    **Position Type**: Full time **Type Of Hire**: Experienced (relevant combo of work and education) **Education Desired**: Bachelor's Degree **Travel Percentage**: 0% **Mainframe Db2 Database Administrator(DBA) - Bangalore/Pune/Chennai (5 to 8 yrs)** Are you curious, motivated, and forward-thinking? At FIS you’ll have the opportunity to work on some of the...


  • Bengaluru, India Equiniti Full time

    Management LevelFOverview of Equiniti GroupEquiniti is a leading provider of technology and solutions for complex administration and payments. Our technology platforms and solutions are used by 70% of the FTSE 100, Government and other large corporates, particularly in banking, insurance and other financial services. We have 1,700 clients, make £160 billion...

  • Db2 Database Admin

    3 days ago


    Bengaluru, India IBM Full time

    **Introduction** At 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...


  • Bengaluru, India FIS Full time

    Position 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 financial...


  • Bengaluru, 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...

  • Database Engineer

    1 week ago


    Bengaluru, India SPG Consulting Solutions Pvt.Ltd Full time

    Responsibilities :- Provide technical leadership for all aspects of database management such as database lifecycle management, monitoring, support, disaster recovery, compliance, and standards.- Research new MySQL & DB2 LUW database versions, features, tools, and technologies with an Enterprise perspective to meet customer needs while maintaining a secure...


  • Bengaluru, India Cranium IT Inc Full time

    **SAP Database Administrator** **Key responsibilities** Monitoring 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...


  • Bengaluru, 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...


  • Bengaluru, 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...


  • Bengaluru, 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...


  • Bengaluru, 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...


  • Bengaluru, India Fidelity Investments Full time

    The 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 Deliver The Mainframe DBA group provides a variety of...


  • Bengaluru, Karnataka, India Fidelity Investments Full time

    **Job Title : Principal - Database Administration** **The 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 Deliver** The...


  • Bengaluru, India Yash Technologies Full time

    Date: Jan 11, 2023- Job Requisition Id: 51958- Job Category: Digital- Location: Bangalore, KA, INOur Digital Service Line is currently looking for industry-leading seasoned **DB **professionals with hands-on experience in **DB2**. **You are required to have skills in the following areas**: - Provide logical and physical database design and implementation...


  • Bengaluru, India Covi-Sense Full time

    **Experience: 4-6 years** **Location: Bengaluru/Mumbai** **Immediate Joiner Preferred** Implementation, 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,...

  • Db2 Dba

    8 hours ago


    Bengaluru, Karnataka, India Technology Next Full time

    **DB2 DBA (Immediate Joiner)** **Location**:Bangalore **(Hybrid 3 Days WFO)** **Tenure**:6 Months **Job Type**:Contractual **Salary**:15-16 LPA **Experience - **5 Years **Note: (**Strong written and verbal communication skills**)** **Preferred Qualifications**: - Experience with other relational database management systems (RDBMS) such as Oracle or SQL...