Oracle Performance tuning

19 hours ago

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

    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

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

  • DBA/RAC/Dataguard

    5 days ago

    Delhi, India Oracle Full time

    The Advanced Customer Services (ACS) is a unit within the Oracles Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. ACS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. ACS services are...

  • Oracle Fusion SCM Fuctional Lead

    7 days ago

    delhi, India Oracle Full time

    Working Location:Bangalore, Hyderabad, Chennai , NCR , Pune , Mumbai , Gandhinagar , KolkataOverviewOracle 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 cater to the needs...

  • Oracle Fusion SCM Sr Functional Consultant

    19 hours ago

    Delhi, India Oracle Full time

    Working Location: Bangalore, Hyderabad, Chennai , NCR , Pune , Gandhinagar , KolkataJob DescriptionAs an Oracle SCM Functional specialist, you will be working both at offshore and onshore client engagements which involves implementation of Oracle SCM Cloud modules. You will be interacting with the customer to understand their business processes and map them...

  • Oracle Database Administrator

    21 hours ago

    Delhi, India Sky Systems, Inc. (SkySys) Full time

    Role: Oracle Database Administrator (DBA) Position Type: Full-Time Contract (40hrs/week) Contract Duration: Long Term Work Hours: 3:30 AM to 1:00 PM EST Work Schedule : 8 hours/day (Mon-Fri) Location : 100% Remote We are seeking an experienced Oracle DBA with strong expertise in managing Oracle databases on AWS (EC2/RDS). The role involves deploying,...

  • Oracle Dba Avdf

    1 week ago

    Delhi, Delhi, India NetConnect Global Full time

    Job description Location-Delhi **Salary**: 25- 30 LPA **Experience**: 7 -10 Years Notice Period - Immediate to 15 days. Mode of Work - Work from Office Must-Have. - Experience in Oracle Enterprise Manager (OEM) 11g/12c/13c is a plus. - Knowledge of DB Security viz. AVDF, DB Vault, Oracle Key Vault, e-Wallet, and TDE would be added advantages. -...

  • High-Performance Oracle Developer

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

    1 week ago

    Delhi, India Mastech Digital Full time

    Position:Oracle Application Database AdministratorLocation:RemoteDuration:Full Time and Full Time ContractorsNotice Period:Only Immediate Joiners/ Currently Serving Notice/ Notice is less than 30 daysBudget : 10-16 LPA for Full Time and 15-25 LPA for Contract (For Contract- No PF, No Gratuity, No leaves, No benefits)Year of experience:6 - 12 yearsWe are only...

  • Oracle Cloud Engineer

    19 hours ago

    Delhi, India Optimal Virtual Employee Full time

    Job Description: Oracle Cloud Engineer (ERP, PaaS, APEX, DB, and AI Integration)Position Title: Oracle Cloud Engineer (ERP, PaaS, APEX, DB, and AI Integration)Location: RemoteExperience: 5-8 YearsJob Overview:We are seeking a highly skilled and motivated Oracle Cloud Engineer to join our dynamic consultancy team. The ideal candidate will have strong...