Engineer, Senior, Site and Database Reliability

TriMet - Oregon; Portland (OR); Hybrid; USD 124,000 - 185,000; Full time

Job summary

TriMet in Portland, Oregon is seeking a Senior Site and Database Reliability Engineer to build and maintain hosting platforms for Enterprise Services. The role blends site and database reliability engineering, guiding architecture, and advising on database schemas.

In-person collaboration is emphasized with some potential remote days based on policy. The position requires 4+ years of experience, a Bachelor's in CS preferred, and expertise across Linux, Windows, and major RDBMS.

Qualifications

• Minimum 3 days in-person per week.
• A minimum of 4 years total credited experience.
• Experience with UNIX/Linux and Microsoft Windows environments.
• ERP application administration and ERP cloning experience preferred.

Responsibilities

• Build and maintain hosting environments for applications and datastores using automated builds and desired state configuration.
• Manage build-and-deploy tool chain including CI/CD pipelines and version control.
• Design, install, upgrade, and support Linux and Windows servers and RDBMS (Oracle, SQL Server, PostgreSQL).
• Architect new solutions and redesign existing systems for reliability and performance.
• Develop automation, data management and monitoring tools using scripting languages.

Skills

Systems architecture

Cross-team collaboration

Mentoring/leadership

Education

Bachelor's Degree in Computer Science

Tools

Linux

Windows

Oracle

MS SQL Server

PostgreSQL

Bash

PowerShell

Python

Java

Golang

CI/CD pipelines

Version control

Monitoring

Job description

The Senior Site and Database Reliability Engineer is responsible for building and maintaining the hosting platforms for TriMet's Enterprise Services. This role integrates both site reliability and database reliability engineering, and acts as systems architects in support of TriMet projects and initiatives, as a point of escalation for application programming staff in developing database schemas, and as a trusted advisor in the use of RDBMS as back end datastores. This role provides technical guidance and support across IT to align with functional road maps, execute strategic initiatives, and establish standards and best practices.

This position requires a minimum of three (3) days in-person per week.

Ensure a commitment to safety through consistent and professional behaviors in performance of job requirements. Safety is a fundamental value that guides all aspects of our work. Perform related duties as required.

Serve as a good steward of TriMet and maintain a strong and current understanding of customers’ experiences and of TriMet’s product and service offerings. Reliable in-person attendance is an essential function of all positions.

TriMet is an in-person first organization, with a strong emphasis on in-person collaboration, customer service, and safe and efficient operations. Some positions may be able to work up to two days remotely depending on department policy, business needs, and manager discretion.

1. Build and maintain operating environments for application and datastore hosting using automated builds to minimize manual intervention while also enhancing reliability using desired state configuration tools.
2. Manage the application build-and-deploy tool chain, including version control system, monitoring, and CI/CD pipelines.
3. Design, install, upgrade, and support both Linux and Windows servers, as well as RDBMS including Oracle, Microsoft SQL Server, and PostgreSQL.
4. Work on projects of all size that require in-depth knowledge across multiple specialized architecture domains.
5. Advises projects on options related to risk, costs vs benefits, system impacts, and technology priorities in support of the Enterprise Systems application portfolio and development efforts.
6. Architects new solutions, redesigns existing systems, and provides proactive strategies around opportunities pertaining to continuous improvement.
7. Analyze database performance, reorganize database as needed, monitor current and projected database disk space usage, develop reliable and timely backup, export and upgrade procedures.
8. Develops tools for automation, data management and extraction, and monitoring using bash, powershell, python, Java, and/or golang.
9. Oversee the development of data design elements, of the development of applications, in coordination with Information Technology planning. Work closely with vendors and contracted staff to evaluate software upgrades for their effect on database integrity and performance. Assist in technical support of integrated database design.
10. Provides consulting expertise to other IT groups and projects, driving innovation and operational excellence to develop optimal systems architecture. Work collaboratively across IT and business units to enhance system resilience, minimize downtime, and drive continuous improvement in infrastructure and database management.
11. Own and manage the following datastores: ERP system, eFare system, and Oracle databases.
12. Manage the infrastructure supporting the TriMet internet site and the corporate intranet site.

A minimum of a Bachelor's Degree is required.

A Bachelor's Degree in Computer Science is preferred.

A minimum of four (4) years total credited experience.*

• Four (4) years of experience managing UNIX/Linux or Microsoft Windows operating environments are required.
• Two (2) years of experience creating software are required.
• Two (2) years of experience managing infrastructure with IoC and desired state configuration tools are preferred.
• Two (2) years of experience with ERP Application administration via vendor provided front end apps as well as cloning ERP environments are preferred.

Or any equivalent combination of training or experience.

*The amount of credit a candidate receives for prior years of experience is based on the relevancy of that experience to the required or preferred prerequisites of the job description. Experience is prorated based on hours worked. LRHR assigns and validates the "credited experience".

Salary offers will be determined by a candidate's education, training and relevant experience. A complete work history will be required for this purpose at the time of offer; any omitted work history will not be considered after hire. Any final offer of employment will fall within the range stated above. For transparency, we choose to list the full available grade range, however, TriMet's salary administration process will ultimately determine the final salary offered.

Type of Position / Grade / FLSA

Grade 18, Exempt, Non-Union, Full-Time

Salary Range

• Minimum: $123,570.00
• Maximum: $185,355.00

TriMet is an equal opportunity employer, committed to developing an organization that is reflective of and sensitive to the needs of the diverse community we serve, including veterans, the elderly, and individuals with disabilities.

As applied to the workplace, applicants and employees must be qualified to perform the essential functions of the job with or without reasonable accommodation. Essential functions may include required job functions performed infrequently as well as production standards related to the quality and quantity of work. If a person with a disability could meet job qualifications with a reasonable accommodation, TriMet will work with the employee to accommodate the need. If TriMet's accommodation is effective in allowing the employee to perform the essential functions of the job, it need not be the employee's preferred accommodation.