Oracle Performance tuning

9 hours ago

india, IN AMV2 Services Pvt. Ltd. Full time

Performance tuning - Logical DBA


The primary responsibilities of the Database Administrator include supporting database operations including but not limited to performance monitoring, query optimization, code deployments, access management, and database analysis. The candidate will be responsible for operating in Oracle, and Exadata database re-platforming efforts. They will be responsible for creating database objects, investigating performance issues, and monitoring data retention. They will work closely with data architects, data analysts, and database owners to support both short-term work requests and long-term strategy implementation. The candidate must have strong technical and communication skills coupled with the ability to convey their findings and recommendations to large groups.


Must have skills on :

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


Qualifications

  • 5+ years of logical and physical DBA experience, including experience in Oracle Exadata.
  • Extensive working knowledge of all aspects of Database Data Movement and Processing, including Golden Gate and Informatica ETL.
  • Familiarity with JIRA workflow processes and agile methodology.
  • Working experience with TOAD or Oracle SQL Developer.
  • Good Communication skills.
  • Self-Motivated.
  • Works well in a team environment.

  • Oracle Exadata Engineer

    9 hours ago

    Bangalore Urban, Karnataka, India, IN Relevance Lab Full time

    Job Description – Oracle Exadata EngineerWe are looking for an experienced Oracle Exadata Engineer with strong expertise in migrating Oracle Databases from standard Oracle platforms to Exadata. The ideal candidate should have 8–10 years of hands-on experience in database engineering, administration, and migration, with proven success in large-scale...

  • Senior Oracle Exadata DBA

    9 hours ago

    india, IN Centrilogic Full time

    Senior Oracle Exadata DBA – Advisory ServicesAs part of the Advisory Services organization, the role of the Senior Oracle Exadata Database Administrator will be responsible for the implementation, configuration, maintenance, and performance of critical Oracle RDBMS systems, including Exadata and Oracle Cloud Infrastructure (OCI), to ensure availability and...

  • Architect- Oracle Sevice Bus

    9 hours ago

    Gurugram, Haryana, India, IN Digile Full time

    Key ResponsibilitiesArchitect and design OSB-based integration solutions, ensuring scalability, reliability, and maintainability.Translate business requirements into technical specifications and integration blueprints.Develop and optimize integration patterns, including service orchestration, mediation, transformation, and routing.Lead implementation, guide...

  • Oracle cloud consultant

    9 hours ago

    india, IN TalentBridge Full time

    Oracle Cloud HCM ConsultantRemoteFull Time PermanentPosition OverviewWe are seeking an experienced Oracle Cloud HCM Consultant with expertise across multiple functional modules, including Recruitment, Learning, Talent Management (Career Planning & Performance), Payroll (UK Payroll), and Helpdesk. The ideal candidate will be responsible for designing,...

  • Oracle HCM Consultant

    9 hours ago

    india, IN TalentBridge Full time

    Role: Sr. Oracle HCM ConsultantLocation: Remote (Need to be from the following location)Maharashtra: Mumbai, Pune, Navi Mumbai, ThaneKarnataka: Bengaluru/BangaloreHaryana: GurugramUttar Pradesh: Noida, Lucknow, Greater Noida, GhaziabadHiring for the following domains:Oracle Cloud RecruitmentOracle Cloud LearningCloud Talent Management, Career Planning &...

  • Oracle HCM Functional Consultant

    9 hours ago

    india, IN Intellicore Consulting Group Full time

    About the Company - Intellicore is a global services provider with a focus exclusively on delivering world class services in the domains of Oracle Enterprise Resource Planning, Enterprise Performance Management, Business Intelligence & Analytics and Digital Transformations.Job Summary:We are looking for a skilled Oracle Fusion HCM Functional Consultant to...

  • Senior Full Stack Java Developer

    9 hours ago

    Bangalore Urban, Karnataka, India, IN Oracle Full time

    This role does not offer Visa/Work Permit sponsorshipJob Requirements:Proficient Full Stack developer with Java/J2EE.Proficient in REST services and micro service architectureProficient in Mysql Queries or any Backend technologies.Experience in common open source Software and tools such as Docker, Kubernetes, Jenkins, GIT or other Continuous...

  • Oracle Fusion Technical Developer

    9 hours ago

    , India, IN H&P Full time

    About UsSince 1920, Helmerich & Payne, Inc. (H&P) has been the industry’s most trusted partner in drilling productivity and reliability. We continue that legacy with a strategy focused on long-term profitable growth and high-quality, innovative products and services. We are committed to improving lives through efficient and responsible energy. H&P expanded...

  • Oracle Business Suite Consultant

    9 hours ago

    india, IN TalentBridge Full time

    Oracle E-Business Suite (EBS) HCM ConsultantRemoteFull Time PermanenetPosition OverviewWe are seeking an experienced Oracle E-Business Suite (EBS) HCM Consultant with expertise across Compensation & Benefits, Payroll (Technical), Career Development, and Core HR techno-functional domains. The ideal candidate will play a key role in implementing, supporting,...

  • Oracle Cloud Security and Risk Management

    9 hours ago

    india, IN Atom Full time

    Job Title: Oracle Cloud Security and Risk Management (RMC) Consultant Experience: 5–7 Years Location: India OffshoreJob Summary:We are seeking an experienced Oracle Cloud Security and Risk Management (RMC) Consultant to join our team. The ideal candidate will have 5–7 years of hands-on experience in Oracle Fusion Security, Oracle Cloud Infrastructure...