Analyst Programmer (Oracle DBA & AWA administrator)

The Analyst Programmer DBA reports to the Application Development Manager in Enterprise Application Services and is responsible for ensuring the effective administration of OSU Oracle databases and applications used to support key administrative functions such as enrollment, registration, grading, and user authentication processes operate smoothly, securely and efficiently. The ideal candidate is an organized and procedural individual with a strong sense of responsibility and accountability and the ability to dig deeply into technical puzzles and challenges. The DBA will actively evaluate and support new technologies and participate in technical planning and deployment of Oracle database solutions. This includes administrative applications such as Banner, OSU's Data Platform, and Transactional Integration Platforms which use support these Oracle databases.

The Oracle DBA is responsible for the hands-on administration and day-to-day operational support of Oracle database environments used to support key functions. This position works within established architectural standards, governance processes, and security frameworks to ensure reliability, availability, and compliance of supported systems across production and non-production environments.

In addition, the System Administrator maintains system documentation and configuration standards, ensures audit readiness, and contributes to audit readiness activities by maintaining documentation, configuration standards, and supporting audit-related requests in coordination with technical leadership, security, and compliance partners. This position plays a critical role in safeguarding the integrity, compliance, and effective operation of the platform.

Other related responsibilities include providing support for code management, job scheduling support, and Disaster Recovery planning and testing. This position also supports Workday Tenants (production and non-production)., 40% -Oracle Database Administration

35% - Application Integration and Support

15% -Infrastructure Support, Standardization, and Optimization

10% - Teamwork and other duties as assigned

This classification requires a basic foundation of knowledge and skills in systems analysis and related programming support functions generally obtained by a bachelor's degree in computer science, or an equivalent amount of training and applied experience.

What You Will Need

• Solid fundamental knowledge of database design and computer operating systems, including system components and resource utilization
• Experience with Oracle database management ( DBA ), or equivalent database management experience supporting complex ERP level databases (min 3 years is preferred)
• Excellent verbal and written communication skills
• Ability to write stored procedures, and demonstrated competency with coding, testing, debugging, and documenting.

This position is designated as a critical or security-sensitive position; therefore, the incumbent must successfully complete a criminal history check and be determined to be position qualified as per University Standard: 05-010 et seq. Incumbents are required to self-report convictions and those in youth programs may have additional criminal history checks every 24 months.

What We Would Like You to Have

• Demonstrated experience with Kubernetes containers
• Demonstrated experience with Ansible
• Experience managing Workday Tenants within a complex corporate or higher education environment
• Direct work experience with Oracle database structure and design, Oracle, ODS solutions, Ellucian Banner, other Ellucian higher education software products, shared storage solutions, system and database backup methodologies and monitoring tools
• Experience with Workday Studio, Workday Extend
• Experience with C, HTML , Java, SQL , PHP , Apache, Tomcat and Python
• Experience working in a higher education environment
• Linux server system administration skills
• Strong customer service skills, Equivalent required experience is based on full-time equivalent (40 hours per week).

Oregon State has a statewide presence with campuses in Corvallis and Bend, the OSU Portland Center and the Hatfield Marine Science Center on the Pacific Coast in Newport.

Oregon State's beautiful, historic and state-of-the-art main campus is located in one of America's best college towns. Corvallis is located close to the Pacific Ocean, the Cascade mountains and Oregon wine country. Nestled in the heart of the Willamette Valley, this beautiful city offers miles of mountain biking and hiking trails, a river perfect for boating or kayaking and an eclectic downtown featuring local cuisine, popular events and performances.

Total Rewards Package

