Data Engineer

Job not on LinkedIn

October 24

⚔️ Virginia – Remote

Although this job is listed in Virginia, this company may be open to hiring remote in other states.

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

Apply Now

Receive Emails with Similar Jobs

CMIT

WebsiteLinkedInAll Job Openings

Transport • B2B

CMIT is Cai Mep International Terminal Co. , Ltd. , a port and container terminal operator in Vietnam providing maritime terminal services, vessel handling, cargo operations and related terminal services. The company focuses on safe, sustainable and efficient terminal operations, offering customer services such as tracking and e-invoicing, and connects Vietnam to international shipping routes.

201 - 500 employees

Founded 2007

🚗 Transport

🤝 B2B

📋 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

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

🏖️ Benefits

• fully remote position • professional development opportunities