Senior Database Architect – Hybrid, Data & Security

State of Oregon; Salem (OR); Hybrid; USD 87,000 - 132,000; Full time

Job summary

State of Oregon’s Department of Transportation seeks a Senior Database Administrator to design, implement, and optimize databases across IBM DB2, MS SQL Server, and Oracle. You’ll collaborate with teams to ensure secure data architectures and robust data governance in a hybrid office environment.

The role emphasizes data modeling, performance tuning, disaster recovery planning, and cross-institution data sharing.

Qualifications

• Seven years of information systems experience in database administration and related domains.
• Alternative: associate or bachelor degree plus required experience as specified in job posting.

Responsibilities

• Develop conceptual, logical, and physical data models for new and existing applications.
• Design secure data exchange solutions for batch and real-time processing across cloud and in-house systems.
• Define and enforce data modeling, storage, and governance policies and procedures.
• Conduct profiling, analysis, and performance tuning to ensure high-quality, reliable databases.
• Manage relational databases, metadata repositories, and enterprise schemas with compliance and security in mind.
• Assist with data sharing, analytics initiatives, and infrastructure for reporting and AI/ML initiatives.
• Coordinate complex database installations, upgrades, and migrations across distributed environments.

Skills

Database administration

Data modeling

Performance tuning

Data governance

Education

Bachelor's degree in IT/CS or related field

Associates degree or vocational IT diploma

Vocational IT training + 5 years experience

Tools

IBM DB2

MS SQL Server

Oracle

Job description

State of Oregon’s Department of Transportation seeks a Senior Database Administrator to design, implement, and optimize databases across IBM DB2, MS SQL Server, and Oracle. You’ll collaborate with teams to ensure secure data architectures and robust data governance in a hybrid office environment.

The role emphasizes data modeling, performance tuning, disaster recovery planning, and cross-institution data sharing.