Technoidentity - Senior Database Developer - PostgreSQL

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

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