Oracle PeopleSoft Applications Database Administrator
Job Code: 4762
Reporting to the Senior Technical Manager of Student & HR Systems in Stanford University IT (UIT), this position provides critical PeopleSoft applications and database administration support of enterprise business systems for Stanford University. A successful candidate will have good experience in the installation, upgrade and maintenance of PeopleSoft production and development infrastructure environments. Candidate must have PeopleSoft Administration as well as database administration experience.
Install, configure, upgrade, administer, monitor, and maintain highly available PeopleSoft PIA, web, application servers and databases.
- Provide PeopleSoft applications administration and databases services support.
- Build, configure, secure and enhance PeopleSoft PIA server environments.
- Design, install and maintain highly-available and secure application environments using current web and app server technologies (load balancing and clustering methods).
- Maintain, monitor highly available and secure databases environments.
- Provide on-going application patching, administration and technical support.
- Configure, upgrade, and support relational database management systems (Oracle RDBMS, MySQL, etc.).
- Utilize products such as OEM, Cloud Control, PPM, PTF to monitor health of systems.
- Develop and maintain efficient and appropriate integration/connectivity solutions between various campus databases to ensure necessary data is available as needed.
- Participate in performance loading testing, tuning and improving operational processes.
- Review the physical and logical design of databases for optimal database structures, performance tuning, security, and database backup/recovery. Plan and implement pro-active and reactive performance analysis, monitoring, troubleshooting, and capacity planning.
- Take responsibility for database design and performance optimization, backup and recovery, as well as monitoring the overall health of the database environment.
- Perform and maintain change management process and procedure.
* - Other duties may also be assigned
Education & Experience:
Bachelor's degree and eight years of relevant experience or a combination of education and relevant experience.
Knowledge, Skills and Abilities:
- Must have solid PeopleSoft Administration experience.
- Hardworking, quick learner with can-do attitude and aptitude.
- Team player and work with multi-functional teams
- Current PeopleSoft and Oracle DBA skills(Oracle 12c or higher).
- Experienced with recent PeopleSoft and PeopleTools 8.54+ patching and upgrade
- Experienced on Middleware technology with Tuxedo 11g and 12c, Apache, Tomcat and fusion middleware.
- PeopleSoft Cloud deployments using DPK
- UNIX Shell. WLST/Shell scripting, SQL scripting automation is highly preferred.
- Demonstrated experience in the support requirements of large database applications/systems including performance analysis and tuning of high volume, transaction systems.
- Knowledge of Linux and Windows systems platform.
- Oracle Apex administration is a plus.
- Good experience in shell programming environments.
- Ability to work well independently or as a team member.
- Ability to maintain knowledge of new and current technology and trends.
- Ability to collaborate with vendors and system service providers, provide administration for system solutions, and act as a liaison.
- Extensive experience with database security protocol.
- Skilled in troubleshooting, configuring Weblogic, Apache, Tomcat and Oracle technologies
- Proven experience in Apache and Weblogic servers. SSL certificate management – PKI, CSR, keytool, key creation via openssl and weblogic keystore management
- Setup and management of Oracle data guard. GC, MySQL and or MongoDB experience is a plus.
- Skilled in installation/setup and management of highly available application clustered environment.
- Cloud implementation experience is a plus.
Certifications and Licenses:
- Constantly perform desk-based computer tasks.
- Frequently sit, grasp lightly/fine manipulation.
- Occasionally stand/walk, use a telephone.
- Rarely writing by hand, lift/carry/push/pull objects that weigh up to 10 pounds.
* - Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.
- Extended and weekend hours.
- Some off hour work maybe required during work week.
- Must be available for on-call work.
Why Stanford is for You:
- Stanford University has revolutionized the way we live and enrich the world. Supporting this mission is our diverse and dedicated 17,000 staff. We seek talent driven to impact the future of our legacy. Our culture and unique perks empower you with:
- Freedom to grow. We offer career development programs, tuition reimbursement, or audit a course. Join a TedTalk, film screening, or listen to a renowned author or global leader speak.
- A caring culture. We provide superb retirement plans, generous time-off, and family care resources.
- A healthier you. Climb our rock wall, or choose from hundreds of health or fitness classes at our world-class exercise facilities. We also provide excellent health care benefits.
- Discovery and fun. Stroll through historic sculptures, trails, and museums.
- Enviable resources. Enjoy free commuter programs, ridesharing incentives, discounts and more!
- Redwood City. Our new Stanford Redwood City campus, scheduled to open in 2019, will be the workplace for approximately 2,700 staff, including University IT, whose jobs are important to supporting the University’s mission. The campus will offer amenities such a onsite cafes and a dining pavilion, a high-end fitness facility with an outdoor pool, and a childcare center for Stanford families.
We are not able to provide relocation or sponsorship for this position.
How to Apply
We invite you to apply for this position by clicking on the “Apply for Job” button. Please submit your resume and a one-page cover letter along with your online application.
Stanford is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law.