Oracle Performance tuning

5 days 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

    1 week ago

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

  • Principal Dba

    7 days ago

    India Oracle Full time

    Database administration - Design and implement **database migration strategies**using **OCI Data Pump, GoldenGate, and Oracle Cloud MAA best practices**. - Database RU Patching in Exadata DB systems. - Database upgrade. **GoldenGate Administration & Data Replication** - Deploy, configure, and manage **Oracle GoldenGate**for real-time data replication and...

  • Oracle Performance tuning

    6 days 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...

  • Oracle Performance tuning

    5 days 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...

  • Oracle Performance tuning

    6 days ago

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

  • Principal Oracle Psft Admin

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

  • Urgent Search) Senior Oracle Database Administrator

    6 days 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...

  • Cloud Infrastructure Architect Db

    2 weeks 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

    4 days 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...

  • Application Developer

    5 days ago

    India Oracle Full time

    Job Description PL/SQL Developer - Oracle, SQL Tuning Our Team We work for one of the largest multi-national banks (Client) with presence across the globe. We work on Supply Chain Finance domain and is one of the industry leading solution for the Client. We are responsible for the enhancements to the existing platform to cater to the growing business...