Database Developer
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).
Interested in this role?