
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.

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
Similar jobs
1.Technical Sales
Develop and execute strategies to achieve sales targets for equipment and elevator systems.
Conduct technical presentations and product demonstrations for prospective and existing clients.
Provide detailed technical and application advice to customers on equipment and elevator solutions.
2. Customer Engagement
Identify and assess customer needs through site visits, consultations, and discussions.
Prepare and deliver proposals, quotations, and technical documentation.
Maintain and build relationships with key clients, ensuring high levels of customer satisfaction and retention.
3. Project Management
Oversee the technical aspects of sales projects from inception to completion, ensuring all specifications and requirements are met.
Collaborate with engineering and installation teams to ensure successful project delivery.
Address and resolve technical issues that arise during the sales process or order finalization.
4. Market Analysis
Monitor and analyse market trends, competitor activities, and customer feedback to identify opportunities and threats. Provide insights and recommendations to enhance product offerings and sales strategies.
5. Reporting and Documentation
Maintain records of sales activities, customer interactions, and project status in the CRM system.
Prepare regular sales reports, forecasts, and performance metrics for management review.
Qualifications:
•Bachelor's degree B.E. / Diploma (Mechanical)
Skills:
•2-3 years of proven experience as a sales or in a similar role.
•Strong written and verbal communication skills.
•Strong technical knowledge of equipment and elevator systems.
•Excellent communication and presentation skills.
•Time management and ability to meet deadlines
•Strong problem-solving skills and a customer-focused approach.
•Proficiency in CRM software and Microsoft Office Suite (Excel, Word, PowerPoint).
•Valid driver’s license and willingness to travel as required.
•Ability to work independently and manage time effectively in a field-based role.
About the Role:
We are looking for a technically skilled and field-oriented Service Engineer to handle installation, commissioning, and after-sales support of industrial machinery. This role requires strong on-site execution, customer coordination, and troubleshooting capabilities.
Qualifications:
Diploma / Degree in Mechanical Engineering
Diploma / Degree in Electrical / Electronics Engineering
ITI – Fitter Trade
Key Responsibilities:
Installation & Commissioning:
Execute on-site installation and commissioning of machinery
Ensure timely completion of assigned work orders
Participate in FAT (Factory Acceptance Testing) with customers
Handle machine shifting, de-boxing, and installation setup
Site Management & Coordination:
Plan and execute site visits as per project schedule
Coordinate with customers for site readiness and execution
Manage site activities independently
Ensure proper handover and customer satisfaction
Technical Support & Troubleshooting:
Diagnose and resolve on-site technical issues
Coordinate with design, QA, and internal teams for support
Follow up for material requirements and shortages
Reporting & Communication:
Maintain regular communication with customers
Submit daily site visit reports to reporting manager
Ensure documentation and reporting accuracy
Required Skills:
Strong mechanical and technical aptitude
Hands-on experience in installation & commissioning
Good communication and customer handling skills
Problem-solving and troubleshooting ability
Ability to work independently at client sites
Basic computer skills (MS Office, reporting tools)
Team coordination and leadership qualities
Job Responsibilities:
• Drive sales strategies to meet revenue goals
• Build & maintain key client relationships
• Lead, mentor & manage the sales team
• Conduct market research and identify opportunities
• Coordinate with Marketing & Product teams
• Prepare sales reports for senior management
• Attend industry events & generate business
• Maintain strong sales pipeline & improve processes
About Us
We are seeking a talented and results-driven professional to join our dynamic team. As a Business Development Executive - Upwork Specialist(International Sales), you will play a pivotal role in expanding our presence on one of the leading freelance platforms. If you have a proven track record of success on Upwork and a passion for driving business growth, we’d love to hear from you!
Key Responsibilities
- Client Engagement: Identify and connect with potential clients on Upwork to generate new business opportunities.
- Profile Optimization: Strategically enhance our Upwork profile to attract high-quality leads and boost visibility.
- Proposal Crafting: Develop compelling, customized proposals aligned with client requirements to secure projects.
- Relationship Management: Build and nurture long-term relationships with clients to ensure repeat business and referrals.
- Market Analysis: Stay informed about market trends, Upwork algorithms, and competitor activities to maintain a competitive edge.
Requirements
- Proven Expertise: Demonstrated success in acquiring projects on Upwork with a track record of achieving revenue targets.
- Communication Skills: Exceptional verbal and written communication skills to interact effectively with clients.
- Platform Knowledge: Comprehensive understanding of Upwork algorithms, best practices, and optimization techniques.
- Self-Motivation: Ability to work independently, manage multiple client interactions, and meet deadlines.
- Adaptability: A proactive and resourceful approach to addressing client needs and challenges.
What We Offer
- Flexibility: Enjoy flexible working hours tailored to your needs.
- Supportive Environment: Collaborate with a talented and enthusiastic team dedicated to growth and innovation.
- Career Growth: Opportunities to enhance your skills and advance your career in a supportive organization.

