Oracle Database Migration Specialist

Dynamo Technologies LLC; Northern (KY); Hybrid; USD 120,000 - 155,000; Full time

Benefits offered by this job

100% Paid Medical Benefits

Health Savings Account

401K with Company Match

Tuition Reimbursement

Monthly Commuting Stipends

Paid Time Off

Job summary

Dynamo Technologies LLC is seeking an Oracle Database Migration Specialist to lead assessment, planning, and execution of Oracle-to-PostgreSQL migrations in enterprise environments.

The role requires hands-on experience with Ora2Pg, CDC-based cutover, and manual PL/SQL to PostgreSQL conversions, plus strong SQL tuning and cloud-hosted DB expertise. Minimal travel and a focus on secure, scalable migrations are expected.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent combination of education and experience).
• Minimum of 7+ years of relevant database experience (11+ years without a Bachelor’s).
• Experience supporting at least one Oracle database migration project.
• Experience with Oracle-to-PostgreSQL migrations and data transformation concepts.
• Hands-on use of migration tooling and manual remediation of complex objects.

Responsibilities

• Assess current Oracle database environments and identify migration considerations, risks, and dependencies.
• Develop migration strategies, roadmaps, and implementation plans.
• Execute database migration activities, including schema conversion and data migration.
• Collaborate with application teams to remediate DB issues during migration, including JDBC/ODBC changes.
• Analyze and optimize database performance during migration lifecycle.
• Support testing activities: functional, integration, performance, and UAT.
• Document migration procedures, designs, and operational processes.
• Provide recommendations for modernization and operational improvements.
• Participate in technical discussions with customers and stakeholders.
• Troubleshoot and resolve DB-related issues throughout the migration lifecycle.

Skills

Oracle DBA/Dev

Oracle migrations

Ora2Pg tooling

PL/SQL to PostgreSQL

SQL performance tuning

AWS RDS/config

Data migration planning

Education

Bachelor's in CS/IS/Engineering

Tools

Ora2Pg

AWS SCT

AWS DMS

Job description

Where Passion, Growth, and Success Come Together

Why a Career at Dynamo?

At Dynamo, we don’t just offer technology company jobs—we build careers. We’re passionate about bringing together driven, collaborative professionals who thrive on solving challenges and making an impact. When you join our team, your growth becomes our priority. From tailored professional development plans to mentorship opportunities, we invest in equipping you with the skills and knowledge needed to excel in your role and beyond.

Our culture is built on trust, inclusivity, and camaraderie—we’re more than colleagues; we’re a family. Through team-building events, community service initiatives, and a commitment to work-life balance, we create an environment where every team member feels valued and supported.

At Dynamo, we believe exceptional work deserves exceptional rewards. That’s why we offer a competitive benefits package that supports your well-being, financial health, and professional ambitions:

• 100% Paid Medical Benefits and Disability Insurance Coverage
• Health Savings Account (H.S.A.)
• 401K with Company Match
• Tuition Reimbursement for continued learning
• Monthly Commuting Stipends
• Generous Paid Time Off (PTO) and Holidays
• A collaborative, growth-focused workplace culture

When you join Dynamo, you’re not just taking a job—you’re becoming part of a team that’s reshaping the future with bold ideas, innovative solutions, and a shared commitment to excellence.

Your future is bright at Dynamo—come grow with us.

When you join Dynamo, you don’t just become another number, you become part of a family. A family who thrives to keep morale high and opportunities endless.

The Oracle Database Migration Specialist will support assessment, planning, and execution of Oracle database modernization and migration initiatives. This individual will work with technical stakeholders to evaluate existing Oracle environments, develop migration strategies, perform data migration activities, and support testing and post‑migration optimization efforts. The ideal candidate has demonstrated experience successfully migrating applications and databases from Oracle to alternative database platforms in complex enterprise environments, combining hands‑on use of approved migration tooling with the ability to manually convert complex Oracle‑specific objects that tooling cannot fully automate.

Duties/Responsibilities

