Oracle Performance tuning

1 week ago

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 Performance tuning

    2 weeks ago

    india, IN AMV2 Services Pvt. Ltd. Full time

    Performance tuning - Logical DBAThe 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...

  • Senior Oracle DBA

    2 days ago

    Hyderabad, India Oracle Full time

    Job Description As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical inquiries regarding the use of and fix for our...

  • Senior Oracle DBA

    3 weeks ago

    India Oracle Full time

    Job Description Job Description CSS is industry-leading expertise with the highest customer satisfaction to support organization's business every step of the way. - Available to work in 24X7 capability. - Must have solid Oracle RAC , Golden Gate & Data Guard experience. - Strong Performance tuning skills Query level tuning / DB tuning / Memory level...

  • Oracle Exadata Dba

    2 weeks ago

    India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • Senior Oracle Apps Technofunctional

    2 days ago

    Pune, India Oracle Full time

    Job Description Job Description As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of...

  • Cloud Infrastructure Architect Db

    1 week ago

    India Oracle Full time

    FSRE OAL and SaaS Engineering team manages and implements the technical infrastructure for Oracle and various customers. We are expanding the team and are looking for people with strong technical skills, drive, innovation and enthusiasm. - Bachelor's degree in Computer Science or Software Engineering (or equivalent) - 6-10 years experience in performance...

  • Principal Oci Paas Adminstrator

    1 day ago

    India Oracle Full time

    **Principal OCI PaaS Administrator | IC4** As a Principal OCI PaaS Administrator, you will play a critical role in managing, optimizing, and securing Oracle Database environments on Oracle Cloud Infrastructure (OCI). Leveraging your expertise in PL/SQL tuning and deep knowledge of OCI, you will design, implement, and maintain high-performance database...

  • Principal Technical Analyst

    3 weeks ago

    Bengaluru, India Oracle Full time

    Job Description As a member of support organization, the job focus is to deliver high quality customer service to the Oracle database cloud customer base while serving as an advocate for the customer needs. The job profile involves resolving technical issues mostly raised by customers through the customer portal. The job responsibility includes: - Taking...

  • ▷ Apply in 3 Minutes! Sr.Oracle Service Bus Developer

    1 week ago

    India Oracle Full time

    Job Description - Developing a good understanding of the System(s) Architecture - Fully understand the project requirements and define the To-Be architecture and translate them to the Design - Working independently and perform responsibilities under minimal supervision - Working in global environment with people from diverse cultural backgrounds -...

  • Principal Exadata Dba

    1 day ago

    India Oracle Full time

    Minimum 6+ Years experience as a Oracle database engineer/DBA - Very thorough and clear understanding of Oracle Exadata Architecture. - Extensive knowledge and solid troubleshooting experience in the following areas RAC, ASM, Exadata features, Performance tuning, Multitenant, OEM, Patching, Security, OKV, Data Guard (Physical and Logical) - Including Active...