137 applicants

Company

ASSYST · 14 hours ago

Oracle Database Performance Engineer

United States

Full-time

Remote

Senior Level, Lead/Staff

10+ years exp

Maximize your interview chances

Big DataEnterprise Resource Planning (ERP)

Culture & Values

Insider Connection @ASSYST

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Identifies performance and scalability bottlenecks and issues and propose solutions to resolve the same.

Simulates user/system traffic/load using scripts or other mechanisms, measure, evaluate and analyze component behavior.

Optimizes code, queries, and system configurations to improve response time, scalability, and resource efficiency (CPU, memory, I/O).

Analyzes and interprets Oracle wait events, AWR Raw data and trace and correlate observations and analysis to system behavior.

Generates and analyzes AWR, ASH and ADDM reports.

Extrapolates system behavior under representative load to predict system behavior under full load/stress.

Extrapolates system behavior from application and data tier metrics.

Communicates complex results, analysis, and metrics to diverse technical and non-technical audience.

Evaluates and predicts future performance needs based on application usage trends, traffic patterns, and growth projections.

Conducts detailed root cause analysis (RCA) on performance issues to pinpoint the underlying cause of slowdowns or failures.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Oracle Database PerformancePerformance TuningLinux Shell ScriptingSQL TuningOracle Wait InterfaceAWR AnalysisASH AnalysisADDM AnalysisOracle ExadataRoot Cause AnalysisPerformance Bottleneck TroubleshootingApplication Behavior AnalysisModeling Tools VisioModeling Tools ErwinMicrosoft Office SuiteMS ProjectJIRA SoftwareAgile MethodologyHealthcare Industry ExperienceTechnical Writing

Required

10 year of experience in analyzing and evaluating application performance across multiple tiers with particular emphasis on the data tier in both cloud and on-prem environments.

Experience with identification and solution implementation for performance and scalability bottlenecks and issues

Experience with Oracle wait interface and event analysis

Experience with Performance tuning of large Oracle databases in AWS (50+ TB)

Experience with large Oracle Exadata databases and clusters

Experience with Single node non-Exadata Database tuning

Experience with Linux shell scripting, SQL tuning and session tracing.

Experience with AWR, ASH, ADDM generation and analysis

Experience with Oracle AWR Raw data analysis and interpretation.

Experience Extrapolating system behavior under representative load to predict system behavior under full load/stress.

Experience with Presenting complex results, analysis, and metrics to a diverse audience of technical and non-technical personnel.

Experience with Troubleshooting performance bottlenecks and issues.

Knowledge of Oracle internals pertaining to database performance

Experience with understanding of application behavior, performance, and interaction patterns with DBs in relation to performance and scalability.

Experience with extrapolating application and data tier metrics to explain system behavior.

Experience with Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.

Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality