Oracle Database Administrator

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