Different aspects of SEO optimization
- ORM (Online Reputation & Response Management) for the client's account
- live Google Ads projects, keyword research & campaign optimization
- Google my business - handling & optimization
- Hands-on experience in live Social media projects
- preparing daily & weekly client reports Skill
Skill Requirements:
Good command over English both written and verbal
- Good MS Excel skills and exposure to work on Google docs or G-suite
- Focused on delivery - Attention to detail and high on rigor & energy
- Expected to work & contribute individually on modules of a project
- Ability to thrive in a fast-paced environment Basic English literature graduates with an aptitude
for Social Media can also be considered
Key Responsibilities:
- Creating and implementing efficient solutions to optimize the customer journey and experience
- Solid experience with customer journey mapping, process optimization, and process improvement
- Owning product implementation and contributing recommendations on product roadmap
- Defines the product vision, strategy, and roadmap.
- Monitor all projects and ensure achievement of all revenue objectives
- Achieve all business objectives and determine an effective strategy
- Coordinate internal resources and third parties/vendors for the flawless execution of projects
- Manage changes to the project scope, project schedule and project costs using appropriate verification techniques
- Measure project performance using appropriate tools and techniques
- Report and escalate to management as needed
- Track project performance, specifically to analyze the successful completion of short and long-term goals
- Campaign Management
Educational Requirements:
- 3+ years’ experience in the FinTech, product / project management
- Education: B Tech (Bachelor of Technology)
Skills:
- Strategy and Planning: Proficient in developing & implementing need-based plans
- Campaign Management
- Excellent organizational and data analysis skills; ability to derive actionable conclusions from
- large data sets and statistical studies
- Maximizing profitability, Client Engagement, Revenue
- Products/promotions / discounts/ Cashback offers for B2C
- Customer Life Cycle Management
- Understanding the product Life cycle and sympathy towards customer pain points
- Works closely with stakeholders to ensure business case and customer satisfaction goals are met
- Measure project performance using appropriate tools and techniques
- Excellent communication and writing skills
- Team player
TECHNICAL SKILLS
- Computer Languages: Data Structure, Algorithms, DBMS (Conceptual), SQL DBA
- Software Packages: CleverTap (Mobile App Analytics Tool), MS office - Excel, PPT, Visio
Platform - Clevertap, Netcore
1. Work with development team to ideate software solutions
2. Design client-side and server-side architecture
3. Build the front-end of applications through appealing visual design
4. Develop and manage well-functioning databases and applications
5. Designing and developing effective APIs
6. Test software to ensure responsiveness and efficiency
7. Troubleshoot, debug and upgrade software
8. Create security and data protection settings
9. Build features and applications with a mobile responsive design
10. Meeting both technical and consumer needs
11. Staying abreast of developments in web applications and programming languages
Qualifications & Requirements:
1. At Least 2 years of proven experience as a Full Stack Developer or similar role
2. Degree in Computer Science, IT, Statistics or relevant field
3. Experience developing both desktop and mobile applications
4. Proficiency with fundamental front-end languages such as HTML/ CSS and JavaScript
5. Familiarity with JavaScript frameworks such as VueJS, React and NodeJS
6. Proficiency with server-side languages such as NodeJS, ExpressJS and Python
7. Knowledge of database technology such as MongoDB, Redis, PostgreSQL
8. Excellent problem-solving and analytical skills
9. Great attention to detail
Required: NodeJS, MongoDB
Preferred: HTML/CSS, VueJS, Redis
Cityflo is an app-based daily commute solution for Mumbai's professionals. With a smart app, clever route design, and a fleet of premium buses, we are providing an airline experience on wheels. Cityflo has been operational since 2015 and is solving Mumbai's travel woes in a big way.
You can read more about our engineering and culture on our blog: https://blog.cityflo.com/tag/engineering/" target="_blank">https://blog.cityflo.com/tag/engineering/
Roles & Responsibilities:
- Working closely with business vendors, product, and BI team to identify and implement necessary technologies.
- Maintaining and improving the dashboard which helps the team to run the operations in the most efficient manner.
- Optimizing daily operations and identifying avenues for effective introduction of technology.
- Working closely with the on-ground operations team and understanding their daily challenges.
We are looking for:
- Experience in developing web applications at scale.
- Strong knowledge and experience in web technologies and Python.
- Experience in writing modular/reusable code in ReactJS.
- Good UI/UX design sense and intuition
- Following good software engineering practices like version control, code-reviews, test-driven development, and continuous integration, etc.
- Experience with AWS services such as Lambda, RDS(PostgreSQL), AWC Chalice(serverless framework) is a plus.
- Long-term thinking around creating products and owner mentality.
- Great communication skills, the ability to articulate and evangelize product vision.
- Willingness to take initiatives, the ability to hustle and get things done.









