Senior Oracle Database Administrator

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.  

PRIMARY RESPONSIBILITIES:
Design, maintain, and control a variety of databases in a federally secure datacenter. Primarily manage Oracle databases but also Postgres and MSSQL.   The position will provide 24X7 operational support for databases which run internally developed applications.  Such applications are revenue generating under stringent SLAs.  The position will work closely with Application Delivery, Infrastructure- Systems and Networking and Technical Support, in support of the databases/application.  In addition to operational DBA tasks, the position will work closely with the Security team for annual audits for compliance.   The position is hybrid with a required 50% time in a PTC office.

ESSENTIAL FUNCTIONS:

• Maintains the operations of a mixed Oracle database environment- single, RAC and DG, multi-tenant instances.
• Maintains the operations of single Postgres and MSSQL databases
• Perform regular maintenance of the databases including backups and restores and review of logs for errors or potential problems.
• Regularly review space capacity and perform tasks to manage space usage through archiving or increasing disk space
• Collaborate with other operational Oracle DBAs, developers, infrastructure teams and external customers to resolve problems with application/database systems.
• Installation, Configuration, Upgrading and Patching of databases and related products
• Develop and implement archiving, backup and recovery strategies
• Ability to complete tasks and produce appropriate deliverables within project time schedules
• Responsible for database monitoring, troubleshooting
• Configuration, backup/recovery, sizing, space management, diagnostics, and proficient with the use of Oracle's Enterprise Manager/ Cloud Control.
• Designs, implements, and periodically tests the database backup and recovery procedure in conjunction with other IT staff.
• Team player with excellent written and oral communication and organizational skills
• Demonstrate willingness to learn new skills, cross train on a large number of systems and provide knowledge transfer to other team members
• On call schedule participation and provide 24X7 Support
• Off hours patching support
• Manage cases in ticketing system

Requirements/Qualifications:

• 4+ years as an Oracle Database Administrator
• B.S. degree in computer science or equivalent.
• Oracle - OCP or equivalent certification
• Experience with Oracle ASM/GRID/RAC - 19c, 26ai (exposure)
• Experience with managing multiple RDBMS on large systems, preferably high availability 24x7 environments in both on-premise data centers and Cloud environments (AWS, Azure, OCI)
• Experience installing, patching, upgrading and maintaining Oracle database
• Experience with configuration, backup/recovery, sizing, space management, PL/SQL tuning, diagnostics, and proficient with the use of Oracle's Enterprise Manager/Cloud Control.
• Experience planning, configuring, and replicating Oracle DataGuard, or similar Disaster Recovery solution.
• Experience with DataPump, RMAN &  restore and recoveries across various scenarios
• Hands on experience with advanced Oracle features like partitioning, parallelized queries and other Oracle EE features.
• Prior experience with performance analysis, performance tuning and with debugging, identifying and fixing performance issues.
• Experience with SQL Server 2019/2022 for performance and tuning and backup/restore
• Strong verbal, written and interpersonal communication skills
• Ability to manage responsibilities as a hybrid employee.
• Experience with Linux and Windows environment
• Demonstrates excellent communication, organizational and follow up skills. 
• Must have or be able to obtain a Secret Security Clearance
• US citizen requirement

PTC carefully considers a wide range of factors when determining compensation. The anticipated annual salary range for this position is between $110,000 - $130,000. The anticipated annual salary range encompasses both the base salary and the on-target incentive compensation that may be attained in this role. The salary range reflects a good-faith estimate of compensation at the time of posting. 

Actual compensation may vary based on a candidate's skills, qualifications, experience, and location. Eligible employees 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 plan eligibility and other terms and conditions.  

For more information about PTC’s comprehensive benefits, please visit our Careers Page. 

Applications will be accepted on an on-going basis. 

At PTC, we believe in the power of diverse ideas and perspectives. As a global company that values and respects all identities, cultures, and perspectives, we strive to create an inclusive PTC for ALL through an environment where everyone feels like they belong and are empowered to bring their true, authentic selves to work. Proud to be an Equal Opportunity Employer, we welcome applicants from all backgrounds and hire without regard to race, national origin, religion, age, color, ethnicity, ancestry, marital status, sex (including pregnancy), sexual orientation, gender identity, gender expression, genetic information, disability, veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

PTC endeavors to make ptc.com/careers accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact PTC's Talent Acquisition team at [email protected]. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

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."