Tata Consultancy Services Oracle Database Expert

2 weeks ago


San Jose, California, United States Tata Consultancy Services Full time

Job Description

Technical/Functional Skills

As an Oracle Database Expert at Tata Consultancy Services, we are seeking a highly skilled professional with a strong background in Oracle database administration and performance optimization. The ideal candidate will have a minimum of 8+ years of experience in the software industry and a proven track record of delivering high-quality solutions.

Key Responsibilities

  • Understanding of software design patterns, SDLC, Continuous Integration and Continuous Delivery
  • Drive to get things done in a highly collaborative and agile development environment
  • Strong analytical and problem-solving skills
  • Oracle database concepts and architecture
  • Knowledge on Oracle Cluster Ready services (CRS), Data Guard, RMAN backup/recovery methods and maintenance of ASM
  • Oracle RAC administration and performance analysis
  • Overall system performance tuning
  • SQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian)
  • Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods)
  • AWR report, TKPROF analysis and interpretation
  • Troubleshooting Long running transactions and ERP concurrent requests

Requirements

  • Experience in performance tuning of database, instances, SGA, I/O, and rollback segment
  • Experience in SQL Tuning, Wait Events, Histogram, Join Methods (Nested Loop, Hash Join, Merge join cartesian), Index scan Methods (Range Index scan, Fast full index scan, Skip scan index methods), oracle wait events (DB file sequential read, DB file scattered read, GC wait events), Top SQLs Analysis at database level (CPU/Memory/load)
  • Expertise in Plan change Analysis of the SQLs while upgradation of databases
  • SQL query optimization and instance tuning using TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, running scripts, troubleshooting, bug fixing
  • Able to work with oracle support to create SR and troubleshooting and fix the issues

What We Offer

