Postgresql Database Administrator
Company Background:
Gilt Groupe provides access, by invitation only, to Men's, Women's, Children's, Beauty, and Home coveted fashion and luxury brands at prices up to 70% off retail. Each sale lasts 36 hours and features hand selected styles from a single designer. The business model, based on urgency and scarcity, offers extraordinary goods at incredible prices, but only for a limited time. All of these sales occur daily at noon, driven by daily email reminders and alerts to a private membership. Most of the hot items are sold within the first 10 minutes, with the bulk of sales occurring within the first 90 minutes.
Summary
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.
Responsibilities
• Responsible for the integrity of our high-volume databases and improving the overall system to increase fault tolerance
• Responsible for the administration activities supporting mission-critical products and architectural skills contributing to the design of next-generation applications
• 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
• Work with developers to understand applications and operational system parameters and contribute to engineering designs
• Communicate daily with business customers and partners
• Interact directly with the open source community to further usage, knowledge and capabilities of PostgreSQL database
Required Skills and Experience
• Expert knowledge of RDBMS concepts including query and data model optimization covering indexing, bitmaps, query plans, data file organization, etc
• Deep experience with alternative technologies (Oracle, MySQL, Key value stores, etc)
• Experience deploying software in the cloud
• Deep experience with large data warehouses
• B.S. in Computer Science
If interested, please send your resume to careers@gilt.com