Sr. Database Developer

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 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.

Whats 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 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?

• 8+ 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.

Benefits

Health benefits, skill-based growth tracks, and recognition for high-impact technical delivery.

Ready to Drive High-Impact Database Migrations with Us?

If you're passionate about database transformations, logic rewriting, and cloud-native performance—apply now and help us shape the future of intelligent, data-driven enterprise solutions.

By applying, you confirm the authenticity of your information and authorize background checks for employment purposes.