Cutshort logo
Technoidentity logo
PostgreSQL Expert
PostgreSQL Expert
Technoidentity's logo

PostgreSQL Expert

Human Resources's profile picture
Posted by Human Resources
5 - 15 yrs
Best in industry
Hyderabad
Skills
skill iconPostgreSQL

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. 


Read more
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos

About Technoidentity

Founded :
2011
Type :
Products & Services
Size :
100-1000
Stage :
Profitable

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.

Read more

Tech stack

skill iconJava
skill iconReact.js
skill iconPython
Generative AI
Data engineering
skill iconScala
Clojure

Company social profiles

bloglinkedintwitter

Similar jobs

Semi Stealth Mode startup in Gurgaon
Semi Stealth Mode startup in Gurgaon
Agency job
via Qrata by Blessy Fernandes
Gurugram
3 - 5 yrs
₹20L - ₹26L / yr
User Interface (UI) Design

We are a Delhi NCR-based Applied AI and consumer Tech company tackling one of the largest unsolved consumer internet problems of our time. We are a motley crew of smart, passionate, and nice people who believe you can build a high-performing company with a culture of respect aka a sports team with a heart aka a caring meritocracy. Our illustrious angels include unicorn founders, serial entrepreneurs with exits, tech & consumer industry stalwarts and investment professionals/bankers


Responsibilities:

  • Own end-to-end design of the consumer app as we try to reinvent an exciting category from first principles, working closely with the Founders and Engineers
  • Additional opportunity to work on brand & marketing design across the product lifecycle


Requirements:

  • 2-4 years of UI/UX design experience for a consumer app (academic projects not counted).
  • Strong communication and interpersonal skills. Degree in Design a bonus.
Read more
Kitty Technologies Pvt Ltd
Nagercoil
0 - 1 yrs
₹2L - ₹2L / yr
English Proficiency

Job Description:


  • This is BPO Night shift job (US Voice process) in Nagercoil.


  • This is purely night shift with fix saturday sunday off .


  • This is not sales or tele marketing, it is to help the US citizens .


  • It is work from office only. with salary range 15000 to 25000 per month along with unlimited incentives based on leads that you generate.(per lead you get Rs 500)


Responsibilities:


  • Handle outbound calls to international customers.


  • This is US Government project that you will be working on where you get the details of customers and complete the further process.


  • Maintain accurate and detailed records of customer interactions and transactions.


  • Collaborate with team members to achieve individual and team goals.


  • Strive to achieve customer satisfaction and ensure positive feedback.


Requirements:


  • Freshers and Experienced both can apply.


  • Excellent communication skills / Fluency in English.


  • Ensure Timely& Professional Responses to all queries.


  • Strong ability to multitask and take fast decisions independently.


  • Night shift only.(7.30 PM to 4.30 AM.)


Benefits:


  • Competitive salary + incentives.


  • After shift Drop facility for females only.


  • ESI, PF, and insurance benefits
Read more
Club Mahindra
Club Mahindra
Agency job
via Prathigna HR Solutions by Akshay KC
Kochi (Cochin)
1 - 4 yrs
₹3L - ₹4.5L / yr
Sales
Sales strategy
Business Development
Communication Skills
Effective communication

Sales Officer Responsibilities:


  • Calling potential customers to explain company products and encourage purchases.
  • Answering customers' questions and escalating complex issues to the relevant departments as needed.
  • Developing in-depth knowledge of company products.
  • Maintaining an accurate record of all sales, scheduled customer appointments, and customer complaints.
  • Collaborating with the marketing department to ensure that the company is reaching its target audience.
  • Informing product developers of possible product improvements and changes to ensure that company products meet current market needs.
  • Preparing cost-benefit analyses for prospective and existing customers to determine the most suitable purchase options.
  • Analyzing competitors' products to determine product features, benefits, shortfalls, and market success.
Read more
Zupee
at Zupee
8 recruiters
Simran Taneja
Posted by Simran Taneja
Remote only
1 - 5 yrs
₹12L - ₹15L / yr
Test Automation (QA)
SDET
Selenium
Automation
RESTful APIs
+8 more
About Zupee:
Zupee is India’s fastest growing innovator in online gaming with a focus on skill-based games on the mobile platforms. Started by 2 IIT-K alumni in 2018, we are backed by marquee global investors such as WestCap Group, Tomales Bay Capital, Matrix Partners, Falcon Edge, Orios Ventures & Smile Group with an aspiration to become the most trusted and responsible entertainment company in the world.
To know more about our recent funding coverage: https://bit.ly/3AHmSL3
Our focus has been on innovating in the board, strategy, and casual games sub-genres. We innovate to ensure our games provide an intersection between skill and entertainment, enabling our users to earn while they play.
  • Role:- SDET 2
  • A Software Engineer Test (SDET) at Zupee is a master of all. It combines the "building" aspect of software engineering with the "breaking" aspect of software test engineering. You’ll be writing code that automatically verifies the quality of the product.
  • Reporting Managers:- SDET Lead
  • Location:- Agnostic/Work from anywhere

