Product Specialist (PS6) - 10 plus years relevant experience- *This position has the opportunity for extension based on candidate experience and performance.*
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.
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.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.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.
Launch your career - Create your profile now!Create your Profile
Loading some great jobs for you...