Oracle Database Administrator at PTC

Gurugram, haryana, India -

Full Time

Start Date

Immediate

Expiry Date

11 Mar, 26

Salary

0.0

Posted On

11 Dec, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle, Microsoft SQL Server, PostgreSQL, Database Management, Backup and Recovery, PL/SQL, Stored Procedures, Triggers, Linux, Windows Server, Networking, Storage, RAC, High Availability, Database Monitoring, Troubleshooting

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. About PTC (NASDAQ: PTC) PTC enables global manufacturers to realize double-digit impact with software solutions that enable them to accelerate product and service innovation, improve operational efficiency, and increase workforce productivity. In combination with an extensive partner network, PTC provides customers flexibility in how its technology can be deployed to drive digital transformation – on premises, in the cloud, or via its pure SaaS platform. At PTC, we don't just imagine a better world, we enable it. Job Title- Cloud Infrastructure Engineer (Oracle DBA) Job Location: Gurgaon About Role: 24x7 Management (monitor, maintain, and control) of database systems in the PTC Cloud Services environments, including Oracle, Microsoft SQL Server and PostgreSQL. The applications are revenue generating, externally facing databases under stringent SLAs. The position will work closely with R&D, Support and the Network Operations Center (NOC). In addition to operational DBA tasks, the position will work closely with Developers to design and build/modify appropriate structures to support future enhancements and provide guidance on efficient database access methods. Day-To-Day: •Assist in the maintenance and operations of multiple database environments •Assists with regular maintenance of the databases including backups, restores, archiving, and review of logs for errors or potential problems •Regularly review space capacity and perform tasks to manage space usage •Collaborate with other operational DBAs, developers, and infrastructure teams •Work closely with development teams on activities such as schema definition, PL/SQL, stored procedures and triggers •Installation, configuration, upgrading and patching of database systems •Assist in the development and implementation of archiving, backup and recovery strategies •Ability to complete tasks and produce appropriate deliverables within project time schedules •Work with senior members of the team for database monitoring, troubleshooting •Proficient with the use of Oracle's Enterprise Manager/Cloud Control and SQL*Plus and Microsoft SQL Server Administration tools. •Designs, implements, and periodically tests the database backup and recovery procedures •Participate in the on-call schedule Preferred Skills and Knowledge: • Bachelors Degree or equivalent in computer science or related field •2-4 years as a Database Administrator •Extensive experience with Oracle including ASM/GRID/RAC (11gR2,12c) managing multiple RDBMS in a high availability, 24x7 RAC environment •Exposure to Microsoft SQL Server and PostgreSQL in production environments highly desirable •Mid-level skills with Linux (Red Hat & derivatives) and Windows Server 2008 and later •Good understanding of networking and storage (iSCSI & Fibre Channel) principals Basic Qualifications: • Bachelor, Master or equivalent graduate. 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 role involves 24x7 management of database systems in the PTC Cloud Services environments, including monitoring, maintaining, and controlling databases. The position also requires collaboration with development teams to design and modify database structures for future enhancements.