Overview
On Site
$50 - $60,000
Contract - W2
Contract - 8 Month(s)
75% Travel
Skills
Cloud Computing
Performance Tuning
Oracle Db
Database
Job Details
The high-level responsibilities of the Oracle DB Performance engineer will be as below:
- Identify performance bottlenecks, resource contention, and areas of inefficiency, and provide actionable insights for improvements.
- Recommend and implement changes to query structures (e.g., indexing strategies, query refactoring) to improve performance.
- Regularly rebuild or reorganize indexes to avoid fragmentation and improve data retrieval efficiency.
- Fine-tune database configurations (e.g., buffer sizes, connection pooling, memory allocation) to maximize resource utilization and ensure optimal performance.
- Analyze current and future database growth patterns and plan for scalability to handle increasing data volume and user loads.
- Implement strategies for vertical and horizontal scaling, including partitioning, sharding, and distributed databases.
- Configure and optimize database replication for fault tolerance and performance, ensuring minimal lag between nodes.
- Conduct root cause analysis (RCA) of recurring performance issues, providing solutions to prevent future occurrences.
- Work closely with developers to optimize database interactions, improve SQL query efficiency, and establish best practices for database access.
Collaborate with operations teams to ensure that the database infrastructure (cloud, on-premises, etc.) is aligned with performance requirements and can support future growth.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.