Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Able to Provide Sponsorship
Skills
Python
Oracle
PL/SQL
AWS
Kubernetes
Docker
PostgreSQL
Job Details
We are seeking a seasoned Database Engineer to lead the migration of Oracle databases hosted on AWS EC2 to modern, cloud-native platforms, ideally Amazon RDS for PostgreSQL. This role demands deep expertise in PL/SQL, SQL, and performance tuning, along with working knowledge of modern programming languages and containerized environments.
The ideal candidate will be proficient in Python and/or Node.js, with exposure to Kubernetes-based deployments, enabling smooth integration of database changes in distributed systems.
Key Responsibilities:
- Lead the end-to-end migration of Oracle databases to Amazon RDS PostgreSQL or other target platforms.
- Experience with event management tools like AWS EventBridge.
- Refactor and rewrite PL/SQL logic to PostgreSQL-compatible code.
- Use AWS tools like DMS (Database Migration Service) and Schema Conversion Tool (SCT) for schema and data migration.
- Conduct database performance analysis, query optimization, indexing, and tuning on both Oracle and PostgreSQL.
- Collaborate with application teams to ensure seamless integration during and after migration.
- Work with Python or Node.js codebases that interact with the databases.
- Assist with container orchestration and deployment using Kubernetes for database-related services or tooling.
- Maintain technical documentation and migration runbooks.
Required Skills and Qualifications:
- Overall 9+ years of IT experience with 5+ years of experience with Oracle database administration and development.
- Expert-level proficiency in PL/SQL, SQL, and performance tuning.
- Hands-on experience with PostgreSQL, preferably Amazon RDS PostgreSQL.
- Experience using AWS tools (DMS, SCT) for database migration.
- Strong understanding of database design, data modeling, and schema transformation.
- Proficiency in Python or Node.js for scripting, automation, or integration.
- Working knowledge of Kubernetes and containerized environments (e.g., Docker).
- Excellent problem-solving, communication, and documentation skills.
Preferred / Good-to-Have:
- Experience with Redis and/or Graph databases (e.g., Neo4j, Amazon Neptune).
- Familiarity with CI/CD pipelines and DevOps workflows for database deployments.
- AWS certification (e.g., AWS Certified Database Specialty, Solutions Architect) is a plus.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.