Oracle Database Administrator — Niskayuna, NY

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