Senior Database Administrator

Senior Database AdministratorInformation Systems Specialist 8 – Senior Database Administrator Oregon Department of Transportation Support Services Division – Information Systems Branch Enterprise Technology Security and Database Administration Salem / HybridThe role: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!This announcement has been revised to allow it to remain open until filled. Our first application screening is scheduled for 8:00 a.m. on Friday, July 31, 2026. We encourage interested applicants not to delay in applying.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.Before applying, visit our applicant information website to learn more about our process. If you are a current State of Oregon employee, you must apply through your employee Workday profile.A day in the life: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.Work in an office environment with hybrid work options available.To request a copy of the position description, which includes all duties and working conditions, please email View email address on click.appcast.io's in it for you:Work/life balance, 11 paid holidays a year, flexible work schedules, paid leave and so much more. Learn more about working at the Oregon Department of Transportation and the benefits we offer.Comprehensive and equitable base salary offer within the listed range. Through an equal pay assessment, we will determine the salary offer using the information you provide in your submitted application materials. Please ensure your application materials are detailed, accurate and reflect your skills, experience (paid and unpaid) and education as they relate to the position when applying.The salary range listed is the non-PERS monthly salary range. If you are already a participating PERS member or once you become PERS eligible, the salary range will increase by 6.95%.Public Service Loan Forgiveness opportunity!Minimum qualifications:Seven (7) years of information systems experience in: Database administration that includes all of the following databases: SQL, Oracle, and DB2 development, or a combination of 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 that includes all of the following databases: SQL, Oracle, and DB2, or a combination of 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 that includes all of the following databases: SQL, Oracle, and DB2, or a combination of 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 that includes all of the following databases: SQL, Oracle, and DB2, or a combination of database architecture and modeling, and database administration.What we'd like to see:Experience in Database architecture, design, and implementationExperience documenting DBA processes for MS SQL, IBM DB2 and Oracle, handing these processes off, and provide training as needed, in support of said processesHow to apply:Complete the following required steps:Fill out the application or attach a resume. Please contact the recruiter under the 'Need help?' section if you have any questions about how to fill out the experience fields or to attach a document. Your submitted experience fields or attached resume must include dates (MM/YYYY) for each employer.Attach a cover letter. Your cover letter should clearly demonstrate how your experience and training relates to the qualities that you have under the "what we'd like to see" section above.Your cover letter must be limited to no more than two (2) pages.Please address your cover letter to Teresa Rankin, Security and Database Administration Manager.Generic cover letters that do not address the qualities that you have under the "what we'd like to see" section may receive lower scores than those that addressed the desired qualities.You must upload your cover letter in the 'Resume/Cover Letter' section of the application.Complete questionnaire. Answer the checkbox-style questions before submitting your application.After you submit your application, please respond to the public records request authorization and gender identity questionnaire. This screen will come after you submit and will complete the process. If you are a current State of Oregon employee, the tasks will come to your Workday inbox.If you are a veteran or Oregon National Guard servicemember, you may receive preference. The task to upload your documents will be available after you submit your application. For privacy reasons, please do not attach your military service document(s) to your application or combine it with any other required document attachments.Need help?For questions, call View phone number on click.appcast.io or email View email address on click.appcast.io information:This recruitment will remain open until filled. Our first application screening is scheduled for 8:00 a.m. on Friday, July 31, 2026, but we may close the announcement at any time after this date when we have received an adequate number of applications. We cannot guarantee that we will consider applications received after this screening date. We encourage interested applicants not to delay in applying.We do not offer visa sponsorship. If you are hired, you will be required to fill out the US Department of Homeland Security's I-9 form confirming you are able to work in the US. We are not an E-Verify participating employer, and we are unable to proceed if E-Verify participation is required [e.g., STEM Optional Practical Training (OPT) Extension].The State of Oregon does not request or require your age, date of birth, attendance or graduation dates from an education institution during the application process.We may use this recruitment to fill multiple or future vacancies.We will conduct name-based and fingerprint-based criminal background checks on final candidates under consideration for this position. All applicants may be subject to additional pre-employment check(s) such as driver license, LEDS (Law Enforcement Data System), and/or education verification as required for the position.You will be represented by the Service Employees International Union (SEIU).ODOT is an Equal Employment Opportunity and Affirmative Action Employer. We do not discriminate on the basis of race, religion, color, sex, age, national origin, disability, sexual orientation or any other class protected by state or federal laws in admission or access to our programs, services, activities, hiring, and employment practices. Applicants with a disability may request a reasonable