LOCATION: New York City, NY
TITLE: Expert PostGRE SQL DBA
JOB TYPE: FTE
Job Description:
Our 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 us continues to leverage the latest in open source RDBMS technologies while expanding into alternative storage solutions (distributed key value stores).
We are deeply committed to the open source Postgresql community. Team members have spoken at Postgresql conferences and we are one of the sponsors of the hot standby project under consideration for version 8.5.
Specific responsibilities will include:
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 Characteristics:
· 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 alterntive 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 design
· Deep experience working with large data warehouses.
• BS or MS in Computer Science
In addition to the relevant software engineering experiences, we are looking for self-starters who can work in a fast paced environment. If you possess the required capabilities for this position, and if you are looking for an opportunity to grow with a cutting edge leader in an exploding industry, we'd like to talk with you.
Please apply directly to: resumes@RPOmax.catsone.com