OneLogin Logo

Senior PostgreSQL DBA at OneLogin (San Francisco, CA)

About the Employer

Job Description

OneLogin is the leader in Unified Access Management, Enabling Organizations to Access the World™. Businesses of all sizes use OneLogin to secure company data, while increasing IT administrator and end users efficiencies. Implementation of our  identity management solutions  can be achieved in hours not days, delivering a fully featured administrative and self-service portal. Our ability to handle on-premises and cloud/SaaS applications makes us the  identity as a service  vendor of choice for the hybrid enterprise.  Two-factor authentication , mobile identity management for one-click access on smartphones and tablets, and real-time directory synchronization add an extra layer of protection. ABOUT ONELOGIN ENGINEERING We value technical design skills, programming ability, and teamwork. Being able to design applications from top to bottom, troubleshooting and debugging tough problems, and brainstorming new ideas are important to this role. You will be working primarily with Ruby, Rails, and Javascript, but our general approach is to choose the best language for the job. We utilize PostgreSQL for storage, and we use RabbitMQ and RESTful APIs for communication between our various services. We employ continuous integration for testing and deployment.   ABOUT YOU You value open collaboration, have a strong desire to learn, and are excited to pick up new skills and technologies. You like to share your knowledge with others and are willing to ask for help in return. You enjoy solving difficult problems, and make use of metrics, monitoring, and testing to help you understand the inner workings of a system. You’re excited to work closely with people throughout the organization, from close teammates to members of ops, UX designers, and service team members. YOUR EXPERIENCE Minimum 5+ years of DBA or database management experience Minimum 3+ years of PostgreSQL experience on Linux/UNIX environment  managing, supporting and designing large (atleast 100GB+ sized) high-availability database systems Demonstrated experience in architecting a large-scale production database platforms  24x7 production on-call support handling emergencies Strong troubleshooting, communication and documentation skills Expertise with Postgres systems metrics and systems optimization strategies Experience with schema design and data normalization Understanding of common replication strategies SQL query writing and optimization skills Monitoring and reporting on performance metrics Experience with merging large sets of data for imports and exports Fluency with one of these: Python, Perl, Bash or other scripting language Ability to produce consistent results with minimal direction and supervision NICE TO HAVE SKILLS: Experience with Amazon Web Services - EC2, RDS, EBS, Route53, S3 etc. Experience managing database systems within SaaS industry NoSQL experience Experience with other types of database systems in a plus (MySQL, MS SQL, DB2, Oracle, Amazon Aurora, RDS, Redshift, etc.) Our core values : Security first - We make it our #1 priority to protect data and privacy. From the way we work to the technology we provide, security is top of mind Customer focused - We design for, listen to and partner with customers to come up with smart solutions that drive business value Collaborative - We take bold steps and work together to thrive across boundaries. We drive productivity as we grow as one team Accountable - We get things done and take ownership in our work. Showcasing consistent quality and pride to perform at the highest levels Creative - We embody creativity in everything we do. We embrace a diversity of ideas. We execute with ingenuity, flexibility, and agility