Database Administrator
External
Westernpartitionsinc · Lake Oswego, OR$90K–$120K/yrFull-timeOn-site1mo ago
ComplianceDocumentationPerformance OptimizationSOC 2SQL
Prepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
Responsibilities
- 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?
- 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 payIncentive bonus plan401(k) retirement savings plan with matchMedical, prescription drug, dental and vision insurance plans with flexible spending account optionLife insurance, accidental death, and disability benefitsFlexible paid time off policy and paid holidaysWPI 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.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 USDDental insuranceVision insurance401(k)Flexible schedulePerformance bonus
Additional Information
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.
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at westernpartitionsinc? Share your experience