Database Developer

5 - 10 years

4 - 8 Lacs

Posted:1 day ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

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.

Benefits

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

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
TechnoIdentity logo
TechnoIdentity

IT Services and IT Consulting

Richardson Texas

RecommendedJobs for You

Pune, Gurugram, Mumbai (All Areas)

Noida, Uttar Pradesh, India

pune, maharashtra