Database Administrator

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.