PostgreSQL performance tuning
Practice explaining how you would design database resources and tune an application for performance and scalability.
The Database Administrator III role designs database resources and tunes applications for optimum performance and scalability.
Source posting