PRIMARY FUNCTION :
Responsibilities include performance of Database Administration and Database design and development functions for an expanding suite of Oracle-based applications, with an emphasis on providing Oracle DBA support for PeopleSoft Supply Chain Management, Financials, and Human Resources databases hosted on Red Hat Linux servers. These functions include RDBMS software installation, maintenance, and support; creation and modification of database storage structures and objects; managing user access to databases; monitoring and optimizing database performance and availability; planning and execution of recovery schemes; technical support for development activities; including logical and physical database design and development of database stored procedures.
Ensure policies and procedures are being followed regarding databases
Incident management and communication to the user community
Posting of alerts, system status changes, and other web-based communications.
Communications between Technology Services, Service Center, Applications group and Client Services groups
Monitor database logs and performance issues
Troubleshoot and identify problems with database / application performance
Maintain server and database uptime through use of various monitoring, reporting, and alerting solutions.
Proactively works with clients and other technical support staff to resolve production issues.
Develop scripts for consistent and secure execution of common tasks
Proactively raises issues if specifications, architecture, or implementation strategies will lead to quality or system performance issues or problems.
Participates in technical design reviews, functional specification reviews, and contributes to ongoing project estimates, scheduling, test plans, and code reviews.
Demonstrates self-directed and proactive approach to tackling problems and leveraging resources consistent with the overall goals of the project.
Proactively mentors and recommends training for team members as well as members of other departments.
OTHER FUNCTIONS AND COMPETENCIES:
This individual will be part of the on-call rotation. These responsibilities will entail monitoring the ticket queue and resolving/assigning tickets as necessary as well as providing assistance to internal IS&T technicians, as needed, for database & application related issues and questions. This responsibility entails responding to off-hours calls for 24x7 support systems, and either resolving the problem or escalating to the necessary IS&T technician, engineer, or manager.
This individual should have a high level of technical ability, and be able to work in a fast-paced environment. A team-oriented individual with good oral and written skills is required for this position. Must be able to sit/stand for extended periods of time, lift and carry up to 40 lbs., unassisted.
This individual may also be called upon to perform projects and other activities by management.
EDUCATIONAL/TRAINING REQUIREMENTS :
Bachelor’s degree in computer science or related field. ________________________________________________________________________ EXPERIENCE REQUIREMENTS :
Requirements include a minimum of 3 years Oracle database design, development and administration experience in a PeopleSoft environment. Experience with RMAN and TSM/CommVault backup technologies is desirable. Knowledge of Linux operating systems is required; experience in implementing Data Guard standby databases is preferred. Exposure to Oracle Data Warehousing, and SQL Server-based and/or MySQL-based applications is advantageous.
Jefferson Health delivers state-of-the-art healthcare services to patients throughout the Delaware Valley and southern New Jersey. Jefferson (Philadelphia University + Thomas Jefferson University) provides more than 7,800 students from nearly 40 states and 40 countries with 21 st century professional education. We have 30,000 employees.
Jefferson Health , with 14 hospitals (three are Magnet-designated by the ANCC for nursing excellence) and 50+ outpatient and urgent care locations, offers a broad range of primary and complex, highly specialized care that touches the lives of more than four million patients annually . This year, U.S. News & World Report has ranked Thomas Jefferson University Hospital as the 16 th best hospital in the nation, and among the nation’s best in 11 specialties. Jefferson Health also includes the NCI-designated Sidney Kimmel Cancer Center; it is one of only 69 such centers in the nation.
Thomas Jefferson University, nationally recognized for advancing groundbreaking developments in healthcare education and research, recently combined with Philadelphia University, internationally known for architecture, design, engineering, textiles and more. Jefferson (Philadelphia University + Thomas Jefferson University) has nine colleges and three schools dedicated to interprofessional and transdisciplinary approaches to learning that offer a vibrant and expandable platform for professional education. Through this unique model, we are preparing our students for current and yet-to-be-imagined careers.
As an employer, the Jefferson Enterprise maintains a commitment to provide equal access to employment. Jefferson values diversity and encourages applications from women, members of minority groups, LGBTQ individuals, disabled individuals, and veterans.
VISIT Jefferson Health
VISIT Jefferson (Philadelphia University + Thomas Jefferson University