Principal Data Systems Operations Developer

As a Principal 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.

Qualifications/Skills:

Required:

• B.S. in computer engineering or equivalent work experience

• Solid knowledge of Oracle database internals

• At least 12 years’ hands-on 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

  • Or 8 years with master’s degree
  • Or 5 years with PhD

• Proficiency in SQL and extensive experience with database driven applications

• Excellent communicator in both technical and non-technical contexts

• A passion for performance optimization work. You love to improve system scalability through smart iteration, intelligent testing, logically sound proof-of-concept work, and innovation

• A focus on designing for reliable and repeatable results, from the design stage through testing and into production

• A mindset focused on the importance of testing to validate working designs, discovering new and better configurations, and generating data that guides decision making with demonstrations of value

• A desire to delight the customer by taking initiative, responsibility, and ownership of your projects

• SaaS, PaaS, IaaS, or ASP environment work experience

Recommended:

• Exadata and/or RAC experience.

• Agile/Scrum development experience.

• Enterprise business application development experience.

• Experience working on defining and refining requirements.

Basic Linux proficiency.