Roles and Responsibilities:-
  • Experience in Manual Testing & Automation - UI and Functionality.
  • Experience in Database using any ETL tool.
  • Good knowledge in writing SQL Queries and understanding of Complex SQL Queries.
  • Experience in Functionality, Compatibility, Integration and Regression Testing.
  • Experience in preparing Test scenarios and writing Test cases for UI, Functionality, API and Database testing.
  • Hands Experience in ,white box testing, Test Case execution, result generation, status reporting and Defect reporting, Regression Testing, JIRA
  • Experience in API testing using POSTMAN or any REST API testing tool.
  • Good knowledge on any automation tool and Framework
  • Technical Documentation - Test case, Test Plan, Matrixes and Reporting.
  •  
What Are we looking for?
  • Has the ability to think clearly, analyse quantitatively, communicate coherently, organize effectively, prioritize and ideate.
  • They have metric-driven, fast paced, attentive to detail, data-driven and
  • self-motivated.
  • Has analytical, creative, curious, a problem solver and can influence stakeholders
  • Good analytical, reasoning and problem-solving skills required
  • Good communication skills - both verbal and written
Passionate about Quality and Automation

Qualifications and Skills

  • Experience in Java/Python programming (testing area)
  • 1-4.5 Years of experience with acumen for Automation Testing
  • Experience in back end testing (ETL, API, Services, Data Center Automation etc)
  • Experience in Frontend and/or RPA testing (Selenium, Robot Framework)
  • Experience in designing and managing test suites for aforementioned use cases
  • Experience in testing Android/iOS apps and performing ui automation for either is a plus
  • Prior experience in using tools like Testrail, jira and confluence is a plus
  • Good analytical, reasoning and problem solving skills required.
  • Work well in a collaborative, team based environment (both work autonomously and as part of a team)
Read more
Our Client company is into Computer Software. (EC1)
Our Client company is into Computer Software. (EC1)
Agency job
via Multi Recruit by Fiona RKS
Bengaluru (Bangalore)
3 - 5 yrs
₹12L - ₹15L / yr
ETL
Snowflake
snow flake
Data engineering
SQL
+1 more
  • Create and maintain optimal data pipeline architecture
  • Assemble large, complex data sets that meet functional / non-functional business requirements.
  • Author data services using a variety of programming languages
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Snowflake Cloud Datawarehouse as well as SQL and Azure ‘big data’ technologies
  • Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
  • Keep our data separated and secure across national boundaries through multiple data centers and Azure regions.
  • Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
  • Work with data and analytics experts to strive for greater functionality in our data systems.
  • Work in an Agile environment with Scrum teams.
  • Ensure data quality and help in achieving data governance.

Basic Qualifications

  • 3+ years of experience in a Data Engineer or Software Engineer role
  • Undergraduate degree required (Graduate degree preferred) in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
  • Experience using the following software/tools:
  • Experience with “Snowflake Cloud Datawarehouse”
  • Experience with Azure cloud services: ADLS, ADF, ADLA, AAS
  • Experience with data pipeline and workflow management tools
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
  • Understanding of Datawarehouse (DWH) systems, and migration from DWH to data lakes/Snowflake
  • Understanding of ELT and ETL patterns and when to use each. Understanding of data models and transforming data into the models
  • Strong analytic skills related to working with unstructured datasets
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management
  • Experience supporting and working with cross-functional teams in a dynamic environment.
Read more
Salesken.ai
at Salesken.ai
2 recruiters
akash r
Posted by akash r
Bengaluru (Bangalore)
6 - 12 yrs
₹40L - ₹65L / yr
skill iconJava
Data Structures
Algorithms
SQL
Microservices
+1 more


1. Be a visible leader to drive and own the architecture and design of some of the most advanced & complex software systems / products in the industry to create company wide impact
2. Design systems that can scale to billions of data records in micro service architecture
3. Design and develop full stack product features based on customer and business requirements
4. Be an operational and technical leader with a passion for distributed systems, cloud service development, deployment and delivery
5. Technically Hands-on with scalable Architecture managing team of (30+) Sr. Engineers / Engineers, and coaching mentoring while maintaining a hands-on role with code development
6. Drive code and design reviews of components / systems / products in scope and drives the architectural governance for them
7. Set directional paths for the teams/department for adoption of new technology stacks for solving business problems
8. Be a very visible representative of multiple technology domains and represent Salesken in external technical forums
9. Teamwork skills, flexibility, and ability to handle multiple tasks
10. Bring in software engineering life cycle best practice
11. Analytical and problem-solving skills

