Software Consultant - Database at PTC

Pune, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

15 Apr, 26

Salary

0.0

Posted On

15 Jan, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, PL/SQL, Database Development, Performance Tuning, Oracle Database, SaaS Applications, Debugging, Data Optimization, Teamwork, Communication, Problem Solving, Java, REST API, Angular, ReactJS, Postgres-SQL

Industry

Software Development

Description

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. Job Description- Software Consultant (Database) 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. Job Title: Software Consultant Location: Pune, India Responsibilities: Being a part of Arena Engineering team: Work with development teams and product managers to ideate software solutions. Design database 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 Analyze 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 resolve any existing issues. 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 the database to performance optimally. Strong knowledge in database configuration and performance tunings like partitioning, indexing, memory management etc., Handson experience or knowledge of other databases like postgres-SQL Hands on experience in handling 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 understanding 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."

Responsibilities

The Software Consultant will work with development teams and product managers to design and develop optimized database solutions. Responsibilities include troubleshooting, debugging, and improving existing database performance.