Reporting to the Senior Technical Manager of Student & HR Systems in Stanford University IT (UIT), this position provides critical PeopleSoft applications and database administration services and support of enterprise business systems for Stanford University. A successful candidate will have demonstrated experience with the installation and maintenance of stable production and development infrastructure.
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.
Configure, upgrade, and support relational database management systems (Oracle RDBMS, MySQL, etc). Design, develop, and maintain highly-available application environments (load balancing and clustering methods).
Maintain, monitor highly available and secure applications and database environments.
Provide on-going application system administration and technical infrastructure support. Take responsibility for database design and performance optimization, backup and recovery strategies and implementation, as well as monitoring the overall health of the database environment. Execute complete database solutions from evaluation to implementation. 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. Utilize products such as Cloud Control, PPM, PTF to monitor health of systems. Develop and maintain efficient and appropriate connectivity solutions between various campus databases to ensure necessary data is available as needed. Assist in performance testing, tuning, and improving operational processes.
* - 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 of PeopleSoft Administration experience Hardworking, quick learner with can-do attitude. Strong Oracle DBA skills supporting PeopleSoft with Oracle 11g and 12c. Solid experience in cloning databases. Experienced with PeopleSoft PeopleTools 8.53+: Application Designer, Data Mover, and Upgrade with Change Assistant and patch updates with PUM. Experienced on Middleware technology with Tuxedo 11g and 12c, Apache, Tomcat and fusion middleware. Oracle Apex administration. 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 hierarchical database systems. Extensive knowledge of systems platform. Extensive knowledge and experience in the design and implementation of complex database architecture. Extensive experience in programming environments. Ability to develop a vision for future computing needs and to develop appropriate plans to meet these needs. 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. Desired Skills: Highly technical in troubleshooting Weblogic, Apache, Tomcat, Server and Oracle logs. 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. Proven experience implementing highly secure application and server infrastructure.
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.
Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations. Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned. Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University's Administrative Guide, http://adminguide.stanford.edu.
We are not able to provide sponsorship or relocation for this position.
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.
Located between San Francisco and San Jose in the heart of Silicon Valley, Stanford University is recognized as one of the world's leading research and teaching institutions. Leland and Jane Stanford founded the University to "promote the public welfare by exercising an influence on behalf of humanity and civilization." Stanford opened its doors in 1891, and more than a century later, it remains d...edicated to finding solutions to the great challenges of the day and to preparing students for leadership in a complex world. The University's thriving diverse community is comprised of nearly 7000 undergraduate students, 9000 graduate students, 2000 faculty members, 1900 postdoctoral scholars, and over 11,000 academic and administrative staff in seven schools including several interdisciplinary research centers and institutes. The campus spreads over 8000 contiguous acres and nearly all undergraduates live on campus. Stanford offers bachelor's and master's degrees in addition to doctoral degrees (PhD, MD, DMA and JD) plus a number of professional and continuing education programs and certifications. More at http://facts.stanford.edu and http://www.stanford.edu.
Stanford University is an equal opportunity employer and is committed to increasing the diversity of its faculty. It welcomes nominations of and applications from women, members of minority groups, protected veterans and individuals with disabilities, as well as from others who would bring additional dimensions to the university’s research, teaching and clinical missions.