Tata Consultancy Services offers a competitive salary range of $100,000-$120,000 a year, along with a comprehensive benefits package and opportunities for career growth and professional development.


  • SRE Engineer

    4 weeks ago


    San Jose, California, United States Tata Consultancy Services Full time

    Job DescriptionAt Tata Consultancy Services, we are seeking a highly skilled SRE Engineer to join our team. As a key member of our infrastructure team, you will be responsible for designing, implementing, and maintaining scalable and highly available cloud infrastructure.Key ResponsibilitiesDesign and implement containerization solutions using Kubernetes and...


  • San Jose, California, United States Tata Consultancy Services Full time

    Job Title: Site Reliability EngineerAt Tata Consultancy Services, we are seeking a highly skilled Site Reliability Engineer to join our team. As a Site Reliability Engineer, you will be responsible for ensuring the smooth operation of our data pipelines and cloud infrastructure.Key Responsibilities:Design and implement data pipelines using Tableau and Azure...


  • San Jose, California, United States Tata Consultancy Services Full time

    Job RequirementsAs a Salesforce CPQ Developer at Tata Consultancy Services, you will be responsible for implementing and integrating Salesforce and CPQ solutions. The ideal candidate will have a minimum of 5+ years of experience in Salesforce and 1+ year in CPQ, with a strong understanding of Salesforce CRM development, including Administrator, Development,...


  • San Jose, California, United States Tata Consultancy Services Full time

    Key ResponsibilitiesAs a Technical Product Analyst at Tata Consultancy Services, you will be responsible for working effectively with Acrobat Sign, configuring and using it for document workflows, and architecting API-based workflows that integrate Enterprise Tech Stacks.RequirementsMust-Have SkillsProven ability to work with Acrobat Sign, including...


  • San Jose, California, United States Diverse Lynx Full time

    Key Responsibilities:Lead the design and implementation of Oracle database solutions with a strong focus on scalability and performance.Collaborate with cross-functional teams to ensure seamless integration with existing systems and applications.Develop and maintain Oracle database architecture, ensuring optimal configuration and tuning for maximum...


  • San Jose, California, United States Tata Consultancy Services Full time

    Key Responsibilities:As a Site Reliability Engineer SRE at Tata Consultancy Services, you will be responsible for ensuring the reliability and scalability of our cloud infrastructure. This includes administration experience in Tableau, debugging data pipelines, and monitoring alerts using Grafana, Azure Metrics, Kusto Functions, and LogicApps. You will also...


  • San Jose, California, United States Diverse Lynx Full time

    Database Performance ExpertWe are seeking a skilled Database Performance Expert to join our team at Diverse Lynx LLC. As a key member of our database team, you will be responsible for ensuring the optimal performance of our databases.Key Responsibilities:Experience in performance tuning of database instances, SGA, I/O, and rollback segment.Expertise in SQL...


  • San Jose, California, United States Diverse Lynx Full time

    Job Requirements:As a highly skilled Oracle Database Expert, you will be responsible for ensuring the smooth operation of our Oracle databases. This includes planning and implementing changes to database architecture, optimizing SQL queries, and troubleshooting issues. You will work closely with our development team to ensure that our databases are scalable...


  • San Jose, California, United States Diverse Lynx Full time

    Job Title: Oracle Database AdministratorOverview:Diverse Lynx LLC is seeking a highly skilled Oracle Database Administrator to join our team. As an Oracle DBA, you will be responsible for designing, implementing, and maintaining Oracle databases to ensure optimal performance and security.Responsibilities: Minimum 8+ years of experience in the software...


  • San Jose, California, United States TekisHub Consulting Services Full time

    Job DetailsWe are seeking a highly experienced Oracle Service Cloud consultant to join our team at TekisHub Consulting Services.Key Responsibilities:Minimum 5-7 years of experience in Oracle Service Cloud implementationProven track record of working on at least 3 Oracle Service Cloud implementation projectsStrong understanding of Customer Portal, Customer...


  • San Jose, California, United States Diverse Lynx Full time

    Job SummaryAs a Senior Oracle Database Administrator at Diverse Lynx LLC, you will be responsible for designing, implementing, and maintaining large-scale Oracle databases. You will work closely with the development team to ensure the smooth operation of our database infrastructure. Key ResponsibilitiesDesign and implement Oracle databases to meet the needs...


  • San Jose, California, United States Diverse Lynx Full time

    Job Title: Senior Oracle Database SpecialistJob Summary: We are seeking a highly skilled Senior Oracle Database Specialist to join our team at Diverse Lynx LLC. The ideal candidate will have a strong background in Oracle database concepts and architecture, with a minimum of 8+ years of experience in the software industry.Key Responsibilities:Design and...


  • San Diego, California, United States Tata Consultancy Services Full time

    Job Title: Cloud Infrastructure EngineerAt Tata Consultancy Services, we are seeking a highly skilled Cloud Infrastructure Engineer to join our team. As a key member of our engineering team, you will be responsible for designing, developing, and managing CI/CD pipelines to support Data Lakehouse environments on AWS.Key Responsibilities:Design and implement...

  • Reliability Engineer

    4 weeks ago


    San Francisco, California, United States Resource Informatics Group Full time

    Job Title:Database Systems Administrator - Site ReliabilityKey Responsibilities:Administer large mission-critical Oracle database systemsSet up and administer GoldenGate, RAC, and Data GuardTroubleshoot and optimize database and system performanceRequirements:10+ years of Oracle database administration experienceStrong Linux/UNIX OS understanding and...


  • San Jose, California, United States NR Consulting Full time

    Job SummaryNR Consulting is seeking a skilled Database Systems Specialist to join our team. The ideal candidate will have expertise in Oracle Database and a strong understanding of database performance tuning. Key Responsibilities Identify areas of improvement in database performance and develop strategies to increase efficiency Monitor progress of various...


  • San Jose, California, United States Synoris Information System Pvt Ltd Full time

    Job Title: Oracle Procurement Cloud Lead ConsultantWe are seeking a highly skilled Oracle Procurement Cloud Lead Consultant to join our team at Synoris Information Systems Pvt Ltd.Job Summary:The successful candidate will be responsible for leading the implementation of Oracle Procurement Cloud solutions, ensuring seamless integration with existing systems,...


  • San Diego, California, United States Centraprise Full time

    Job Summary:A seasoned Database Administrator with expertise in Oracle and SQL is sought after to provide production support and manage databases. The ideal candidate will have a strong analytical mindset, excellent communication skills, and hands-on experience with various Oracle database versions, including 10g, 11g, 12c, and 19c, as well as SQL Server...


  • San Jose, California, United States TechStar Group Full time

    This is an exciting opportunity to join Techstar Group as a Senior Oracle ERP Cloud Consultant. We are seeking a highly skilled professional to lead the implementation of Oracle Procurement Cloud solutions for our clients.Key Responsibilities:Develop and implement Oracle Procurement Cloud solutions to meet client requirements.Collaborate with clients to...


  • San Jose, California, United States TechStar Group Full time

    This is an exciting opportunity to join Techstar Group as a Senior Oracle ERP Cloud Consultant. We are currently hiring for a Senior Oracle ERP Cloud Consultant for one of our clients.Please let us know your interest and comfort level with your updated profile, Thanks in advance.Job Description:· Demonstrate expert knowledge of Procurement and Payables with...

  • Software Engineer

    4 weeks ago


    San Jose, California, United States Oracle Full time

    Job DescriptionOracle is seeking a highly skilled Software Engineer to join our team. As a member of our software engineering division, you will play a key role in the definition and evolution of standard practices and procedures.Responsibilities:Design, develop, troubleshoot, and debug software programs for databases, applications, tools, networks, and...