Oracle DBA: Remote at Oracle, Arizona, USA |
Email: [email protected] |
From: Chandra N, Siri Info [email protected] Reply to: [email protected] Oracle DBA 10+ years Remote Rate : $55/hr C2C Only H1/USC Technical Skills: 1. in depth knowledge of identifying performance problems on Oracle instances (Azure VM AWS RDS) 1. Pinpoint specific cause of any performance issue (CPU, memory, disk in, tablespace, 2. Evaluating SQL plans to find high cost operations 3. Query performance tuning and being able to apply sg patches to add hints to queries. Evaluating need for indexes of query restructuring based on a query plan 5. Finding missing indexes and relations 6. Tuning SGA PGA 7. Strongly driven to monitor alert on performance metrics Database recovery 1. Proficient in Backup and restore operation 2. Perform Point in Time restores 3. Recover tables-recover tables using Oracle Flashback 4. Validate backups are successful and maintaining retention Roles & Responsibilities: 1. Creating, managing and monitoring application jobs using the Oracle job scheduler 2. Experience with database Gul tools such as SQL Developer, Toad and DEM 3. Proficient in the use of SQL and PL/SQL Proficient irr shell scripting on the Sioux platform Expert with Azure VM BHEL and evaluating performance metrics to take corrective action Expert with AWS RDS Oracle and evaluating clothwatch performance insights metrics to take corrective action 2. Performing periodic security checks to maintain security policies Keywords: procedural language Oracle DBA: Remote [email protected] |
[email protected] View all |
Tue Sep 03 23:32:00 UTC 2024 |