• Assess current Oracle database environments and identify migration considerations, risks, and dependencies.
• Develop migration strategies, roadmaps, and implementation plans.
• Execute database migration activities, including schema conversion, PL/SQL object conversion, data migration, validation, and cutover support.
• Collaborate with application teams to identify and remediate database‑related issues during migration efforts, including JDBC/ODBC connectivity changes.
• Analyze and optimize database performance before, during, and after migration.
• Support testing activities, including functional, integration, performance, and user acceptance testing.
• Document migration procedures, technical designs, and operational processes.
• Provide recommendations for database modernization and operational improvements.
• Participate in technical discussions with customer and project stakeholders.
• Troubleshoot and resolve database‑related issues throughout the migration lifecycle.

Required Skills/Abilities

• Strong experience with Oracle Database administration and/or development.
• Experience leading or supporting Oracle-to-non-Oracle database migrations.
• Hands‑on experience with Ora2Pg (the customer‑approved Oracle-to-PostgreSQL migration tool for this environment) or a comparable Oracle-to-PostgreSQL migration toolset, including experience with Change Data Capture (CDC)-based migration for minimal‑downtime cutover.
• Demonstrated ability to manually convert Oracle PL/SQL objects (packages, procedures, functions, triggers, views, and synonyms) to PostgreSQL/PL-pgSQL equivalents, since portions of migration work require manual remediation even with approved tooling in place.
• Knowledge of database migration methodologies, tools, and best practices.
• Experience with database assessment, planning, testing, and cutover activities.
• Strong SQL and database performance tuning skills.
• Experience provisioning and configuring cloud‑hosted relational databases (e.g., AWS RDS), including parameter groups, monitoring, and backup configuration.
• Ability to analyze complex technical environments and develop migration recommendations.
• Experience troubleshooting database and application integration issues.
• Strong written and verbal communication skills.
• Ability to work independently and collaboratively within cross‑functional teams.

Nice to Have Skills

• Experience migrating Oracle databases to: PostgreSQL, Microsoft SQL Server, Azure SQL Database, AWS RDS.
• Experience with AWS Schema Conversion Tool (SCT) and/or AWS Database Migration Service (DMS), which could further reduce migration effort if approved for use by the customer in the future.
• Experience with an enterprise migration/ETL toolkit such as EDB (EnterpriseDB) Postgres AI Migration Toolkit (MTK), or an equivalent enterprise‑grade migration tool.
• Experience migrating Oracle 19c database environments specifically.
• Cloud migration and modernization experience.
• Application modernization experience associated with database migrations.
• Experience with ETL, data integration, and data conversion tools.
• Data validation and reconciliation experience (e.g., row‑count checks, referential integrity validation) following migration cutover.
• Database architecture and solution design experience.
• Familiarity with DevOps, CI/CD, and Infrastructure as Code practices.
• Experience supporting federal, public sector, or highly regulated environments.
• Previous experience serving as a technical lead or migration architect.

Education and Experience

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent combination of education and experience).
• Minimum of 7+ years of relevant database experience (11+ years of relevant experience without a Bachelor's degree).
• Demonstrated experience supporting at least one Oracle database migration project.
• Experience working in enterprise‑scale IT environments preferred.

Travel Requirement

Minimal travel anticipated.

Clearance Requirement

• Public Trust

Salary Range: The salary range for this position represents Dynamo's good‑faith estimate of the compensation expected to be offered at the time of posting. Actual compensation will be determined based on several factors, including, but not limited to, the responsibilities of the role, the candidate's experience, skills, education, work location, and internal equity.
120k - 155k annually

Dynamo is a full lifecycle digital transformation company providing best‑in‑class technology and mission support services to our clients. Dynamo’s mission is to lead the digital transformation industry and provide best‑in‑class solutions for our clients with a truly human touch.

We leverage industry leading practices to empower our clients, ultimately providing them with the necessary tools, knowledge, and information required to successfully achieve their strategic goals, while optimizing their operations.

Through our partnerships, boldness, and authenticity, Dynamo goes against the grain of a traditional government contracting company by providing top‑caliber team members, delivering quality results, and always exceeding expectations.

Dynamo Technologies is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, disability, protected veteran status, age, or any other characteristic protected by law.

Individuals with Disabilities (IWD) Contact Statement

The Dynamo Technologies Career page is accessible to any and all users. If you would like to contact us regarding the accessibility of this portal or you need assistance completing the application process, please contact [e-mail] . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

Equal Employment Opportunity Commission (EEOC) and Office of Federal Contract Compliance Programs (OFCCP)

Applicants to and employees of most private employers, state and local governments, educational institutions, employment agencies and labor organizations are protected under Federal law from discrimination.