Back to results

Database Administrator

  • Calgary, AB, Canada

Full-time

Applications open in a new tab.

Job details

Job type
Full-time
Apply by
Posting language
English
Posted

Original job description

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.

TCS has been serving the Canadian marketplace for more than 35 years and today is the technology partner of choice for many of the country's leading organizations. As one of the largest IT services providers in Canada and globally, TCS is aiming 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 and values of the Tata Group, TCS is focused on creating long-term value for its clients, investors, employees, and the communities it serves. With a highly skilled workforce supporting customers from coast to coast, TCS has consistently been recognized as a Top Employer by the Top Employers Institute, including a recent top ranking at the country level.

TCS also sponsors 14 of the world's most prestigious marathons and endurance events, including the TCS Toronto Waterfront Marathon, reflecting its commitment to health, sustainability, and community empowerment.

Job Requirements:-

  • Senior 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

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.

More about this job

Responsibilities

Administer Oracle and SQL Server databases, maintaining availability, performance, security, and disaster recovery readiness through monitoring, maintenance, upgrades, patching, and recovery operations. Support application deployments and database migrations, maintain operational documentation, and collaborate with infrastructure, cloud, security, and application teams.

Requirements

Requires extensive enterprise database administration experience with Oracle, SQL Server, and PostgreSQL, including high-availability configurations, disaster recovery, performance tuning, upgrades, and backup and recovery. Candidates should also have experience with database security and cloud migration, and be able to support 24x7 production environments and on-call rotations.

Skills

  • Oracle Database Administration
  • SQL Server Administration
  • PostgreSQL
  • Oracle Data Guard
  • SQL Server Always On Availability Groups
  • Failover Clustering
  • Database Performance Tuning
  • Query Optimization
  • Database Patching and Upgrades
  • Backup and Recovery
  • Database Migration
  • Database Security
  • Disaster Recovery
  • Capacity Planning
  • Production Support

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Data & Analytics
  • Software
  • Consulting

Keywords

  • Oracle
  • SQL Server
  • PostgreSQL
  • Oracle Data Guard
  • Physical Standby
  • Logical Standby
  • Switchover
  • Failover
  • Oracle Multitenant
  • CDB
  • PDB
  • Always On Availability Groups
  • Failover Clustering
  • Performance Tuning
  • Query Optimization
  • Indexing
  • Capacity Planning
  • Database Patching
  • Database Upgrades
  • Vulnerability Remediation
  • RMAN
  • Backup and Recovery
  • Cloud Migration
  • Database Modernization
  • Database Security
  • Encryption
  • Auditing
  • Access Management
  • Disaster Recovery
  • 24x7 Production Support

Report this job