Oregon State University offers acomprehensive benefits package (https://hr.oregonstate.edu/benefits/prospective-employee) with benefits eligible positions that is designed to meet the needs of employees and their families including:

-Medical, Dental, Vision and Basic Life. OSU pays 95% of premiums for you and your eligible dependents.

-Free confidential mental health and emotional support services, and counseling resources.

-Retirement savings paid by the university.

-A generous paid leave package, including holidays, vacation and sick leave.

-Tuition reduction benefits for you or your qualifying dependents at OSU or the additional six Oregon Public Universities.

-Robust Work Life programs including Dual Career assistance resources, flexible work arrangements, a Family Resource Center, Affinity Groups and an Employee Assistance Program.

-Optional lifestyle benefits such as pet, accident, and critical illness insurance, giving you peace of mind and the support you need to thrive in all aspects of your life.

Future and current OSU employees can use theBenefits Calculator (https://hr.oregonstate.edu/benefits/new-employees/benefits-calculator) to learn more about the full value of the benefits provided at OSU ., This position will work a typical Monday - Friday schedule and will be based on the Corvallis campus.

This position may at times require work outside of normal business hours and/or weekends.

Remote potential: This position may qualify for remote work. Some occasional on-site presence may be required for training, meetings, etc. Remote work is dependent on business needs.

Pay Method Salary

Pay Period 1st through the last day of the month

Pay Date Last working day of the month

Min Salary $5,511 monthly

Max Salary $10,228 monthly

At Oregon State University ( OSU ), University Information and Technology ( UIT ) is at the forefront of the university's technological transformation. UIT is dedicated to empowering the entire university community by providing secure access to the right data, tools, and services needed to navigate and shape their unique paths to success. By protecting OSU's technological assets and managing resources efficiently, we enable the university to thrive in an ever-evolving landscape. Led by the Office of the Chief Information Officer ( CIO ), UIT manages IT operations for OSU's three campuses, serving students in Oregon's 36 counties and in more than 100 countries. UIT's leadership philosophy centers around a human-centric and fully architected technology landscape, leveraging enterprise solutions for common good services while empowering individual colleges and business units to innovate and invest in their missions and initiatives. UIT designs and implements a seamless, interconnected digital ecosystem that aligns to the university's strategic goals and maximizes impact. The division is comprised of trusted partners and consultants committed to igniting innovation and fostering a culture of continuous improvement by providing expert guidance and innovative solutions that support the university's teaching, research, outreach and extension mission. Together, we are building a future where technology and education converge to create limitless possibilities., AI Statement: OSU IT embraces the transformative potential of artificial intelligence (AI) to drive innovation, enhance efficiency, and create meaningful impact across our teaching, research, and administrative functions. As a member of the OSU IT community, the person in this position is expected to thoughtfully engage with AI tools and practices, champion their ethical and responsible use, and actively contribute to the development of AI-driven solutions that uphold our institutional values and advance the university's mission. Data Statement: OSU IT commits to deliver data as a strategic working asset and to enable data informed decision making across OSU . OSU IT leaders and staff lead by example and use data to inform decision making at all levels in the organization. Persons in technology roles are also expected to design systems with data portability in mind and work within enterprise architecture and privacy guidelines. DEIA Statement: OSU IT commits to and believes in the strength and value of diversity, equity, inclusion, and access ( DEIA ) both throughout our team and as an intentional and active practice to advance the vision, mission, and strategic efforts of the entire university. As a member of the OSU IT community, the person in this position is expected to foster and promote the values of DEIA and demonstrate a commitment to inclusive excellence in their work. Security Statement: Proactively securing and protecting OSU's digital assets and information systems is crucial to our missions of teaching and learning, research, and extension and engagement. All OSU IT professionals are directly responsible for providing high quality and secure IT systems and services. Persons in technology roles are expected to be responsive to security related actions and requirements, and to collaborate to find secure ways to support the OSU community. Why OSU? Working for Oregon State University is so much more than a job! Oregon State University is a dynamic community of dreamers, doers, problem-solvers and change-makers. We don't wait for challenges to present themselves - we seek them out and take them on. We welcome students, faculty and staff from every background and perspective into a community where everyone feels seen and heard. We have deep-rooted mindfulness for the natural world and all who depend on it, and together, we apply knowledge, tools and skills to build a better future for all. FACTS : -Top 1.4% university in the world -More research funding than all public universities in Oregon combined -1 of 3 land, sea, space and sun grant universities in the U.S. -2 campuses, 11 colleges, 12 experiment stations, and Extension programs in all 36 counties -7cultural resource centers (https://hr.oregonstate.edu/work-life/diversity-and-cultural-resources) that offer education, celebration and belonging for everyone -100+ undergraduate degree programs, 80+ graduate degrees plus hundreds of minor options and certificates -35k+ students including more than 2.3k international students and 10k students of color -217k+ alumni worldwide