Database Administrator (DB2 DBA)

Inclusion without Exception

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.

Tata Consultancy Services (BSE: 532540, NSE: TCS) is the technology partner of choice for industry-leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence and customer service.

It has set an aspiration to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence.

Rooted in the heritage of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large. With a highly skilled workforce spread across 56 countries and 194 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients. Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today.

Skills and Responsibilities:

"DB2 DBA (LUW) Administrator

Role Summary

A DB2 LUW Administrator is responsible for managing IBM DB2 databases on distributed platforms (Linux, Unix, Windows). The role focuses on database installation, maintenance, performance optimization, and ensuring high availability and security of database systems.

Required Skills

Technical Skills

• Strong experience with IBM DB2 LUW (KUW)

• Hands-on experience with:

• HADR configuration

• Backup \& recovery strategies

• Performance tuning

• Strong SQL knowledge

• Experience with Linux/Unix environments

• Familiarity with DB2 tools (db2pd, db2top, EXPLAIN)

Preferred Skills

• DB2 certifications (IBM Certified DBA)

• Experience with cloud environments (AWS/Azure)

• Exposure to other RDBMS (Oracle, SQL Server)

• Knowledge of automation and DevOps tool

Experience

• Good years of DB2 LUW administration experience

Key Competencies

• Problem-solving and troubleshooting skills

• Strong analytical thinking

• Ability to work in production support environments

• Good communication and teamwork

Key Responsibilities

Database Administration

• Install, configure, and maintain DB2 LUW databases

• Create and manage instances, databases, tablespaces, and schemas

• Perform database upgrades, patches, and migrations

• Manage storage, space allocation, and capacity planning

Performance Management

• Monitor and analyze database performance

• Tune SQL queries, indexing strategies, and database configurations

• Optimize memory usage, buffer pools, and workload management

• Troubleshoot locking, deadlocks, and slow queries

Backup \& Recovery

• Configure and manage backup strategies (offline/online backups)

• Perform restores and point-in-time recovery (PITR)

• Ensure proper archival logging and recoverability

• Regularly validate backup integrity

High Availability (HA) \& DR

• Implement and manage HADR (High Availability Disaster Recovery)

• Configure failover, replication, and standby databases

• Support disaster recovery drills and testing

Security \& Access Management

• Manage users, roles, and permissions

• Implement DB security policies and encryption

• Ensure compliance with organizational and regulatory requirements

Monitoring \& Troubleshooting

• Monitor database health and system logs

• Resolve incidents, outages, and performance issues

• Perform root cause analysis and preventive actions

Automation \& Scripting

• Develop automation scripts (Shell, Python, Perl)

• Automate routine DBA tasks such as backups and monitoring

• Use scheduling tools like cron for maintenance jobs"

Salary Range - CA$ 100,000 - CA$ 120,000 Per Year

TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion.

Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodation during the recruitment and selection process, please inform Human Resources.

Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.