Oracle Database Developer

Job Description

Job Description At Technoidentity, were 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 performanceoptimized practices. If you're hands-on with PL/SQL and PL/pgSQL, experienced in performance tuning and validation, and confident in transforming complex data logic—this role is designed for you. What’s 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. Requirements 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 postmigration. 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.