PostgreSQLAt 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.
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
Responsibilities:
- Design, implement, and maintain scalable and reliable database solutions on the AWS platform.
- Architect, deploy, and optimize DynamoDB databases for performance, scalability, and cost-efficiency.
- Configure and manage AWS OpenSearch (formerly Amazon Elasticsearch Service) clusters for real-time search and analytics capabilities.
- Design and implement data processing and analytics solutions using AWS EMR (Elastic MapReduce) for large-scale data processing tasks.
- Collaborate with cross-functional teams to gather requirements, design database solutions, and implement best practices.
- Perform performance tuning, monitoring, and troubleshooting of database systems to ensure high availability and performance.
- Develop and maintain documentation, including architecture diagrams, configurations, and operational procedures.
- Stay current with the latest AWS services, database technologies, and industry trends to provide recommendations for continuous improvement.
- Participate in the evaluation and selection of new technologies, tools, and frameworks to enhance database capabilities.
- Provide guidance and mentorship to junior team members, fostering knowledge sharing and skill development.
Requirements:
- Bachelor’s degree in computer science, Information Technology, or related field.
- Proven experience as an AWS Architect or similar role, with a focus on database technologies.
- Hands-on experience designing, implementing, and optimizing DynamoDB databases in production environments.
- In-depth knowledge of AWS OpenSearch (Elasticsearch) and experience configuring and managing clusters for search and analytics use cases.
- Proficiency in working with AWS EMR (Elastic MapReduce) for big data processing and analytics.
- Strong understanding of database concepts, data modelling, indexing, and query optimization.
- Experience with AWS services such as S3, EC2, RDS, Redshift, Lambda, and CloudFormation.
- Excellent problem-solving skills and the ability to troubleshoot complex database issues.
- Solid understanding of cloud security best practices and experience implementing security controls in AWS environments.
- Strong communication and collaboration skills with the ability to work effectively in a team environment.
- AWS certifications such as AWS Certified Solutions Architect, AWS Certified Database - Specialty, or equivalent certifications are a plus.
This position is contractual. The appointment will be for a period of one year. Interested candidates should fill-up a Google Form within 30th July, 2024 (midnight) with the Link: https://forms.gle/VifhWi6yGZxbmUsN7
Job responsibilities:
i) Develop and implement communication and public engagement strategies that align with the institution's goals and objectives and promote the institution's work and impact.
ii) Conduct regular analysis and reporting on the effectiveness of communication and public engagement strategies and adjust them as needed
iii) Assist with other administrative tasks as and when needed
Business development ex/sales/ops
Vacancy - 1
Looking for a dynamic person who can be committed to the growth of the startup.
- Should be comfortable in handling varied responsibilities of business development, sales and operations
- Willing to travel to Mumbai n Goa need basis.
- fluent in English
- Should be able to drive car.
- Photography would be a big plus.
Salary - Prove yourself and we'll pay more than market is our promise.
Google Analytics
HTML/CSSJob Description : SEO executive (4-5 years of exp)
We are looking for someone who has -
- Deep knowledge of offpage and preferably good knowledge of onpage
- Worked on increasing rankings, traffic, content marketing.
- Experience when it comes to using tools such as Google Analytics and Google Webmaster.
- Excellent time management skills.
- Solid knowledge of Backlinks
- Experience in HTML coding and JavaScript.
- Understanding of what works for and against Google’s algorithms.
- Keeps upgrading knowledge.
- Experience in using tools like Ahrefs, SEMrush and others
- Good communication skills.
Our client is an Innovative B2B Saas company which focuses on integrating technology into solving regulatory compliance, privacy, cyber security and financial issues management. Founded in 2009, as a technology service provider, it aimed to specialize in digitalizing and transforming the enterprise systems, data and processes of professional service companies by providing in depth computer system design and related services.
Revenue earned by the client as on 2020 is $13.6 Mn and also has partnered with almost 50% of top 20 companies. They have been showing a significant growth of over 30% in the last few years.Their client base has over 300+ customers and 3 lakhs + users comprising big 4s and major Companies worldwide.
They are located in Chicago, London, Mumbai, Pristina and Philadelphia.
As a Clojure Developer, you will be responsible for enhancing and maintaining our flagship product. You will work in all areas of our stack, which includes working on the Clojure web server, backend data processing services, web front-end, Go components, as well as our platform API.
What you will do:
- Developing new features, troubleshooting and improving existing ones, and participating in tech debt efforts that aim to improve the product as well as the development experience
- Writing automated tests to ensure your code functions as desired
- Working closely with our design team in our design driven development style, helping our designers dream up solutions to user problems that astonish and delight
- Helping improve your and others' code during code review
Desired Candidate Profile
What you need to have:- Demonstrated software development experience preferably with a functional language. Bonus if you already know Clojure or Go
- Full-stack development experience, possibly with a bias towards either front-end or backend development
- Knowledge in React and Javascript
- Unit testing experience
- Prior experience in RESTful API use, implementation, or design
- Experience with a relational data store, PostgreSQL is a bonus
Laravel
CakePHP
CodeIgniter
.NET
C#· Job Title:- MS Dot Net MVC Develop
· Job Location:- CG Road, Ahmedabad
· Experience:- 3 to 8 Years
· Number of Vacancy:- 03
The DotNet Developer will help to produce scalable software solutions. This person will be part of a cross-functional team that is responsible for the full software development life cycle, from conception to deployment - participating in the design and creation of scalable software, writing clean functional code, testing and fixing bugs or other coding issues. This person should be comfortable with DotNet, development frameworks and third-party libraries. This developer should also be a team player, as the role is responsible for interacting with users to define system requirements and/or necessary modifications in an Agile/Scrum environment followed by development and delivery of committed features.
Mandatory Skills Competencies:
· Ability to communicate effectively with clients and teams.
· Strong Team Player and ability to lead, guide, mentor, review track progress of team members.
· Good interpersonal skill
· Proven troubleshooting and debugging skills
· Strong knowledge of OOPs and Design Pattern
· Strong technical experience with .NET framework (4.0/4.5), C#, WEB API, http://asp.net/" target="_blank">ASP.NET MVC, JavaScript
· Sound understanding of Database concepts experienced with SQL SERVER
· Knowledge of Angular/React JS, Redux, Node JS, TypeScript, ES6 and Object-oriented JAVASCRIPT will be an added advantage
· Knowledge of HTML5 and CSS3
· Knowledge of any message queuing software (MSMQ, RabbitMQ)
· Knowledge of writing secure code (OWASP Guidelines)
· Experience with .NET CORE, Azure, docker and Kubernetes
· Understanding of Code Optimization techniques, Code coverage tool and code analysis tool
· Involved in analysis, design, development, unit testing and maintenance of detailed software modules
· Awareness with any of revision control systems like Git/SVN/TFS/VSS etc
NodeJS (Node.js)
NextJs (Next.js)
JavascriptRoles , Responsibilities& Skills :-
- Proficiency in js, deep knowledge of SQL and NoSQL databases.
- Knowledge of ElasticSearch is a plus.
- Design, build and maintain high performance, reusable system applying best Engineering practices.
- Experience in building and consuming REST API.
- Work with Agile methodology
- Go getter attitude with delivery mindset.
- Strong communication skills across the board, with a passion for finding and sharing best practices and driving greater discipline.
- Team player
- Ability to multi-task and work in fast paced environment
- Quality focus.
UI experience
- Angular Version 7+ or React experience
- Knowledge of CSS/design frameworks
- Ability to coordinate and implement UX designs.
React.jsNodeJS (Node.js)
MongoDB
Expresshaving built a few of India's largest companies across multiple domains. This will be an opportunity to directly work with the founders. What we are looking for: An entrepreneurial, thoughtful, and positive mindset/approach to solving large problems, capable of adapting to changing market conditions, willing to join a growing startup, a rational and no-nonsense approach, and practical thought process.
Full-stack experience designing and building scalable applications from end-to-end
- Excellent JavaScript skills and strong proficiency in React
- Familiarity with the MERN stack (MongoDB, Express.JS, React.JS, and Node.JS)
- Working experience with React, Redux, ES6
- Experience building backend API's using NodeJs and ExpressJs
- Experience with NoSQL databases such as MongoDB, mongoose, aggregation framework
and Redis
- Experience with Web sockets and related frameworks (e.g. Socket.IO)
- Experience using RESTful APIs and basic authentication mechanisms
- Create and maintain microservices
- Ability Showcase past work via live web pages
Required Skills: Database - MongoDB, Restful, Express.JS, React.JS and Node.JS, MySQL,
NoSQL.
Leadership
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon