Database Administrator (PostgreSQL DBA)

Sorry, this job was removed at 12:15 p.m. (PST) on Wednesday, February 3, 2021
Find out who's hiring in Greater LA Area.
See all Data + Analytics jobs in Greater LA Area
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

UpKeep is revolutionizing the way businesses maintain, manage, and repair their facilities and equipment. We’re a Series B SaaS startup with 100 remote team members around the world. We’ve raised $50M in venture capital funding and recently surpassed 10,000 customers! UpKeep quickly became the #1 cloud-based maintenance and asset management software application by constantly innovating and always putting our customers first.

We celebrate our inclusive culture and strive to create a diverse and equitable workplace where everyone is treated with kindness and respect.

We are a Node.js shop with a React/Angular frontend. Our platform is built with Express and GraphQL in a microservices architecture. Our infrastructure is on top of AWS and maintained with Terraform. We are using both MongoDB & PostgreSQL. We are 100% containerized with docker, and orchestrated with Kubernetes, and we use Helm to tie it all together in our CI pipeline.

What you'll do:

  • Responsible for the administration, implementation, management, and maintenance of UpKeep’s databases (PostgreSQL & MongoDB)
  • Develop, manage, and test DB backup and recovery strategies
  • Perform DB installations, upgrades, and migrations
  • Define and implement database schema and configurations
  • Maintain custom vacuum strategies at table and DB levels
  • Manage the SQL Server ETL (Extraction, Transformation, and Loading) process 
  • Establish policies and procedures pertaining to data management, security, and utilization
  • Proactively monitor and tune DB for performance, integrity, and consistency across all systems and infrastructure
  • Work with development and operations teams to tune production queries and indexes for optimal performance
  • Responsible for capacity planning with scalability and industry best practices in mind
  • Consult with development and architecture teams to meet requirements that support continued application growth, usage, and availability
  • As UpKeep’s DB subject matter expert, you’ll be motivated to research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements

What we're looking for:

  • Professional DBA experience— PostgreSQL (at least 2 years) & MongoDB (at least 1 year)
  • Experience with large enterprise solutions including but not limited to high availability, disaster recovery, and data management
  • Experience with DB migration
  • Experience developing databases and data warehouses with an Agile SDLC
  • Experience with Replication and Change Data Capture (CDC) techniques and tools
  • Experience with data conversion and management strategies
  • Experience with database partitioning and microservices
  • Knowledge of AWS database offerings
  • Knowledge of with CI/CD tools
  • Knowledge of ETL (Extraction, Transformation, and Loading) process 
  • A desire to be a team player on a close-knit team within a fast-growing startup

Employee Benefits:

In this full-time position, you'll receive top-notch benefits such as equity/stock options, paid holidays, 12-week parental leave, unlimited vacation/sick time, 401k, and affordable medical, dental, vision and mental health insurance options. We value a work/life balance and believe that family and mental health should always come first. 

The Company:

UpKeep was founded by our CEO, Ryan Chan, from an idea he had while working as a process engineer in a manufacturing plant. He believed a cloud-based, mobile-first software solution could drastically improve the workflow and productivity of maintenance teams, technicians, and facility managers. He was determined to build on this vision— so he learned how to code and created the first version of UpKeep in 2014.

Today, we’re simplifying and modernizing work orders for half a million people in over 50 countries. Our 100+ team members are focused on ensuring UpKeep is the smartest and easiest-to-use Computerized Maintenance Management System (CMMS) and Enterprise Asset Management (EAM) software available. We have customers in industries like manufacturing, food production, education, healthcare, property management, hospitality, energy, and transportation. In addition to providing data-driven insights and reporting, UpKeep gives users the ability to manage tasks and teams on-the-go.

 

Top VC’s including Insight Partners, Emergence Capital, and Mucker have confidently backed us since we graduated from Y Combinator in 2017. Here’s an interesting fact: Only 1% of all software venture capital is invested in the deskless workforce, yet 80% of the global workforce is not sitting at a desk. That’s over 100 million people in the U.S. alone! We’re committed to empowering those underserved deskless workers.

Company culture and employee appreciation are very important to us, which is why we've been named a "Best Place to Work" by Inc. Magazine and Built in LA.

Interested in learning more?

$36M Series B:

https://www.onupkeep.com/blog/upkeep-series-b-funding-announcement/

Demo Video: 

https://www.youtube.com/watch?v=oX7Lak7o0qI

Customer Reviews: 

https://www.capterra.com/p/145635/UpKeep/

UpKeep Slack Community:

https://upkeep.org/communityslack/ 

Website: 

www.onupkeep.com 

UpKeep Technologies Inc. is proud to be an equal opportunity workplace. All qualified applicants will receive consideration for employment without regard to, and will not be discriminated against based on age, race, gender, color, religion, creed, marital status, pregnancy, disability, national origin, sexual orientation, gender identity, veteran status, or any other protected category. Please let us know if you need any accommodation due to a disability. We celebrate our inclusive work environment and will always strive to create a diverse and equitable workplace by hiring people from all racial, ethnic, and socioeconomic backgrounds. 

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Location

We are a mostly remote team; however, our HQ is in Westwood Village near UCLA. Local employees love that we're surrounded by restaurants and stores.

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about UpKeep TechnologiesFind similar jobs