Database Administrator 1

Stanford University; Menlo Park (CA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

SLAC National Accelerator Laboratory in Menlo Park, CA is seeking a Database Administrator to drive the transition from TeamCenter to PTC WindChill. You will work with the PLM support staff from requirements through implementation and beyond.

This role emphasizes data transfer between systems, end-user support, training, and onboarding into the new PLM environment, with opportunities to support the Chief Engineer’s office Labwide Toolkit.

Qualifications

• Experience installing and operating a relational database system.
• Experience with PLM suites back end and data transfer.
• Ability to design, configure, and implement PLM/workflow environments.
• Strong troubleshooting and user support skills.
• Experience with security, backups, and performance tuning.

Responsibilities

• Install, configure, and support RDBMS or PLM back end.
• Perform resource and usage management (tuning).
• Manage backup and recovery services.
• Coordinate usage and security with vendors.
• Interface with users and support onboarding into new system.
• Document system setup and procedures.
• Stay current with technology trends.
• Work on data transfers between TeamCenter and WindChill.

Skills

Database administration

PLM workflow knowledge

Problem solving

Communication skills

Independent/team collaboration

Education

Bachelor's degree

5+ years relevant experience

Tools

WindChill

TeamCenter

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