Senior Database Administrator (Oracle Application DBA / AWS Cloud)

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.

TCS Interactive is Tata Consultancy Services’ award-winning full-service agency unit. We design, engineer and activate digital products and services that drive growth and transformation for leading organizations. Global brands leverage our end-to-end experience transformation capabilities to increase acquisition, engagement, conversion, retention and operational efficiency through customer experience, digital products, commerce, marketing, loyalty and self-service solutions powered by data, technology and AI.

We are seeking hands-on TCS Interactive Partners to join our Customer Success team. A TCS Interactive Partner works closely with TCS Client Partners and account leadership teams to drive growth, strengthen executive relationships, and expand the adoption of TCS Interactive services within strategic client accounts.

While the Client Partner is often aligned to CIO and technology leadership stakeholders, the Interactive Partner focuses on CMOs, Chief Digital Officers, Customer Experience leaders, Product leaders, Data and Analytics leaders, and other business decision-makers. The Interactive Partner serves as a trusted advisor, helping clients solve business challenges through customer experience, marketing, digital product, data and AI-enabled transformation.

The primary KPI for an Interactive Partner is customer success, measured through revenue growth, portfolio expansion, executive relationship development, opportunity creation, and client outcomes. Interactive Partners are expected to identify growth opportunities, shape strategic pursuits, orchestrate TCS Interactive capabilities, and help clients achieve their business objectives

Role Overview

We are seeking an experienced Senior Oracle Application DBA to optimize, scale, and maintain mission-critical database applications. This role partners closely with development and engineering teams to ensure high availability, optimal SQL/PL-SQL performance, and smooth database operations, while helping drive our database modernization and cloud migration strategy.

Key Responsibilities

• Collaborate with application development teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views.
• Analyze execution plans, perform SQL query tuning, and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.
• Lead database release automation, code reviews, and schema migrations across development, staging, and production environments.
• Monitor database application health, identify lock contention, resolve deadlocks, and troubleshoot latency issues.
• Partner with infrastructure and cloud teams to design, test, and execute on-premises to AWS cloud database migrations.
• Participate in database capacity planning, failover drills, and disaster recovery design.

Required Qualifications & Skills

• Oracle Application DBA Expertise: 8+ years specializing in Oracle Database (12c/19c+) application support, advanced PL/SQL programming, execution plan analysis, and performance diagnostics (AWR, ASH, ADDM).
• AWS & Cloud Databases: Practical experience administering managed database services including Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora.
• PostgreSQL: Hands-on working knowledge of PostgreSQL architecture, schema design, and performance optimization.
• Cloud Migration Experience: Strong, proven track record of migrating on-premises databases to AWS environments (using tools such as AWS DMS, SCT, or native utilities).
• Collaboration & Release Management: Solid background in CI/CD integration for database deployments and working alongside Agile engineering teams.

Nice-to-Have Qualifications

• Experience with Oracle Exadata administration and performance tuning features (Smart Scan, Hybrid Columnar Compression).
• Proficiency in shell scripting (Bash) and automation using Python.
• Relevant AWS (e.g., AWS Certified Database – Specialty) or Oracle certifications."

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.