Senior Oracle Developer - Arena

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.  

Senior Oracle Developer

San Mateo, CA Hybrid (3 days a week in office)

Job Description:

Support and enhance the company’s PLMs (Product Lifecycle Management) physical data models deployed on Oracle; Contribute to the application design and development by devising an optimal data model and efficient PL/SQL code for various domain problems; Contribute to the design and development of schema objects, technical review of SQL code with peers, as well as design review with other members of the team; Re-factor poorly performing SQL and undertake system and application tuning activities, including tuning SQL queries and the database/system; Write high quality SQL and PL/SQL code to implement new product features; Participate in a scrum-based, collaborative development process.  

Job requirements: 

The position requires a Bachelor’s degree, or foreign equivalent, in Computer Engineering, or a related field plus five (5) years of experience in the job offered or a related field. Position also requires demonstrable experience with each of the following: 

• Ability to commute to the office 3 days a week in San Mateo.
• US Citizenship or Green Card is required due to Govcloud/ITAR specifications.
• Designing and developing cloud-based applications using Oracle involving Online and Batch Mode transaction processing; 

• Writing PL/SQL stored procedures and SQL queries to implement and maintain product features;    

• Designing and developing applications for high-availability systems; 

• Development experience in three-tier architecture to provide Database support for applications that use Java/J2EE technologies; 

• Developing applications in Unix Or Linux environments including shell scripting, and using source code control tools like git or svn; 

• Writing Detailed Technical Design documents, Explain the Data Model, Provide Detailed Comments in Software Code; 

• Communicating software design to development team members, collaborating with functional leaders to understand business requirements, and explaining designed behavior to cross-functional team members and management; 

• Supporting and enhancing physical data models deployed on Oracle; 

• Designing and developing database schema objects; 

• Designing Database Package procedures to maintain the database tables; 

• Conducting technical review of SQL code and participating in design reviews;  

• Oracle database Performance tuning activities, including tuning SQL queries and database applications; 

• Reviewing Oracle AWR (Automatic Workload Repository), ASH (Active Session History), and ADDM (Automatic Database Diagnostic Monitor) Reports to identify database bottlenecks, slow running queries and implement necessary performance improvements to the design; 

• Maintaining the existing product release code and address bugs and enhancements in a timely manner; and 

• Participating in a scrum-based development process 

This position is not eligible for employment-based immigration sponsorship. Applicants must be authorized to work in the United States without requiring current or future sponsorship from PTC.

  

At PTC, we believe in the power of diverse ideas and perspectives. As a global company that values and respects all identities, cultures, and perspectives, we strive to create an inclusive PTC for ALL through an environment where everyone feels like they belong and are empowered to bring their true, authentic selves to work. Proud to be an Equal Opportunity Employer, we welcome applicants from all backgrounds and hire without regard to race, national origin, religion, age, color, ethnicity, ancestry, marital status, sex (including pregnancy), sexual orientation, gender identity, gender expression, genetic information, disability, veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.For more information about PTC’s comprehensive benefits and our AI usage, please visit our Careers Page (https://www.ptc.com/en/careers/united-states-careers). Applications will be accepted on an on-going basis until the opportunity is filled.PTC endeavors to make ptc.com/careers accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact PTC's Talent Acquisition team at TalentAcquisition@ptc.com. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

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