About this role
As a Senior Data Systems Operations Developer, you'll work in an 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 classes and wait events, and performance views and reports such as ASH and AWR.
The core skill needed for this role is SQL tuning. Oracle 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.
You will have 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 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.