Oracle Database Administrator

Tata Consultancy Services Limited

Niskayuna, NY, United States

5 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$100,000.0 - $125,000.0

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Backup Devices Bash Shell Cloud Computing Databases Oracle Data Guard Disaster Recovery Perl (Programming Language) Oracle Exadata Monitoring of Systems Oracle Databases Oracle (Applications)

+11 more

Oracle Rac Performance Tuning Query Optimization Recovery Manager (RMAN) PL-SQL Oracle Enterprise Manager Database Optimization Database Performance Database Migration Database Monitoring Oracle Cloud Infrastructure

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.

Requirements

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.

Benefits & conditions

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.