An Interview with Tracy Tan: Database Administrator at Perfect Market

Article ImageName With The Face:
Tracy Tan

Job Title:
Database Administrator

Perfect Market


Job Function:
As the sole database administrator (DBA) for startup Perfect Market, which provides traffic and content optimization solutions for web publishers, Tracy Tan likes the dual nature of her role. "It's nice to play with data-when business users ask me questions I can retrieve the answers. But I also like table design, and I get to do that for both our operational database and data warehouse database."

The real-time nature of the job doesn't faze Tan. "In our sector, we need to closely monitor the performance of our design and delivery to make decisions based on up-to-the-minute results." She provides Perfect Market business analysts a technical interpretation of that data.

In A Day's Work:
The first task of Tan's day, whether in the office or on 1 of her 2 work-from-home days each week, is to ensure the prior evening's extract, transform, and load (ETL) job for the data warehouse has been completed successfully. "Then it's time to work on my regular tasks: table design, ETL-related tasks, or monitoring database performance," Tan says. As tech lead for the company's outsourced data warehouse developers, she interacts frequently via email and centralized project tracking tools to make sure the team in India is on track.

Most Memorable Customer Encounter:
"Our product manager wanted us to find out the most popular search terms
for a particular publisher's content, and our data analysis showed a noticeable percent of search terms related to sex-and traffic from certain regions had a higher correlation with those terms. Luckily our product manager is also female, otherwise it would have been more embarrassing to interpret!"

View From The Desk:
"Our workspace is very open and there are no barriers (no offices, no cubicles) between each person. I have a great view of 70% of my coworkers when I look up, which makes starting conversations so much easier. ..."

Outside Interest:
"As mom of a 2-year-old girl, my free time is occupied with activities and play time. But if I get chance, I enjoy watching movies. Beach biking is my newfound interest. I also enjoy ping pong and volley ball, but it's been a while since I've gotten the chance to play."

If Not Econtent, Then What?
"I might be a preschool or kindergarten teacher. I like the feeling of lighting up the face of an innocent child and giving them lots of love."