Oracle DBA
Tata Consultancy Services, Lake Mary, FL, United States
Expectations from Role
- Optimization of SQL query, Analyzing execution plans. - Create and maintain database objects likes Tables, Index, Sequence etc. - Monitoring Database using OEM. Tuning of Oracle objects. - Experience in Performance Tuning at Database and Application level. - Must have good troubleshooting skills. - Understanding Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports is a must. - Strong knowledge of source control and release management tools. - Stay updated with emerging technologies and recommend improvements to enhance system efficiency. - Flexible to extend the work hours based on Project delivery need.
Roles & Responsibilities
Primary Skills
1. Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning 2. RMAN Backup & Recovery 3. RAC, Data Guard, ASM, Security & Patching 4. GoldenGate, Exadata support
Secondary Skills
1. Shareplex, Database Migration & Upgrade 2. Linux & Shell Scripting 3. Monitoring Tools, Automation and Other Database hands-on (Postgres/Mongo)
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.
Salary Range: $100,000 - $120,000 a year
- Optimization of SQL query, Analyzing execution plans. - Create and maintain database objects likes Tables, Index, Sequence etc. - Monitoring Database using OEM. Tuning of Oracle objects. - Experience in Performance Tuning at Database and Application level. - Must have good troubleshooting skills. - Understanding Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports is a must. - Strong knowledge of source control and release management tools. - Stay updated with emerging technologies and recommend improvements to enhance system efficiency. - Flexible to extend the work hours based on Project delivery need.
Roles & Responsibilities
Primary Skills
1. Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning 2. RMAN Backup & Recovery 3. RAC, Data Guard, ASM, Security & Patching 4. GoldenGate, Exadata support
Secondary Skills
1. Shareplex, Database Migration & Upgrade 2. Linux & Shell Scripting 3. Monitoring Tools, Automation and Other Database hands-on (Postgres/Mongo)
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.
Salary Range: $100,000 - $120,000 a year