RPX is seeking an experienced PostgreSQL professional to contribute to the success of the Systems Development department. In this role, the Software Engineer will be responsible for developing and deploying backend system (ETL) applications and data access layers to Postgres servers running on Amazon EC2. This individual will partner closely with other engineering teams including, Product Management, QA, Web Development (Ruby on Rails), and Operations Development. The Software Engineer will be responsible for the complete software development lifecycle for RPX products. Reports to the Senior Director, Software Engineering *** Role * Designs database schemas for frontend and backend systems * Builds ETL systems using Pentaho, Kettle, PlPgSQL, and other technologies * Builds data access APIs using PL/PGSQL, Ruby, and Java * Supports analysis needs by building rollups, views, and complex queries using Tableau and other reporting/analytics tools * Creates design and architecture documentation (ERD, DFD) *** Education/Experience Required * Bachelor¹s degree in Computer Science or related field and/or equivalent experience * Minimum of 6 years¹ experience in Database development with Oracle or Postgres, using stored procedures/functions * Experience designing and building ETL and ELT applications * Experience with relational and dimensional modeling *** Required Competencies * Ability to work independently and collaboratively as part of a small team * Excellent understanding of relational database mechanisms and concepts * Strong procedural and architectural documentation (ERD, DFD) skills and experience with related tools (such as visio, erwin) * Results-oriented and service-minded with ability to develop and foster relationships with key stakeholders internally and externally * Willingness to adapt to the many changing requirements/needs of a fast-growing, young company * Collaborative work ethic and ability to work in a team-oriented culture * Ability to work with virtual, global teams * Excellent interpersonal, networking, and influencing skills * Motivated, self-directed, and proactive with a willingness to take on additional projects * Proven track record of excellence, ownership, and accountability * Confident personality supported by disciplined, logical thinking and fact-based, documented conclusions and opinions * Ability to demonstrate sound judgment and execute against deliverables under deadlines and competing priorities * Highly focused, organized, and detail-oriented * Excellent oral and written communications skills * Represents RPX in a manner consistent with its culture and values *** Technical Skills * Excellent knowledge of SQL and PLSQL/PLPGSQL * Good working knowledge of UNIX shell scripting * Experience with Pentaho (Kettle) ETL * Best practice methodologies established for database development, ETL development, relational and dimensional modeling, and design skills * Able to code in one of the following: Java, Ruby, or Python * Strong proficiency with the Microsoft Office suite, including Word, Excel, PowerPoint, and Outlook *** Preferred Competencies * Experience with Ruby and Amazon EC2/EBS experience viewed favorably * Experience with Tableau or other analytics/reporting system viewed favorably RPX is an equal opportunity employer. -- Sent via pgsql-jobs mailing list (pgsql-jobs@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jobs
