Oracle Performance tuning

2 days ago

bangalore, 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.

  • Fully Remote

    2 weeks ago

    Bangalore, India Oracle Full time

    At Oracle Cloud Infrastructure (OCI), we build the future of the cloud for Enterprises as a diverse team of fellow creators and inventors. We act with the speed and attitude of a start-up, with the scale and customer-focus of the leading enterprise software company in the world. Cloud pretty much cannot exists without our org. We develop and operate...

  • Senior sre

    2 weeks ago

    Bangalore, India Oracle Full time

    At Oracle Cloud Infrastructure (OCI), we build the future of the cloud for Enterprises as a diverse team of fellow creators and inventors. We act with the speed and attitude of a start-up, with the scale and customer-focus of the leading enterprise software company in the world. Compute is one of the core organisations within OCI. We are responsible for...

  • Senior Fusion Middleware Consultant

    3 days ago

    bangalore, India Oracle Full time

    We are looking at Oracle WebLogic Administrator who will be responsible for deploying and supporting middleware applications using Oracle WebLogic products. The ideal candidate will have a minimum 5 years of experience with middleware administration in a large enterprise environment with a focus on WebLogic. Responsibilities: Oracle FUSION WebLogic...

  • ▷ Immediate Start! Senior Oracle Database Administrator

    2 weeks ago

    Bangalore, Karnataka, India ORACLE Full time

    Job Category Consulting We are looking for a highly capable self-motivated and independent Database Administrators based in India If you are passionate about Oracle database technology as well as cloud computing this is the ideal role you ve been waiting for Our DBA team supports databases which are available both on-premise and on Cloud In this role ...

  • Oracle Fusion Hcm Technical Consultant

    2 weeks ago

    Bangalore, Karnataka, India ORACLE Full time

    Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications Standard assignments...

  • Oracle Exadata Engineer

    2 weeks ago

    Bangalore, India Relevance Lab Full time

    Job Description – Oracle Exadata Engineer We 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 exadata engineer

    1 week ago

    Bangalore, India Relevance Lab Full time

    Job Description – Oracle Exadata Engineer We 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...

  • Production Service Systems Administrator 3

    2 weeks ago

    Bangalore, Karnataka, India ORACLE Full time

    Hands on experience in DBA 12c 19c is mandatoryHands on experience in Weblogic administration is mandatory Hands on experience in in DB patching and upgrade Monitor and optimize system performance Thorough knowledge of DB Performance SQL Tuning Strong knowledge of SQL and PL SQL code review Troubleshoot and resolve performance issues at the database and...

  • Principal Engineer, Css Global Saas

    5 days ago

    Bangalore, Karnataka, India ORACLE Full time

    Job Category Product Development We are looking for a versatile Senior Developer Database Engineer with expertise across AI ML cloud-native development DevOps and enterprise database administration In this role you will work on building and optimizing AI ML pipelines developing scalable cloud-based applications and managing mission-critical...

  • Oracle Database Administrator

    7 days ago

    bangalore, 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,...