Senior Database Administrator

AppNexus is an internet technology company that enables and optimizes the real-time sale and purchase of digital advertising. Our powerful, real-time decisioning platform supports core products that enable publishers to maximize yield; and marketers and agencies to harness data and machine learning to deliver intelligent and customized campaigns. Headquartered in New York City, AppNexus employs over 1000 professionals in offices spanning five continents.

The Senior Database Administrator is responsible for participating in building, operating, and maintaining a heterogeneous database environment in the Technical Operations group. The data environment consists primarily of Hadoop, MySQL, PostgreSQL, Vertica and Aerospike’s clustered low latency key-value data store and is constantly growing.

* 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 * Prototype and proof of concept system development and benchmarking * Install patches and do upgrades as required * Write and perform DML and DDL as required * Work on 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, and managing constraints) * Evaluate new data storage technologies based on team needs * Participate in architectural discussions around data optimization and design * Help stand up a continuous deployment process for DDL

**About your skills:** Extensive DBA experience in one or more of the following: * MySQL * PostgreSQL * Columnar databases (Vertica) * Key-value Store/NoSQL Beneficial skills and experience (if you don’t have all of them, you can learn them at AppNexus): * Experience with Network Attached Storage (NAS) * Experience with system administration automation software such as Chef, cfengine, or Puppet (Puppet preferred) * Perl and/or Python 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/graphing tools like Cacti, Ganglia, and Graphite * Experience with tcpdump, ethereal, and other packet capture and analysis tools **More about you:** * You are passionate about a culture of learning and teaching. You love challenging yourself to constantly improve, and sharing your knowledge to empower others * You like to take risks when looking for novel solutions to complex problems. If faced with roadblocks, you continue to reach higher to make greatness happen * You care about solving big, systemic problems. You look beyond the surface to understand root causes so that you can build long-term solutions for the whole ecosystem * You believe in not only serving customers, but also empowering them by providing knowledge and tools