Oracle​/Exadata DBA

Core Responsibilities of a Technical Administrator - Oracle Database Administrator:

• The ability to build and maintain the issuances for the Oracle database client software installation.
• The ability to define/understand and manage the database processes and provide feedback to enhance them.
• The ability to work with Oracle Support on Oracle Service Requests.
• The ability to troubleshoot problems.
• The ability to create and support environments and databases for business application product teams.
• The ability to enable backup/recovery jobs and execute backup/recovery when needed using Data Guard and OEM.
• The ability to perform a database refresh when required.
• The ability to monitor performance and space for application databases.
• The ability to monitor performance of all Engineered System environments, Exadata and Exadata Cloud@Customer.
• The ability to complete any State Farm Infrastructure changes to the environment, including tasks with IaaS Server patches and Data Center Network changes.
• The ability to complete any Risk and Compliance findings.
• The ability to perform tasks associated with hardware installations and/or migrations.
• The ability to perform tasks associated with patching/maintenance of the Engineered Systems, Exadata and Exadata Cloud@Customer.
• The ability to define/understand the Version Management Plan for the database tools utilized and the Engineered Systems.
• The ability to utilize Oracle Enterprise Management (OEM) for monitoring, scheduling backups, discovering targets, etc.
• The ability to define/understand the Capacity Management Plan.
• The ability to tune/optimize the Virtual Clusters residing on the Engineered Systems, Exadata and Exadata Cloud@Customer.
• The ability to perform tasks associated with Disaster Recovery/High Availability.
• The ability to educate Business Partners on how their application interacts with Oracle Databases and the Environment.
• The ability to define/understand the Database Version Management Plan.
• The ability to perform database migrations.
• The ability to enable the Database Strategies (Encryption (TDE, Oracle Key Vault), Multi-Tenant).
• The ability to understand OCPU Utilization needed to ensure the environment is appropriately utilized.
• The ability to understand and utilize Oracle Cloud Infrastructure to perform database functions.
• The ability to perform SCP files from one server to another.
• The ability to perform SFTP files from one server to another.