PTC Logo

PTC

Software Technical Consultant (Oracle DB Development)

Reposted 4 Days Ago
Be an Early Applicant
In-Office
Pune, Maharashtra, IND
Expert/Leader
In-Office
Pune, Maharashtra, IND
Expert/Leader
Design, develop, and optimize Oracle databases and PL/SQL for a SaaS multi-tenant application. Analyze and refactor queries, troubleshoot customer issues, identify and remove database bottlenecks, and collaborate with engineering teams to deliver high-performance database solutions.
The summary above was generated by AI

Our world is transforming, and PTC is leading the way. Our software brings the physical and digital worlds together, enabling companies to improve operations, create better products, and empower people in all aspects of their business. 

Our people make all the difference in our success. Today, we are a global team of nearly 7,000 and our main objective is to create opportunities for our team members to explore, learn, and grow – all while seeing their ideas come to life and celebrating the differences that make us who we are and the work we do possible.  

At Arena, a PTC Business, we help high tech manufacturers and medical device companies create products that change the world. Our cloud-based product lifecycle management (PLM) and quality management (QMS) software is used by leading product innovators like Nutanix, Bio-Rad, Sonos, Teleflex, and Citrix. Join our PTC family and you will thrive in an award-winning workplace that fosters a work-life balance.

 

Responsibilities:

 

Being a part of Arena Engineering team:

 

  • Work with development teams and product managers to ideate software solutions.
  • Design databse queries tables & PL/SQL development.
  • Develop optimized PL/SQL code that serves multiple customers with high performance.
  • Develop and manage well-functioning databases and applications
  • Analyse existing database design and PL/SQL and refactor the queries wherever applicable to improv the performance.
  • Troubleshoot, debug internal and customer bugs to provide well optimized database solution.
  • Identify any bottleneck in database related implementation or deployment architecture to reslve any existing isues.

Must Have Skills and Knowledge:

  • 11-13 years of Proven experience in database SQL & PL/SQL development or similar role
  • Experience developing enterprise applications with more PLSQL development where more of the business logic resides.
  • Optimize existing oracle database and design optimized database for SaaS based multi-tenant application.
  • Analyse customer issues and provide optimized solutions to resolve them quickly.
  • Identify bottlenecks in the database for the SaaS application and tune th database to performa optimally.
  • Strong knowledge in databse configuration and performance tunings like partitioning, indexting, memory management etc.,
  • Handson experience or knowledge of other databases like postgres-SQL
  • Hnadson experience in hadlng large volume of data and optimize the database to perform quickly.
  • Strong knowledge Oracle SQL and PL/SQL development.
  • Having working experience with Oracle RAC to configure and understanging of the implementations.
  • Having experience in using various SQL front end tools like SQL developer, TOAD, DBVisualizer etc.,
  • Excellent communication and teamwork skills
  • Ability to prioritize and manage multiple tasks and milestones efficiently

Good to have skills:

  • Handson experience or knowledge of other databases like postgres-SQL.
  • Having basic Java and REST API implementation experience.
  • Knowledge on any modern UI frameworks like Angular or ReactJS
  • Experience in developing SaaS based applications

 

Basic Qualifications:

  • Graduate / BE / B Tech / ME/ Mtech/ MCA / MSc Computer Science with excellent academics.
  • 11-13 years’ relevant experience in quality assurance domain covering all phases of SDLC.
  • Strong verbal and written communication skills.
  • Excellent problem-solving skills
  • Good Team Player and working experience with multi location teams.





Life at PTC is about more than working with today’s most cutting-edge technologies to transform the physical world. It’s about showing up as you are and working alongside some of today’s most talented industry leaders to transform the world around you. 

If you share our passion for problem-solving through innovation, you’ll likely become just as passionate about the PTC experience as we are. Are you ready to explore your next career move with us?

We respect the privacy rights of individuals and are committed to handling Personal Information responsibly and in accordance with all applicable privacy and data protection laws. Review our Privacy Policy here."

PTC Pune, Mahārāshtra, IND Office

Marisoft - II, Survey No. 15, Vadgaonsheri, Kalyani Nagar, Pune, India

Similar Jobs

18 Minutes Ago
Remote or Hybrid
India
Entry level
Entry level
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Provide onsite and remote IT support to internal and external users, handle high-volume service desk tickets, troubleshoot Microsoft OS/Office/Exchange/AD and network/infra issues, track KPIs and SLAs, participate in on-call rotational shifts, produce documentation, and ensure compliance with ITIL and security policies.
Top Skills: Active DirectoryInfrastructureItilMessagingMicrosoft ExchangeMS OfficeWindowsNetworking
22 Minutes Ago
Easy Apply
Remote or Hybrid
India
Easy Apply
Mid level
Mid level
Big Data • Cloud • Software • Database
Manage full-cycle recruiting for People and Finance roles across business units. Source candidates via advanced techniques and tools, partner with hiring managers, maintain ATS data accuracy, and deliver a high-touch candidate experience from outreach through offer execution.
Top Skills: AtsBoolean SearchCRMGemGreenhouseLinkedin Recruiter
An Hour Ago
In-Office
Expert/Leader
Expert/Leader
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
The Head ASP Management is responsible for procurement of ASP services, vendor relationships, contractual compliance, quality delivery, and supplier performance evaluation while driving cost efficiency and improvements in service delivery processes.
Top Skills: AspMicrowaveOhsRan

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account