Oracle Performance tuning

3 days ago

New Delhi, India 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 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

    1 week ago

    Delhi, India 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...

  • Oracle Performance tuning

    6 days ago

    Delhi, India 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...

  • Oracle Performance tuning

    3 weeks ago

    Delhi, India 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...

  • Oracle Middleware Administrator

    2 weeks ago

    Delhi, Delhi, 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 inquiries regarding the use of and troubleshooting for our...

  • OSB Developer

    1 day ago

    New Delhi, India Oracle Full time

    OSB DeveloperLocation- Bangalore/Chennai/Pune/MumbaiExp Range- 4-15 YearsDeveloping 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...

  • Fircosoft – Tuning

    3 weeks ago

    Delhi, India People Prime Worldwide Full time

    Title : Fircosoft – TuningLocation: Working Location in ChennaiDuration: Full TimeCREQ: Kindly upload other RAK Positions for nowMinimum of 13 years of experience.Strong analytical skills required to organize and analyses multiple, complex data sets as well as strong interpersonal and organizational skills.Leadership skills to manage both on shore and...

  • Fircosoft – Tuning

    3 weeks ago

    Delhi, India People Prime Worldwide Full time

    Title : Fircosoft – TuningLocation: Working Location in ChennaiDuration: Full TimeCREQ: Kindly upload other RAK Positions for nowMinimum of 13 years of experience.Strong analytical skills required to organize and analyses multiple, complex data sets as well as strong interpersonal and organizational skills.Leadership skills to manage both on shore and...

  • Oracle EPM Consultant

    3 days ago

    New Delhi, India Oracle Full time

    Oracle GSC is hiring for EPM Consultants ARCS Sr Developer/Leads Job Locations - PAN India (Bengaluru, Mumbai, Chennai, Hyderabad, Noida, Pune, Kolkata, Gandhinagar, Gurgaon)Overview Oracle Global Service Center (GSC) is a unit within oracle that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and...

  • Oracle EPM Consultant

    1 day ago

    New Delhi, India Oracle Full time

    Oracle GSC is hiring for EPM Consultants ARCS Sr Developer/LeadsJob Locations - PAN India (Bengaluru, Mumbai, Chennai, Hyderabad, Noida, Pune, Kolkata, Gandhinagar, Gurgaon)Overview Oracle Global Service Center (GSC) is a unit within oracle that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and...

  • Oracle EPM Planning Sr Consultant/Principal/Sr Principal Consultant

    3 days ago

    New Delhi, India Oracle Full time

    Oracle GSC is hiring for Oracle EPM Planning Consultants (Sr Consultant/Principal Consultant/Sr Principal)Overview Oracle Global Service Center (GSC) is a unit within oracle that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project-based one-time services. It is an offshore Hub that will...