PostgreSQL Expert at Technoidentity · Hyderabad · 5 - 15 years · Profitable · Posted 6 May 2026

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 (10)

Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.
We are seeking an experienced Senior Database Developer to lead and support Oracle to PostgreSQL/Aurora PostgreSQL migration initiatives. The role involves deep hands-on work across SQL refactoring, schema conversion, DMS operations, performance tuning, and post–go-live stabilization. The candidate will work closely with application teams, cloud engineers, and stakeholders to ensure a smooth, performant, and compliant migration.
What you will do?
- Refactor and convert Oracle SQL, PL/SQL, and database objects to PostgreSQL-compatible SQL/PLpgSQL.
- Analyze and remediate AWS SCT (Schema Conversion Tool) findings and limitations.
- Manage and maintain Flyway migration codebase (versioned scripts, repeatable migrations, rollbacks).
- Identify, troubleshoot, and fix database-related application bugs.
- Perform query optimization for PostgreSQL (execution plans, indexing strategies, query rewrites).
- Support and monitor AWS DMS during full load and CDC phases.
- Diagnose and resolve DMS data and performance issues.
- Perform data validation and reconciliation between Oracle and PostgreSQL.
- Collaborate with application teams to align SQL behavior and performance expectations.
What are we looking for?
- Bachelor's degree in Computer Science or a related field.
- 5+ years of experience as an Oracle/PostgreSQL DBA and database developer.
- Strong experience with Oracle Database and PostgreSQL / Aurora PostgreSQL.
- Hands-on expertise in Oracle to PostgreSQL migration.
- Advanced SQL and query performance tuning skills.
- Experience with AWS SCT and AWS DMS.
- Knowledge of Flyway/Liquibase or similar schema migration tools.
- PostgreSQL internals: indexing, statistics, execution plans.
- AWS services: RDS/Aurora, CloudWatch, IAM (preferred).
You will be preferred if:
- Familiarity with automation and configuration management tools, such as Ansible, Chef, or Puppet.
- Familiarity with IAAC tools such as Terraform, CloudFormation.
- Familiarity with CI/CD implementation tools like Liquibase/Flyway.
- AWS Certified Database – Specialty.
- AWS Certified Solutions Architect.

