Senior SQL Developer (PostgreSQL)

Job Title: Sr. SQL Developer : 

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. 

Duties and Responsibilities: 

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. 

Knowledge and Skills required: 

Education 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:  

• 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. 

Behavioral Competencies: 

• Fanatical Customer Service: Ensure high-quality product delivery aligned with customer expectations. 

• Absolute Ownership: Take full responsibility for QA deliverables and outcomes. 

• Passion for Improvement: Continuously enhance testing practices and product quality. 

• Uncompromising Integrity: Maintain transparency and accountability in all QA processes. 

• Strong teamwork and adaptability in a dynamic environment. 

Benefits: 

• Opportunity to work on enterprise-scale applications and modern database technologies.  

• Exposure to cloud databases, AI-enabled applications, and DevOps practices.  

• Collaborative and innovative work environment.  

• Room for professional growth and continuous learning.  

• Competitive compensation package. 

Additional Information: 

This is a full-time Work from Office position located in Navi Mumbai. 

Inevia is an equal opportunity employer and encourages applications from candidates of all backgrounds and experiences.