Core PS6 (Havertown)

Compensation

: $40,270.00 - $63,940.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Short Description:
Product Specialist (PS6) - 10 plus years relevant experience- *This position has the opportunity for extension based on candidate experience and performance.*

Complete Description:
Oracle Query Database
PSERS currently has a read-only Oracle Database that is used for querying data. Data is replicated from the production database to another instance of Oracle. Application Developers and Business Analyst configure queries to run against the query DB to minimize impact on the main production Oracle DB. PSERS would like the Oracle Database Administrator to research the current setup and make recommendations to improve the reliability and availability of the query only database.

Oracle OEM
PSERS currently has Oracle OEM deployed and is seeking a candidate experienced with OEM to configure and document the OEM setup to monitor Oracle Database and Application servers, the following items are in scope:

Candidate must have working knowledge and at least 1 year of experience installing Oracle database software on a Windows 2012 or Windows 2016 environment.
Candidate must have working knowledge and at least 1 year of experience creating Oracle databases.
Candidate must have working knowledge and at least 1 year of experience exporting Oracle database subsets and restoring those subsets to a different Oracle database server.
Candidate must have working knowledge and at least 1 year of experience installing Oracle Enterprise Management 12c or higher on a Windows 2012 or Windows 2016 environment.


OEM Installation, Configuration, Documentation
1. Install Oracle Enterprise Manager software on sandbox server
1.1. Enterprise
1.2. Targets
1.3. Favorites
1.4. Setup
1.5. Profile (Upper right corner displaying users name)

2. Create incident rules
2.1. Create notification rules such as alerts when database instances are down
2.2. Create and implement alerts

3. Incident manager
3.1. Overview of incident manager
3.2. Demonstrate functionality

4. Create metrics for instances/servers

5. Enterprise Reports
5.1. Discuss the purpose
5.2. Demonstrate how to create and publish reports
5.3. Create reports based upon metrics collected
5.4. Add targets for new servers/instances
5.5. Add hosts
5.6. Identify errors and resolve errors

6. Security
6.1. Setup credentials
6.2. Modify credentials

7. Set targets in maintenance mode and creating blackouts

8. Notification Center
8.1. Discuss purpose
8.2. Set up notifications

9. Assist with documenting functions within OEM as configured for PSERS.

10. Perform work in pre-production instance and the migrate/configure production instance of OEM.

Skills:

Skill Required /Desired Amount of Experience Expertise Rating Oracle DBA experience Required 10 Years Database replication for DR Required 1 Years Oracle Enterprise Manager experience Required 6 Years Oracle integration with Active Directory for user authentication and role based security Desired 1 Years Oracle DB encryption, key management, and working with application developers to integrate applications with encrypted databases. Desired 1 Years Working knowledge and experience installing Oracle database software on a Windows 2012 or Windows 2016 environment Required 1 Years Experience exporting Oracle database subsets and restoring those subsets to a different Oracle database server. Required 1 Years Oracle Enterprise Management 12c or higher on a Windows 2012 or Windows 2016 environment. Required 1 Years Experience creating Oracle databases Required 1 Years
Associated topics: chief program officer, cpo, manage, manager, management, monitor, product manager, project manager, relationship manager, task * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...