Postgress Developer
Experience: 2 to 5 Years
Location: Chennai
Type: Contract
Duration : 6+ Months
Immediate joiners only
Roles & Responsibilities:
Hands-on experience writing efficient SQL queries, views, stored procedures, custom functions, indexing strategies.
Analyse execution plans, and triggers.
Ability to Identify and resolve blocking sessions, deadlock issues, slow queries, and database locks in high-concurrency environments.
PostgreSQL Developer – Chennai
Experience: 2–5 Years
Location: Chennai
Employment Type: Contract
Contract Duration: 6+ Months
Immediate Joiners Only
Payroll: Candidate's existing payroll will continue (Payroll stays with you).
Job Description
We are looking for an experienced PostgreSQL Developer with strong hands-on experience in SQL development, database optimization, and troubleshooting.
Roles & Responsibilities
- Write and optimize efficient SQL queries, views, stored procedures, and custom functions.
- Develop and implement indexing strategies for better database performance.
- Analyze SQL execution plans and optimize query performance.
- Work with database triggers and troubleshoot database-related issues.
- Identify and resolve blocking sessions, deadlocks, slow queries, and database locking issues.
- Handle high-concurrency database environments and ensure optimal performance.
Required Skills
- PostgreSQL
- Advanced SQL
- Stored Procedures & Functions
- Views & Triggers
- Indexing & Query Optimization
- Execution Plan Analysis
- Deadlock & Lock Management
- Performance Tuning
Interested candidates can share their updated resumes.
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
Role overview:
· Technology Expertise & DBA Skill Set
· Cloud Platforms: AWS, Azure
· Database IaaS: Oracle, Microsoft SQL Server, PostgreSQL
· Database PaaS: CosmosDB, MySQL, SQL Managed Instance, RDS Aurora, MongoDB
· Infrastructure as Code: Terraform, Ansible
· CI/CD & Automation: GitHub Actions, GitLab, Azure DevOps
· Programming & Scripting: Python, Bash/Shell, PowerShell
· Operating Systems: Linux/Unix (RHEL, Ubuntu), Window
Database Team Overview
Our Database Team is the foundation of enterprise-grade databases delivering secure, compliant and high-performing database platforms across Azure and AWS. We provide managed services for Oracle and Microsoft SQL Server, operating in a system DBA role to ensure platform reliability, resilience, and operational excellence. In addition, we support PaaS and RDS database services by acting as the platform team defining policies, enforcing security standards, and managing networking configurations while enabling self-service capabilities for application teams to consume these services efficiently.
What would you do here:
· Database Security & Compliance: Implement robust security controls, encryption, and auditing to safeguard sensitive data and meet regulatory requirements.
· Lifecycle Management: Oversee patching, upgrades, and end-of-life transitions to maintain platform stability and minimize risk.
· Performance Optimization: Monitor and tune databases for optimal performance across diverse workloads.
· Automation & Operational Excellence: Design and deploy automation for provisioning, monitoring, and maintenance to achieve “brilliant basics” and reduce manual intervention.
· Business-Critical Certification: Validate and certify database environments to support mission-critical applications with high availability and disaster recovery strategies.
· Incident & Problem Management: Provide rapid response and root-cause analysis for database-related incidents to ensure business continuity.
· Capacity Planning & Scalability: Forecast growth and optimize resources to support evolving business needs.
Best Regards!

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
Job Title: Senior Data Engineer
Position Summary
We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.
Key Responsibilities
- Design, develop, and maintain reporting infrastructure and data platforms.
- Build and optimize complex SQL queries, data models, and reporting datasets.
- Develop scalable ETL/ELT pipelines and data integration processes.
- Design and maintain database schemas to support analytics and reporting requirements.
- Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
- Implement data quality, governance, and performance best practices.
- Support and enhance enterprise reporting solutions and dashboards.
- Work with large-scale datasets in cloud data warehouse environments.
- Troubleshoot reporting issues and optimize database performance.
- Partner with engineering and product teams to establish sustainable data architecture.
Must Have: Technical Skills
- PostgreSQL
- Snowflake
- Advanced SQL
- Data Modeling
- Data Warehousing
- Reporting & Analytics Infrastructure
- ETL/ELT Development
- Query Performance Tuning
Success Profile:
The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.
Experience Range: 5-10 years
Role Type: Individual Contributor / Senior Engineer
Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.

Job Overview:
We are seeking an experienced Cloud Data Engineer to the architecture, development, Data migration, ETL pipeline in cloud and optimization of a next-generation data platform. This is a development role for an individual with over 4 years of deep data engineering and data migration, data pipeline in AWS expertise, capable of driving technical direction, and delivering high-impact solutions in a fast-paced
4+ Years of hands-on, progressive experience in Cloud Data Engineering, cloud ecosystems AWS, Data Architecture
• Deep conceptual understanding of core data engineering principles, ETL/ELT patterns, and metadata management
• Ability to translate complex business needs into actionable technical requirements.
• Strong troubleshooting and problem-solving skills in distributed systems.
• Agile/Scrum teamwork capabilities and version control practices
• Insurance industry experience preferred but not mandatory
• Tools:
o Cloud Environment: AWS (S3, IAM, VPC, Glue, Lambda etc.)
o Experience with dbt Core, Iceberg, AWS Glue Catalog, AWS lambda, Redshift, Athena, Splunk, AmazonQ, AWS streaming services, Git
o Strong SQL, Pyspark and Python

