Lead Product Manager

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

Mandatory skills

.net

Aws/Azure

Location Chennai

Development background

Mandatory skills

.net

Aws/Azure

Location Chennai

Development background

Job Responsibilities -

● Identifying and onboarding the potential DSAs and Channel partners from open market

● Build and strengthen relationships with new and existing partners to drive business targets

● Provide day to day operational support to your channel partners

● Responsible for driving monthly sales targets and respective business metrics

Job Requirements -

● Excellent sales skills, e.g. rapport building and negotiation skills

● Good written and verbal communication skills

● Should have prior experience in NBFC and DSA preferably in mortgages (Home loan and

LAP)

● Own Conveyance and strong local industry network are preferred for this role

● Fluency in the regional language will be an additional benefit

• Would be responsible for end to end loan processing, from initial receipt of loan application to credit approval stage within TAT parameters.

• Reviewing the loan application.
• Reviewing the credit application
• Credit underwriting 
• KYC verfication.

Searce is a modern tech consulting firm that empowers clients to futurify their businesses, leveraging Cloud, AI & Analytics.

• Natural creativity:

The best designers are creative visionaries, people who are capable of stepping back, seeing the big picture, and coming up with new ways of approaching challenges and making positive changes to how the company is managed and marketed.

• Not a CAVEr: 

You are a person that people like to be around. You are not a CAVE (Constantly Against Virtually Everything) personality.

• Say no to HiPPO: 

At Searce, we want people who value everyone’s opinions & perspectives. We don’t want them to get overpowered by HiPPO (Highest Paid Person’s Opinion)

1. Have a point of view and can distinguish between "good" and "great" work.
2. Strong hands-on skills which should range from designing using Photoshop to coding UI mockups. 
3. Hands-on knowledge of front-end technologies: Html 5, CSS, JavaScript.
4. Hands-on knowledge on Photoshop / Illustrator / Dreamweaver / Fireworks / Flash. 
5. A design portfolio demonstrating the breadth and proven experience in product and services marketing communication, workflow and interaction design, visual design work, and a thorough understanding of a good design process is required.
6. Have the ability to work on digital marketing strategies, define workflows, write concepts and content to generate interest in Searce’s products, brands, and services.
7. Have the ability to think strategically, act tactically, and solve problems quickly.
8. Successfully overcome engineering challenges and understand the need for testing and iteration of new user experiences.
9. Have a track record in creating highly functional, user-focused, complete, and desirable experiences and designs.
10. Be able to lead teams through the design process and partner effectively within cross-functional teams.
11. Be innovative, enthusiastic, flexible, and creative.
12. Demonstrate excellent project management and scheduling skills.

Is Education overrated? Yes. We believe so. But there is no way to locate you otherwise. So we might look for at least a Bachelor’s degree in Design (B.Des.).

1. A lead of visual design who envisions and creates the next generation of user interfaces for customer service.
2. A design pioneer, who will invent user interfaces that combine speech, touch, and other modalities to drive intuitive interactions on smartphones, tablets, and other connected consumer devices.
3. The ability to combine strategy with design thinking to deliver an experience like our audience never had before.
4. Bring passion and dedication to his/her job and become a storyteller through exceptional and engaging designs.