PostgreSQL Developer

Inevia; Mumbai; Presencial; INR 2.500.000 - 3.800.000; Jornada completa

Descripción de la vacante

Inevia is seeking a SQL & PostgreSQL Developer to design, develop, and optimize enterprise database solutions powering our business-critical applications. You will build scalable PostgreSQL and SQL Server structures, write efficient SQL, and ensure data integrity across environments.

The role collaborates with software engineers, DevOps, and stakeholders to deliver reliable database solutions for enterprise applications, reporting, analytics, and AI-enabled systems.

Formación

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 5+ years of professional experience as a SQL Developer or Database Developer.
• Strong hands-on experience with PostgreSQL and SQL Server.

Responsabilidades

• Design, develop, and maintain PostgreSQL database schemas, tables, indexes, views, materialized views, functions, and stored procedures.
• Develop and maintain SQL Server database objects, including stored procedures, triggers, functions, and views.
• Optimize PostgreSQL and SQL Server queries for performance and scalability.
• Develop data integration solutions for enterprise applications and support ORM integration.
• Monitor database health and troubleshoot issues; implement logging and monitoring.
• Collaborate with DevOps teams on CI/CD, version control, and cloud/on-prem deployments.

Conocimientos

PostgreSQL

PL/pgSQL

Query optimization

Indexing

Partitioning

Views

Materialized views

Performance tuning

SQL Server

T-SQL

Stored procedures

Functions

Triggers

Migration

Relational DB design

Normalization

Execution plans

Transaction management

Azure Database for PostgreSQL

Azure SQL Database

Azure DevOps

Git

CI/CD pipelines

SSRS

ETL tools

Power BI

NoSQL databases

GitHub Copilot

Claude

RAG concepts

Educación

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.

Herramientas

Azure DevOps

Git

SSRS

Power BI

NoSQL databases

Descripción del empleo

As a SQL & PostgreSQL Developer, you will play a key role in designing, developing, and optimizing enterprise database solutions that power our business-critical applications. This role focuses on building scalable, high-performance database structures, writing efficient SQL code, and ensuring data integrity across PostgreSQL and SQL Server environments.

You will work closely with software developers, architects, DevOps engineers, and business stakeholders to deliver reliable database solutions that support enterprise applications, reporting, analytics, and AI-enabled systems.

The ideal candidate is analytical, detail-oriented, proactive, and passionate about database optimization, performance tuning, and solving complex data challenges.

The Work:

Database Design & Development

• Design, develop, and maintain PostgreSQL database schemas, tables, indexes, views, materialized views, functions, and stored procedures.
• Develop and maintain SQL Server database objects, including stored procedures, triggers, functions, and views.
• Design scalable database structures following normalization and database best practices.
• Create reusable SQL scripts, utilities, and database migration scripts.
• Collaborate with software developers and architects to build efficient and scalable database solutions.
• Support database migration activities between SQL Server and PostgreSQL.

Database Performance & Optimization

• Optimize PostgreSQL and SQL Server queries for maximum performance and scalability.
• Analyze execution plans, indexing strategies, and database performance metrics.
• Identify and resolve performance bottlenecks proactively.
• Review SQL code and database changes to ensure coding standards and best practices.
• Ensure database reliability, integrity, and compliance with organizational standards.

Database Integration & Data Management

• Develop efficient data integration solutions for enterprise applications.
• Support application teams with optimized database access and ORM integration.
• Develop scripts for data migration, synchronization, import/export, and bulk data processing.
• Maintain data accuracy, consistency, and security across environments.

Monitoring & Troubleshooting

• Monitor database health and troubleshoot database-related issues.
• Implement logging, monitoring, and error-handling mechanisms.
• Ensure database availability and high performance across development, testing, and production environments.

DevOps & Database Deployment

• Support database version control using Git and Azure DevOps.
• Participate in CI/CD pipelines for automated database deployments.
• Collaborate with DevOps teams to manage cloud and on-premises database deployments.
• Develop SQL queries and reports to support business intelligence and operational requirements.
• Collaborate with business analysts and stakeholders to understand data requirements.
• Maintain database documentation and contribute to continuous process improvements.

Qualification And Experience:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 5+ years of professional experience as a SQL Developer or Database Developer.
• Strong hands-on experience with PostgreSQL and SQL Server.

Knowledge And Skills Required:

• Strong expertise in PostgreSQL, including PL/pgSQL, query optimization, indexing, partitioning, views, materialized views, and performance tuning.
• Hands-on experience with SQL Server, T-SQL, stored procedures, functions, triggers, and database optimization.
• Experience in database migration between SQL Server and PostgreSQL.
• Strong understanding of relational database design, normalization, indexing strategies, execution plans, and transaction management.
• Experience with Azure Database for PostgreSQL and Azure SQL Database is preferred.
• Familiarity with Azure DevOps, Git, and CI/CD pipelines.
• Knowledge of SSRS, ETL tools, Power BI, and NoSQL databases is an advantage.
• Experience with AI-assisted development tools such as GitHub Copilot, Claude, or similar tools is a plus.
• Understanding of AI-enabled applications, vector databases, embeddings, and Retrieval-Augmented Generation (RAG) concepts is an added advantage.
• Opportunity to work on scalable enterprise applications and backend architecture
• Room for professional growth and learning.
• Competitive compensation package

Additional Information:

This is a full-time position located in Navi Mumbai.
Inevia is an equal opportunity employer and encourages applications from candidates of all backgrounds and experiences.