CMIT

Data Engineer

CMIT

full-time

Posted on:

Location Type: Remote

Location: Remote • Virginia • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AWSCloudETLOraclePostgresPythonSQL

About the role

  • 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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Oracle database administrationPostgreSQLSQLPL/SQLdata migrationscripting languagesETLdata synchronizationdata integrityperformance tuning
Soft skills
collaborationdocumentationproblem-solvingcommunicationorganizational skills
Certifications
Bachelor's Degree