
At Technoidentity, we’re a Data + AI product engineering company delivering scalable, modern enterprise solutions.
We are seeking a seasoned Senior Database Developer & PostgreSQL Expert with 8–10 years of experience across multiple database systems, with deep hands-on 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.
Requirements
Key Responsibilities
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.
Ideal Candidate Profile
Experience & Skills
- 4–10 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.

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
Hiring Regional Manager/ Sr. RM for fintech company based in North India
Location- Gurugram, Faridabad, Bulandshahr, Badaun, Rewari, Palwal, Jaitaran (Rajasthan), Haridwar (Uttarakhand)
Experience required - 6months to 1 year
CTC offered – 2.38L – 4 L.
Net in hand -15K-28 monthly.
Age Limit – 37 Yrs. LAP, HL, Mortgage Loans
Ticket Size handling – 2L-50L or above.
ROI Handling - 16%-24% or above
Geo Limit Travelling– 50km-75km
No of DSA Local, DSA Corporate, Connectors if Candidate has.
Key Responsibilities:
- Lead the erection and commissioning of 11 kV and LT distribution lines including overhead and underground works.
- Coordinate with clients (NBPDCL), contractors, site engineers, and consultants for project planning and execution.
- Prepare and validate project documents including Bill of Quantity (BOQ), Joint Measurement Certificates (JMCs), client billing, and handover-takeover (HOTO) reports.
- Implement conversion of bare conductors to Aerial Bundled (AB) cables to reduce AT&C losses.
- Ensure installation and material quality adherence to project drawings and specifications.
- Supervise and train field teams on layout, material handling, safety practices, and execution methodologies.
- Utilize GPS-based techniques to define coordinates for township-level layouts and planning.
- Manage execution under 4 critical schedules of the RDSS scheme:
- Feeder Segregation
- Bifurcation of Long/Lengthy Feeders
- HVDS (High Voltage Distribution System)
- Cabling & Re-conductoring Works
Desired Candidate Profile:
- B.Tech in Electrical Engineering (Mandatory); MBA in Project Leadership Management (Preferred)
- 3.5 – 7 years of experience in EPC/Power Distribution projects, preferably in rural and urban electrification works.
- Proficiency in project documentation, estimation, client coordination, and quality inspections.
- Strong team management and leadership skills with the ability to mentor junior engineers and field staff.
- Knowledge of GPS and basic electrical testing tools (e.g., Megger Testing).
- Familiarity with government-led projects such as IPDS, R-APDRP, RDSS is a plus.
Key Competencies:
- Strategic Planning & Execution
- Quality & Compliance Monitoring
- BOQ & Billing Documentation
- Vendor and Subcontractor Coordination
- Field Supervision and Site Safety
- Client Relationship Management
Safety Connect is a growing company in the domain of field force and road safety.
We are looking for a high-energy and dynamic Inside Sales Representative to join our growing team and fix quality meetings with potential customers. This role will be responsible for servicing outbound sales with a focus on generating, qualifying, and engaging all prospective clients. This role is one of the first touchpoints for prospects and has the opportunity to set the tone for the sales cycle.
This position requires outbound cold calling, emailing, qualification, and tight collaboration with the Business Development Manager (BDM) to generate new opportunities.
Roles and Responsibilities:
• Primary responsibility would be to generate demand and move leads through the pipeline and convert them into sales qualified leads.
• Respond, engage and qualify inbound leads and inquiries.
• Develop and execute a strong prospecting plan of attack, including email and call scripts.
• Quickly learn about the product, effectively communicate the value proposition and be able to respond to objections.
• Follow-up on leads and provide appropriate information to foster relationships.
• Educate leads on our product and nurture them until they are qualified and ready to talk with BDM.
• Schedule meetings and demos for BDM.
Requirements /Qualifications:
-
Exceptional communication skills (both verbal and written).
-
Self-motivated with diligent work ethic, Experience with CRM applications.
-
Data-driven mindset.
-
1-3 years of experience as an Inside Sales Representative in SaaS/ B2B.
-
Bachelor’s degree or equivalent required.
Graduate / Post Graduate in Management / Rural Management / Social Studies / Agriculture / Food Engn. / Food Technology / Horticulture & Agribusiness
Ideal Candidate for this position :
- The ideal candidate should be an enterprising person with fair exposure to government business / departments. The candidate should have prior exposure to deal with decision makers and should have the hunger for business.
- Prior experience in dealing with Civil Supplies, Consumer Affairs, Dairy, Agriculture Marketing departments will be an added advantage.
- Exposure to commodity trade in general. Exposure in pulses, sugar , oilseeds, F&V would be desirable
- Understanding of the commodity markets and its entire value chain across the commodity ecosystem
- Linkages with Agri commodity trade houses, export firms and Agri related corporates.
- Demonstrated ability to lead and coordinate effectively with a wide variety of stakeholders, including national and local government, trade, banks, community- based organizations, and the private sector
- Experience in networking with the various stakeholders in the government departments and agencies along with ability to influence the decision makers. Prior experience in bid / tendering process including record of accomplishment of successful wins. Should have handled projects worth a min of 10 Cr. plus.
- Ability to commercially manage (revenue collections) large projects within stipulated timelines is necessary for this position.
- Should have lead a team size of ten member’s direct reportees.
- Prior experience in managing technology intensive projects will be highly advantageous for the candidature.
Must Have: An unblemished track record for integrity and respect for fellow colleagues.
Job Responsibilities:
Revenue generation and collections as per the mutually agreed annual target for the said geography New account / business / vertical acquisition from various government departments Managing and building a high performance state team to deliver stunning results.
Skills Required:
1. Proficiency in written and spoken English, along with a presentable personality to represent the organization at
state level.
2. Exposure to technology and effective usage of the same in terms of web / app and tools.
3. Ability to write commercial proposals along with understanding of basic law.
4. Ability to prepare presentations using Microsoft Office Suite
5. Ownership for assigned responsibilities and organization frameworks
6. Ability to build and develop internal as well as client relationships
WHAT YOU’LL BE DOING:
- Compile and analyze data, processes, and codes to troubleshoot problems and identify areas for improvement.
- Collaborate with the front-end developers and other team members to establish objectives and design more functional, cohesive codes to enhance the user experience.
- Develop ideas for new programs, products, or features by monitoring industry developments and trends.
- Record data and report it to proper parties, such as clients or leadership.
- Participate in continuing education and training to remain current on best practices, learn new programming languages, and better assist other team members.
- Take the lead on projects, as needed.
- Be involved and participate in the overall application lifecycle.
- Build high-quality reusable code that can be used in the future.
- Develop functional and sustainable web applications with clean codes.
- Conduct UI tests and optimize performance.
- Manage cutting-edge technologies to improve applications.
QUALIFICATIONS:
- Bachelor’s degree in Computer Science, Computer Programming or relevant field. Master’s Degree in a related field is preferred.
- 5-7 years of relevant experience
- Must be an expert programmer, skilled at computer languages such as HTML, C+++, C#, PHP, Python and Java.
- Must understand Spring Core, Spring Boot, Spring MVC, Spring Data, JMS, Mysql, Redis, CouchDb, Micro Services, Docker, Kubernetes
- Must be able to interpret and follow instructions related to the ultimate functionality of our IT-based product
- Familiarity with front-end languages such as HTML, JavaScript and CSS
- Must be comfortable with technology architecture and how a computer and its software functions.
- Deadline driven, organized and understand how people view and understand content on the front-end
- Proven experience in highly complex environments
- Strong technical documentation skills
- An ability to solve multifaceted technical issues in a fast-paced environment
- Self-motivated and accountable for your work
- Passionate about learning and continuous improvement
- Excellent written and verbal communication skills
- Ability to work overtime
A highly motivated and passionate individual who has experience in executing end to end web based application projects and bringing them to production quickly and with high quality. Passionate about building flexible and scalable solutions with an eye for detail and can weigh pros and cons to find best possible solutions.
Responsibilities:
- Collaborate with Product Manager and Engineering Manager to plan, implement and deliver tasks and modules on a timely basis with best practices and adherence to SOPs.
- Understand the product specification and be able to ask questions and gather information and feedback to build a well rounded solution.
- Deliver end to end applications starting from front end web development, back end development, middleware integration and persisting data in no SQL or RDBMS databases.
- Should be able to use existing front-end components to build web based UI interfaces.
- Strong technical design approach to problem solving for backend services.
- Should be able to communicate and defend the tech design choices taken for long term scalability and maintainability.
- Play the role of an unblocker in a tight scrum environment.
- Should be able to help other developers with challenges and help achieve milestones as per plan.
- Prioritise to manage ad-hoc requests in parallel with ongoing projects.
- Document API specification, technical design and other key information for all projects/modules/services owned
Requirements:
- A highly talented developer with 4-7 years of hands-on experience in building secure and scalable web-based applications using Java in backend and JS-based frontend frameworks
- Strong knowledge of Java 8+, databases (SQL and NoSQL), MySql, Mongo
- Experience working with Cassandra, Spring Boot, Apache Spark, Kafka, RabbitMQ is highly desirable
- Working knowledge of any one or more of AngularJS/ReactJS/VueJS and CSS3, HTML5
- Strong experience in data modeling for data storage tools in SQL; experience with noSQL is highly desirable.
- Experience building scalable solutions for 2x, 5x and 10x growth with high quality and flexibility.
- Practitioner of test-driven development practices.
- Experience in creating and adhering to best practices for development
- Experience working with container technologies like Docker and knowledge of CI/CD processes for automated integration and deployment.
- Basic knowledge of AWS preferred
- Strong experience in Microservices (SRP) paradigm
- Willing to learn new technologies (Golang)
- Qualification B.Tech/M.Tech/MCA(IT/Computer Science)
- Years of Exp 4 - 7 years
Brewhackers Technologies is a place for creative people to develop themselves and thrive in a rapidly changing world. We are developing a service to help people consume and share ideas that matter faster and more efficiently. We deliver this through an app for iOS and Android.
We are small team so :
- Passion for the problem is our secret sauce. At a startup, everyday is a struggle but we get through that by keeping our eyes on the prize.
- We find a way or make a way. No excuses.
- We thrive in uncertainties. We have more questions than answers and more opportunity to learn new things.
Our tech stack is made of :
- Node.Js, PostgreSQL, AWS on the backend
- Flutter on the front end.
We are looking for a full-stack engineer with a passion for product and delivery. This is the type of job where you are pushed in cold water and you have to learn to swim by yourself. Your personality and your traits matter more than your tech expertise:
- We are looking for an independent, responsible person. Mainly because there is no time for micro-management. We expect you to be able to carry your own weight and be a reliable partner.
- We are looking for a fast learner. We may need to use technologies that you never used before. That should not scare, but excite you. In most cases we may not even know what we need and you may have to propose something.
- We are looking for you to get stuff done. We work in weekly sprints because we believe in consistent delivery over big lengthy releases.
- We want you to be proactive. We appreciate conviction way more than consensus. Words are nice, opinions are cute … but proactivity in action is golden.
- We want you to be a partner for your colleagues in the dev team. Help or lead the planning process, code reviews, commits etc. Provide guidance and help your colleagues when they get stuck.
- We want you to be an over-communicator. We are remote-first and it’s up to you to show your work, explain your ideas or highlight problems.
Now on technology, these would be nice:
- Experience with Javascript.
- Experience with mobile development (native or hybrid)
- Experience with interface building frameworks (React, Angular, Vue etc)
- Experience with Node.JS, Express Framework and GraphQL
- Experience with SQL and NoSQL databases
We have a great work culture and offer amazing technical and architectural challenges.
The ideal candidate will be an enthusiastic developer eager to work on the innovative Product.
Qualification : 4 to 8 years of relevant experience in Core Java. Excellent coding skill in Java, Spring / Springboot, React, Javascript







