Senior Database Administrator
AppNexus - New York, NY

This job posting is no longer available on AppNexus. Find similar jobs: Senior Database Administrator jobs - AppNexus jobs

As a senior database administrator, you will participate in building, operating, and maintaining a heterogeneous Big Data environment in the Technical Operations group.The data environment consists of Hadoop, MySQL, PostgreSQL, Vertica’s clustered columnar store database, Netezza’s data warehouse appliances, and Citrusleaf’s clustered low latency key-value data store and is constantly growing.

The Technical Operations organization is responsible for the production service delivery infrastructure including data centers, networks, servers, storage, data warehouse appliances/subsystems, and other similar systems.

MAJOR RESPONSIBILITIES/DUTIES

Help keep the database and data systems infrastructure running smoothly

Work with Data Engineering team to help design and implement next iteration of scaling (and the next, and the next, ...)

Tune and optimize systems, processes, queries, databases to handle constantly increasing data flows

Participate in prototyping and proof of concept system development and benchmarking

Install patches and do upgrades as required

Write and perform DML and DDL as required

Manage storage restructuring as required

Participate in on-call rotation responding to alerts and systems issues

Audit various databases to ensure data integrity

Deal with the usual database situations (replication, stale locks, queries run amok, tables that need to be indexed but are not, managing constraints)

REQUIREMENTS

At least one of the following two, with a strong desire and capability to learn and gain expertise in both:

1. Extensive DBA experience with a majority of the following:
MySQL

PostgreSQL

Columnar databases (Vertica)

Netezza administration experience

Key-value Store/NoSQL

2. Hadoop use and administration experience with the majority of the following:

HDFS

HBase

Hive, Pig, Sqoop

2+ years of hands on Unix/Linux system administration

Proficiency with cron, syslog, and other Unix system interfaces/utilities

Excellent troubleshooting skills

Excellent written and oral communication skills

Good organizational skills

High professional standards and desire to continue to develops skills and growth professionally

Strong commitment and drive to deliver high quality service to all customers, regardless of whether they are internal or external

DESIRED, BUT NOT REQUIRED

Experience with Network Attached Storage (NAS)

Experience with system administration automation software such as Chef, cfengine, or Puppet (Puppet preferred)

Perl programming experience

Regular expression fluency

Substantial experience with networking from a systems standpoint to include but not limited to TCP/IP, DNS, DHCP, SNMP, ARP, NTP, SMTP, HTTP

Experience with Nagios or similar monitoring tools

Experience with data collection tools like Cacti, Ganglia, and Graphite

Experience using a Mac

Experience with tcpdump, ethereal, and other packet capture and analysis tools

Bachelor Degree in CS or MIS, or equivalent experience desirable

AppNexus - 2 years ago - save job - copy to clipboard
About this company
AppNexus is a world-class ad technology company, and one of the hottest young companies in New York City (Silicon Alley Insider, amNY). Our...