Oracle Performance tuning

3 weeks ago

Pushkar, India 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 Database Administrator

    2 weeks ago

    Pushkar, India Sky Systems, Inc. (SkySys) Full time

    Role: Oracle Database Administrator (DBA)Position Type: Full-Time Contract (40hrs/week)Contract Duration: Long TermWork Hours: 3:30 AM to 1:00 PM ESTWork Schedule: 8 hours/day (Mon-Fri)Location: 100% RemoteWe are seeking an experienced Oracle DBA with strong expertise in managing Oracle databases on AWS (EC2/RDS). The role involves deploying, configuring,...

  • .Net Architect

    5 days ago

    Pushkar, India SourceFuse Full time

    SourceFuse Technologies hiring .NET ArchitectSkills & Abilities:● 10+ years complete SDLC experience● 4+ years of Architect experience● 7+ years browser-based (intra/internet) development● Well versed with Microsoft .Net Framework, .NET Core● Well versed in SQL server (Current and 2 prior versions)● Well versed with Visual Studio Development...

  • Offshore Contract

    4 weeks ago

    Pushkar, Rajasthan, India KPG99 INC Full time

    HiHope you are doing wellPlease look at below mentioned Job Description and share your updated resume and mention Current Location .If the JD match with your skills.Role: Oracle Costing Analyst Location: India (Remote)Duration: Offshore Contract Job Description:We are seeking an experienced Oracle Costing Consultant to support our ongoing Oracle...

  • Datapath Engineer

    2 weeks ago

    Pushkar, India Novelus Full time

    Who We’re Looking For:We are currently hiring a dynamic Datapath Engineer to support our team remotely.What You'll Do:Work on debugging the performance bottleneck of Datapath software on multi-core, multi-thread and NUMA architecture using profiling toolsEnhance the software to achieve line-rate performanceBe the subject matter expert on Intel DPDK related...

  • AI LLM Research Engineer

    5 days ago

    Pushkar, India FlashIntel Full time

    Role OverviewFlashIntel is seeking a dedicated and innovative Research Engineer with a focus on Multimodal Large Language Models (m-LLMs), Text-to-Speech (TTS) technologies, and agentic workflows. This position offers a unique opportunity to engage in cutting-edge research and development of AI solutions that integrate various data modalities and enhance...

  • Sap Embedded Analytics Associate Managing Consultant-

    4 weeks ago

    Pushkar, Rajasthan, India HARP Full time

    Permanent with one of reputed MNC companyRole - SAP Embedded Analytics Associate Managing Consultant Summary The SAP Technical Embedded Analytics Associate Managing Consultant is responsible for leading and managing the design, development, and implementation of SAP Embedded Analytics solutions.This role involves overseeing projects, managing teams, and...

  • Big Data Engineer

    4 weeks ago

    Pushkar, Rajasthan, India Idyllic Services Full time

    Job Title: Big Data Engineer – ScalaLocation: Bangalore, Chennai, Gurgaon, Pune, Mumbai.Experience: 7–10 Years (Minimum 3+ years in Scala)Notice Period: Immediate to 30 DaysMode of Work: Hybrid Role OverviewWe are looking for a highly skilled Big Data Engineer (Scala) with strong expertise in Scala, Spark, Python, NiFi, and Apache Kafka to join our data...

  • Principal Engineer- Platform

    2 weeks ago

    Pushkar, India Talentiser Full time

    Summary of RoleParticipate in design, development, test, and maintenance.Develop and maintain complex Linux systems software to support deployment, upgrade, and day-to-day operation operations for the NAS appliance.Write automated tests and contribute to build/release workflows.Debug and fix bugs reported by customers, support, QA, and development.Work with...

  • Lead Data Scientist-Gen AI

    4 weeks ago

    Pushkar, Rajasthan, India YASH Technologies Full time

    Job Overview: We are looking for a AI/ML Developer to join our team of researchers, data scientists, and developers. You will work on cutting-edge AI solutions across industries such as commerce, agriculture, insurance, financial markets, and procurement. Your role involves developing and optimizing machine learning and generative AI models to solve...

  • Senior Manager

    4 weeks ago

    Pushkar, Rajasthan, India SPIRO Full time

    Job Title: Financial Planning & Analysis (FP&A) ManagerLocation: Dubai, UAECompany: SpiroAbout Spiro:Spiro is a fast-growing organization at the intersection of innovation and operational excellence. We are looking for a sharp and strategic FP&A Manager to join our finance team in Dubai. This role is key to driving financial visibility, performance tracking,...