Senior SQL Developer (PostgreSQL)

Job Title: Sr. SQL Developer:

As aSQL & 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:

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

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