Oracle DBA
Tata Consultancy Services, Florida, NY, United States
Roles & Responsibilities
Optimization of SQL query, analyzing execution plans.
Create and maintain database objects like tables, indexes, sequences, etc.
Monitoring database using OEM; tuning Oracle objects.
Experience in performance tuning at database and application level.
Must have good troubleshooting skills.
Understanding of Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports.
Strong knowledge of source control and release management tools.
Stay updated with emerging technologies and recommend improvements to enhance system efficiency.
Flexible to extend work hours based on project delivery needs.
Expectations from Role
Optimization of SQL query, analyzing execution plans.
Create and maintain database objects like tables, indexes, sequences, etc.
Monitoring database using OEM; tuning Oracle objects.
Experience in performance tuning at database and application level.
Must have good troubleshooting skills.
Understanding of Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports.
Strong knowledge of source control and release management tools.
Stay updated with emerging technologies and recommend improvements to enhance system efficiency.
Flexible to extend work hours based on project delivery needs.
Primary Skills
Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning
RMAN Backup & Recovery
RAC, Data Guard, ASM, Security & Patching
GoldenGate, Exadata support
Secondary Skills
Shareplex, Database Migration & Upgrade
Linux & Shell Scripting
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
Qualifications BACHELOR OF COMPUTER SCIENCE
#J-18808-Ljbffr
Optimization of SQL query, analyzing execution plans.
Create and maintain database objects like tables, indexes, sequences, etc.
Monitoring database using OEM; tuning Oracle objects.
Experience in performance tuning at database and application level.
Must have good troubleshooting skills.
Understanding of Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports.
Strong knowledge of source control and release management tools.
Stay updated with emerging technologies and recommend improvements to enhance system efficiency.
Flexible to extend work hours based on project delivery needs.
Expectations from Role
Optimization of SQL query, analyzing execution plans.
Create and maintain database objects like tables, indexes, sequences, etc.
Monitoring database using OEM; tuning Oracle objects.
Experience in performance tuning at database and application level.
Must have good troubleshooting skills.
Understanding of Automatic Workload Repository (AWR), Oracle hints, Active Session History (ASH) reports.
Strong knowledge of source control and release management tools.
Stay updated with emerging technologies and recommend improvements to enhance system efficiency.
Flexible to extend work hours based on project delivery needs.
Primary Skills
Oracle DBA, Real Application Cluster (RAC), Oracle Enterprise Monitor (OEM), Performance Tuning
RMAN Backup & Recovery
RAC, Data Guard, ASM, Security & Patching
GoldenGate, Exadata support
Secondary Skills
Shareplex, Database Migration & Upgrade
Linux & Shell Scripting
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
Qualifications BACHELOR OF COMPUTER SCIENCE
#J-18808-Ljbffr