Engineer, Senior, Site and Database Reliability

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.Essential Functions

• 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.
• Manage the application build-and-deploy tool chain, including version control system, monitoring, and CI/CD pipelines.
• Design, install, upgrade, and support both Linux and Windows servers, as well as RDBMS including Oracle, Microsoft SQL Server, and PostgreSQL.
• Work on projects of all size that require in-depth knowledge across multiple specialized architecture domains.
• 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.
• Architects new solutions, redesigns existing systems, and provides proactive strategies around opportunities pertaining to continuous improvement.
• Analyze database performance, reorganize database as needed, monitor current and projected database disk space usage, develop reliable and timely backup, export and upgrade procedures.
• Develops tools for automation, data management and extraction, and monitoring using bash, powershell, python, Java, and/or golang.
• 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.
• 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.
• Own and manage the following datastores: ERP system, eFare system, and Oracle databases.
• Manage the infrastructure supporting the TriMet internet site and the corporate intranet site.

Position Requirements

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.Benefits 0