Senior Oracle Developer

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. Design and develop schema objects; perform technical review of SQL code with peers, and participate in design reviews with other team members. 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 Ability to commute to the office 3 days a week in San Mateo. US Citizenship is required. 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, explaining the data model, providing 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, ASH, and ADDM reports to identify database bottlenecks, slow running queries and implementing necessary performance improvements. Maintaining existing product release code and addressing bugs and enhancements in a timely manner. Participating in a scrum‑based development process. Compensation The anticipated annual salary range for this position is between $125,500 and $170,000. Employees may be eligible for performance‑based bonuses and equity programs. Benefits include medical, dental, and vision insurance; paid time off and sick leave; tuition reimbursement; 401(k) with employer match; flexible spending accounts; life and disability insurance; and a commuter subsidy for office‑assigned employees (subject to plan eligibility). Equal Opportunity At PTC, we are 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. #J-18808-Ljbffr