Staff Database Engineer

Trellix; Salem (OR); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading technology company in Salem, Oregon is seeking a DevOps DBA Engineer responsible for improving software development and database design, managing PostgreSQL clusters, and optimizing cloud resources. The ideal candidate will have strong Linux and database expertise, with skills in automation tools like Jenkins and Ansible. Competitive benefits include medical coverage and flexible work hours.

Benefits

Retirement Plans

Medical, Dental and Vision Coverage

Paid Time Off

Paid Parental Leave

Support for Community Involvement

Qualifications

• Strong knowledge of Linux systems administration and architecture.
• Experience with configuring, managing and supporting virtualized environments.
• In-depth knowledge of SQL, PL/pgSQL, and advanced PostgreSQL features.
• Familiarity with AWS cloud services and database management practices.
• Extensive scripting experience, especially with Python.

Responsibilities

• Improve and maintain software development and database design.
• Design and manage PostgreSQL clusters ensuring high availability.
• Optimize public cloud resource usage for efficiency.
• Ensure data security and availability.
• Drive automation frameworks to enhance efficiency.

Skills

Linux systems administration

Virtualized environments

Continuous integration and deployment tools

SQL databases

PostgreSQL features

AWS services

Database tuning for high performance

Scripting (Python preferred)

Tools

Jenkins

Ansible

GitHub Actions

ArgoCD

Job description

Role Overview

We are hiring for a DevOps DBA Engineer who will improve and maintain software development and database design, test and deliver infrastructure and services.

About the Role

• You will work closely with the development teams, follow DevOps practices, automate infrastructure activities, documents standards and procedures.

• Design and manage PostgreSQL (self hosted and Aurora), and Greenplum, and similar DB clusters, ensuring high availability and disaster recovery resilience.

• Optimize the usage of public cloud based resources to ensure cost-effective and efficient use.

• Monitor and maintain database systems in cloud environments and on-prem, ensuring data security and availability.

• Drawing on your creative nature, you will drive the existing automation frameworks forward to benefit automation across multiple products, and may be asked to create new frameworks depending on need.

• Provide visibility on application health by defining dashboards, metric/log aggregation mechanisms.

• Ensure that the database architecture complies with organizational security policies and best practices.

• Implement database encryption, user management, and access controls.

• Ability to learn to use new tools, and quickly become a subject matter expert.

• Improving site performance, monitoring and overall stability of our infrastructure.

• Evaluate new technologies and provide proof-of-concept

• Additional duties as assigned

About You

• Strong knowledge of Linux systems administration and architecture.

• Experience with configuring, managing and supporting virtualized environments.

• Experience with continuous integration and deployment automation tools such as Jenkins, Ansible, GitHub Actions, ArgoCD.

• Experience with SQL and NoSQL databases.

• In-depth knowledge of SQL, PL/pgSQL, and advanced PostgreSQL features like triggers, stored procedures, and replication.

• Familiarity with AWS services (Aurora, RDS, EC2, S3, etc.) and cloud database management practices.

• Expertise in tuning PostgreSQL databases for high performance, including memory usage optimization, connection pooling, and query optimization.

• Proficiency in analyzing and resolving database performance issues, especially in high-traffic and high-volume production environments.

• Analyse slow-running or poor performing queries and optimize performance through proper indexing, query restructuring, or caching mechanisms.

• Extensive scripting experience, including extract, transform, and load programs (Python preferred).

• Experience supporting, analyzing and troubleshooting large-scale distributed mission critical systems.

Company Benefits and Perks

We believe that the best solutions are developed by teams who embrace each other's unique experiences, skills, and abilities. We work hard to create a dynamic workforce where we encourage everyone to bring their authentic selves to work every day. We offer a variety of social programs, flexible work hours and family-friendly benefits to all of our employees.

• Retirement Plans

• Medical, Dental and Vision Coverage

• Paid Time Off

• Paid Parental Leave

• Support for Community Involvement

We’re serious about our commitment to a workplace where everyone can thrive and contribute to our industry-leading products and customer support, which is why we prohibit discrimination and harassment based on race, color, religion, gender, national origin, age, disability, veteran status, marital status, pregnancy, gender expression or identity, sexual orientation or any other legally protected status.