PostgreSQL Expert at Technoidentity · Hyderabad · 5 - 15 years · Profitable · Posted 6 May 2026
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 (10)
Job Overview
As an SDR at Awign, you will play a key role in driving new business across the Indian market. You will work closely with the Sales teams to identify the right accounts, generate interest, and convert early signals into qualified sales opportunities.
You will engage with decision-makers across multiple industries where Awign enables large-scale workforce deployment, last-mile execution, and on-ground operations. This role is ideal for someone who enjoys outbound sales, cold calling, and building pipelines from scratch.
Key Responsibilities
- Be the first point of contact for prospective customers across India
- Research and build target account lists across multiple Indian industries
- Identify decision-makers and influencers and map buying committees
- Run outbound campaigns using email, LinkedIn, and cold calling
- Make high-volume, high-quality cold calls to start sales conversations
- Qualify inbound and outbound leads through structured discovery calls
- Book meetings and hand off qualified opportunities to Regional Sales Managers with clear context
- Clearly communicate Awign's value proposition based on industry-specific use cases
- Track outreach performance and improve scripts, sequences, and call pitches
- Maintain clean CRM records and accurate pipeline data in Zoho CRM
- Work closely with Marketing and Sales to run account-based and vertical-focused campaigns
Expected Outcomes
- Consistent generation of qualified meetings and sales opportunities
- Strong understanding of Indian buyer behavior and sales cycles
- High-quality opportunity handoffs with clear qualification notes
- Continuous improvement in conversion rates channels
Ideal Candidate Profile
- 3+ years of experience in SDR, Inside Sales, Tele-sales, or Business Development roles
- Hands-on experience selling into the Indian B2B market
- Strong comfort with cold calling and outbound prospecting
- Prior experience in B2B SaaS, staffing, workforce management, or services-led sales is a plus
- Ability to handle objections and maintain high energy across daily outreach
PRINCIPAL RESPONSIBILITIES :
1. Inbound/Outbound Call Handling
2. Email/Ticket Handling
3. Escalation Handling
4 Data handling/managing
CRITICAL SKILLS REQUIRED :
1. Good listening skills
2. Good problem solving skills
3. Good English written skills
4. Good learning abilities
5. Good spoken English/Hindi skills
Good MS Excel & MS Word skills
AngularJS (1.x)
Angular (2+)React.js
NodeJS (Node.js)This is a full-time on-site role for a Full Stack Developer at Arahas in Gurugram. As a Full Stack Developer, you will be responsible for both front-end and back-end web development, software development, and utilizing cascading style sheets (CSS).
·. The candidate should have a minimum of 5 years of experience in developing robust, scalable web applications.
Immediate joiners are preferred .
Key Skills:
• 5+ years of experience with Angular 2+, Node.js, and MongoDB
• Strong knowledge of front-end technologies (HTML5, CSS3, JavaScript)
Responsibilities:
• Develop and maintain full-stack web applications
• Collaborate with cross-functional teams to deliver high-quality solutions
• Write clean, scalable, and maintainable code
• Troubleshoot and optimize application performance
Company Profile :-
Arahas excels in delivering sustainable solutions to diverse sectors, including Telecom, Defense, Land Management, Smart & Sustainable City, Utilities, Municipal Services, Environment, Infrastructure & Real-estate, Forest Management, Logistics & Distribution, Public Safety, Wildlife, Water & Rainfall, Emergency and Disaster Management.
Backed by marquee climate investors like NIIF, Arahas is at the forefront of India's green economy transition. Arahas has seen impressive growth, now working with 30+ clients across urban development, agriculture, disaster response, and ESG performance management. With 110+ professionals delivering solutions from 5+ delivery centers, Arahas combines human expertise and digital capabilities into innovative offerings across 15+ product and service lines.
C#- Proficiency in Unity3D and C# programming language.
- Strong understanding of unity 3d and 2d principles and best practices.
- Familiarity with version control systems such as Git.
- Excellent problem-solving and communication skills.
- Ability to work effectively in a collaborative team environment.
- Familiarity with VR/XR/AR hardware and platforms, including Oculus, HTC Vive, HoloLens, and ARKit/ARCore.
- Excellent problem-solving skills and ability to adapt to evolving technologies and project requirements.
Review, update and maintain the company's SOPs along with ensuring proper documentation.
Help with employee engagement activities.
Assist the HR team in facilitating internal branding.
Our client is among the rare success stories of Indian tech companies that are publicly listed. They are a pioneer in the adtech space and have built up market leadership at the global level serving fast growing digital native companies with the ability to do better audience targeting and get more ROI on their ad spends.
As a Data Operations (CPS), you will be responsible for overall coordination so as to manage end to end ad campaign delivery. You will also be responsible for interaction with all publishers that the company works with and managing ongoing relationships with them.
What you will do:
- Being responsible for the CPS affiliate channel, disbursement of offers, quality of delivery, margin management, and channel expansion
- Maximization of campaign deliveries in terms of ROI as well as absolute volume while maintaining the required margin targets
- Identifying new affiliates
- Growing business from existing affiliates
- Being responsible for the overall health of all campaigns, managing sales team/client expectations, coordination with the technical operations teams for required integrations between advertisers/clients and meeting margin targets
Desired Candidate Profile
What you need to have:- Graduation/ Post graduation in any discipline from a reputed institution
- 3+ years’ experience in the digital advertising domain, with CPS experience
- Record of working with cross functional teams and external partners
- Ability to multitask in a high pressure environment
- Basic finance understanding to manage the overall revenue and cost reconciliation
- A mindset of troubleshooting/ problem solving as required
- Maniacal attention to detail and very strict adherence to timelines
We are looking for ambitious and dynamic professionals, who have skills in driving presales activities, client servicing and client relationship building.
Industry Type: IT Software
Experience: 1-3 yrs.
Profile: IT Presales & Marketing
Job Type: Full Time
Location: Indore (MP)
Responsibilities
We are looking for smart working, high output individuals who want to grow fast and work with PROCESS MASTER in Presales and Marketing field. The role will require performing on all key pre- sales activities including:
- Responsible for generating sales with existing customers and developing opportunities with new customers
- Cold calling (International/Domestic) and to assist the team members to generate & follow up leads
- Prepares reports by collecting, analyzing, and summarizing information
- Maintaining and updating customer databases in our CRM related to sales
- Tracking the status of business opportunity
- Draft proposal strategy, proposal writing and create sales presentations to be submitted to customers
- Draft RPF and RFQ according to customer requirements
- Responsible for working on CRM from Presales standpoint
Mandatory Requirements
Qualifications:
- Any graduate/Post Graduate may apply with consistently good academic record =>60% throughout
- B Tech with MBA background candidates will be given slight preference
Skills and Knowledge:
- Excellent presentation skills with ability to lead & manage discussion
- Strong people-networking and influencing skills
- Advanced skills in MS-Excel, PowerPoint, MS Word
- Self-learner with abreast on the latest in technology, competition and the industry landscape
- Excellent organizational skills to help keep track of all sales leads.
- Ability to analyze, learn, anticipate, identify and resolve problems and make logical decisions
Competencies:
- Excellent Communication (Verbal and written Concise & detailed)
- Ability to work in a dynamic set-up with a never-say-die attitude
- Good interpersonal and Analytical skills
- Ability to work under strong pressure of deadlines
- No travel required except travelling in MP Region
Adobe Illustrator- Be creative, with a good eye for a picture
- Have excellent technical and Photographic and Video graphic skills.
- Have good communication and people skills.
- Have good IT skills, especially with computer programs such as Photoshop, Premier Pro etc.
- Ability to use different types of photographic equipment and photography software.
- Understanding of artificial and natural lighting and how it affects different settings, shapes and skin tones.
- A keen eye for detail and a well-developed artistic and creative aesthetic.
- Keeping up-to-date with technology and method in the industry.
- Good Software Knowledge of Adobe Photoshop, Adobe Lightroom.
- Bachelor’s degree in Photography related field.
- Experience as a Photographer in related field.
- Demonstrable Photographer
skills with a strong portfolio. - Proficiency with editing software- Photoshop, Premiere Pro, Lightroom.
- A strong eye for visual composition.
- Effective time management skills and the ability to meet deadlines.
- Able to give and receive constructive criticism.
- Take the brief to understand specifications and work closely with the team to develop the concept.
- Capture and process images and videos until the desired result is achieved.
- Constantly improve image and video quality using various editing methods.
- Use and maintain modern and traditional technical equipment (cameras, lenses, lights etc).
- Arrange objects, scenes, lighting and background to adhere to specifications.
- Archive photographic images, videos and maintain database.
- Maintain an in depth understanding of photographic and video graphic best practices and procedures.
- Carrying out research and preparation for a shoot.
- Working in different locations and circumstances to get the right images and videos.
- Using an extensive range of technical equipment, including cameras, lenses, lighting and specialist software.
- Communicating with photographic subjects, putting them at ease, encouraging them and directing them.
- Adjust apertures, shutter speeds, and camera focus based on a combination of factors such as lighting, field depth, subject motion, film type, and film speed.
- Estimate or measure light levels, distances, and numbers of exposures needed, using measuring devices and formulas.
- Create artificial light, using flashes and reflectors.
- Perform maintenance tasks necessary to keep equipment working properly.
PHP
LaravelPython
Django
Programming
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon