Oracle Performance tuning

3 weeks ago

Solapur, Maharashtra, 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.

  • EPM Planning Sr Consultant/Principal/Sr Principal Consultant

    4 weeks ago

    Solapur, Maharashtra, India Oracle Full time

    Oracle GSC is hiring for Oracle EPM Planning Consultants (Sr Consultant/Principal Consultant/Sr Principal)OverviewOracle 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...

  • Functional Consultant- Oracle EBS

    4 weeks ago

    Solapur, Maharashtra, India Marsh McLennan Full time

    Location- Gurugram/Noida/Mumbai/PuneFunctioanl Consultant- Oracle EBS (SME) FinancialsAbout the RoleIn this role, you will work on Oracle applications finance modules support for the company's business solutions within a defined Software Development Lifecycle.Supports and assist other developers/team members in testing and debugs of software programs and...

  • Senior Engineer – Oracle ERP Reporting

    4 weeks ago

    Solapur, Maharashtra, India Talent500 Full time

    Talent500 is hiring for one of its clients.About Talent500:Talent500 is the go-to premium destination for the best global job opportunities at Global Capability Centres or GCCs in India.We believe in opportunities favoring the bold and thus, we help the best tech and non-tech talent find their dream jobs at renowned companies that leads to a transformative...

  • Program/Delivery Manager

    4 weeks ago

    Solapur, Maharashtra, India ARA Resources Pvt. Ltd. Full time

    About The Company:ARAs client Tech Global (pseudonym) is a global leader in strategy, technology consulting and digital services, enabling clients in more than 100+ countries to implement cutting edge solutions in their transformation journey.Role:We are seeking an experienced Oracle HCM Mobilization Program Manager who can combine deep technical expertise...

  • Azure Integration Engineer

    4 weeks ago

    Solapur, Maharashtra, India Dautom Full time

    Job Title: Azure Integration Engineer (Development & Support)Employment Type: Contract - 1 year renewable (Third-party payroll under Dautom IT Consultants LLC)Work Location: Remote (Offshore from India) Can work from the comfort of your home for a government client in DubaiAvailability: Immediate Joiners Preferred (Notice Period: 0 days)Strictly: Independent...

  • Technical Project Lead/Architect/GenAI Lead – AWS Cloud

    4 weeks ago

    Solapur, Maharashtra, India ADP Full time

    Experience: 6-8 years working experience on AWS & GenAI.We are seeking a highly skilled and visionary Technical Lead to spearhead our next-generation AI initiatives. This role demands deep expertise in Large Language Models (LLMs) integration, cloud-native architecture, and hands-on leadership in delivering scalable GenAI solutions on cloud platforms. You...

  • Team Lead-Advanced Data Systems Delivery

    4 weeks ago

    Solapur, Maharashtra, India ArcOne AI Full time

    Team Lead – Advanced Data Systems DeliveryLocation: PuneEmployment Type: Full-TimeDepartment: DeliveryPosition Overview:The Team Lead for Advanced Data Systems Delivery will lead a team responsible for delivering high-performance, scalable data solutions, with a focus on designing and optimizing data architectures for mission-critical Tier 1 systems....

  • Senior Data Scientist LLM T500-18293

    4 weeks ago

    Solapur, Maharashtra, India ANSR Full time

    ANSR is hiring for one of its client.About 4flow:Headquartered in Berlin, Germany, 4flow provides consulting, software and services for logistics and supply chain management. More than 1300 team members leverage their supply chain expertise and IT know-how to best serve their customers at 20+ locations around the world.4flow develops and implements lean,...

  • Ruby on Rails Developer

    4 weeks ago

    Solapur, Maharashtra, India Droisys Full time

    About Company,Droisys is an innovation technology company focused on helping companies accelerate their digital initiatives from strategy and planning through execution. We leverage deep technical expertise, Agile methodologies, and data-driven intelligence to modernize systems of engagement and simplify human/tech interaction.Amazing things happen when we...

  • mdmd edq

    4 weeks ago

    Solapur, Maharashtra, India Best Infosystems Ltd. Full time

    MDMD EDQ_Full-Time_Bangalore/Pune/Navi Mumbai/Noida/Hyderabad/ChennaiJob Title: MDMD EDQLocation: Bangalore/Pune/Navi Mumbai/Noida/Hyderabad/ChennaiJob Type: Full-TimeExperience: 4-6 yearsExperience in EDQ, Integration development preferred. Oracle SQL DB, PL/SQL a must. Knowledge on JDE, PDH, CDH, SQM are preferred. Job...