Software Technical Consultant (Oracle DB Development)

Reposted 4 Days Ago
Be an Early Applicant
Pune, Maharashtra, IND
In-Office
Expert/Leader
Information Technology • Internet of Things • Software • Virtual Reality
We Are Innovators. We Are Creators. We Are PTC.
The Role
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.
Summary Generated by Built In

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

Skills Required

  • 11-13 years proven experience in SQL & PL/SQL development
  • Strong knowledge of Oracle SQL and PL/SQL development
  • Experience developing enterprise applications where business logic resides in PL/SQL
  • Optimize existing Oracle databases and design optimized databases for SaaS multi-tenant applications
  • Experience identifying and resolving database bottlenecks and performance tuning (partitioning, indexing, memory management)
  • Hands-on experience handling large volumes of data and optimizing performance
  • Working experience with Oracle RAC and understanding of implementations
  • Experience using SQL front-end tools such as SQL Developer, TOAD, DBVisualizer
  • Hands-on experience or knowledge of other databases like PostgreSQL
  • Graduate degree in Computer Science or related (BE/BTech/ME/MTech/MCA/MSc) with excellent academics
  • Excellent verbal and written communication skills and ability to work in multi-location teams
  • Ability to prioritize and manage multiple tasks and milestones efficiently
  • Basic Java and REST API implementation experience
  • Knowledge of modern UI frameworks like Angular or ReactJS
  • Experience in developing SaaS-based applications

PTC Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about PTC and has not been reviewed or approved by PTC.

  • Strong & Reliable Incentives Bonuses are routinely part of offers and widely expected, providing predictable variable pay. This consistency helps bolster total compensation beyond base salary.
  • Leave & Time Off Breadth PTO is portrayed as generous and is complemented by flexible work arrangements. Additional paid volunteer time broadens time-away options.
  • Equity Value & Accessibility Accessible equity through ESPP and RSUs is available for many roles, adding meaningful long-term value. This ownership upside strengthens overall total compensation, particularly in higher-level roles.

PTC Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Boston, MA
7,347 Employees
Year Founded: 1985

What We Do

PTC (NASDAQ: PTC) unleashes industrial innovation with award-winning, market-proven solutions that enable companies to differentiate their products and services, improve operational excellence, and increase workforce productivity. With PTC, and its partner ecosystem, manufacturers can capitalize on the promise of today’s new technology to drive digital transformation.

Similar Jobs

Ericsson Logo Ericsson

Support Engineer

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
Mumbai, Maharashtra, IND
88000 Employees

Wipfli Logo Wipfli

Consultant

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Hybrid
Pune, Maharashtra, IND
2900 Employees

Capco Logo Capco

Managing Principal - Data

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Zscaler Logo Zscaler

Staff Threat Researcher

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Hybrid
Pune, Maharashtra, IND
8697 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account