Database Developer

CIMCON Lighting; United States; On-site; USD 100,000 - 130,000; Full time

Job summary

CIMCON Lighting is seeking a highly skilled PostgreSQL Database Developer to design and maintain database systems. The role involves working with software engineers and data analysts to ensure optimal performance. Key responsibilities include developing SQL queries, migrating data from legacy systems, and performance tuning. Ideal candidates should have over 5 years of PostgreSQL experience and strong SQL skills. The position offers an opportunity for impactful contributions in a collaborative environment.

Qualifications

• 5+ years of hands-on experience with PostgreSQL in a production environment.
• Strong SQL skills, including query optimization and performance tuning.
• Proficiency in writing PL/pgSQL functions, procedures, and triggers.

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.

Skills

PostgreSQL expertise

SQL optimization

PL/pgSQL functions

Data migration

Job description

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

• 5+ years of hands‑on experience with PostgreSQL in a production environment.
• Strong SQL skills, including query optimization and performance tuning.
• Experience with PostgreSQL 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.