JOBSEARCHER

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).