Oracle Performance tuning

3 weeks 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 Flexcube

    2 weeks ago

    india, IN Dautom Full time

    Role Overview:We are looking for a Technical Consultant with strong experience in Oracle FCUBS Islamic modules to handle report development, data extraction, and performance optimization.Key Responsibilities:Develop and optimize reports within Oracle FCUBS (Islamic modules).Perform data extraction, validation, and transformation for reporting.Tune SQL/PLSQL...

  • Oracle Technical Consultant

    2 weeks ago

    india, IN Recro Full time

    Role : Oracle Application Technical ConsultantProven experience (8+ years) as an Oracle Apps Technical consultant for Oracle E-Business Suite (R12 or later).Strong expertise in Oracle PL/SQL, SQL, Oracle Forms, Reports, Workflow, triggers, and custom interface/integration development.Deep knowledge of Oracle EBS modules (Supply Chain, Finance).Experience...

  • Oracle Consultant

    2 weeks ago

    india, IN Digile Full time

    7+ years of hands-on experience with ODI and OIC in enterprise Oracle ERP integration and migration projects.Proven experience leading integrations from source systems to Oracle ERP Cloud, including master and transactional data flows.Strong expertise in:ODI ETL/ELT development and performance tuningOIC integration flows, adapters, orchestration, and error...

  • Oracle Database Administrator

    2 weeks ago

    , India, IN Tekskills Inc. Full time

    Lead Oracle DBA – OSS/BSS Transformation ProgramLocation: HyderabadExperience: 10–14 YearsShift: UK Shift (1 PM – 10 PM IST)Immediate HireWe are seeking a Lead Oracle DBA to drive the database migration, upgrade, and DR implementation for a large-scale OSS/BSS Transformation Program. This includes transitioning Oracle Communications applications...

  • Oracle Exadata Engineer

    3 weeks 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...

  • Oracle Technical Consultant

    2 weeks ago

    india, IN Recro Full time

    Job Title: Oracle Apps Technical ConsultantExperience: 8+ YearsWork Mode: RemoteJob Summary:We are looking for a highly skilled Oracle Apps Technical Consultant with strong hands-on experience in Oracle E-Business Suite (R12 or later). The ideal candidate will have deep technical expertise in PL/SQL, Forms, Reports, Workflows, and custom...

  • Senior ORMB Developer- OUAF

    2 weeks ago

    Bangalore Urban, Karnataka, India, IN Oracle Full time

    Our Team“ORMB” Consulting – Oracle Revenue and Management Billing. Consulting group is responsible for supporting and making its customer successful in implementing Pricing and Billing engine for revenue management. Oracle’s ORMB consulting group covers customers across the globe in various line of businesses like Banking, insurance and healthcare....

  • Senior Oracle Exadata DBA

    3 weeks 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...

  • Oracle Integration Backend API, Fusion

    2 weeks ago

    india, IN DeepLLMData Full time

    Company DescriptionDeepLLMData excels in providing human expertise to power advanced frontier models. Our offerings include coding SFT (Structured Fine-Tuning) and RLHF (Reinforcement Learning with Human Feedback), as well as STEM, PhD, and domain-specific experts. We also provide image and video annotators and data provisioning services.Role...

  • Oracle Retail Consultant

    2 weeks ago

    Bangalore Urban, Karnataka, India, IN Tata Consultancy Services Full time

    TCS present an excellent opportunity for Oracle Retail ConsultantJob Location: BangaloreExperience required : 5-8 yrsSkills: SQL/PLSQL, Unix, Oracle Forms, JAVAMust-Have**(Ideally should not be more than 3-5)1. Functional Knowledge in Oracle Retail modules ( RMS, RPM, ReIM, ReSA, RTM, etc. )2. SQL/PLSQL3. Unix, ProC4. Oracle FormsGood-to-Have1. Core Java2....