Database Administrator
PulsePoint - New York, NY

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

PulsePoint is a digital media company headquartered in NYC that’s looking to grow the engineering team supporting our Exchange by adding engineers who are: smart, get things done, communicate well, understand computer science, take pride in engineering, and want to work in an interesting and rapidly evolving industry. We have an experienced team that is looking to add developers seeking technical challenge and empowerment to make decisions that really move the business forward.

Some major projects the Exchange team is currently working on: continuing to scale our core exchange platform, honing the intelligence of our optimization, cutting feedback time for business intelligence, improving fraud protection, and aggressive automation. Currently, the PulsePoint Exchange:
  • handles hundreds of thousands of transactions per second, billions of times each month
  • conducts real-time ad-serving based on statistical and machine-learning models
  • returns responses collected from dozens of parties in milliseconds
  • constantly evolves to a market that changes in days and weeks, not months and years
  • incorporates thousands of data-points into every serving decision
If working in an agile shop with a team of top-flight engineers growing the system described above sounds interesting, some things that you should know:

Summary

PulsePoint is looking to add a DBA to manage the growth in volume and diversity of our data systems as we increase the breadth and intelligence of our products offerings.

Responsibilities:
  • Define and perform database work necessary to achieve sprint goals, including:
    • Data Modeling, Database design and implementing SQL Server best practices
    • T-SQL development and testing, SSIS packages
    • SQL tuning, stored procedure development, SQL Server performance tuning
    • Subject-matter expert, providing input on system design and architecture
  • Participate as a member of the operations team including:
  • On-call coverage for Database systems
  • Diagnosing and solving issues with data management and flows
  • Implementing best practices for database troubleshooting, corruption, backup, disaster recovery and security
  • Support scheduled jobs using SSIS packages, Partitioning, Encryption and replication
  • Assist in the design and configuration of database infrastructure, including hardware and physical layout
  • Assist in Implementing SQL Server high-availability solutions including clustering and mirroring

Requirements
  • 3+ years of experience working with Microsoft SQL Server (2000, 2005, 2008).
  • Excellent command of SQL
  • A history of creative problem solving
  • Track record of meeting deadlines in a fast- paced, dynamic work environment.
  • Able to quickly grasp and troubleshoot complex Data Flows, Experience with SSIS
  • A passion for continuous learning, finding and sharing new knowledge
  • A major fascination with detail and exactitude
  • A strong commitment to quality
  • Strong communications, organizational and project management skills
  • B.S. in Computer Science, Information Systems, Engineering or related field

Desirable
  • Microsoft Certification
  • Experience with SQL Server Reporting Services
  • Experience with OLAP and/or Analytic Databases
  • Experience with complex Data environments (esp. MySQL, Vertica and Hadoop)
  • Experience working in an Agile environment (e.g. Scrum, Kanban, or XP).
More about working in Technology at PulsePoint:

We’re small enough you can own something and have a direct impact, but big enough that you don’t have to go it alone. We care deeply about quality and doing the right thing, but have a strong focus on business value and time to market – and believe that focusing on the first part enables the second. Tech staff have technical management (who are technical and write code), as well as direct access to business, product, and operations (and they have access to us). Lastly, our Sr. Engineers have lots of empowerment and freedom of action (but we don’t water down our responsibilities or expectations)
  • Tools we use: SQL Server, MySQL, Vertica, Hadoop/Pig/Hive, SAS, Qlikview
  • Practices we’ve adopted: TDD/unit-testing, continuous integration, code-reviews, Scrum
  • Current Projects: cloud-computing, event-driven IO, self-healing systems, analytic s
  • We like open source: Spring, Hadoop (we run the NYC Hadoop Meetup), MySQL, Glassfish, Linux, Memcache
  • We have rules around meetings – to keep them short and useful
  • Tech staff get fast boxes, with multiple monitors, and can choose Windows or Linux
  • We keep a library of technical books (several hundred)
  • We have the usual coffee, tea, sodas, snacks, socials and events
We also believe that good balance outside work produces good work, so have:
  • Sane work hours (with flexible scheduling)
  • Real salaries, real benefits
  • Decent paid vacation (which your manager will make sure you actually take)

About this company
7 reviews
We help brands engage the right consumers at scale by fusing the science of programmatic distribution with the art of content...