Software Technical Consultant at PTC in Pune, Maharashtra, India

Software Technical Consultant Location: Pune, India 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."