| Description: |
All applications must be submitted through the Pepperdine University Human Resources Online Employment site at https://jobs.pepperdine.edu No resumes will be accepted without an application. AN EQUAL OPPORTUNITY EMPLOYER Principals only; no agencies. JOB DESCRIPTION: Design physical data structures supporting applications requirements and may assist in the design of logical data structures; assist in the identification of information flows; aDesign physical data structures supporting applications requirements and may assist in the design of logical data structures; assist in the identification of information flows; analyze data flow between systems to establish entity and functional relationships; provide logical and physical database design; analyze data requirements and develop design specifications; create test files and perform system tests; perform integration testing; support and assist in establishing enterprise database development standards; assist in establishing enterprise metadata models; define system specific dependencies; provide, evaluate and develop data access tools and techniques to enable information access by business users; schedule and perform upgrades of databases, adding new structures and elements; monitor utilization for capacity planning; forecast utilization patterns and recommend modifications or upgrades; analyze audit trails to detect systematic security violations; make recommendations to improve security; perform database backup and recovery procedures; establish requirements, methods and procedures; track and report database performance metrics; assist in developing performance metrics; monitor, analyze, and calibrate database management system (DBMS) parameters so that the database is tuned for optimal performance; schedule and implement enterprise DBMS software installs; assist in establishing the methods and procedures of database installations; evaluate future technologies and make recommendations for software and hardware upgrades; provide technical leadership, coaching, and mentoring to less-experienced individuals; oversee training of personnel; perform other duties as assigned.nalyze data flow between systems to establish entity and functional relationships; provide logical and physical database design; analyze data requirements and develop design specifications; create test files and perform system tests; perform integration testing; support and assist in establishing enterprise database development standards; assist in establishing enterprise metadata models; define system specific dependencies; provide, evaluate and develop data access tools and techniques to enable information access by business users; schedule and perform upgrades of databases, adding new structures and elements; monitor utilization for capacity planning; forecast utilization patterns and recommend modifications or upgrades; analyze audit trails to detect systematic security violations; make recommendations to improve security; perform database backup and recovery procedures; establish requirements, methods and procedures; track and report database performance metrics; assist in developing performance metrics; monitor, analyze, and calibrate database management system (DBMS) parameters so that the database is tuned for optimal performance; schedule and implement enterprise DBMS software installs; assist in establishing the methods and procedures of database installations; evaluate future technologies and make recommendations for software and hardware upgrades; provide technical leadership, coaching, and mentoring to less-experienced individuals; oversee training of personnel; perform other duties as assigned. SKILLS/QUALIFICATIONS: Requires an associate's degree in programming/systems, computer science or mathematics, specialized training, certification, or equivalent work experience; 4-6 years experience working with various database management systems in database design, testing, implementation, maintenance, and administration required; at least 5 years experience as a production or development Oracle Database Administrator; working knowledge of backup and recovery procedures, basic performance and application tuning, database creation, space management and other database maintenance procedures including standards and documentation; proven experience with the installation and maintenance of Oracle Databases and PeopleSoft application architecture; experience writing scripts and triggers with SQL and PL/SQL; proven knowledge of stored procedures; knowledge of Unix Shell scripting; knowledge of BEA Tuxedo and WebLogic Applications; knowledge of Oracle 10g; experience working with Oracle RDBMS physical architecture required; familiar with Oracle running on IBM AIX and Windows Operating Systems; superior research and analysis skills with the ability to define critical issues, functional priorities and competitive factors; excellent financial, analytical and problem solving skills; strong written and oral communication skills; proven ability to multi-task in a fast-paced environment; ability to prioritize, take initiative, self learn and work well under pressure. |
