PostgreSQLSupercharge Your Career as a PostgreSQL Expert at Technoidentity!
Are you ready to solve people challenges that fuel business growth? At Technoidentity, we’re a Data+AI product engineering company building cutting-edge solutions in the FinTech
domain for over 13 years—and we’re expanding globally. It’s the perfect time to join our team of tech innovators and leave your mark!
What’s in it for You?
We are seeking a seasoned Senior Database Developer & PostgreSQL Expert with 8–10 years of experience across multiple database systems, with deep hands expertise in PostgreSQL internals, performance tuning, advanced indexing, and enterprise data architecture.
With a strong preference for Oracle to AlloyDB (PostgreSQL) migration expertise, this role blends modernization, advanced PostgreSQL engineering, and cloud-native architecture on Google Cloud Platform (GCP). If you thrive in transforming complex data
logic, optimizing performance, and architecting enterprise-grade PostgreSQL systems, this opportunity is built for you.
What Will You Be Doing?
Database Migration & Development
- Lead database migrations from Oracle to PostgreSQL-based platforms like AlloyDB, applying both manual and automated strategies.
- Re-engineer stored procedures, triggers, and packages from PL/SQL to PL/pgSQL.
- Recreate and optimize DB objects (schemas, constraints, views, indexes) across target platforms.
- Design PostgreSQL-specific architecture including partitioning strategies, indexing plans (GIN, GiST, BRIN), and query optimization paths.
- Leverage PostgreSQL internals such as vacuum tuning, WAL configuration, and connection management for optimal system performance.
Performance Optimization
- Implement indexing strategies, query plans, and table partitioning to enhance database performance.
- Use tools like EXPLAIN ANALYZE, pg_stat_statements, and GCP-native monitoring dashboards for tuning.
- Collaborate with DevOps for deployment pipelines and infrastructure-as-code (IaC) best practices.
- Perform deep-dive PostgreSQL performance fine-tuning including buffer cache analysis, autovacuum configuration, and planner optimization.
- Optimize PostgreSQL workloads for high concurrency and large datasets, ensuring stable and predictable performance.
Data Integrity & Validation
- Build and execute validation scripts for source-to-target comparison.
- Ensure row-level data accuracy, transformation logic fidelity, and zero data loss post-migration.
- Manage large-scale datasets for archival and bulk processing tasks.
- Implement PostgreSQL-native data integrity strategies like constraint management, row-level security (RLS), and trigger-based validations.
Collaboration & Documentation
- Work with cross-functional teams to translate business logic and legacy workflows to scalable, modern database systems.
- Maintain clear documentation on schema conversions, validation methods, rollback strategies, and change history.
- Create PostgreSQL architecture documents, optimization playbooks, and database best-practice guidelines for engineering teams.
What Makes You the Perfect Fit?
- 5–14 years of database development experience across Oracle, PostgreSQL, and similar RDBMS platforms.
- Strong expertise in PL/SQL and PL/pgSQL for procedural logic, error handling, and performance tuning.
- Proven track record of large-scale database migration projects (Oracle to PostgreSQL/AlloyDB preferred).
- Proficient in query optimization, indexing, partitioning, and schema normalization.
- Familiar with Agile practices, Git-based version control, and CI/CD workflows.
- Hands-on experience with Google Cloud Platform (GCP) for database hosting, monitoring, and scaling.
- Deep expertise in PostgreSQL internals — query planner, vacuum processes, WAL, replication, logical decoding, and high-availability strategies.
- Experience designing PostgreSQL architectures including HA, replication, fault-tolerance, and disaster recovery.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Technoidentity
About
Founded a decade ago, a group of seasoned professionals came together to ask ‘How might we use technology to bring the world closer to social justice?’ A small team was put together to create incredible solutions for organisations working towards delivering large scale impact. Today, we’re a global organisation providing disruptive software solutions to our customers who are solving important problems in their industry and also the world we live in. At TechnoIdentity, we challenge our team of passionate technologists to create forward-looking solutions for our customers that improve operational efficiency and bolster their bottom line. We empower them with the tools, methodologies and decision-making to make real impact, fast. We invite creative minds and businesses to TechnoIdentity, let’s collaborate to transform lives through technology.
Life at TechnoIdentity is shaped by the belief that everyone deserves to bring their authentic self to work and as responsible adults, you will choose to spend your time wisely on things matters the most to you.
Tech stack
Java
React.js
Python
ScalaCompany social profiles
Similar jobs
Amazon Web Services (AWS)Dear Candidate,
We are urgently Hiring AWS Cloud Engineer for Bangalore Location.
Position: AWS Cloud Engineer
Location: Bangalore
Experience: 8-11 yrs
Skills: Aws Cloud
Salary: Best in Industry (20-25% Hike on the current ctc)
Note:
only Immediate to 15 days Joiners will be preferred.
Candidates from Tier 1 companies will only be shortlisted and selected
Candidates' NP more than 30 days will get rejected while screening.
Offer shoppers will be rejected.
Job description:
Description:
Title: AWS Cloud Engineer
Prefer BLR / HYD – else any location is fine
Work Mode: Hybrid – based on HR rule (currently 1 day per month)
Shift Timings 24 x 7 (Work in shifts on rotational basis)
Total Experience in Years- 8+ yrs, 5 yrs of relevant exp is required.
Must have- AWS platform, Terraform, Redshift / Snowflake, Python / Shell Scripting
Experience and Skills Requirements:
Experience:
8 years of experience in a technical role working with AWS
Mandatory
Technical troubleshooting and problem solving
AWS management of large-scale IaaS PaaS solutions
Cloud networking and security fundamentals
Experience using containerization in AWS
Working Data warehouse knowledge Redshift and Snowflake preferred
Working with IaC – Terraform and Cloud Formation
Working understanding of scripting languages including Python and Shell
Collaboration and communication skills
Highly adaptable to changes in a technical environment
Optional
Experience using monitoring and observer ability toolsets inc. Splunk, Datadog
Experience using Github Actions
Experience using AWS RDS/SQL based solutions
Experience working with streaming technologies inc. Kafka, Apache Flink
Experience working with a ETL environments
Experience working with a confluent cloud platform
Certifications:
Minimum
AWS Certified SysOps Administrator – Associate
AWS Certified DevOps Engineer - Professional
Preferred
AWS Certified Solutions Architect – Associate
Responsibilities:
Responsible for technical delivery of managed services across NTT Data customer account base. Working as part of a team providing a Shared Managed Service.
The following is a list of expected responsibilities:
To manage and support a customer’s AWS platform
To be technical hands on
Provide Incident and Problem management on the AWS IaaS and PaaS Platform
Involvement in the resolution or high priority Incidents and problems in an efficient and timely manner
Actively monitor an AWS platform for technical issues
To be involved in the resolution of technical incidents tickets
Assist in the root cause analysis of incidents
Assist with improving efficiency and processes within the team
Examining traces and logs
Working with third party suppliers and AWS to jointly resolve incidents
Good to have:
Confluent Cloud
Snowflake
Best Regards,
Minakshi Soni
Executive - Talent Acquisition (L2)
Rigel Networks
Worldwide Locations: USA | HK | IN
Amazon Web Services (AWS)PythonPosition: AWS Data Engineer
Experience: 5 to 7 Years
Location: Bengaluru, Pune, Chennai, Mumbai, Gurugram
Work Mode: Hybrid (3 days work from office per week)
Employment Type: Full-time
About the Role:
We are seeking a highly skilled and motivated AWS Data Engineer with 5–7 years of experience in building and optimizing data pipelines, architectures, and data sets. The ideal candidate will have strong experience with AWS services including Glue, Athena, Redshift, Lambda, DMS, RDS, and CloudFormation. You will be responsible for managing the full data lifecycle from ingestion to transformation and storage, ensuring efficiency and performance.
Key Responsibilities:
- Design, develop, and optimize scalable ETL pipelines using AWS Glue, Python/PySpark, and SQL.
- Work extensively with AWS services such as Glue, Athena, Lambda, DMS, RDS, Redshift, CloudFormation, and other serverless technologies.
- Implement and manage data lake and warehouse solutions using AWS Redshift and S3.
- Optimize data models and storage for cost-efficiency and performance.
- Write advanced SQL queries to support complex data analysis and reporting requirements.
- Collaborate with stakeholders to understand data requirements and translate them into scalable solutions.
- Ensure high data quality and integrity across platforms and processes.
- Implement CI/CD pipelines and best practices for infrastructure as code using CloudFormation or similar tools.
Required Skills & Experience:
- Strong hands-on experience with Python or PySpark for data processing.
- Deep knowledge of AWS Glue, Athena, Lambda, Redshift, RDS, DMS, and CloudFormation.
- Proficiency in writing complex SQL queries and optimizing them for performance.
- Familiarity with serverless architectures and AWS best practices.
- Experience in designing and maintaining robust data architectures and data lakes.
- Ability to troubleshoot and resolve data pipeline issues efficiently.
- Strong communication and stakeholder management skills.
- Daily coordination with consultant / clinic head basis of the treatment advised by them.
- Helps patient to understand the value of treatment (Convincing patient to commit to treatment)
- Explain the tariff of the respective procedures/investigations to patients in detail and upselling the packages
- Maintain counselor reports daily (Advice, Conversion and Patient-wise data).
- Coordinating with finance department (Invoices, Getting Discount Approval, Billing).
- Establishing a tone of empathy that helps to resolve any patient complaints or conflicts.
- Follow up with patients at all stages.
- Doctor for life - Responsible for long term relationship management with the patient.
Bloomreach Experience, the digital experience platform built for commerce, includes three pillars:
- Discovery, offering AI-driven search and merchandising;
- Content, offering a headless CMS; and
- Engagement, offering leading CDP and marketing automation solutions.
Our India team is a critical product development and innovation hub for the company, with many of the company’s key products and technology initiatives created and developed by this team. Bloomreach Search, our search and personalization product, was built and shipped out of our India office.
We are currently allowing flexibility for all our employees to work from home until it is deemed safe for us to return back to the office.
What you will do:
- Chalk-out and implement the vision, technology roadmap and business goals for your scope of deliverables.
- Have the opportunity to define, implement, manage and deliver systems that maintain the Bloomreach Platform.
- Lead multiple small, agile teams of high-performing engineers with a diversity of experience backgrounds and locations.
- Operate with scale and speed, amidst flux, in a fast-paced environment while contributing to business goals and product strategies.
- Partner with Engineering Leaders, Managers and Product Management, and enable them by owning the integrity of scalable and high-quality technology solutions.
- Manage and influence remote teams to ensure a consistently awesome experience across platforms and products.
- Create a culture of Engineering Excellence and execution across locations ensuring development and adoption of best practices in technical design implementation and code optimisation.
- Help attract, select and hire best-in-class talent and help retain top performing talent by creating clear career paths and providing technical mentorship.
- Ensure compliance with security practices/guidelines and relevant technology standards.
What you will need:
- B.E./B.S. Degree or higher in Computer Science or related technical discipline.
- 10+ years of programming experience in Java, Python with strong knowledge of web technologies like HTTP, Tomcat or Django, networking and web performance engineering.
- 3+ years of experience in managing direct reports and their careers.
- Experience in leading technical teams in systems/databases or large scale distributed/infrastructure systems in production.
- Capable of sitting down with engineers to constructively review designs and debug live production issues.
- Extensive background in algorithms, strong software architecture and design skills in building large scale internet applications.
- Comfortable in designing big data technology solutions using Spark, Hadoop, Cassandra and MySQL.
- Capable of handling ambiguous business requirements with excellent prioritisation, time management abilities and focus on execution.
- Experience hiring, mentoring, coaching and developing top engineering talent.
Engineering Blog Link:
- https://developers.bloomreach.com/blog/2018/breaking-down-a-monolithic-api---dockerizing-the-bloomreach-suggest-api-layer.html" target="_blank">How Bloomreach built a monolithic API
- https://developers.bloomreach.com/blog/2018/developer-talk-corwin-on-containers.html" target="_blank">Developer Talk - Corwin on Containers
- https://www.bloomreach.com/en/blog/2018/07/introducing-identity-and-access-management-for-bloomreach-personalization.html" target="_blank">Introducing Identity and Access Management for Bloomreach personalization
If this is you and you can prove it – we’re interested in talking with you to join us as one of Bloomreach’s Engineering Leaders.
Regional benefits:
- Annual Medical Insurance Coverage for yourself and your dependents
- Annual Master Health Check-Up by up to 4000 INR per month
- Statutory Retiral Benefits (Provident Fund Gratuity)
More things you'll like about Bloomreach:
Culture:
- A great deal of freedom and trust. At Bloomreach we don’t clock in and out, and we have neither corporate rules nor long approval processes. This freedom goes hand in hand with responsibility. We are interested in results from day one.
- We have defined our https://careers.bloomreach.com/about-us">5 values and the 10 underlying key behaviors that we strongly believe in. We can only succeed if everyone lives these behaviors day to day. We've embedded them in our processes like recruitment, onboarding, feedback, personal development, performance review and internal communication.
- We believe in flexible working hours to accommodate your working style.
- We work remote-first with several Bloomreach Hubs available across three continents.
- We organize company events (summits) twice a year to experience the global spirit of the company and get excited about what's ahead.
- We have a friendly atmosphere and motivated colleagues who love what they do.
- The https://www.glassdoor.com/Overview/Working-at-Bloomreach-EI_IE442167.11,21.htm">Bloomreach Glassdoor page elaborates on our stellar 4.5/5 rating.
Personal Development:
- We have a People Development Program -- participating in weekly personal development workshops on various topics run by experts from inside the company. We are continuously developing & updating competency maps for select functions.
- Our managers are strongly encouraged to participate in the Leader Development Program to develop in the areas we consider essential for any leader. The program includes regular comprehensive feedback, consultations with a coach and follow-up check-ins.
- Bloomreachers utilize the $1,500 professional education budget on an annual basis to purchase education products (books, courses, certifications, etc.)
- Our resident communication coach https://www.linkedin.com/in/ivo-ve%C4%8De%C5%99a-2a94291/">Ivo Večeřa is available to help navigate work-related communications & decision-making challenges.
Well-being:
- The Employee Assistance Program -- with counselors -- is available for non-work-related challenges.
- Subscription to Calm - sleep and meditation app.
- We organize ‘DisConnect’ days where Bloomreachers globally enjoy one additional day off each quarter, allowing us to unwind together and focus on activities away from the screen with our loved ones.
- We facilitate sports, yoga, and meditation opportunities for each other.
Compensation:
- Stock options are granted depending on a team member’s role, seniority, and location.
- Everyone gets to participate in the company's success through the company performance bonus.
- We offer an employee referral bonus of up to $3,000 paid out immediately after the new hire starts.
- We celebrate work anniversaries -- Bloomversaries!
- Develop digital marketing strategy by studying economic indicators, tracking changes in supply and demand, identifying customers and their current and future needs, and monitoring the competition.
- Plan and execute all digital marketing, including SEO/SEM, keywords, marketing database, email, social media and display advertising campaigns.
- Plan, monitoring & maintaining company online presence on social media.
- Employing online marketing analytics to gather information from web and social media pages.
- Measure and report performance of all digital marketing campaigns, and assess against goals.
- Acquire insight in online marketing trends and keep strategies up-to-date.
- Manage all digital marketing channels - FB, Insta, Marketplaces such as Amazon, Flipkart.
- Ability to execute campaigns across all online selling platforms.
- Prepare and manage digital marketing budgets, analytics & reports.
iOS App Development
Objective C
SwiftJD:
Responsibilities
- Design and build applications for the iOS platform
- Ensure the performance, quality, and responsiveness of applications
- Collaborate with a team to define, design, and ship new features
- Identify and correct bottlenecks and fix bugs
- Help maintain code quality, organisation, and automatisation
Skills
- Proficient with Objective-C, Swift and Cocoa Touch
- Experience with iOS frameworks such as Core Data, Core Animation, etc.
- Experience with offline storage, threading, and performance tuning
- Familiarity with RESTful APIs to connect iOS applications to back-end services
- Knowledge of other web technologies and UI/UX standards
- Understanding of Apple’s design principles and interface guidelines
- Knowledge of low-level C-based libraries is preferred
- Experience with performance and memory tuning with tools.
- Familiarity with cloud message APIs and push notifications
- Knack for benchmarking and optimisation
- Proficient understanding of code versioning tools like Git, SVN.
- Familiarity with continuous integration
Role: Art Director
Responsibilites:
Think out of the box and guide the team with an innovative design approach and great-looking products that users desire
Create an inspiring team environment with an open communication culture and deeper collaboration
Set clear goals and motivate team members. Oversee day-to-day operations
Be a point of contact for team, stakeholders and report to HOD - Arts
Impart the importance of user-centricity and research to build scalable and valuable solutions
Monitor team performance and report on metrics and share honest reviews ,·:
Mentor team and discover training needs and provide coaching
Building a seamless process and flexible to iterate to suit a specific need
Empathies with team members and lead towards growth by constructive feedback
Exploration of various art styles and communicate a story through various mocks and presentation
Work closely with multiple departments and stakeholders and ensure transparency in the process and delivery milestones
Awareness of emerging gaming trends both for on line and offline events and technology landscape
Stays current with new game genres, game art best practices, emerging technology and promotional activities
Build a learning environment within the art team (acquisition and retention) and implement processes of artistic research
Good understanding of product and marketing objectives and ability to translate the same in all communication channels
Implementing visual design systems across a range of platforms in an iterative game development environment
Understand strategic solutions that identifies with the business values and the end-user objectives
Portfolio highlighting multiple projects and your specific contributions.
Domain: Ecommerce
ENGINEERING @MYNTRA
Myntra’s Engineering team builds the technology platform that powers our customer’s
shopping experience and enables the smooth flow of products from suppliers to our
customer’s doorsteps. We work on areas such as building massive-scale mobile and
web-applications, engaging user-interfaces, big-data analytics, mobile apps, content
systems, catalogue systems, search systems, supply chain systems, imaging and
visualization systems for products etc. We are a small technology team where each
individual has a huge impact. You will work closely with the business in shaping our product
and serve hundreds of millions of Indians! You will have the opportunity to be part of a
rapidly growing organization and gain exposure to all the parts of a comprehensive
eCommerce platform.
YOUR RESPONSIBILITIES
1. Technical Guidance: You will provide technical leadership to a team of excellent software
engineers; this requires that you have the technical depth to make complex design decisions
and the hands-on ability to lead by example
2. Execution and Delivery: You will be expected to instill and follow good software development
practices and ensure timely delivery of high-quality products. You should be familiar with agile
practices as well as be able to adapt these to the needs of the business, with a constant focus
on product quality
3. Team management : You will be responsible for hiring and mentoring your team; helping
individuals grow in their careers, having constant dialogue about their aspirations and sharing
prompt, clear and actionable feedback about performance
SKILLS / EXPERIENCE
● Total of 5+ years’ experience building cutting edge products. Deep experience in
building very large scale applications and 1+ years’ experience in team management
● Strong problem solving skills, data structures and algorithms
● Experience with distributed systems handling large amount of data
● Experience in very large scale applications.
● Strong problem solving skills, data structures and algorithms.
● Experience with distributed systems handling large amounts of data.
● Excellent coding skills in Java/J2EE.
● Very good understanding of Web Technologies.
● Excellent coding skills in NODE JS & PHP (Laravel)
● Very good understanding of Web Technologies
● Good understanding and experience with using open source technologies and building
complex products
● Handling large data (batch and real-time), workflows and scheduling, building pluggable
frameworks and systems, strong abstraction and architecture skills
● Experience using traditional RDBMS, NOSQL DBs (Cassandra, Mongo DB, Aerospike
etc.), caches
● (redis, memcache), messaging frameworks (Rabbit MQ, AWS SQS)
QUALIFICATIONS
B Tech/BE in Computer Science or equivalent or higher from a reputed institution.
REQUIREMENTS
1. Technical depth
You have the strong technical competence required to gain credibility. Ability to architect, design
and code yourself. Technical experience in building and operating web-based applications.
Deep understanding of all layers of the web-stack work (from the client interface to the
database.) Knowledge of multiple technology stacks/languages/tools and their pros/cons
2. Execution ability
Focus on delivering products in a timely manner with high quality. Familiarity with multiple
software development practices and tools, and the proven ability to adapt, champion and
institute good practices and tools
3. You must have a degree in Computer Science or related field. Strong understanding of
object-oriented programming, concurrency and fundamentals of computer-science
YOUR CAREER
Being a relatively small sized Engineering team, individuals carry a lot of responsibility on their
shoulders.Coming up with the designs of features, evaluating external libraries and frameworks,
enhancing existing platform infrastructure, reviewing major architectural decisions, planning and
executing deployments with minimal system downtimes is part of the everyday job. For an individual with
a hunger to solve problems and who thrives on challenges, passionate about leading teams, the
opportunities @Myntra are practically limitless.
YOUR TEAM
You’ll be a part of the team who’s passionate about scaling & delivering omnichannel initiatives @Myntra.
The primary products that you’ll be working on will be Myntra’s entire Omnichannel Suite. This consists of
end-to-end integrations with seller systems, omni order management system & in-store assistance initiatives
PHP
HTML/CSS
JavascriptJob Description:
- Code optimization for www.wellcurve.in to improve performance.
- Constant improvement in website functionalities (expertise in building custom plug-ins).
- You should have the ability to own the product, drive improvements, assess latest trends in e-commerce and implement the same for Wellcurve.
- Expertise in php, html, css, javascript needed.
- Ability to work independently and take ownership of the entire tech cycle - from requirement gathering to deployment.
- Build a tech ecosystem around the website to solve business challenges. E.g. Implement ERP, CRM, other API integrations, etc.
- Server Deployment and Maintenance skills are desirable.
- This role is an ideal fit for you, if you looking for a challenge involving ownership of a product that will eventually drive scale and growth for the company.
JavaPythonJavascriptAmazon Web Services (AWS)
Go Programming (Golang)
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon