Database Administrator II: SQL, Crystal Reports & SSRS

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

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.