Senior Oracle Developer
Job Location:
San Mateo, CA - USA
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
Our world is transforming and PTC is leading the 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 7000 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 companys PLMs (Product Lifecycle Management) physical data models deployed on Oracle;Contribute to the application design and developmentby 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 requiresaBachelorsdegree or foreignequivalent inComputer Engineeringor a related field plusfive(5)yearsofexperience in the job offered or a related also requiresdemonstrable experience with each of the following:
Ability to commute to the office 3 days a week in San Mateo.
US Citizenship is.
Designinganddevelopingcloud-basedapplications using Oracle involving Online and Batch Mode transaction processing;
Writing PL/SQL stored procedures and SQL queries to implement andmaintainproduct 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 applicationsin UnixOrLinux environments including shell scripting and using source code control tools like git orsvn;
WritingDetailed Technical Design documents Explain the Data Model Provide Detailed Comments in Software Code;
Communicatingsoftware design to development team members collaboratingwith functional leaders to understand business requirementsand explainingdesignedbehavior 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 tomaintainthe database tables;
Conducting technical review of SQL code andparticipatingin design reviews;
Oracle database Performance tuning activities including tuning SQL queries and database applications;
ReviewingOracle AWR (Automatic Workload Repository) ASH (Active Session History) and ADDM (Automatic Database Diagnostic Monitor) Reports toidentifydatabase bottlenecks slow running queries and implement necessary performance improvements to the design;
Maintaining the existing product release code and address bugs and enhancementsin a timely manner; and
Participating in a scrum-based development process
Compensation (CIP)
PTC carefully considers a wide varietyof factors when determining compensation. The anticipated annual salary range for this position is between $125500 - 170000. The salary range reflects a good-faith estimate of compensation at the time of posting. Actual compensation may vary based on a candidates skills qualifications experience and location. Additionally candidates may be eligible for a performance-based also have the opportunity to become a PTC shareholder through our employee share purchase program (ESPP) which allows for the purchase of discounted PTC stock. Certain roles may also be eligible for participation in our equity programs. Employees may be eligible for medical dental and vision insurance paid time off and sick leave tuition reimbursement 401(k) contributions and employer match flexible spending accounts life insurance disability coverage and if you are an office-assigned employee a generous commuter subsidy. All total rewards and benefits programs are subject to applicable plan eligibility and other terms and conditions.
For more information about PTCs comprehensive benefits please visit our Careers Page.
Applications will be accepted on an on-going basis.
Life at PTC is about more than working with todays most cutting-edge technologies to transform the physical world. Its about showing up as you are and working alongside some of todays most talented industry leaders to transform the world around you.
If you share our passion for problem-solving through innovation youll 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.
Required Experience:
Senior IC
About Company
PTC accelerates digital transformation with a new generation of technology that powers the ways you engineer, manufacture, and service your physical products.
