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’s stories across our workforce and implemented through equitable workplace policies and processes. About TCS TCS is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is delivered through its unique Location Independent Agile™ delivery model, recognized as a benchmark of excellence in software development. A part of the Tata group, India's largest multinational business group, TCS operates in 55 countries and employs over 607,000 highly skilled individuals, including more than 10,000 in Canada. The company generated consolidated revenues of US $30 billion in the fiscal year ended March 31, 2025, and is listed on the BSE and the NSE in India. TCS' proactive stance on climate change and award-winning work with communities across the world have earned a place in leading sustainability indices such as the MSCI Global Sustainability Index and the FTSE4Good Emerging Index. Job Requirements Good years of enterprise DBA experience supporting Oracle, SQL Server, and PostgreSQL databases Strong hands‑on experience with Oracle Data Guard (physical/logical), switchover, and failover operations Expertise in Oracle Multitenant architecture (CDB/PDB), upgrades, and PDB lifecycle management Solid experience with MS SQL Server Always On Availability Groups and failover clustering Advanced database performance tuning, query optimization, indexing, and capacity planning Experience performing database patching, minor/major upgrades, and vulnerability remediation Proven knowledge of backup and recovery tools (RMAN, SQL Server native, third-party solutions) Exposure to on‑prem to cloud database migrations and modernization initiatives Working knowledge of database security, encryption, auditing, and access management Ability to support 24x7 production environments and participate in on‑call rotations Key Responsibilities Administer and support Oracle databases using Data Guard and Multitenant (CDB/PDB) architecture Manage MS SQL Server environments including Always On, clustering, and performance baselines Ensure high availability, disaster recovery readiness, and conduct regular DR drills Proactively monitor databases and resolve availability, performance, and capacity issues Plan and execute database upgrades, patching cycles, and maintenance activities Perform database restores and recovery during incidents and unplanned outages Support application teams with deployments, schema changes, and query optimization Participate in database migration projects across on‑prem and cloud platforms Maintain operational documentation, SOPs, and runbooks Collaborate with infrastructure, cloud, security, and application stakeholders 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. #J-18808-Ljbffr
Database Administrator (Dba / Sme – Oracle, Sql Server & Postgresql)
TATA CONSULTANCY SERVICES
calgary, calgary
Published 24 days ago
Report job