Software Engineer
6 days ago
JD:We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration. The ideal candidate will have a strong background in building scalable database solutions, writing complex queries, and collaborating with backend/frontend teams to ensure efficient and reliable data access. This role is focused on development and engineering within PostgreSQL.Roles and Responsibilities· Database Design & Developmento Design normalized and denormalized database schemas for high-performance applications.o Develop complex SQL queries, functions, views, triggers, and stored procedures to support application needs.· Performance Optimizationo Write highly efficient queries, ensuring performance and scalability.o Conduct query tuning and indexing strategies to reduce latency.o Optimize data retrieval processes for real-time and batch processing workloads.· Application Development Integrationo Collaborate with backend developers to build seamless integrations with PostgreSQL.o Support APIs and microservices by designing effective database interaction layers.o Work on ETL pipelines and data transformation tasks.· Testing & Quality Assuranceo Write unit tests for queries and procedures using tools like pgTAP.o Ensure data consistency and accuracy across environments.o Perform code reviews for SQL scripts and database logic.· Collaboration & Deliveryo Partner with product teams to translate business requirements into efficient database solutions.o Document database designs, queries, and logic for maintainability.o Provide technical guidance to junior developers and peers on best practices in SQL coding.o Primary Skills:· Strong expertise in PostgreSQL development (schemas, functions, triggers, views, stored procedures).· Advanced skills in SQL query writing and optimization.· Hands-on experience with query execution plans and indexing strategies.· Experience in data modeling, relational design, and query performance tuning.· Strong knowledge of transactions, concurrency control, and isolation levels.· Exposure to application development with PostgreSQL (integration with Java, Python, or other languages).· Exposure to cloud-hosted PostgreSQL services (AWS RDS/Aurora, GCP Cloud SQL/Spanner).· Extensive experience in database performance improvement.· Experience in Migration from Legacy DB to Postgres DB· Hands-on experience with shell scripting· knowledge on Elastics SearchSecondary Skills:· Working knowledge of unit testing frameworks for SQL logic (pgTAP, DbUnit).· Experience with PostgreSQL extensions (PostGIS, pg_stat_statements, pg_trgm, TimescaleDB)· Experience with database backup, recovery, and high availability solutions· Proficiency in database security best practices and access control· Knowledge of ETL tools (Apache Airflow, Talend, dbt) and data pipelines.· Familiarity with message brokers like Kafka/ActiveMQ for streaming integration.· Good understanding of CI/CD pipelines for database code deployment.
-
Senior Software Engineer
2 days ago
bangalore, India Sonata Software Full timeSonata Software Overview In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers. As a leading Modernization Engineering company, we aim to deliver modernization-driven...
-
Software Engineer
6 days ago
bangalore, India Sonata Software Full timeJ.D- .Net Fullstack DeveloperJob Title: Full Stack Developer – .NET Core, RXJS, Angular 14+ & Azure APP ServiceLocation: Chennai/Bangalore/HyderabadJob Type: HybridExperience Level: 3–8 YearsJob Summary:We are seeking a skilled and proactive Full Stack Developer with expertise in .NET Core, Angular, and Web API, to join our growing team. The ideal...
-
Systems Software Engineer
3 days ago
Bangalore, India - Home Cloud Software Group Full time ₹ 12,00,000 - ₹ 24,00,000 per yearAbout This Team:We are seeking a highly motivated and experienced Systems Software Engineer to join our ibi WebFOCUS development team. In this role, you will play a crucial part in ensuring the quality and new implementation of our flagship business intelligence and analytics WebFOCUS platform. The ibi WebFOCUS platform helps organizations manage and use...
-
Systems Software Engineer
3 days ago
Bangalore, India - Home Cloud Software Group Full time ₹ 9,00,000 - ₹ 12,00,000 per yearAbout This Team:We are seeking a highly motivated and experienced Systems Software Engineer to join our ibi WebFOCUS development team. In this role, you will play a crucial part in ensuring the quality and new implementation of our flagship business intelligence and analytics WebFOCUS platform. The ibi WebFOCUS platform helps organizations manage and use...
-
Systems Software Engineer
3 days ago
Bangalore, India - Home Cloud Software Group Full time ₹ 12,00,000 - ₹ 24,00,000 per yearAbout This Team:We are seeking a highly motivated and experienced Systems Software Engineer to join our ibi WebFOCUS development team. In this role, you will play a crucial part in ensuring the quality and new implementation of our flagship business intelligence and analytics WebFOCUS platform. The ibi WebFOCUS platform helps organizations manage and use...
-
Systems Software Engineer
3 days ago
Bangalore, India - Home Cloud Software Group Full time ₹ 9,00,000 - ₹ 12,00,000 per yearAbout This Team:We are seeking a highly motivated and experienced Systems Software Engineer to join our ibi WebFOCUS development team. In this role, you will play a crucial part in ensuring the quality and new implementation of our flagship business intelligence and analytics WebFOCUS platform. The ibi WebFOCUS platform helps organizations manage and use...
-
Java Software Engineer
2 weeks ago
bangalore, India Sonata Software Full timeExperience: 4 to 8 yearsKey Skills:JavaSpringbootMicroservicesHibernateRest APIPayment Gateway (must)EcommerceAWSResponsibilitiesDevelop and maintain Java applications.Implement microservices architecture.Integrate with payment gateways.Collaborate with cross-functional teams.Qualifications4 to 8 years of experience in software development. Required...
-
Staff Software Engineer
5 days ago
Bangalore, India Check Point Software Full timeWe are looking for Senior Development Engineer to be a key player in our fast-growing SASE Core Network Group R&D Centre in Bangalore, India. You will be building and developing a next-generation SASE solution. Dive into the world of microservices, distributed systems, networking, and scalable software design, and leave your mark on cutting-edge developments...
-
Staff Software Engineer
2 weeks ago
Bangalore, India Check Point Software Full timeWe are looking for Senior Development Engineer to be a key player in our fast-growing SASE Core Network Group R&D Centre in Bangalore, India. You will be building and developing a next-generation SASE solution. Dive into the world of microservices, distributed systems, networking, and scalable software design, and leave your mark on cutting-edge developments...
-
Staff Software Engineer
2 weeks ago
bangalore, India Check Point Software Full timeIf you are a sharp developer who likes to explore, investigate, and learn new things every day, this is the job for you!As a SW developer in the Customer Focus Group, you will get the opportunity to take part in the development of complex solutions for Check Point’s security platforms while diving into unfamiliar code with known issues, locate it, and...
