Careers

Careers at Turn

Sr. Database Administrator - Data Infrastructure

About

Turn delivers real-time insights that transform the way leading advertising agencies and enterprises make decisions. Our digital advertising hub enables audience planning, media execution, and real-time analytics from a single login, and provides point-and-click access to more than 150 integrated marketing technology partners. Turn is headquartered in Silicon Valley and provides its products and services worldwide. For more information, visit turn.com or follow@turnplatform.

Data Infrastructure team at Turn is responsible for running very large Hadoop clusters, extremely fast changing RDBMS environments and different types of storage environments. This is an agile environment that provides opportunity to solve complex and scaling challenges.

Overview

Turn is looking for a highly skilled SQL/No-SQL expert to join our Data Infrastructure team. We are growing rapidly and need help scaling our database infrastructure. You will provide technical expertise in design, implementation and maintenance of Turn’s database systems. The Data Infrastructure team provides 24/7 oversight and support of the large-scale production database infrastructure and services that power the Turn Campaign and Audience Suite Platform.  This person is a self-starter with a strong sense of responsibility and problem ownership who can commit to driving issues to completion; someone who can adapt quickly and work with global support teams and is capable of compiling together working solutions across a broad technology stack and working with engineering teams on long-term fixes.

Responsibilities

  • Own our database infrastructure in production, working closely with engineering on database design.
  • Apply in-depth database analysis to project-based work, design solutions to issues, and evaluate their effectiveness.
  • Strategize with fellow DBAs and other development and operations teams on complex problems, and make decisions and recommendations about database improvements after analyzing possible courses of conduct.
  • Perform periodic on-call duty as part of a team maintaining the availability and performance of the Turn Campaign and Audience platform, as well as the various internal services and systems that these core services depend on
  • Play a major role in the design and implementation of the backup, recovery and DR strategy for the Turn Campaign and Audience Platforms
  • Performance analysis and optimization of database infrastructure
  • Database monitoring and capacity planning
  • Perform database upgrades and security patches
  • Manage SAN & NAS storage as needed for Oracle systems
  • Research new database technologies and make recommendations to management

Required Skills

  • Overall DBA experience of at least 10-15 years, with a minimum of 5+ years’ experience managing a large database (Internet scale) in 24x7 environment.
  • BS/MS in a technical field or demonstrated equivalent working experience
  • Hands on administration experience in Oracle 11g, 12c and MySQL
  • Experience working in production, Linux based environment
  • High degree of proficiency in SQL, Python/Perl/Ruby and puppet scripts
  • System administration experience is highly desired
  • Must have expertise in utilities and tools like SQL*PLUS, SQL*Loader, Import/Export, data pump, Enterprise Manager and Capacity Planner.
  • Extensive knowledge in implementation of ASM, RAC and Data Guard
  • Experience managing SAN and NAS storage subsystems is also good to have
  • Knowledge of various hot backup and recovery scenarios using RMAN
  • Experience with bigdata eco-system components like hadoop, spark, Oozie, zookeeper is a big plus

Location: Redwood City, CA

In addition to our great environment, we offer a competitive base salary, bonus program, stock options, employee development programs and other comprehensive benefits. Please send a cover letter along with your resume when applying to the position of interest located at Turn.com. We are an Equal Opportunity Employer. No phone calls and no recruiting agencies, please.

#LI-FO1 #GD

Application Data:

company 
careers 
sr_database_administrator_data_infrastructure 
path /srv/www/sites/turn-dev.com/dev/repo/build/app 
main_controller app\controllers\Primary 

Request Data:

$_GET
No Data
$_POST
No Data
$_COOKIE
No Data
$_FILES
No Data
$_SERVER
REDIRECT_STATUS 200 
HTTP_HOST turn.stage.elusive-concepts.com 
HTTP_ACCEPT_ENCODING x-gzip, gzip, deflate 
HTTP_USER_AGENT CCBot/2.0 (http://commoncrawl.org/faq/) 
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 
PATH REMOVED 
SERVER_SIGNATURE Apache/2.4.10 (Linux/SUSE) Server at turn.stage.elusive-concepts.com Port 80 
SERVER_SOFTWARE Apache/2.4.10 (Linux/SUSE) 
SERVER_NAME turn.stage.elusive-concepts.com 
SERVER_ADDR 192.168.1.201 
SERVER_PORT 80 
REMOTE_ADDR 54.81.44.140 
DOCUMENT_ROOT /srv/www/sites/turn-dev.com/prod/webroot 
REQUEST_SCHEME http 
CONTEXT_PREFIX  
CONTEXT_DOCUMENT_ROOT /srv/www/sites/turn-dev.com/prod/webroot 
SERVER_ADMIN roger.soucy@elusive-concepts.com 
SCRIPT_FILENAME /srv/www/sites/turn-dev.com/prod/webroot/index.php 
REMOTE_PORT 41436 
REDIRECT_URL /company/careers/sr-database-administrator-data-infrastructure 
GATEWAY_INTERFACE CGI/1.1 
SERVER_PROTOCOL HTTP/1.0 
REQUEST_METHOD GET 
QUERY_STRING  
REQUEST_URI /company/careers/sr-database-administrator-data-infrastructure 
SCRIPT_NAME /index.php 
PATH_INFO /company/careers/sr-database-administrator-data-infrastructure 
PATH_TRANSLATED redirect:/index.php/company/careers/sr-database-administrator-data-infrastructure/careers/sr-database-administrator-data-infrastructure 
PHP_SELF /index.php/company/careers/sr-database-administrator-data-infrastructure 
REQUEST_TIME_FLOAT 1506099980.768 
REQUEST_TIME 1506099980 

Logs:

Time Data
2017-09-22 17:06:20
Loading Framework...
2017-09-22 17:06:20
app\models\Career:Array
(
    [id] => 0
    [slug] => sr-database-administrator-data-infrastructure
)

Events:

Event Data Listeners
APPLICATION >> RUN null 0
APPLICATION >> LOADED null 0
APPLICATION >> HANDOFF null 0
TEMPLATE >> HTML_START "" 0
TEMPLATE >> BEFORE_HTML_END null 1

Errors:

Notice (8) Undefined index: label /srv/www/sites/turn-dev.com/dev/repo/build/tmp/smarty/templates_c/2a6b68665934d429f218f0734699a46d465d234c.file.share-bar.tpl.php L: 28
Notice (8) Trying to get property of non-object /srv/www/sites/turn-dev.com/dev/repo/build/tmp/smarty/templates_c/2a6b68665934d429f218f0734699a46d465d234c.file.share-bar.tpl.php L: 28

Benchmarks:

Benchmark Tag Time Comment
execution_time TIMER_START 0.000ms Starting bootstrap...
execution_time TIMER_STOP 27.255ms Debug console render output...