Data Engineer

Who We Are.

At CMiT, we do more than provide real-world solutions. We deliver transformative results. Through cutting-edge technology and process innovations, we are changing how federal and commercial clients worldwide deliver their mission. A service-disabled veteran-owned small business, we take pride in serving our nation through exemplary support for our clients and employees alike.

DATA ENGINEER

CMiT is seeking an experienced Data Engineer to help lead the analysis, documentation, and migration of a ~2TB Oracle database environment to PostgreSQL. This role involves mapping complex data dependencies across multiple schemas Oracle in legacy data centers to Postgres RDS in AWS environments.

This role offers the opportunity to play a pivotal role in a mission critical database modernization initiative, working with enterprise scale data systems while building expertise in both traditional and cloud-native database technologies.

Responsibilities

• 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

Education / Certification Required

Required Qualifications

Preferred Qualifications :

Clearance Required

Who Makes It Happen.

At CMiT, we firmly believe that our innovative solutions are only as powerful as the teams harnessing them. Our people are more than just contributors - they are at the heart of everything we do and every success that we earn. Our employees are offered ample options to design a personalized benefits package that best meets their needs. Options include :

CMiT provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.