Skip to main content
HCL Worldwide Navigation
  • Contact Us

Close

En
EnglishJapanese
Menu Trigger
HCLTech
Main Navigation
  • Capabilities
    • HCLTech
      • AI & Generative AI
      • Cloud
      • Engineering
      • Software
    • HCLTech
      • Application Services
      • Automation
      • Business Process Operations
      • Commercial Apps / SaaS
      • Cybersecurity
      • Data and AI
      • Digital Design and Manufacturing Services
      • Digital Engineering
      • Digital Workplace
      • EdTech
    • HCLTech
      • Global Capability Center (GCC)
      • Intelligent Operations
      • Internet of Things (IoT)
      • Marketing Services
      • Networks
      • Operational Technology
      • Product Engineering
      • Supply Chain
      • Unified Service Management (USM)
  • Industries
    • HCLTech
      • Aerospace and Defense
      • Automotive
      • Consumer Goods
      • Energy and Utilities
      • Life Sciences and Healthcare
      • Manufacturing
      • Mining and Natural Resources
    • HCLTech
      • Oil and Gas
      • Public Sector
      • Retail
      • Semiconductor
      • Technology
      • Telecom Media and Entertainment Services
      • Travel, Transport, Logistics & Hospitality
    • Financial Services
      • Financial Services
      • Financial Services Overview
      • Banking
      • Capital Markets
      • Financial Crime Compliance and Risk
      • Fintech
      • Insurance
  • Ecosystem
  • About Us
    • About Us Overview
    • Analyst Recognitions
    • Annual Report 2024
    • Awards and Recognition
    • Code of Business Ethics and Conduct
    • Corporate Social Responsibility
    • Diversity, Equity and Inclusion
    • Global Presence
    • Investor Relations
    • Leadership
    • Newsroom
    • Privacy Trust Center
    • Strategic Alliances
    • Supercharging Progress
    • Sustainability
    • Sustainability Report 2024
    • ABOUT BLANK MENU
  • Resources
    • Trends and Insights
    • Case Studies
    • Events and Webinars
  • Careers
    • Careers Overview
    • Careers by LoB
      • Digital Business
      • Digtial Foundation
      • Engineering
    • Americas
      • Brazil
      • Canada
      • Costa Rica
      • Guatemala
      • Mexico
      • United States
    • Asia Pacific
      • Australia
      • Malaysia
      • New Zealand
      • Philippines
      • Singapore
      • Sri Lanka
      • Vietnam
    • Europe and Africa
      • Bulgaria
      • Germany
      • Hungary
      • Morocco
      • Poland
      • Portugal
      • Romania
      • Spain
      • Sweden
      • United Kingdom
    • India
    • Meet our people
    • Explore job opportunities
  • Contact Us
  • Our Global Presence
En
EnglishJapanese

Close

Home
    ›
  • Careers
  • ›
  • Careers in India
  • ›
  • Associate consultant

Job Description

Associate consultant

Job Summary

  • Location: Noida

  • Project role: Associate consultant

  • Qualification: B.E, B-Tech

  • Experience: 4.5-8 Years

  • Skills: Oracle

  • No. of positions: 1

Job description:

Support ongoing efforts and provide technical support for multiple database re-platforming efforts to Exadata.\\r\\n Reviewing and implementing data loading scripts related to Golden Gate data replication.\\r\\n Optimization and tuning of SQL queries and indexes in Oracle.\\r\\n Working knowledge of Oracle 12c/Oracle 19c/Exadata added capabilities and functionality.\\r\\n Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) a plus.\\r\\n Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, and Hints.\\r\\n Strong knowledge of database triggers, indexes, and partitioning.\\r\\n Expertise in Oracle architecture. \\r\\n Proficient in reading Query Execution Plans with the ability to evaluate and improve performance characteristics of SQL.\\r\\n Manage database objects like table space, users, indexes, roles, privileges, profiles, and synonyms.\\r\\n Monitoring of the database performance as it relates to memory usage, proper backups, active sessions, long-running queries, tablespace configuration, and space allocations. \\r\\n Coordinate with data architects and analysts on the building of schemas, tables, functions, views, stored procedures, and roles.\\r\\n Coordination with the automation team for the scheduling of various AWA/RMJ jobs to be executed on multiple databases.\\r\\n Provide DBA supervision and Oracle best practices guidance for custom application development and routine database administration efforts.

  • To adhere to quality standards, regulatory requirements and company policies
  • To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions / Reopen Cases
  • To participate or contribute on EN business in creation of proposals to drive Service improvement plans.
  • To independently resolve tickets & esnure that the agreed SLA of ticket volume and time are met for the team.
  • To provide support for on call escalations /L3 level support and doing incident & problem management
  • Work on value adding activities such Knowledge base update & management, Training freshers, coaching analysts & conducting interviews/participation in hiring drives.

