Hello- The Gilt Groupe is an e-commerce organization that is in
hyper-growth mode. We are huge supporters of the open source community
and some of our top officers are heavily involved with the Postgres
community. We stay on the cutting edge of technology and are in need of a
PostgreSQL DBA. Postgresql Database
Administrator - NYC Company Overview
The business causes a
daily, massive flood of transactional traffic at noon. Hundreds of thousands of
shoppers compete online for the limited inventory, creating the need for a
highly scalable and reliable web infrastructure. Our peak traffic is
approaching the average load of large ecommerce sites like Amazon.com.
The technology team must build an infrastructure that can scale to this capacity
near noon, sustain the tremendous load for a few hours, and then go away. Gilt
Groupe requires the techniques of cloud computing and virtualization. DESCRIPTION Gilt Groupe’s
primary data systems run on Postgresql (version 8.3). Today’s system is
growing rapidly and requires very high levels of availability. The future data
strategy for Gilt Groupe continues to leverage the latest in open source RDBMS
technologies while expanding into alternative storage solutions (distributed
key value stores). Gilt Groupe is deeply
committed to the open source Postgresql community. Team members have spoken at
Postgresql conferences and Gilt Groupe is one of the sponsors of the hot
standby project under consideration for version 8.5. This position is
ultimately responsible for the integrity of our high-volume databases and
improving the overall system to increase fault tolerance. The position involves
both administration activities supporting mission-critical products and
architectural skills contributing to the design of next-generation
applications. The position is highly technical but involves a day-to-day
communications with business customers and partners. RESPONSIBILITIES ·
Implement and manage PITR and warm
standby to meet data backup and standby database needs over both LAN and WAN ·
Evaluate and implement hot data
replication strategy (e.g. SLONY or competing tools) ·
Systematically evaluate and tune
individual Postgresql parameters to increase throughput and minimize data loss ·
Interact directly with the open source
community to further usage, knowledge, and capabilities of Postgresql database REQUIRED SKILLS AND
EXPERIENCE ·
Passion for extremely high quality
software application development ·
Expert knowledge of RDBMS concepts
including query and data model optimization covering indexing, bitmaps, query
plans, data file organization, etc ·
Deep experience of alternative
technologies (Oracle, MySQL, Key value stores, etc) ·
Interest in / experience deploying
software in the cloud. ·
Work with developers to understand
applications and operational system parameters and contribute to engineering
designs ·
Deep experience working with large data
warehouses. EDUCATION ·
BS or MS in Computer Science We offer a very competitive salary, benefits, stock options
and we will contribute to relocation for the right candidate. Regards, Dave Moccia Technical
Recruiter Gilt Groupe New York,
NY 10011 646.929.6944 http://www.giltgroupe.com/invite/dmoccia6
|