Senior Database Administrator

State of Oregon

124d • $7,617 - $11,535

About The Position

Join ODOT’s Enterprise Technology team as a Senior Database Administrator and help shape the data architecture that drives our mission! You’ll work with internal and external partners to design, manage, and optimize corporate databases across IBM DB2, MS SQL Server, and Oracle. If you’re passionate about building smart, efficient data solutions – apply today! We provide a safe and reliable multimodal transportation system that connects people and helps Oregon's communities and economy thrive. We encourage people from all backgrounds and abilities to apply for our positions.

Requirements

• Seven (7) years of information systems experience in database administration, SQL, Oracle, and DB2 development, or a combination of application development, database architecture and modeling, and database administration.
• OR an associate's degree or higher in computer science, information technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field; AND 5 years of information systems experience in database administration, SQL, Oracle, and DB2 development, or a combination of application development, database architecture and modeling, and database administration.
• OR a bachelor's degree in information technology, computer science, or related field AND three (3) years of information systems experience in database administration, SQL, Oracle, and DB2 development, or a combination of application development, database architecture and modeling, and database administration.
• OR master's degree in information technology, computer science, or related field AND one (1) year of information systems experience in database administration, SQL, Oracle, and DB2 development, or a combination of application development, database architecture and modeling, and database administration.

Nice To Haves

• Experience in Database architecture, design, and implementation.
• Experience administering and maintaining Oracle databases.
• Experience administering and maintaining IBM DB2 databases.
• Experience administering and maintaining MS SQL databases.
• Experience documenting DBA processes for MS SQL, IBM DB2 and Oracle, handing these processes off, and provide training as needed, in support of said processes.

Responsibilities

• Develop conceptual, logical, and physical data models to support new and existing ODOT applications using DB2, MS SQL Server, Oracle, and other platforms.
• Design secure, efficient data exchange solutions for both batch and real-time processing across cloud and in-house systems.
• Define and enforce policies, procedures, and best practices for data modeling, storage, and governance.
• Conduct profiling, analysis, and performance tuning to maintain high-quality, reliable databases.
• Manage relational databases, metadata repositories, and enterprise schemas while ensuring regulatory compliance and system security.
• Provide input on data sharing, integration, and analytics initiatives, including infrastructure for reporting, AI/ML, and data products.
• Coordinate complex software installations, version upgrades, and migrations across distributed environments.
• Work with IS staff, vendors, and business units to assess needs, solve problems, and align technology with agency goals.
• Develop and execute database backup, recovery, and disaster recovery plans to minimize downtime to system failures, assist users with data issues, and train staff on database tools and best practices.

Benefits

• Work/life balance
• 11 paid holidays a year
• Flexible work schedules
• Paid leave
• Public Service Loan Forgiveness opportunity

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 501-1,000 employees