SoFi is a leader in marketplace lending and the largest provider of student loan refinancing, with over $950M in loans issued to more than 11,600 members. We're transforming financial services for ambitious early-stage professionals with student loan refinancing, MBA loans, mortgages, and personal loans. Unlike traditional lenders, our proprietary underwriting approach takes into account merit and employment history to offer unique credit products our members won't find elsewhere. We offer individual and institutional investors the ability to create positive social impact on the communities they care about while earning compelling rates of return.
We are seeking a PostgreSQL DBA to work in a fast-paced environment in our Helena office. Ideal candidates must be enthused about database administration, a quick learner and self-starting. The role will require hands-on experience with database management, Linux, cloud environments, networking and security. You will be responsible for the day-to-day operation, including maintenance of databases for corporate and development environments. Desired skills include database tuning, maintenance, PSQL and Linux administration. This position is on call 24/7 and includes production support.
Desired Skills: Ubuntu, AWS, Performance Tuning, Replication and NOSQL, PostgreSQL, and an opportunity to work with MySQL.
Key responsibilities include:
- Be responsible for day-to-day PostgreSQL database administration and monitoring. Keep the database operational and responsive, with minimal downtime.
- Work with senior Database Integration Engineer on database design and implementation of enhancements.
- Help developers to optimize queries, develop stored procedures, and ensure consistent database design.
- Communicate database knowledge and experience to impart best practices to application developers.
- Fine tune database queries and create, refresh and rebuild indexes as appropriate.
- Setup & maintenance of PostgreSQL master-slave clusters utilizing streaming replication and backup planning.
- Perform regular capacity and performance management analysis across all databases.
- Assure maximum uptime and minimal downtime using familiarity with High Availability
- Scale the current infrastructure to handle greater levels of reliability and accessibility, as needed, using data storage methods such as sharding, partitioning and data modeling.
Requirements:
- Undergraduate Degree or equivalent experience.
- Two (2) or more years recent experience using PostgreSQL, including PostgreSQL Admin tools with the focus of experience on the latest versions.
- Experience with database security concepts, including access, auditing, and encryption.
- Knowledge and experience in Open Source solutions, include vetting patches, applying patches to the database and the open source tools, libraries, and daemons.
- Knowledge in database synchronization, failover, and recovery.
- SQL programming including writing SPs and PSQL scripting.
- Performance tuning skills.
- Ability to proactively identify, troubleshoot and resolve live database systems issues.
- Knowledge of disaster recovery principles and practices, including planning and testing.
- Hands-on experience with database administration, replication, backup recovery and troubleshooting in co-location environments.
Plusses:
- Experience managing NoSQL systems such as Redis is an added bonus.
- Experience working with configuration management system like Chef and Puppet.
- Experience with cloud computing solutions such as Amazon Web Services (AWS).
Personal Attributes of the Ideal Candidate Include:
- Ability to thrive in a fast-paced growing company.
- Ability to drive a project from inception to completion.
- Enthusiasm for solving challenging problems.
- Team attitude: a willingness to roll up your sleeves, work with others and get stuff done.
This is a great opportunity for professionals looking to join an emerging leader, focused on disrupting a huge industry.
We offer competitive salary, bonus and benefit programs including medical, dental, vision and 401(k), stock options, an unlimited time-off policy and a subsidized lunch program to all employees.
This job is located in Helena, the capital of the state of Montana. The city is located a few miles from the continental divide, in the heart of the Rocky Mountains. Residents enjoy a wide variety of outdoor summer and winter activities, including hiking, mountain-biking, boating, hunting, fishing, snowmobiling, and skiing. Helena has an excellent public school system, and the cost of living is much lower than most urban areas. By joining our team you can have the best of both worlds, a technical job while being able to maintain a good work-life balance.
SoFi is an equal employment opportunity employer.
Please see https://sofi.resumetracker.com/public/job_detail/1209 to apply for this position.
