Website:
inevia.co
Job details:
About The Job:
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.
Reporting & Collaboration
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.
Benefits:
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.
Click on Apply to know more.
_1548133325694.png){kind=logo}
