Database Administrator 1

Stanfordlivetickets; Menlo Park (CA); Hybrid; USD 120,000 - 170,000; Full time

Job summary

SLAC National Accelerator Laboratory seeks a Database Administrator to implement and support the transition from TeamCenter to PTC WindChill. You will work with PLM support staff from requirements through implementation and focus on data transfer and end-user support.

As part of the Chief Engineer’s office, you will maintain RDBMS systems, perform performance tuning, backup/recovery, and documentation, while serving as the main contact for training and onboarding to the new system.

Qualifications

• Demonstrated experience installing and operating relational database systems and PLM back ends.
• Experience with external users, internal systems services, and file system structures.
• Knowledge of PLM suite security protocols and system design.

Responsibilities

• Install, configure, and support relational database management systems or PLM back ends.
• Perform resource and usage management (performance/optimization tuning).
• Manage backup/recovery services for data/database systems.
• Coordinate and monitor usage of the database/PLM suite and ensure integrity.
• Diagnostics, issue resolution, and vendor interfacing as required.
• Design, configuration, and implementation of new database/PLM environments.
• Document system setup and operational procedures for users.
• Maintain knowledge of technology trends and their application.

Skills

Database administration

PLM systems

RDBMS

Backup/Recovery

Performance tuning

Security

Data transfer

End-user support

Documentation

Vendor liaison

Education

Bachelor's degree

Tools

WindChill

TeamCenter

PLM software suites

Job description

The Chief Engineer’s Office at SLAC National Accelerator Laboratory is seeking a talented Database Administrator to implement and support SLAC’s transition from TeamCenter to PTC WindChill. This role will work with the existing Product Lifecycle Management (PLM) support staff with a specific focus on PTC workflow creation from requirements through final implementation. Once the system is configured and workflows are implemented, this role will focus on data transfer between the two systems as well as end-user support as SLAC transitions. Longer term, this role will serve as the first point of contact for user support, training, and onboarding into the new system. Additional tasks related to the support of the full Chief Engineer’s office Labwide Toolkit will also be assigned as needed.

As a database administrator, you will be part of the Chief Engineer’s office supporting the suite of tools managed through this office with a focus on our adoption of the PTC suite of software. In this role you will support the wide range of engineering design work performed at the lab in a dynamic, energetic environment that values work life balance and comes with all the benefits of being an employee of Stanford University.

Your specific responsibilities include:

• Install, configure, and support relational database management systems (RDBMS) or PLM suite back end. Work on databases using intermediate-level database design and programming techniques.
• Perform resource and usage management (performance/optimization tuning).
• Manage backup/recovery services for data/database systems.
• Coordinate and monitor usage of the database or PLM suite, including potential security issues/vulnerabilities, and assure the integrity of the database or PLM suite.
• Perform ongoing and problem diagnostics, resolve operational and user problems, and interface with vendors on technical issues as required.
• Participate in the design, configuration, and implementation of new database or PLM suite environments, systems, and tools.
• Perform other database or design tool administration activities as necessary.
• Provide technical documentation on system setup and operational procedures for users.
• Maintain current knowledge of technology trends and their application in the marketplace.

To be successful in this position, you will bring:

• Demonstrated experience with the installation and operation of a relational database system and database applications or PLM suite.
• Experience with external user functions, internal systems services, and file system structures.
• Demonstrated knowledge of systems platform.
• Experience with installing and configuring relational database management systems software or PLM software suites.
• Extensive experience in database or PLM suite administration with proven ability to track and report on capacity, current utilization and projected growth, and general health of databases or PLM back end.
• Experience with database design and programming techniques such as views, triggers, and stored procedures.
• Demonstrated knowledge of database or PLM suite security protocols.
• Demonstrated knowledge of modeling techniques.
• Ability to analyze and solve problems of moderate scope independently, especially on networked computers of varying types and operating systems.
• Ability to work well independently or as a team member.
• Effective oral and written communication skills.
• Bachelor's degree and five years of relevant experience or a combination of education and relevant experience.
• Given the nature of this position, SLAC is open to on-site and hybrid work options.

Preferred Qualifications:

• Experience with the PTC suite of software, specifically Windchill.
• Experience with TeamCenter is a plus.