Db2 Database Administrator

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

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.

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.

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