Database Administrator 1

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

Core Duties:

• Install, configure, and support relational database management systems (RDBMS).  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 database, including potential security issues/vulnerabilities, and assure the integrity of database.

• 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 environments, systems, and tools.

• Perform other database 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.

Minimum Education and Experience:

Bachelor’s degree and five years of relevant experience or a combination of education and relevant experience.

Knowledge, Skills and Abilities:

• Demonstrated experience with the installation and operation of a relational database system and database applications.

• Experience with external user functions, internal systems services, and file system structures.

• Demonstrated knowledge of systems platform.

• Experience with installing and configuring relational databases management systems software.

• Extensive experience in database administration with proven ability to track and report on capacity, current utilization and projected growth, and general health of databases.

• Experience with database design and programming techniques such as views, triggers, and stored procedures.

• Demonstrated knowledge of database 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.