Desired Candidate Profile
1. Strong Java, Java 8 including OOAD design patterns
2. A solid engineer with must have knowledge and experience of Micro services design, security designs, and best practices
3. Excellent knowledge and skills in the areas of Java, Spring Boot, JSP/Servlet, J2EE design patterns, App server & Web servers
4. Strong hands-on technology experience building and running large scale systems handling multi-million sessions/transactions per day
5. Excellent knowledge of RDBMS, NoSQL databases like MySQL and Cassandra
6. Strong design/development experience in building massively large scale distributed internet systems and products
7. Excellent programming skills in Java and expertise in multi-threading and performance oriented programming
8. Sound knowledge of cloud platforms like GCP, AWS, Azure, etc
9. Solid experience in Distributed systems, highly scalable products, performance & reliability
10. Excellent understanding of processing platforms and queues
11. Excellent understanding of standard protocols such as HTTP/HTTPS, DNS, SSL, etc
12. Experience and knowledge of open source software, frameworks and broader cutting edge technologies around server side development in Java
Read more
Trilingual Kids Academy
Sha K
Posted by Sha K
Remote only
0 - 1 yrs
₹3000 - ₹5000 / mo
Digital Marketing
Google Adwords
Web Analytics
skill iconGoogle Analytics
Facebook Marketing
+1 more

Digital Marketing Job Responsibilities:

  • Plans and executes all web, SEO/SEM, database marketing, email, social media, and display advertising campaigns.
  • Designs, builds, and maintains our social media presence.
  • Measures and reports performance of all digital marketing campaigns and assesses against goals (ROI and KPIs).
  • Identifies trends and insights and optimizes spend and performance based on the insights.
  • Brainstorms new and creative growth strategies through digital marketing.
  • Plans, executes, and measures experiments and conversion tests.
  • Collaborates with internal teams to create landing pages and optimize user experience.
  • Utilizes strong analytical ability to evaluate end-to-end customer experience across multiple channels and customer touch points.
  • Identifies critical conversion points and drop off points and optimizes user funnels.
  • Collaborates with agencies and other vendor partners.
  • Evaluates emerging technologies.
  • Provides thought leadership and perspective for adoption where appropriate.

 

Digital Marketing Qualifications / Skills:

  • Creating and maintaining client relationships
  • Self-motivated yet customer-focused
  • Proficient in marketing research and statistical analysis
  • Highly creative with experience in identifying target audiences and devising digital campaigns that engage, inform, and motivate

Education, Experience, and Licensing Requirements:

  • Bachelor’s or master’s degree in marketing or a related field
  • Proven working experience in digital marketing, particularly within the industry
  • Demonstrable experience leading and managing SEO/SEM, marketing database, email, social media and/or display advertising campaigns
  • Experience in optimizing landing pages and user funnels
  • Experience with A/B and multivariate experiments
  • Solid knowledge of website and marketing analytics tools (e.g., Google Analytics, NetInsight, Omniture, WebTrends, SEMRush, etc.)
  • Working knowledge of ad serving tools
  • Experience in setting up and optimizing PPC campaigns on all major search engines
  • Working knowledge of HTML, CSS, and JavaScript development and constraints

 

Read more
G.B. Pvt. Ltd.
at G.B. Pvt. Ltd.
1 recruiter
Gunsai Baba Pvt ltd
Posted by Gunsai Baba Pvt ltd
Jaipur
3 - 9 yrs
₹5.5L - ₹8.4L / yr
skill iconPython
skill iconDjango
skill iconProgramming
Software Development
We are hiring Python Developer- Bot creating experience + Cookie generation + bot protection bypasses.

Qualification -

a. Minimum Bachelor's Degree

b. Minimum 3 yr experience

c. Basic English Proficiency

d. International Clients

