Database Developer

About Quantela

We are a technology company that offers outcomes business models. We empower our customers with the right digital infrastructure to deliver greater economic, social, and environmental outcomes for their constituents.

When the company was founded in 2015, we specialized in smart cities technology alone. Today, working with cities and towns, utilities, and public venues, our team of 280+ experts offer a vast array of outcomes business models through technologies like digital advertising, smart lighting, smart traffic, and digitized citizen services.

We pride ourselves on our agility, innovation, and passion to use technology for a higher purpose. Unlike other technology companies, we tailor our offerings (what we can digitize) and the business model (how we partner with our customer to deliver that digitization) to drive measurable impact where our customers need it most. Over the last several months alone, we have served customers to deliver outcomes like increased medical response times to save lives;

reduced traffic congestion to keep cities moving and created new revenue streams to tackle societal issues like homelessness.

We are headquartered in Billerica, Massachusetts in the United States with offices across Europe, and Asia.

The company has been recognized with the World Economic Forum’s ‘Technology Pioneers’ award in 2019 and CRN’s IoT Innovation Award in 2020.

For the latest news and updates, please visit us at

We are looking for a highly skilled Postgre

SQL Database Developer to design, develop, optimize, and maintain our database systems. The candidate will work closely with software engineers, data analysts, and Dev Ops teams to ensure the reliability, performance, and scalability of our database applications.

• Design and develop complex SQL queries, stored procedures, triggers, and functions in Postgre
  
  SQL.
• Perform performance tuning and optimization of Postgre
  
  SQL queries and indexing strategies.
• Work closely with application developers, data engineers, and architects to implement efficient data structures and access paths.
• Migrate data from legacy systems or other RDBMS (e.g., Oracle, DB2) into Postgre
  
  SQL.
• Write ETL scripts and batch jobs for data processing and transformation.
• Assist in schema design, table partitioning, and materialized view creation.
• Proactively address slow queries and long-running processes.

• 5+ years of hands-on experience with Postgre
  
  SQL in a production environment.
• Strong SQL skills, including query optimization and performance tuning.
• Experience with Postgre
  
  SQL internals and explain plans.
• Proficiency in writing PL/pgSQL functions, procedures, and triggers.
• Exposure to data migration, including use of COPY, FDW, and data loaders.
• Understanding of indexes, constraints, and transaction isolation levels.
• Knowledge of other databases (Oracle, MySQL) and migration strategies.