Job Description – Senior Database Architect (Couchbase)
Experience: 12+ Years
Location: Bangalore
Notice Period: Immediate Joiners Only
Employment Type: Full-Time
Job Summary
We are looking for a highly experienced Senior Database Architect with strong expertise in Couchbase and NoSQL database technologies. The ideal candidate will be responsible for designing enterprise-grade database architectures, driving database performance optimization, ensuring high availability, and providing technical leadership for large-scale, distributed database systems.
Key Responsibilities
- Design and implement scalable, highly available, and secure Couchbase database architectures for enterprise applications.
- Define database architecture strategies, data modeling standards, and best practices.
- Lead Couchbase cluster design, deployment, configuration, replication, and capacity planning.
- Optimize SQL++ (N1QL) queries, indexing strategies, data access patterns, and overall database performance.
- Architect disaster recovery, backup, restore, failover, and business continuity solutions.
- Troubleshoot complex database performance issues and conduct root-cause analysis.
- Lead database migration, modernization, and integration initiatives.
- Establish database security policies, access controls, encryption, and compliance standards.
- Collaborate with application architects, development teams, DevOps, and infrastructure teams to align database architecture with business requirements.
- Evaluate database technologies and recommend solutions based on scalability, performance, availability, and cost.
- Provide technical leadership, mentor database engineers, and conduct architecture and design reviews.
- Develop database monitoring, alerting, automation, and operational excellence strategies.
Required Skills and Qualifications
- 12+ years of experience in database architecture, database engineering, or database administration, with strong hands-on expertise in Couchbase.
- Extensive experience in Couchbase Server architecture, cluster management, replication, and distributed data systems.
- Strong expertise in SQL++/N1QL, indexing, query profiling, and performance tuning.
- In-depth knowledge of NoSQL data modeling, document design, partitioning, and scalability principles.
- Experience designing high-availability, disaster recovery, backup, and recovery solutions.
- Proven experience handling large-scale databases and mission-critical enterprise applications.
- Strong understanding of database security, access management, and performance monitoring.
- Experience with Linux, scripting, and database automation.
- Excellent troubleshooting, analytical, communication, and stakeholder management skills.
Good to Have
- Experience with AWS, Microsoft Azure, or Google Cloud Platform.
- Knowledge of Kubernetes, Docker, and containerized deployments.
- Experience with infrastructure as code, CI/CD pipelines, and automation tools.
- Exposure to database migration, cloud-native architectures, and microservices.
- Experience defining database governance, architecture standards, and technology roadmaps.
Candidate Profile
- Total Experience: 12+ Years
- Core Technology: Couchbase
- Primary Focus: Database Architecture, NoSQL, Performance Optimization, High Availability, and Scalability
- Location: Bangalore
- Joining Requirement: Immediate Joiners Only
- Interview Process: Technical Discussion and Management Round
Job Description:
• Understand existing databases and develop schemas, tables, indexes, relationships, constraints, stored procedures, and data access patterns.
• Design and build the target database structure based on application requirements and business logic.
• Define database architecture, data models, table structures, indexing strategies, and performance optimization approaches.
• Support mapping of existing database objects and data access logic to the target Java application architecture.
• Develop and validate SQL queries, database scripts, and data access components.
• Assess data migration requirements, data integrity, reconciliation, and compatibility.
• Support database testing, performance tuning, troubleshooting, and production readiness.
Experience – 8-10 Years
Location – Preferably Bengaluru
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
Job Description (JD) for the MySQL Database Administrator role
Experience: 4-8 Years
Location : Mumbai
Job Title: MySQL Database Administrator
Responsibilities
- Provision and configure MySQL database instances in clustered and non-clustered environments.
- Ensure database performance, security, availability, and reliability.
- Prepare and maintain database documentation, technical specifications, and operational procedures.
- Perform database upgrades, backups, restoration, recovery, and migrations.
- Monitor database and server resource utilization and perform performance tuning and optimization.
- Manage database users, access privileges, periodic access reviews, audits, and documentation.
- Configure, monitor, and troubleshoot MySQL replication.
- Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues.
- Provide database and application deployment support, as required.
- Perform database backup and restoration validation, data integrity checks, and post-migration validations.
- Follow database change management, security, and operational best practices.
Skills and Qualifications
- Strong hands-on experience in MySQL database administration.
- Good working knowledge of recent MySQL versions, preferably MySQL 8.x.
- Understanding of MySQL storage engines, including InnoDB and MyISAM.
- Practical experience in configuring, monitoring, and troubleshooting MySQL replication.
- Knowledge of MySQL administration best practices, security, and high availability.
- Proficiency in writing, analyzing, and optimising SQL queries.
- Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring.
- Ability to assess database resource requirements based on application workloads and technical specifications.
- Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB.
- Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds.
- Working knowledge of version control tools such as Git, SVN, or CVS.
- Graduate degree in a relevant discipline and good verbal and written communication skills.
Good to Have
- Basic Linux administration, command-line troubleshooting, and Bash scripting skills.
- Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly.

Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.
Enterprises stuck on Oracle carry license renewals, vendor-specific SQL nobody wants to touch, and application layers welded to the database underneath them. This role sits in our Application & Database Modernization pillar: you'll work an Oracle-to-PostgreSQL migration where Aedeon handles the mechanical conversion at scale and you own what the tools can't, which is the refactoring judgment inside large enterprise Java codebases.
You'll rewrite the SQL the application actually depends on, align it with the modernized schema, prove functional parity, and see the application through production cutover. Not a proof of concept. A system that ships.
What you will do?
- Decompose a large Java monolith into microservices: identify bounded contexts, extract services with the strangler-fig pattern, and define REST and event contracts.
- Apply proven microservice patterns: database-per-service (staged pragmatically), Saga with compensating actions, transactional outbox, idempotent consumers, and resilience patterns such as circuit breakers.
- Remediate Oracle- and SQL Server-specific code for Aurora PostgreSQL: rewrite embedded SQL, stored procedure calls, sequences, pagination, date handling and error handling, and update JPA/Hibernate or MyBatis mappings.
- Work closely with database migration engineers so application-layer SQL lines up with the converted target schema and supports environment cloning and refresh.
- Deploy and run services on Amazon EKS: Helm charts, health probes, JVM and resource tuning, autoscaling, ALB/NLB ingress, and Pod Identity for AWS access.
- Build and maintain GitHub Actions CI/CD pipelines for Java services: Maven/Gradle builds, scanned images in Amazon ECR, Flyway/Liquibase migrations, and promotion from dev to prod with approval gates and rollback.
- Automate testing: unit, Testcontainers integration, contract, API and smoke tests, plus parity and performance tests that prove modernized services match or beat legacy baselines. Wire the client's existing suites into the pipeline.
- Use GenAI-assisted tools (Claude Code) to accelerate code conversion, and validate their output rigorously.
- Instrument services for Dynatrace and support production cutover: rehearsals, validation, rollback planning and stabilization.
- Produce engineering documentation that outlives the engagement: design notes, code-migration runbooks, troubleshooting guides and knowledge-transfer material for the client's teams.
- Pair with client engineers and SMEs across US- and India-based teams, reviewing code and keeping business logic aligned.
What are we looking for?
- Bachelor's degree in Computer Science, Engineering, or a related field.
- 5+ years of professional Java development experience (Java, Spring Boot, Spring Cloud, JDBC, JPA/Hibernate or MyBatis).
- Hands-on experience decomposing a monolith into microservices in production: domain-driven design, Saga and event-driven integration (Kafka, SQS/SNS or EventBridge).
- Strong SQL expertise. You can analyze, optimize and rewrite complex SQL embedded in Java, and you've migrated application code from Oracle or SQL Server to PostgreSQL.
- Deep understanding of JDBC, ORMs, transaction management, connection pooling and database-driven application flows.
- Production experience running Spring Boot on Kubernetes (preferably Amazon EKS) with Docker and Helm.
- CI/CD experience with GitHub Actions: reusable workflows, environment approvals and OIDC authentication to AWS.
- Test automation skills: JUnit 5, Mockito, Testcontainers, REST Assured and consumer-driven contract testing.
- Working knowledge of AWS application services: Aurora PostgreSQL, RDS Proxy, KMS and IAM roles for workloads.
- Regular use of AI coding assistants in real delivery work.
- Excellent spoken and written English, and the ability to work US Mountain Time business hours with globally distributed teams.
You will be preferred if you
- Have exposure to automated code-refactoring tools or GenAI-assisted remediation workflows.
- Have experience with Amazon VPC Lattice or a service mesh.
- Have done performance testing (Gatling, JMeter or k6) and worked with observability stacks (Dynatrace or OpenTelemetry).
- Have worked on MuleSoft integrations and Ping Identity (OAuth 2.0 / OIDC).
- Have worked in SOX-regulated environments: change control, approvals and audit evidence.
- Have worked on e-commerce, subscription ordering or commission/compensation systems.
- Hold an AWS certification (Developer Associate or Solutions Architect) and have basic Terraform.







