Oracle Database Administrator

Tata Consultancy Services; Town of Niskayuna (NY); On-site; USD 100,000 - 125,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Medical Coverage

Family Leave

401K Plan

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services in New York is seeking an experienced Oracle Database Administrator to install, configure, and maintain Oracle databases across versions 11g, 12c, and 19c.

You will perform performance tuning, RMAN-based backup and recovery, and manage RAC, Data Guard, and security while coordinating with developers to optimize workloads and ensure high availability.

Base salary ranges from $100,000 to $125,000 per year, with a discretionary incentive plan and comprehensive benefits.

Qualifications

• Install, configure, and maintain Oracle database instances across versions (11g, 12c, 19c).
• Perform routine monitoring, performance tuning, and query optimization.
• Configure RAC, Data Guard, and RMAN for high availability and DR.
• Implement backup/restore strategies using RMAN and manage security.
• Migrate/patch databases with minimal downtime and automate tasks with PL/SQL, Bash, and Perl.

Responsibilities

• Deep expertise in Oracle performance tuning, backups, RMAN, and database optimization.
• Extensive experience with Oracle RAC, Data Guard, and ASM.
• Proficient in PL/SQL scripting and automation.
• Knowledge of Oracle Exadata, Oracle Cloud, and cloud-based solutions (OCI, AWS).
• Strong troubleshooting skills for complex database issues.
• Familiarity with Oracle Enterprise Manager (OEM) and other monitoring tools.

Skills

Oracle Database Administration

Performance Tuning

RAC/Data Guard

RMAN

PL/SQL

Automation Scripting

Education

Bachelor's degree in Computer Science

Tools

Oracle Enterprise Manager (OEM)

Exadata

OCI/AWS

Job description

• Install, configure, and maintain Oracle database instances (All Versions/11g, 12c, 19c).
• Perform routine database monitoring, including performance tuning and query optimization.
• Configure and manage Oracle Real Application Clusters (RAC), Data Guard, and RMAN.
• Implement and manage backup, restore, and disaster recovery strategies using RMAN.
• Troubleshoot and resolve database issues, including performance degradation, corruption, and outages.
• Manage Oracle database security (user roles, privileges, encryption, auditing).
• Perform database migrations, upgrades, and patching with minimal downtime.
• Automate administrative tasks using Oracle scripts (PL/SQL, Bash, Perl).
• Monitor capacity planning, storage, and system resources.
• Collaborate with application developers to enhance database performance and scalability.
• Physical Requirements - Ability to work in a standard office environment and May also need to provide support after regular hours, including on-call assistance.

Job Description

Must Have Technical/Functional Skills

• Install, configure, and maintain Oracle database instances (All Versions/11g, 12c, 19c).
• Perform routine database monitoring, including performance tuning and query optimization.
• Configure and manage Oracle Real Application Clusters (RAC), Data Guard, and RMAN.
• Implement and manage backup, restore, and disaster recovery strategies using RMAN.
• Troubleshoot and resolve database issues, including performance degradation, corruption, and outages.
• Manage Oracle database security (user roles, privileges, encryption, auditing).
• Perform database migrations, upgrades, and patching with minimal downtime.
• Automate administrative tasks using Oracle scripts (PL/SQL, Bash, Perl).
• Monitor capacity planning, storage, and system resources.
• Collaborate with application developers to enhance database performance and scalability.
• Physical Requirements - Ability to work in a standard office environment and May also need to provide support after regular hours, including on-call assistance.

Roles & Responsibilities (L2/L3 Only)

• Deep expertise in Oracle performance tuning, backups, RMAN, and database optimization.
• Extensive experience with Oracle RAC, Data Guard, and ASM.
• Proficient in PL/SQL scripting and automation.
• Knowledge of Oracle Exadata, Oracle Cloud, and cloud-based solutions (OCI, AWS).
• Strong troubleshooting skills for complex database issues.
• Familiarity with Oracle Enterprise Manager (OEM) and other monitoring tools.

Generic Managerial Skills, If any

Leadership, Communication, Decision-making, Problem-solving, Time Management, Delegation, Conflict Resolution, Adaptability, Strategic Thinking, Team Building.

Base Salary Range : $100,000 to $125,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 & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Qualifications:

BACHELOR OF COMPUTER SCIENCE