Database Developer / DB Engineer
job Title: Database Developer / DB Engineer
Location: Scottsdale, AZ (Hybrid)
Experience: 13+ years
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 HaveCloud 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).