Location: Jaipur
Interview will be online on Skype/Zoom.
Read more
Azine Technologies
at Azine Technologies
3 recruiters
Divya Gohil
Posted by Divya Gohil
Ahmedabad
3 - 7 yrs
₹2L - ₹5L / yr
Wordpress
Content Management System (CMS)
skill iconHTML/CSS
skill iconSASS
skill iconBootstrap
+13 more
Job Summary
Design themes using HTML, CSS/SASS, Bootstrap, and WordPress.
Maintain existing WordPress client sites.
QA sites during staging and after deployment.
Create clean, DRY, and reusable code.
Keep yourself and the team up to date with JIRA kanban flow work boards.
Work with Lead and junior developers as a team from start to finish.
Responsibilities and Duties
Fluency with WordPress, PHP, MySQL, HTML5, CSS/SASS, and Frameworks with Responsive design.
PHP frameworks knowledge and MVC understanding
Skilled working with vanilla JavaScript, jQuery, and other JavaScript libraries (Angular or React)
Knowledge of version control (GIT).
Attend meetings with in-house account managers and project leads to discuss technical requirements, timeframes, mockups/wireframes and scope of work.
Working both independently and with other developers.
Ability to work on multiple projects at the same time.
Adhering to best practices, comments in code, and documentation.
2+ year of experience with WordPress and PHP.
Willingness to learn Advance WP CMS and Liquid templating for custom theme development.
Experience building custom themes, plugins, and widgets.
Experience working with third-party APIs - SOAP, REST and other (Facebook and Twitter).
Required Experience and Qualifications
Key Skills
Strong knowledge of web performance optimization, caching. Experience working with WP Engine Server Environment. Benefits Additional Notes We are offering amazing career growth opportunities, great compensation, and benefits. This begins with: - weekly lunches, alternate weekends-off, annual medical checkups, social engagement, financial assistance and more.
Required Experience and Qualifications
3 to 4 Years of working experience in WordPress is required.
Benefits
Perks, Benefits & Culture:
We are offering amazing career growth opportunities, great compensation, and benefits. This begins with -
- weekly lunches
- alternate weekends-off
- Half-day working Saturdays
- annual medical checkups
- Social engagement
- financial assistance
- Diwali Bonuses
- and more...
Read more
Accedo
at Accedo
4 recruiters
Aditya Puthran
Posted by Aditya Puthran
NCR (Delhi | Gurgaon | Noida)
8 - 13 yrs
₹28L - ₹33L / yr
Engineering Management
Mobile App Development
Web Development
skill iconAmazon Web Services (AWS)
Job Purpose: The role of Engineering Manager is focused on driving Customer solutions and delivering technical excellence through close engagement with Customers, Suppliers and cross-functional teams within Accedo. As a senior technical authority you will be responsible for leading tier-1 Customer engagements in Asia, with a strong focus on the domestic OTT market in India. You will also be responsible for leading Accedo Engineering Teams and collaborating closely with other global Engineering Directors to define and shape engineering practices/tools used across the business. Key Responsibilities: - Senior technical authority on key customer projects; responsible for architecting and leading the implementation of complex technical solutions through direct customer/supplier engagement and close collaboration with Accedo delivery teams. - Technology focus will be largely centered on Accedo Solutions for Web, Smart TV, Mobile, Games Consoles and other Connected Devices; with exposure to both front and back end technologies. Some crossover between platforms and solution areas can be expected - Customer focus will be largely centered on Professional Services engagements in India; however it’s anticipated there will also be opportunities to lead/contribute to projects in other Accedo regions - Direct management of local engineering teams; providing technical leadership and direction at project level and professional development/mentorship in a line management capacity - Responsible for driving Technical Assurance activities on Customer engagements; ensuring Accedo developers adhere to engineering best practices and the application of approved technologies/toolsets - Working closely with Accedo Engineering Directors at a global level to standardise and continuously improve engineering practices and tools used by Accedo delivery teams. - Supporting Regional Sales Opportunities, participating in Customer/Supplier workshops, providing solution design insights, technical risk/dependency management, estimations etc. Role Requirements: - Solid engineering background with at least 7+ years hands-on experience architecting and building scalable OTT solutions for mobile and web - Proven expertise in some or all of the following technologies: JavaScript, HTML5, CSS3, AJAX, JSON, MySQL, Java, Objective-C - Excellent working knowledge of Android/iOS SDK, Eclipse/Xcode and modern Developer Tools, with experience integrating open source or 3rd party API’s and libraries - Experience designing and building complex middleware solutions using PHP, Java or Node.js - Good understanding of Global Content Delivery Networks, Video Encoding, DRM Technologies, Ad-Integration, Analytics Solutions etc. - Practical experience working in Agile environments with exposure to Continuous Integration and Test Driven Development - Strong quality focus from a UI, Functional and Performance perspective with proven experience building and testing scalable solutions - Excellent technical solution design and documentation skills with a good understanding of UML and related tools - Exemplary English communication and facilitation skills, with the ability to lead Customer/Partner meetings and workshops at an international level - Degree in Computer Science, Software Engineering, IT or related discipline - Moderate travel (20-30%) throughout India/Asia can be expected.
Read more
Why apply to jobs via Cutshort
people_solving_puzzle
Personalized job matches
Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.
people_verifying_people
Verified hiring teams
See actual hiring teams, find common social connections or connect with them directly.
ai_chip
Move faster with AI
We use AI to get you faster responses, recommendations and unmatched user experience.
Did not find a job you were looking for?
icon
Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.
companies logo
companies logo
companies logo
companies logo
companies logo
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos