Senior Oracle Developer

PTC•San Mateo, CA

2d•$125,500 - $170,000•Hybrid

About The Position

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.

Requirements

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
Demonstrable experience designing and developing cloud-based applications using Oracle involving Online and Batch Mode transaction processing
Demonstrable experience writing PL/SQL stored procedures and SQL queries to implement and maintain product features
Demonstrable experience designing and developing applications for high-availability systems
Demonstrable development experience in three-tier architecture to provide Database support for applications that use Java/J2EE technologies
Demonstrable experience developing applications in Unix Or Linux environments including shell scripting, and using source code control tools like git or svn
Demonstrable experience writing Detailed Technical Design documents, Explain the Data Model, Provide Detailed Comments in Software Code
Demonstrable experience 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
US Citizenship is required

Nice To Haves

Ability to commute to the office 3 days a week in San Mateo

Responsibilities

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
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
Participating in a scrum-based development process