Apply
BT Footer
  • Capabilities
    • Capabilities col 1
      • AI & Generative AI
      • Cloud
      • Engineering
      • Software
    • Capabilities col 2
      • Application Services
      • Automation
      • Business Process Operations
      • Commercial Apps / SaaS
      • Cybersecurity
      • Data and AI
      • Digital Design and Manufacturing Services
      • Digital Engineering
      • Digital Workplace
      • EdTech
      • Global Capability Center (GCC)
      • Intelligent Operations
      • Internet of Things (IoT)
      • Marketing Services
      • Networks
      • Operational Technology
      • Product Engineering
      • Supply Chain
      • Unified Service Management (USM)
  • Industries
    • Aerospace and Defense
    • Automotive
    • Consumer Goods
    • Energy and Utilities
    • Life Sciences and Healthcare
    • Manufacturing
    • Mining and Natural Resources
    • Oil and Gas
    • Public Sector
    • Retail
    • Technology
    • Telecom Media and Entertainment Services
    • Travel, Transport, Logistics & Hospitality
    • Financial Services
    • Banking
    • Capital Markets
    • Financial Crime Compliance and Risk
    • Fintech
    • Insurance
  • Columns group 2
    • Ecosystem
    • About Us
      • About Us Overview
      • Analyst Recognitions
      • Annual Report 2024
      • Awards and Recognition
      • Code of Business Ethics and Conduct
      • Corporate Social Responsibility
      • Diversity, Equity and Inclusion
      • Global Presence
      • Investor Relations
      • Leadership
      • Newsroom
      • Privacy Trust Center
      • Strategic Alliances
      • Supercharging Progress
      • Sustainability
      • Sustainability Report 2024
    • Resources
      • Trends and Insights
      • Case Studies
      • Events and Webinars
  • Columns group3
    • Careers
      • Careers Overview
      • Meet our people
      • Explore job opportunities
      • Careers by LoB
        • Digital Business
        • Digtial Foundation
        • Engineering
      • Americas
        • Brazil
        • Canada
        • Costa Rica
        • Guatemala
        • Mexico
        • United States
      • Asia Pacific
        • Australia
        • Malaysia
        • New Zealand
        • Philippines
        • Singapore
        • Sri Lanka
        • Vietnam
      • Europe and Africa
        • Bulgaria
        • Germany
        • Hungary
        • Morocco
        • Poland
        • Portugal
        • Romania
        • Spain
        • Sweden
        • United Kingdom
      • India
    • Global Presence
      • Global Presence Overview
      • Americas
        • Brazil
        • Canada
        • Costa Rica
        • Guatemala
        • Mexico
        • United States
      • EMEA
        • Austria
        • Belgium
        • Bulgaria
        • Czech Republic
        • Denmark
        • Finland
        • France
        • Germany
        • Hungary
        • Ireland
        • Italy
        • Lithuania
        • Luxembourg
        • Morocco
        • The Netherlands
        • Norway
        • Poland
        • Portugal
        • Romania
        • Saudi Arabia
        • South Africa
        • Spain
        • Sweden
        • Switzerland
        • UAE
        • United Kingdom
      • APAC
        • Australia
        • China
        • Hong Kong
        • India
        • Japan
        • Malaysia
        • New Zealand
        • Philippines
        • Singapore
        • South Korea
        • Indonesia
        • Taiwan
        • Thailand
        • Vietnam
En
EnglishJapanese
  • Facebook 
  • Twitter 
  • LinkedIn 
  • Instagram 
  • Youtube 
  • Threads

We use cookies on our site. Please read more about cookies policy here.

Copyright © 2023 HCL Technologies Limited

Pre footer link
  • Contact Us
  • Disclaimer
  • Privacy Statement
  • Terms of use
  • Sitemap
  • Raise a Grievance