Database Administrator

Tata Consultancy Services; Calgary; On-site; CAD 80,000 - 110,000; Full time

Job summary

Tata Consultancy Services is seeking a Database Admin in Calgary, Alberta. The role involves supporting Oracle and SQL Server databases, ensuring high availability, and participating in disaster recovery strategies.

Candidates should have extensive DBA experience, particularly with Oracle Data Guard and SQL Server Always On functionalities. The position demands 24x7 support capability and participation in database migration initiatives.

Qualifications

• Strong hands-on experience with Oracle Data Guard and SQL Server Always On.
• Expertise in database performance tuning and query optimization.
• Proven knowledge of backup and recovery processes and tools.

Responsibilities

• Administer and support Oracle databases with Data Guard.
• Manage MS SQL Server environments for availability and performance.
• Conduct regular disaster recovery drills and monitor databases.

Skills

Enterprise DBA experience with Oracle, SQL Server, PostgreSQL

Oracle Data Guard expertise

Oracle Multitenant architecture knowledge

MS SQL Server Always On experience

Database performance tuning

Backup and recovery tools knowledge

Cloud database migrations exposure

Database security and access management

24x7 production environment support

Job description

Database Admin

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.

Job Requirements

• 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