Database Administrator / DBA Who You Are You are passionate about PostgreSQL databases and data problems. You relish the opportunity to tune databases, optimize queries, design schemas, and write reports. You've never encountered a query that's fast enough. Big Data does not scare you. You're comfortable working with highly-available, highly-transacted Production databases, as well as data analytics. You've worked with open-source databases, and you're comfortable with, or keen to learn, new database technologies. You enjoy working in a fast-paced environment. You're not tied to any technology, and you love to keep up-to-date on new trends. The Role You will be part of a fun, fast-paced and highly collaborative team that delivers new platform functionality, stability and performance improvements. Working with our PostgreSQL and Greenplum databases, you will work closely with our Software Engineering team to implement new database features, write complex SQL statements, and review data definition updates. You will work with our Analytics and Business teams to optimize queries, and create ad-hoc reports. You will work on IT initiatives and database administration, including backups, scripting and processing data, data warehousing, redundancy, replication and high availability strategies. You will work with other members of the Engineering and IT teams to maintain greater than 99.99% platform uptime and to ensure queries are running optimally. Location: This position is ideally based in-house our San Francisco headquarters, flexibility will be considered for the right candidate. Responsibilities:
Qualifications:
Desired Experience and Knowledge:
About Us Switchfly is the most comprehensive enterprise SaaS provider of travel and loyalty solutions. Our flexible white-label platform powers personalized, feature rich, and localized websites for global brands in travel, financial services and ecommerce. We are continually improving our high-availability, high-traffic solutions for our clients. The Switchfly technology that powers the user experience for these global brands is core to their business and to ours. Whether building technology solutions, growing our clients' businesses, or making daily life at Switchfly rewarding for all employees, Switchfly is dedicated to success. We offer competitive compensation, a comprehensive benefits package, and a convenient downtown San Francisco location within walking distance of BART/Muni Montgomery Street station, Caltrain, and the Ferry Building. We emphasize teamwork and getting things done. "People" is consistently the top team-member-voted reason for what motivates them at Switchfly. We offer employees the chance to work with smart, fun people on exciting projects with sizable opportunity for growth. Are you intensely driven, smart, and results-focused? Do you thrive in an open, collaborative, team environment? If so, let's talk! Miho Ishikura |