Skip to main content

Database Developer

Technology
Arizona, United StatesTodayUntil 12/20/2026
Service contractHybrid

Job description

Job Title: Database Developer / DB Engineer

Location: Scottsdale, AZ (Hybrid)

Duration: 6+ Months

Job Description

We are looking for a Database Developer to design data models and lead the migration of enterprise databases from Oracle to PostgreSQL. You will work with application, data, and infrastructure teams to deliver a secure, high-performing, and reliable migration.

Key Responsibilities

· Design and maintain logical and physical data models (conceptual, ERD, normalization, dimensional modeling).

· Plan and execute Oracle to PostgreSQL migrations, including schema conversion, data migration, and cutover.

· Convert PL/SQL code (procedures, functions, packages, triggers) to PL/pgSQL.

· Tune performance through indexing, query optimization, and partitioning.

· Validate data integrity and reconcile data between source and target systems.

· Document designs, mappings, and migration runbooks.

· Collaborate with cross-functional teams on testing, deployment, and post-migration support.

Required Skills

· Strong hands-on experience with Oracle (SQL, PL/SQL) and PostgreSQL.

· Proven experience in data modeling (tools such as ERwin, ER/Studio, or similar).

· Experience with Oracle to PostgreSQL migration using tools such as AWS SCT/DMS, ora2pg, or EDB Migration Toolkit.

· Strong SQL tuning and troubleshooting skills.

· Understanding of ETL/ELT processes and data validation techniques.

Good to Have

· Cloud database experience (AWS RDS/Aurora PostgreSQL, Azure, or GCP).

· Familiarity with CI/CD and version control (Git, Liquibase/Flyway).

· Knowledge of data security and compliance (HIPAA, PHI/PII handling), valuable in healthcare.

· Scripting skills (Python, Shell).

Keywords
OraclePostgreSQLSQLPL/SQLPL/pgSQLData ModelingDatabase MigrationSQL Performance TuningData ValidationETL/ELTAWS SCT/DMSOra2pgERwinER/StudioData SecurityPythonEntity-Relationship DiagramsNormalizationDimensional ModelingOracle-to-PostgreSQL Migration

Interested in this role?