Oracle Performance tuning

12 hours 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.

  • Senior SRE

    1 day 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 SRE

    15 hours 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...

  • High-Performance Oracle Developer

    7 days ago

    Bengaluru / Bangalore, Delhi, Chennai, India beBeeOracle Full time ₹ 1,04,000 - ₹ 1,30,878

    Job OpportunityWe are seeking an experienced and skilled Oracle developer to join our team.The ideal candidate will have hands-on experience in Informatica PowerCenter and possess excellent knowledge of PL/SQL queries, data mappings, and relational databases.The job involves developing complex PL/SQL packages, procedures, functions, and triggers as well as...

  • Oracle Application Database Administrator

    13 hours ago

    bangalore, India Webologix Ltd INC Full time

    Job Position: ORMB Admin with OCIJob Type: Full-TimeLocation: Pan India (Nearest office LTIMIndtree)Experience: - 3.5+ to 10+ YearsSkill –> ORMB Admin with OCI (Oracle Revenue Billing Management with Oracle Cloud Infrastructure), ORMB WebLogic DBA with OCI experienceKnowledge and skillsProven experience in migrating on premises Oracle EBS 122 and Oracle...

  • Oracle Dba

    11 hours ago

    Bangalore, Karnataka, India virtusa Full time

    Install configure upgrade and patch relational database systems Oracle SQL Server MySQL PostgreSQL Monitor database performance capacity planning and tuning SQL tuning indexing statistics Implement and manage backup recovery strategies RMAN AlwaysOn Data Guard o Ensure data security through proper access controls auditing and encryption...

  • Oracle PL/SQL Developer

    1 day ago

    Bangalore, India Recmatrix Consulting Full time

    Job Title: Oracle PL/SQL Developer Location: ITPL, Bangalore Working model: WFO Role: Permanent/fulltime Experience: 3 to 6 years Notice Period: Immediate to 30 days Responsibilities Design, develop, and maintain Oracle databases , including tables, views, indexes, and other database objects. Write, optimize, and debug complex SQL...

  • Oracle PL/SQL Developer

    13 hours ago

    bangalore, India Recmatrix Consulting Full time

    Job Title: Oracle PL/SQL DeveloperLocation: ITPL, BangaloreWorking model: WFORole: Permanent/fulltimeExperience: 3 to 6 years Notice Period: Immediate to 30 daysResponsibilitiesDesign, develop, and maintain Oracle databases, including tables, views, indexes, and other database objects.Write, optimize, and debug complex SQL queries, stored procedures,...

  • Oracle to Postgres migration

    1 day ago

    Bangalore, India TECEZE Full time

    Job Title: Oracle to PostgreSQL Migration Specialist Job Type: Full-Time Experience: 5–10 years Location: Bangalore Job Summary: We are seeking skilled professionals to lead the migration of Oracle databases to PostgreSQL. The role involves analyzing existing Oracle databases, designing migration strategies, executing the migration,...

  • Oracle Database Administrator

    1 day ago

    Bangalore, India ValueLabs Full time

    **Note*****Notice Max 30 days** **Work From Office** Job description: Experience in Ansible, Jenkins, Terraform and Groovy/Python Excellent knowledge in Oracle database administration Excellent knowledge in Real Application Clusters (RAC) Excellent knowledge in Oracle Dataguard Excellent knowledge in Oracle Cloud Infrastructure (OCI) and AWS ...

  • Oracle Database Administrator

    1 day ago

    Bangalore, India Epsilon Full time

    About Business Unit: A consolidated team of database technology professionals, we provide expertise across all major database engines and Big Data solutions to support Epsilon products and platforms. The team has a unique alignment that combines a horizontal organizational structure with vertically aligned sub-groups dedicated to our clients. By adhering...