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?
- 8–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
Mandatory Criteria
- Key Account Management (preferably in D2C, SaaS, or Growth Marketing)
- Client Relationship Management
- Data-driven problem solving & storytelling
- Funnel Optimization / CRO knowledge
- Revenue Retention & Upselling Strategy
- Proficiency with analytics tools (Google Analytics, Hotjar, VWO, etc.)
- Excellent communication and negotiation skills
- Strong cross-functional collaboration with design & tech teams
OKR
Objective 1 – Client Growth & Retention:
- Achieve ≥95% client retention across assigned accounts.
- Identify and close at least two upsell/cross-sell opportunities per quarter.
Objective 2 – Revenue Accountability:
- Own and deliver quarterly account revenue targets.
- Improve client ROI/ROAS through CRO-driven interventions.
Objective 3 – Relationship Management:
- Maintain client CSAT ≥ 8/10.
- Conduct monthly business reviews and share measurable impact reports.
Objective 4 – Collaboration & Leadership:
- Coordinate with tech, design, and CRO teams to deliver outcomes on time.
- Mentor junior account managers for structured delivery and communication.
If interested kindly share your updated resume at 82008 31681
Role: MIS Analyst
Location: Hyderabad
Experience Required: 4 to 8 Years
Key Skills:
MIS Analyst with 4 Plus Years of Experience.
Strong Experience in Pivot Tables.
Strong Experience in PowerPoint Presentation
Good Experience in Data Validation, Vlookup
Excellent Communication
Java
Spring Boot Participate in the entire application lifecycle, focusing on coding and debugging
Write clean code to develop functional web applications
Troubleshoot and debug applications
Perform UI tests to optimize performance
Manage cutting-edge technologies to improve legacy applications
Collaborate with Front-end developers to integrate user-facing elements with server-side logic
Gather and address technical and design requirements
Build reusable code and libraries for future use
Follow emerging technologies
Desireable skills
3+ years of experience as a Back-end developer
In-depth understanding of the entire web development process (design, development, and
deployment)
Hands-on experience with Java, Springboot and Hibernate
Working knowledge in SQL
Familiarity with Agile methodology of development process
Problem-solving attitude
Responsibilities
- Research industry-related topics (combining online sources, interviews, and studies)
- Write clear marketing copy to promote our products/services
- Prepare well-structured drafts using Content Management Systems
- Proofread and edit blog posts before publication
- Submit work to editors for input and approval
- Coordinate with marketing and design teams to illustrate articles
- Conduct simple keyword research and use SEO guidelines to increase web traffic
- Promote content on social media
- Identify customers’ needs and gaps in our content and recommend new topics
- Ensure all-around consistency (style, fonts, images and tone)
- Update website content as needed
Requirements and skills
- Proven 2-3 Years of work experience as a Content Writer, Copywriter or similar role
- Finance Domain preferred.
- Portfolio of published articles
- Experience doing research using multiple sources
- Familiarity with web publications
- Excellent writing and editing skills in English
- Hands-on experience with Content Management Systems (e.g. WordPress)
- Ability to meet deadlines
Bachelor or Master in Marketing, English, Journalism or related field
JavaSpring BootRole Objectives
-
Participate in complex design and software development tasks within an appropriate schedule, task, and quality guidelines set in conjunction with the Senior Platform Specialists and Platform Architect
-
Hands-on development and implementation of solutions including configuration of our platform components and custom development
-
Tasks associated with testing and documentation of solution implemented
Academic Qualification
B.E/B.Tech/MCA in computer science Engineering or a related field.
Experience Profile
4 to 10 years of experience in development or platform implementations.
Required Technical Skillset for Java Development
Java/J2EE, HTML, CSS. JavaScript, SQL, Servlets, Spring Boot, Hibernate, Web services, SOAP, Restful API
Good to have:
Knowledge in Liferay themes & hooks, Ant, Maven, CI/CD, AWS/GCP/Azure, Docker experience
Must be capable of coding and unit testing their own code
Team player with good interpersonal skills
Should have strong analytical skills
Good communication skills
Capable of juggling several priorities and delivering results on time in a high-pressure, dynamic environment.
React.js
React Native
Javascript
HTML/CSS
Vue.jsJob Description
Role:- Software engineer - front end
About the company:-We are a social learning platform that allows us to learn the way we learn best. If our children are going to learn online we will have to make it social. That’s how learning happens best. We think we’re amongst the first few companies in the world trying to push the boundaries of edtech to a new era of highly social & community driven learning.
Responsibilities:-
You will be responsible for taking end-to-end ownership of the development of beautiful, fast, and responsive mobile and web applications. You will have attention to detail. You will care about the quality of code, design patterns and testability. You will be working closely with designers, product managers and engineers to build products that will delight our educators, students and parents.
HTML, CSS and JavaScript ninja
Patient debugging skills
Using state of the art developer toolkit
React JS / React Native / Vue.js
Curiosity to remain updated with the newest technologies and frameworks
project.
• Deploying required database assets on production (DDL, DML)
• Good understanding of MySQL Replication (Master-slave, Master-Master, GTID-based)
• Understanding of MySQL partitioning.
• A better understanding of MySQL logs and Configuration.
• Ways to schedule backup and restoration.
• Good understanding of MySQL versions and their features.
• Good understanding of InnoDB-Engine.
• Exploring ways to optimize the current environment and also lay a good platform for new
projects.
• Able to understand and resolve any database related production outages
JavaPython
Ruby
Ruby on Rails (ROR)
Go Programming (Golang)Top Skills:
You write high-quality, maintainable, and robust code, often in Java/C#/Python/C++/Go/Ruby on Rails.
You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.
You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.
Roles & Responsibilities:
You solve problems at their root, stepping back to understand the broader context.
You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.
You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.
You recognize and use design patterns to solve business problems.
You understand how operating systems work, perform and scale.
You continually align your work with Amazon’s business objectives and seek to deliver business value.
You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.
You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.
You communicate clearly with your team and with other groups and listen effectively.
Skills & Experience:
Bachelors or Masters in Computer Science or relevant technical field with 3+ years of experience in Design and Development
Experience in software development and full product life-cycle.
Excellent programming skills in any object-oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.
Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.
Proficiency in SQL and data modeling.
Location: Hyderabad/Bangalore
CTC - no bar
Python
C#- We need people with Test complete + Python.
- It's well and good to have Test Complete knowledge but Python knowledge is mandatory.
- C# is good to have too.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon