Engineer, Senior, Site and Database Reliability

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

Job summary

TriMet seeks a Senior Site and Database Reliability Engineer to build and maintain hosting platforms for Enterprise Services. You will merge site reliability with database reliability engineering, guiding architecture and standards across IT.

You will ensure scalable, reliable datastores (Oracle, SQL Server, PostgreSQL) and coordinate with project teams on ERP environments and integration. This is an in-person first role with some remote flexibility.

Qualifications

• Bachelor's degree in a related field.
• Minimum four years total experience in IT roles.
• Four years of UNIX/Linux or Windows server experience required.
• Two years of software development experience required.
• Two years with ERP application administration and cloning ERP environments preferred.
• Experience with IoC and desired state configuration tools preferred.

Responsibilities

• Build and maintain hosting environments for application and datastore hosting.
• Manage build, deployment tooling, CI/CD pipelines, and monitoring.
• Design, install, upgrade, and support Linux and Windows servers and RDBMS.
• Advise projects on risk, costs vs benefits, and technology priorities.
• Architect new solutions and drive continuous improvement in infrastructure.

Skills

Site reliability

Database reliability

Systems architecture

Automation

CI/CD

Education

Bachelor's Degree

Tools

Oracle

MS SQL Server

PostgreSQL

Linux

Windows

PowerShell

Bash

Python

Java

Go

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.

*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

Selection Process

Candidates will be selected based at a minimum on the result of:

1. Application Review (please include: Cover Letter and Resume)
2. Panel Interviews
3. Reference Check and Degree Verification
4. Criminal Background Check

Supplemental Information

Make sure you describe in detail how your education, training and work experience fit with this role.You areencouraged to attach a resume, cover letter, training certificates and/or letters of recommendation with your application. You are permitted five attachments of less than 5MB each.

Internal applicants: Information in your personnel file will not be used in lieu of information requested on your application. Incomplete applications will not be considered.

If you are a qualified veteran and would like to apply for veterans' preference points, you will need to reflect your status on the application and attach supporting documentation at the time of application submission.

If you need accommodation under the Americans with Disabilities Act for any part of the application process, contact our Human Resources staff at 503-962-7505, or the TTY line at 7-1-1. Note that we require a minimum of two workdays' notice prior to the need for accommodation.

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.

ADA Statement

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.