Search Jobs in India, Recruitment India

Database Developer

TechnoIdentity

Posted On: 2025-08-25 20:49:23
Openings: 10
Applicants: 0

Job Description

At Technoidentity, we're a Data + AI product engineering company trusted for delivering scalable and modern enterprise solutions. Join us as a Database Developer and play a critical role in migrating enterprise data systems from Oracle to PostgreSQL on AlloyDB , using cloud-native and performance-optimized practices. If you're hands-on with PL/SQL and PL/ pgSQL , experienced in performance tuning and validation, and confident in transforming complex data logicthis role is designed for you.

What in it for You

Migration Engineering at Scale Execute real-world migrations of legacy Oracle databases to AlloyDB /PostgreSQL using structured and proven methodologies.
Database Rewriting & Optimization Rewrite stored procedures and data logic in PL/ pgSQL , reconfigure indexes, and tune performance for high-throughput systems.
Modern Stack Exposure Work with cloud-native services and best practices as part of enterprise modernization journeys.
Data Validation Accountability Lead source-to-target comparison of Oracle vs. AlloyDB , ensuring no data loss or logic drift post-migration.
Proactive Culture Take ownership of data logic, performance metrics, and delivery quality in a team that values accountability .

What Will You Be Doing

Database Migration & Transformation

Migrate Oracle databases to PostgreSQL ( AlloyDB ) through manual and automated processes.
Rewrite stored procedures, packages, triggers, and SQL logic from PL/SQL to PL/ pgSQL .
Recreate schemas, constraints, indexes, views , and other DB objects in the target PostgreSQL environment.

Performance Optimization

Design and implement table partitioning , advanced indexing , and optimized query plans .
Use tools like EXPLAIN ANALYZE , pg_stat_statements , and cloud-native monitoring to track and improve query performance.
Collaborate with infrastructure and DevOps teams to manage DB provisioning and deployment workflows.

Data Validation & Quality Assurance

Perform data comparison between Oracle and AlloyDB to ensure data integrity post-migration.
Develop scripts to validate row-level accuracy , transformation rules, and reconciliation reports.
Handle large datasets efficiently, including bulk data processing and archival validation .

Collaboration & Documentation

Partner with Business Analysts, Tech Leads, and QA to translate business logic embedded in Oracle code to scalable PostgreSQL logic.
Maintain documentation on migration steps, schema differences, validation strategies , and rollback procedures.

What Makes You the Perfect Fit

5+ years of experience in database development and migration across Oracle and PostgreSQL ecosystems.
Strong expertise in PL/SQL and PL/ pgSQL , including stored procedures, error handling, and performance tuning.
Deep understanding of data validation practices , SQL reconciliation, and performance bench marking.
Hands-on with partitioning, indexing strategies, schema conversion , and legacy modernization workflows.
Familiarity with version control, Agile practices, and collaborative development environments.

Nice to Have

Experience working in cloud environments , particularly with PostgreSQL-based systems such as AlloyDB or Aurora.
Exposure to Python or Shell scripting for automation, validation, or DevOps hand offs.
Knowledge of BTEQ-to-RSQL conversion or legacy script transformation for data workflows.

Personal Attributes

Strong ownership of assigned modules with a proactive approach to problem-solving.
Detail-oriented with a passion for data integrity and completeness .
Accountable, collaborative, and delivery-focused in dynamic cross-functional environments.