Database Developer

Quantela Inc.

Shimla district

On-site

INR 1,000,000 - 1,500,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A technology company is seeking a highly skilled PostgreSQL Database Developer to design, develop, optimize, and maintain database systems. The role requires collaboration with software engineers, data analysts, and DevOps teams to ensure database reliability and performance. Candidates should have over 5 years of experience in PostgreSQL, strong SQL skills, and knowledge of data migration strategies. This position offers the opportunity to work on complex SQL queries and improve database applications.

Qualifications

5+ years of hands-on experience with PostgreSQL in a production environment.
Strong SQL skills, including query optimization and performance tuning.
Knowledge of data migration strategies for PostgreSQL.

Responsibilities

Design and develop complex SQL queries and stored procedures in PostgreSQL.
Perform performance tuning and optimization of PostgreSQL queries.
Work closely with application developers to implement efficient data structures.

Skills

PostgreSQL expertise

SQL optimization

PL/pgSQL functions

Data migration experience

Job description

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 www.quantela.com

Overview of the role

We are looking for a highly skilled PostgreSQL Database Developer to design, develop, optimize, and maintain our database systems. The candidate will work closely with software engineers, data analysts, and DevOps teams to ensure the reliability, performance, and scalability of our database applications.

Roles and Responsibilities

Design and develop complex SQL queries, stored procedures, triggers, and functions in PostgreSQL.
Perform performance tuning and optimization of PostgreSQL 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 PostgreSQL.
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.

Desired Skills/Background