OATUG Policies

Title: Oracle Application DBA

Employee Classification: Professional

Department: Application Solutions

Salary Range:  Commensurate with Experience

Who we are:

We are not-for-profit:  St. Louis Community college (STLCC) is a non-profit institution dedicated to empowering students, expanding minds, and changing lives. Employees are committed to strengthening the St. Louis community with inclusive and transformative education.

We are a respected employer:  For 60 years, STLCC has served the St. Louis community, expanding to 4 main campuses, 2 education centers, 2 workforce training centers, and 5 centers of excellence. More than one-half of the households in St. Louis have at least one member who has taken classes at STLCC.

We make an impact in the community:  Through credit courses, continuing education, and workforce development programs, STLCC annually serves nearly 69,000 students.  More than 80% of career and technical graduates employed in their fields or continue their education at four-year institutions within six months of graduation.  STLCC sends more transfer students to Missouri’s four-year colleges/universities than anyone else.

We value Diversity, equity & inclusion:  STLCC is committed to fostering an atmosphere of appreciation for all people, regardless of race, color, creed, religion, sex, sexual orientation, gender identity and expression, national origin, ancestry, age, disability, genetic information, veteran status, or class.

What you get:

Benefits package:  STLCC offers one of the best benefit packages in the St. Louis area. As a STLCC employee you will have access to a 100% match on your contribution to retirement, two health insurance plans options that are no cost to the employee - including an HSA option, low-cost life Insurance with a 3x salary benefit, and other low-cost benefits including dental, vision, AD&D, ST LT disability insurance.

Opportunity to grow:  Over half of our employees have served the college for more than 12 years, exploring different career paths and advancing to higher level positions.

Education & training opportunities: STLCC offers tuition waivers for employees + their dependents, tuition reimbursement for other institutions after just 6 months of service, and an annual professional development allotment.

Work/life balance:  STLCC employees have access to a generous time off package, including holidays, vacation, personal days, medical leave, and other leave options. Our holiday schedule even includes a paid winter holiday at the end of the calendar year.

Commitment to wellness:  STLCC HR boasts a dedicated health and wellness specialist who is enthusiastic about creating a culture of wellness throughout the College. With access to college wellness vendors, employees are educated, motivated, and rewarded for healthy behaviors. STLCC employees and anyone living in their household also have access to an employee assistance program (EAP) that can help them with virtually any life need.

The basics of this position:

Perform installations and upgrades of companion products and required components for the campus Enterprise Resource Planning (ERP) administrative system, Ellucian Banner. Perform administration tasks in support of the ERP and associated sub-applications. Install and manage middleware components and web application servers for ERP system. Perform designated Oracle database administration tasks for databases underlying the ERP. Duties include the support of the application systems security, system performance monitoring and tuning of applications, performance monitoring and tuning of Oracle databases; establish operational standards, and recommend hardware and software upgrades. Additional roles include security administrator for granting privileges to ERP modules and manage security classes, and report writer to query and create reports using a wide range of reporting tools and form template creation. Serves as a specialized technical consultant to the technology support staff.

What you'll do:

• Installs, upgrades and manages ERP components on Linux systems to include proprietary ERP upgrade tool; installs, manages and tunes java components supporting the ERP and component / companion applications. Installs and upgrades companion applications including compilers, job scheduling software, address correction software and others.
• Installs, configures, troubleshoots, and maintains application systems that interface with Oracle and other databases. Monitors and tunes those systems to ensure system integrity and provides high performance, high availability service.
• Coordinates and provides middleware support of Tomcat and messaging servers.
• Manages tomcat servers, instances and configurations directly supporting the ERP system; monitors for errors and utilization; troubleshoots and resolves issues.
• Implements new versions, updates, and patches fixes to application software systems. Maintains detailed knowledge of software trends and advancements regarding those systems.
• Coordinates and monitors system security for the ERP.
• Analyzes audit logs and takes appropriate action to address anomalies.
• Responds to legitimate internal and external requests for security related information.
• Routinely communicates with Information Technology and College directors and managers to codify institutional expectations into systems specifications for database architectures.
• Develops requests for proposals (RFPs) and coordinates solutions with third party vendors to ensure control of database projects.
• In coordination with the Senior Oracle DBA, performs replication, backup, and recovery tasks on Oracle databases.
• Troubleshoots and permanently corrects platform problems in a timely manner to provide 24/7
  availability of services.
• Responsible for managing problem escalation to Oracle and third party support teams as appropriate.
• Upgrades databases to new versions as directed; applies security updates and patching as appropriate.
• Performs database cloning, tuning and monitoring. Manages Oracle wallets.
• Implements new versions, updates, and patches fixes to the database management systems.
• Maintains detailed knowledge of computer hardware and software trends and advancements.
• Designs and implements business continuity and disaster recovery protocols.
• Operates, monitors and maintains redundant data center platforms for a disaster response. Tests disaster recovery protocols and platforms to ensure timely and reliable restoration of critical business activities.
• Advises programming staff, Linux and Microsoft system administrators and technical staff on advanced technical aspects pertaining to relational databases and related application software. Trains and instructs functional leaders and users in the proper use of multiple software products to maximize available capabilities.
• Participates in the formal system change management process and is responsible for ensuring that Banner changes are tested and perform as intended.
• Responsible for the integrity and security of the application and must be vigilant in protecting the access from unauthorized changes and disruptive system processes.
• Coordinates modifications, upgrades, new implementation and decommissioning efforts with affected system users.
• Participates in and contributes to divisional performance measurements and process improvement initiatives.
• Leads team activities to review and enhance workflows.
• Performs other job related duties as assigned.

Education, experience, and other requirements:

• Bachelor’s degree in Computer Science or closely related discipline.
• Work experience in database design and administration is necessary.
• 8+ years in an enterprise computing environment of comparable complexity,
• 5+ years of directly related, full-time experience in administrating Enterprise Resource Planning (ERP) Oracle applications
• Experience managing specific technologies of java and tomcat

Preferred Qualifications:

• Experience in basic Linux shell scripting is a plus.
• Experience in current operating environment and use of container technologies will be given preference.
• Oracle Certified Professional Certification, Red Hat System Administrator is a plus. Certification in systems and applications to be supported may be considered an equivalency for experience requirements.

Logo

About St. Louis Community College

STLCC has provided opportunity for all. As the largest higher educational institution in the region, STLCC has served more than 1.2 million students. Over 50% of households in the St. Louis area are represented in our former and current student body. Since 1962, St. Louis Community College has held fast to the fundamental belief that education has the power to lift us up — as individuals, as communities and as a city.Today, STLCC consistently ranks among the top associate degree-awarding institutions in the United States. As we launch students into new and better careers, four-year degrees and richer lives, we strengthen St. Louis one student at a time. The College employs 1,400+ full-time faculty and staff and 2,300+ part-time faculty and staff

Connections working at St. Louis Community College