CMIT was established on January 26, 2007 as a joint venture between Saigon Port, VIMC and APM Terminals.

Data Engineer

Data EngineerData EngineerFull TimeRemoteTeam 201-500Since 2007H1B No SponsorCompany Site LinkedIn

Location

Virginia

Posted

139 days ago

Salary

Not specified

Bachelor Degree5 yrs expExperience acceptedEnglishAWSCloudETLOraclePostgresPythonSQL

Job Description

• Perform comprehensive analysis of Oracle database structures across multiple schemas and systems • Map table relationships, constraints, and dependencies within the ~2TB environment • Document data flows, lineage, and integration points with legacy systems • Create detailed migration documentation and data dictionaries in Confluence • Design optimized PostgreSQL target schemas for performance and maintainability • Develop migration strategies for complex Oracle features (PL/SQL, packages, materialized views) • Create and execute data migration scripts with comprehensive validation procedures • Implement hybrid migration approaches for legacy data center and AWS environments • Design data synchronization strategies between on-premises and cloud environments • Implement secure data transfer mechanisms and connectivity solutions • Ensure data consistency and integrity across distributed PostgreSQL deployments

Job Requirements

A minimum of a Bachelor's Degree.
5+ years Oracle database administration and development experience
3+ years hands-on PostgreSQL experience with advanced features and performance tuning
Experience with large-scale database migrations (multi-TB environments)
Expert-level SQL skills across both Oracle and PostgreSQL platforms
Proficiency in scripting languages (Python, Bash, PowerShell) for automation
Experience with database migration tools (AWS DMS, ora2pg, pgloader)
Knowledge of ETL/ELT tools and data pipeline frameworks
Hands-on experience with AWS database services (RDS, Aurora PostgreSQL)
Comfortable with a strong culture of documentation
Proficiency with Confluence for technical documentation and knowledge management and sharing
Ability to create clear data flow diagrams and system architecture documentation
Experience with data lineage tools and dependency mapping
Proficiency with diagramming tools (Visio, PowerPoint, etc)
Proven track record of successful Oracle to PostgreSQL migrations
Experience with legacy enterprise systems and data integration patterns
Understanding of compliance and audit requirements for data migrations
Strong collaboration skills with cross-functional teams
Comfortable working in a remote environment.
Demonstrates a passion for solving complex software challenges and enjoys working team collaboration.