Oracle Database Administrator

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.