Database Administrator

Western Partitions, Inc.; Lake Oswego (OR); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive pay

Incentive bonus plan

401(k) with match

Health insurance

Dental and vision insurance

Flexible paid time off

Paid holidays

Job summary

Western Partitions, Inc. seeks a Database Administrator II to create, manage, and ensure the accuracy of Crystal Reports and SSRS. You will troubleshoot data discrepancies while maintaining SQL database integrity for scalability and compliance.

You will collaborate with the existing DBA to document processes, own SQL development, optimize queries, backups, indexing, and data security, and help ensure audit-ready data solutions.

Qualifications

• 4–6 years of SQL database administration (backups, schema, triggers, and integrity).
• Experience optimizing queries, stored procedures, and performance tuning.
• Hands-on experience with Crystal Reports and SSRS.
• Familiarity with Vista ERP or similar financial data flows.
• Security/compliance minded (SOC 2 and ISO 27001).
• Clear documentation habits and contributing to shared repositories.

Responsibilities

• Create, modify, and maintain Crystal Reports and SSRS for accurate data reporting.
• Investigate and resolve data/report discrepancies across reports, stored procedures, and source tables.
• Collaborate with the existing DBA to document processes and share knowledge.
• Own SQL development and data-layer logic: queries, stored procedures, triggers, and data transformations.
• Manage database integrity, performance, backups, restores, indexing, and tuning.
• Design scalable, audit-ready data solutions with growth considerations.
• Ensure data security and compliance aligning with SOC 2, CMMC, and ISO 27001.

Skills

SQL development

Query performance tuning

Documentation practices

Security/compliance mindset

Collaboration with DBA

Tools

Crystal Reports

SSRS

Job description

Database Administrator

We are seeking a Database Administrator II who will create, manage, and ensure the accuracy of Crystal Reports and SSRS. When data doesn’t match, they’ll dive deep to troubleshoot discrepancies, while managing SQL database integrity, performance and designs for scalability and compliance. They’ll collaborate with our existing DBA to document processes and ensure knowledge continuity.

What You’ll Do

• Create, modify, and maintain Crystal Reports and SSRS, ensuring accuracy, performance, and alignment with underlying data structures.
• Investigate and resolve data and reporting discrepancies, tracing issues across reports, stored procedures, and source tables to determine root cause.
• Collaborate with the existing DBA in working sessions, capturing knowledge, documenting processes, and contributing to shared SQL/report repositories.
• Own SQL development and data-layer logic, including writing and optimizing queries, stored procedures, triggers, and data transformations.
• Manage database integrity, performance, and reliability, including backups, restores, indexing, and proactive tuning.
• Design and support scalable, audit-ready data solutions, incorporating performance optimization, auditability, and long-term growth considerations.
• Ensure data security and compliance alignment, supporting standards such as SOC 2, CMMC, and ISO 27001 in database and reporting design

What You Bring

• Minimum 4–6 years of SQL database administration (backups, schema, triggers, and integrity).
• Experience optimizing queries, stored procedures, and performance tuning.
• Proven hands‑on experience with Crystal Reports and SSRS.
• Familiarity with financial data flows or ERP systems (Vista ERP is a plus).
• Security‑ and compliance‑minded, familiar with frameworks like SOC 2 and ISO 27001.
• Clear documentation habits, contributing to shared repositories.

Why Join Us?

You’ll be part of a supportive, fast‑moving team where your work has direct impact and high visibility. We value initiative, craftsmanship, teamwork, and continuous learning. This is an opportunity to help shape modern development standards, contribute to meaningful digital transformation, and grow your career alongside a team that cares about building excellent solutions and automations.

This role is not eligible for visa sponsorship.

Benefits

At WPI our employees are our greatest asset. We put our people first and are proud to provide a comprehensive benefits package designed to meet the needs of our employees at every stage of life.

In our commitment to fostering an environment where everyone can thrive personally and professionally, we offer:

• Competitive pay
• Incentive bonus plan
• 401(k) retirement savings plan with match
• Medical, prescription drug, dental and vision insurance plans with flexible spending account option
• Life insurance, accidental death, and disability benefits
• Flexible paid time off policy and paid holidays

WPI provides equal employment and affirmative action opportunities to applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability.

WPI is a background screening, drug‑free workplace.

This job description is intended to outline the general nature and level of work being performed by employees. It is not designed to cover or contain a comprehensive list of responsibilities, duties, or skills required of the employee of this job. Furthermore, this description is subject to change at the discretion of the company, with or without notice.

Work Location:

We work out of the top floor of a beautiful, newly remodeled, office park in Lake Oswego, Oregon. If you apply today and get hired soon, you have a good chance of getting desk with a view!

Full compensation packages are based on candidate experience and certifications.

Oregon pay range

$90,000—$120,000 USD