Lead Oracle-to-PostgreSQL/AlloyDB migrations, re-engineer PL/SQL to PL/pgSQL, design PostgreSQL architecture (partitioning, indexing), perform deep performance tuning (vacuum, WAL, planner), validate data integrity, and collaborate with DevOps to document and deploy enterprise-grade PostgreSQL systems.
Supercharge Your Career as a PostgreSQL Expert at Technoidentity!
At Technoidentity, we're a Data & AI product engineering company with over 15 years of
expertise in building durable digital products, intelligent enterprise solutions, and scalable
Data & AI platforms. As we continue expanding globally, it's the perfect time to join our
team of tech innovators and make a lasting impact.
What’s in it for You?
We are seeking a seasoned PostgreSQL Expert with 8–10 years of experience across multiple
We are seeking a seasoned 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.
Requirements
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 postmigration.
• 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–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.
• 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, faulttolerance,
and disaster recovery.
Technoidentity Hyderabad, Telangana, IND Office
Sohini Tech Park, 8th Floor, Nanakramguda,Financial District,, Hyderabad, Telangana , India, 500032
Similar Jobs
Financial Services
Leads and coaches multiple software engineering teams while overseeing resources, budgets, technical execution, and operating practices. Drives enterprise adoption of AI-assisted engineering and SDLC automation with governance, security, quality, and measurable delivery outcomes. Guides Java backend development and AWS cloud-native distributed services, participates in architecture and design reviews, promotes testing, CI/CD, observability, and secure coding, and collaborates with product and business stakeholders.
Top Skills:
Apache AirflowAurora PostgresqlAWSAws GlueCassandraCi/CdCloud FoundryDockerDomain-Driven DesignEc2Ecs/FargateEvent-Driven ArchitectureGithub CopilotJavaJava MessagingKafkaKubernetesMicroservicesNoSQLOracle RdbmsRestSoapSpringSpring BootSQLTest-Driven Development
Fintech • Financial Services
Support trade services by processing and amending letters of credit, issuing and advising collections, and handling complex documentation. Collaborate with peers and managers to resolve issues, retain clients, identify growth referrals, and follow trade services policies and procedures.
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Own verification and end-to-end analysis of full-chip gate-level DRAM designs. Develop SystemVerilog and UVM testbenches, test cases, stimuli, test vectors, regressions, and coverage improvements. Simulate, debug, and analyze pre-silicon block and full-chip designs using digital, mixed-signal, and SPICE tools. Apply AI-based automation to accelerate verification while validating outputs against specifications, simulations, waveforms, assertions, and coverage. Guide newer engineers and collaborate globally on verification methodologies and environments.
Top Skills:
AmsCmosDramFinsimHspicePerlPliPythonReal Number ModelsSimvisionSpiceSramSystemverilogUvmVerilogVirtuosoVsimWaveviewXcelium
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
