Sr. Postgresql Developer

Database Developer

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?

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.