Database Admin

Tata Consultancy Services; Phoenix (AZ); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Discretionary Incentive

Medical Coverage

Parental Leaves

Auto & Home Insurance

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

401K Plan

Job summary

Tata Consultancy Services Limited in Phoenix, AZ is seeking an experienced Database Administrator to provide 24x7 production support across multiple environments. You will manage database startups, failovers, maintenance, backups, and performance tuning using AWR/ASH and Oracle OEM tooling.

The role requires strong scripting experience (Shell, Python, PowerShell) and familiarity with cloud platforms (AWS, Azure, GCP), containerization (Docker/Kubernetes), and IaC (Terraform/Ansible).

Qualifications

• 5+ years of database administration experience.
• Proven ability to manage 24x7 production support.
• Experience with multiple RDBMS and cloud environments.

Responsibilities

• Provide 24x7 production support; first contact for DB incidents and restoration.
• Manage startups, shutdowns, failover, switchover, and maintenance validations.
• Monitor availability, OEM alerts, health checks; conduct root-cause analysis.
• Troubleshoot performance using AWR/ASH, explain plans, locks, and long-running queries.
• Manage storage, backups, RMAN, standby databases, and patching tasks.
• Coordinate backups, restore points, and DR activities; maintain CRM dashboards.
• Develop automation tools; improve DBA processes and documentation.
• Collaborate with application, infrastructure, and development teams.

Skills

Database administration

Incident management

Root cause analysis

Automation

Scripting

Tools

Terraform

Ansible

GitHub

GitHub Actions

Grafana

Prometheus

Oracle OEM

Docker

Kubernetes

Shell

Python

PowerShell

Linux/Unix

Windows

AWS

Azure

GCP

Oracle

PostgreSQL

MS SQL Server

YugabyteDB

Aurora PostgreSQL

Aurora MySQL

Spanner

Job description

Job Description

Role - Database Admin

Experience Required -5+ Years

Must Have Technical/Functional Skills

• Oracle, PostgreSQL, Microsoft SQL Server, YugabyteDB, Aurora PostgreSQL, Aurora MySQL, and Spanner

Public Cloud

• AWS, Azure, GCP

IaC

• Terraform

Configuration Management

• Ansible

Source Control & CI/CD

• GitHub, GitHub Actions

Monitoring

• Grafana, Prometheus, ORACLE OEM

Containers

• Docker, Kubernetes

Scripting

• Shell, Python, PowerShell

Operating Systems

• Linux/Unix/windows

Roles & Responsibilities

• Provide 24x7 support for Production (E3) and lower environments; act as the first point of contact for database incidents, restore service, perform troubleshooting, and route issues when required.
• Manage database startups, shutdowns, restarts, instance failover, switchover, parameter changes, and pre/post maintenance validations.
• Monitor database availability, alert logs, OEM alerts, health checks, and infrastructure-related issues; perform root cause analysis for Sev1 and Sev2 incidents.
• Troubleshoot database and SQL performance using AWR, ASH, explain plans, locks, deadlocks, blocking sessions, and long-running session reports.
• Manage database, tablespace, ASM, archive log, backup, Oracle Home, and OS filesystem capacity; forecast space needs and coordinate storage additions.
• Perform proactive and ad-hoc backups, restore points, flashback restores, RMAN table recovery, database restoration, and standby database rebuild.
• Support OS and database patching, upgrades, migrations, server reboots, and application or database maintenance changes.
• Schedule and maintain backup and database jobs using OEM and CRON; configure monitoring thresholds, alerts, reports, and Grafana dashboards.
• Administer users, profiles, roles, privileges, schema unlocks, DBA IDs, application access, and required access for RFC execution.
• Maintain database security, audit configuration, TDE, encryption, and object validity checks.
• Monitor and support Data Guard, GoldenGate, PostgreSQL/SQL Server/YugabyteDB replication, replication lag resolution, DR activities, switchovers, and failovers.
• Support export/import, data truncation, and application-requested database activities in accordance with change controls.
• Develop self-service and automation tools.
• Raise and coordinate vendor cases for DBMS software issues and work directly with application, infrastructure, development, and DBA teams.
• Drive documentation, standardization, operational improvements, and DBA process automation.
• Experience in scripting and AI related tools.
• Experience on Public cloud environments.

Base Salary Range : $90,000 to $120,000 Per Annum

TCS Employee Benefits Summary:

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Tra ining Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Location

Phoenix, AZ

Function

TECHNOLOGY

Role

Database Administrator

ID

433812

Skills

Database Administration | Oracle | PostgreSQL

Salary Range

$90,000 - $120,000