As a Performance Database Engineer you'll work in a expert role to diagnose and resolve performance issues with slow SQL. You'll encounter a variety of interesting problems and find ways to solve them rapidly and effectively. You should be familiar with Oracle SQL tuning, database waits, and performance views and reports such as ASH and AWR.
The core skill needed for this role is SQL tuning. Database internals knowledge and schema related experience are secondary, but occasionally valuable. You will be hands-on in your approach, often modifying SQL by hand and running test timings to see the results, then implementing hints or other changes to resolve problems.
This position calls for weekend coverage; so 4 days of work per week instead of 5, on a Friday-to-Monday schedule. A typical work week would include 10 hours per day Friday through Monday, and a handoff to a different regional team at the end of day. You will have DBE partners in both USA and Australia to enable round-the-clock response coverage. When not working on SQL tuning and deeper database investigations, you may have opportunities to work on small to medium sized functionality improvements and database related projects. Every day is a little different, but every day is focused on improving SQL performance and improving the customer experience.
A Bachelor's degree in a technical area or equivalent experience in a relevant field is required. A candidate should have at least 3 years of experience in performance tuning, database development, software engineering, or database engineering; or directly related SQL tuning experience in other roles such as QA or SRE. A positive desire to learn, listen, think, test, and fix problems daily is essential to success. So is a desire to rapidly and independently solve problems. You need to be very capable with SQL, and good at finding metadata to track down a hunch or hypothesis. You should be comfortable with index access paths, joins, and response times. A solid knowledge of data structures and algorithms is helpful. The position can be Performance DBE or Senior Performance DBE, depending on expertise and experience.
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status or any other characteristic protected by law.
by via developer jobs - Stack Overflow
No comments:
Post a Comment