Database Developer / DB Engineer — Scottsdale, AZ
Зарплата не указана
Откликнуться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 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).