Principal Database Administrator I

Posted:
9/27/2024, 8:30:04 AM

Location(s):
Cambridge, Massachusetts, United States ⋅ Massachusetts, United States

Experience Level(s):
Senior

Field(s):
Software Engineering

Cambridge Mobile Telematics (CMT) is the world’s largest telematics service provider. Its mission is to make the world’s roads and drivers safer. The company’s AI-driven platform, DriveWell Fusion®, gathers sensor data from millions of IoT devices — including smartphones, proprietary Tags, connected vehicles, dashcams, and third-party devices — and fuses them with contextual data to create a unified view of vehicle and driver behavior. Auto insurers, automakers, commercial mobility companies, and the public sector use insights from CMT’s platform to power risk assessment, safety, claims, and driver improvement programs. Headquartered in Cambridge, MA, with offices in Budapest, Chennai, Seattle, Tokyo, and Zagreb, CMT measures and protects tens of millions of drivers across the world every day.

CMT is looking for a collaborative, customer-committed, and creative Principal Database Administrator in our Cloud SRE team who wants to join us in making roads safer by making drivers better!

Responsibilities:

  • Work with Engineering, Architecture, and SRE’s to implement database environment improvements
  • Work proactively in tuning and implementing queries and new features to expand the scalability of the database environment
  • Administer Postgresql Databases on cloud infrastructure with a focus on performance, high availability, and scale
  • Maintain all aspects of our Postgresql and Aurora-PostgreSQL database environments for production, integration, and staging
  • Design databases and database applications to support products, ensuring system scalability, security, performance, and reliability
  • Coordinate with compliance & auditing - assisting in risk analysis assessment and response
  • Maintain data integrity and security (manage roles and permissions of database users)
  • Document detailed steps to recreate configuration changes made to the database environment
  • Collaborate with development, architecture, and release teams providing architectural design recommendations to effectively adapt the database environment to support new platform features and capabilities
  • Manage HA/DR setups to meet or exceed application RTO/RPO targets and implement solutions for managing backup and recovery
  • Support software developers to drive proper coding practices and assist in the development of complex queries, tuning of DML
  • Complete any additional tasks as they arise

Qualifications:

  • Bachelor’s degree or equivalent years of experience and/or certification
  • 7+ years of relevant working experience in relational database administration, (PostgreSQL), with 
  • 5+ years of experience building/administering databases in highly-scalable applications
  • Design and document systems, including writing and reviewing code, to automate away problems within your squad’s domain
  • Ability to use tools to identify bottlenecks or performance problems enabling query and schema optimization
  • Deep understanding of AWS Database services, especially AWS RDS (Postgresql; Aurora), AWS Redshift, and experience DynamoDB
  • Detailed understanding of PostgreSQL database server architecture, concepts, features, and high-availability technologies
  • Strong understanding of Cloud Platforms storage performance, memory, and I/O (AWS, Azure, Google cloud)
  • Demonstrated experience deploying and managing large scale distributed Linux environments
  • Participate in Tier 2 / Tier 3 response alongside the engineers who build our production backends

Nice to Have:

  • Experience with leading projects in system design, architecture changes, and technology selection
  • Strong Linux admin skills
  • Experience in automation using Terraform/Cloudformation
  • Experience managing AWS RDS clusters, especially Postgresql Aurora clusters
  • Experience in AWS Redshift and DynamoDB administration and tuning
  • Experience in agile and DevOps methodologies implementation
  • Experience in production-oriented roles
  • Experience with Linux operating environments and database clients 

Compensation and Benefits:

  • Fair and competitive salary based on skills and experience, and annual performance bonus
  • Equity may be awarded in the form of Restricted Stock Units (RSUs)
  • Medical, Dental, Vision and Life Insurance, matching 401k, short-term & long-term disability and parental leave
  • Unlimited Paid Time Off including vacation, sick days & public holidays
  • Flexible scheduling and work from home policy depending on role and responsibilities

Additional Perks:

  • Feel great working to improve road safety around the world!
  • Join one of our many employee resource groups including Black, AAPI, LGBTQIA+, Women, Book Club and Health & Wellness
  • Extensive wellness, education and employee assistance programs
  • CMT will do all that is possible to support our employees and create a positive and inclusive work environment for all!

Commitment to Diversity and Inclusion:

At CMT, we believe the best ideas come from a mix of backgrounds and perspectives. 

We are an equal-opportunity employer committed to creating a workplace and culture where everyone feels valued, respected, and empowered to bring their unique talents and perspectives. Diversity is essential to our success, and we actively seek candidates from all backgrounds to join our growing team. 

We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status or disability state. “CMT is headquartered in Cambridge, MA. “To learn more, visit www.cmtelematics.com and follow us on X @cmtelematics.”

Cambridge Mobile Telematics

Website: https://www.cmtelematics.com/

Headquarter Location: Cambridge, Massachusetts, United States

Employee Count: 251-500

Year Founded: 2010

IPO Status: Private

Last Funding Type: Private Equity

Industries: Insurance ⋅ Mobile ⋅ Public Safety ⋅ Transportation