Database Engineer (PostgreSQL)

Logile

Khordha

Vor Ort

INR 1.200.000 - 1.800.000

Vollzeit

Vor 5 Tagen
Sei unter den ersten Bewerbenden

Erhalte eine Antwort von diesem Arbeitgeber

Dein Lebenslauf und dein Anschreiben, genau auf das zugeschnitten, was gesucht wird.

Schaffe es an den ATS-Filtern vorbei

Zusammenfassung

Logile is seeking a skilled Database Engineer with 6+ years of PostgreSQL experience to design, model, and optimize complex data stores. You will build scalable schemas, write advanced SQL, and ensure data integrity while partnering with Java developers and architects.

You'll optimize performance, implement schema changes with Liquibase or Flyway, and support migrations. The role is onsite at Logile's Bhubaneswar office with overlap to US business hours to enable global collaboration.

Qualifikationen

  • 6+ years of experience in database development or database engineering.
  • Strong hands-on experience with PostgreSQL.
  • Good knowledge of SQL, PL/pgSQL, joins, subqueries, CTEs, and window functions.

Aufgaben

  • Design and develop PostgreSQL database schemas based on business and application requirements.
  • Perform data modeling, database design, normalization, and database remodeling.
  • Develop and maintain tables, relationships, constraints, indexes, views, and stored procedures.
  • Write, analyze, and optimize complex SQL queries and PL/pgSQL functions.
  • Perform database performance tuning, indexing, and query execution plan analysis.
  • Review and improve existing database structures, queries, and data access patterns.
  • Implement database schema changes and version control using Liquibase or Flyway.
  • Ensure data integrity, consistency, and transactional reliability.
  • Support database migration, data transformation, and modernization initiatives.
  • Work closely with Java application developers and architects to optimize database integration.
  • Troubleshoot database-related issues and support production performance improvements.
  • Follow database engineering standards, best practices, and documentation guidelines.

Kenntnisse

PostgreSQL
SQL
PL/pgSQL
Data modeling
Query optimization
Indexing
Database design
Transaction management
Explain plan

Tools

Liquibase
Flyway

Jobbeschreibung

Job Summary

We are looking for a skilled Database Engineer with around 6+ years of experience in PostgreSQL database development, design, data modeling, and performance optimization. The candidate should have hands-on experience in designing database schemas, developing complex SQL queries, optimizing database performance, and ensuring data integrity and consistency. The role involves collaborating with application developers and architects to build efficient, scalable, and reliable database solutions.

Key Responsibilities

  • Design and develop PostgreSQL database schemas based on business and application requirements.
  • Perform data modeling, database design, normalization, and database remodeling.
  • Develop and maintain tables, relationships, constraints, indexes, views, and stored procedures.
  • Write, analyze, and optimize complex SQL queries and PL/pgSQL functions.
  • Perform database performance tuning, indexing, and query execution plan analysis.
  • Review and improve existing database structures, queries, and data access patterns.
  • Implement database schema changes and version control using Liquibase or Flyway.
  • Ensure data integrity, consistency, and transactional reliability.
  • Support database migration, data transformation, and modernization initiatives.
  • Work closely with Java application developers and architects to optimize database integration.
  • Troubleshoot database-related issues and support production performance improvements.
  • Follow database engineering standards, best practices, and documentation guidelines.

Required Skills & Experience

  • Around 6+ years of experience in database development or database engineering.
  • Strong hands-on experience with PostgreSQL.
  • Good knowledge of SQL, PL/pgSQL, joins, subqueries, CTEs, and window functions.
  • Experience in database design, data modeling, normalization, and schema remodeling.
  • Good understanding of indexes, partitioning, constraints, and database optimization.
  • Experience with query tuning using EXPLAIN and EXPLAIN ANALYZE.
  • Understanding of transactions, locking, concurrency, and isolation levels.
  • Experience with database migration and schema management tools such as Liquibase or Flyway.
  • Good understanding of relational database concepts and data integrity.
  • Familiarity with Linux and basic database administration.

Job Location & Schedule

  • This is an onsite position based at Logile's Bhubaneswar Office.
  • Candidates should be willing to work with a few hours of overlap with the US business hours to support collaboration with global teams.
Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

Database Engineer (Contractor)
Database Engineer (Contractor)

Logile • Khordha

Vor Ort
INR 1.500.000 - 2.500.000
Database Engineer (PostgreSQL)
Database Engineer (PostgreSQL)

Fluentgrid • NTR

Vor Ort
INR 1.400.000 - 2.000.000
Database Engineer (Contractor)
Database Engineer (Contractor)

Logile, Inc. • Khordha

Vor Ort
INR 900.000 - 1.500.000
Senior PostgreSQL Developer / Database Engineer
Senior PostgreSQL Developer / Database Engineer

Sequoia Applied Technologies • Chennai District

Vor Ort
INR 1.000.000 - 1.500.000
Senior PostgreSQL Developer / Database Engineer
Senior PostgreSQL Developer / Database Engineer

Sequoia Applied Technologies • Chennai District

Vor Ort
INR 1.200.000 - 1.800.000
PostgreSQL Developer
PostgreSQL Developer

Technix-Technology Solutions Private Limited • Patna

Vor Ort
INR 700.000 - 1.200.000
Database Expert
Database Expert

Fluentgrid • Visakhapatnam

Vor Ort
INR 1.200.000 - 2.400.000
Specialist - Data Engineering - PSQL
Specialist - Data Engineering - PSQL

Vivantify Technology Solutions India Private Limited • Pune District

Vor Ort
INR 1.200.000 - 1.800.000
Competitive salary package
Professional growth opportunities
Collaborative work environment
PostgreSQL Developer – L2
PostgreSQL Developer – L2

Bharathcloud • Hyderabad

Vor Ort
INR 1.200.000 - 1.800.000
PostgreSQL Developer
PostgreSQL Developer

Aithon Solutions • Mumbai

Vor Ort
INR 1.200.000 - 1.600.000