Cloud Infrastructure Engineer Oracle DBA - Night Shift

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 Role:

24x7 Management (monitor, maintain, and control) of database systemsin 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 Developersto design and build/modify appropriate

structuresto support future enhancements and provide guidance on efficientdatabase 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 logsfor errors or potential problems

• Regularly review space capacity and perform tasksto manage space usage
• Collaborate with other operational DBAs, developers, and infrastructure teams
• Work closely with development teams on activities such asschema 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 projecttime
  
  
  

schedules

• Work with senior members of the team for database monitoring, troubleshooting
• Proficient with the use of Oracles Enterprise Manager/Cloud Control and SQL*Plus and
  
  
  

Microsoft SQL Server Administration tools.

• Designs, implements, and periodically teststhe 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."

---