SME Oracle Database Administrator Job at Interactive Process Technology LLC, Remote

MDVRdkk2elBEbGl1R28zL2VpdmRFbDVzcUE9PQ==
  • Interactive Process Technology LLC
  • Remote

Job Description

SME Oracle Database AdministratorRemote  At IPT Associates (IPTA), we enjoy solving real-world problems with technology. We work closely with our customers, teammates, experts, and partners to come up with practical solutions that make a difference. Whether it's a government or business organization, we focus on understanding the need and building something that works.Our TeamAt IPTA, everything starts with our people. We're big believers that when you invest in your team, great things happen. That's why we encourage learning, growth, and trying new things-even if you don't have all the answers yet.Our culture is rooted in fierce determination, fearless integrity, and passionate service-but we also like to keep things collaborative, supportive, and down-to-earth.We're looking for people who:Are curious and excited about technologyLike solving problems and figuring things outCan take initiative but also enjoy working with a teamWant to keep learning, growing, and challenging themselvesIf you're someone who's eager to jump in, learn something new, and make an impact-you'll fit right in here.Responsibilities:Serves as the Oracle 19c database authority for the migration of a legacy U.S. Army enterprise system into Palantir Foundry (Army Vantage), with a focus on migration and transition engineering rather than steady-state database maintenanceExtracts the legacy Oracle 19c database on NIPRNet, producing a consistent point-in-time, integrity-validated snapshot and staging it for load into Palantir FoundryReverse-engineers the highly normalized, time-variant legacy schema and leads source-to-target data mapping of key processes and data objects, including application-dependency mapping across source systems to sequence the migration safelyAnalyzes legacy Oracle ETL jobs and PL/SQL objects to determine what must be refactored versus retired in the move to the Palantir Foundry pipelinePerforms data profiling, cleansing, and source-to-target reconciliation (row- and field-level integrity) to enforce system data-quality and validation rules on migrated dataWorks within the existing Oracle Data Guard replication/sync topology to establish a repeatable extract and incremental sync into Palantir Foundry without disrupting the legacy system during the proof of conceptPartitions, bulk-loads, and performance-tunes specifically for one-time and incremental migration throughputApplies DoD and Army requirements throughout the transition, including STIG-hardened Oracle baselines, RMF, NIPRNet constraints, and proper handling of controlled dataRequirements:Bachelor's degree in Computer Science, Information Systems, or a related field (equivalent experience may be considered)10+ years of Oracle database administration experience, including hands-on database migration and data transition projectsAdvanced Oracle 19c expertise, including RMAN, Data Pump, ASM, PL/SQL, and partitioning, with working knowledge of Oracle Data Guard replicationDemonstrated data migration experience: point-in-time extraction, source-to-target mapping, data profiling, reconciliation, and data-quality validationExperience analyzing legacy PL/SQL and Oracle ETL code to drive refactor-or-retire decisionsDoD environment experience: STIG-hardened Oracle baselines, RMF, and NIPRNet constraintsAdminister, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databasesPlan, coordinate, and implement security measures to safeguard computer databasesProvides technical/management leadership on major tasks or technology assignmentsEstablishes goals and plans that meet project objectives. Has domain and expert technical knowledgeDirects and controls activities for a client, having overall responsibility for financial management, methods, and staffing to ensure that technical requirements are metInteractions involve client negotiations and interfacing with senior managementDecision making and domain knowledge may have a critical impact on overall project implementationMay supervise othersAn active Secret security clearance is requiredPreferred Qualifications:Oracle Certified Professional (OCP), Oracle Database 19cCompTIA Security+ or equivalent DoD 8570/8140 baseline certificationExperience designing incremental sync or change data capture (CDC) from Oracle sourcesExposure to Palantir Foundry or Army Vantage data integrationIPTA is an Equal Opportunity Employer. All employment decisions are based on individual merit, including qualifications, experience, performance, and business needs, consistent with applicable federal laws and federal contracting requirements. IPTA provides equal opportunity and utilizes merit-based principles to make employment-related decisions.#clearance

Job Tags

Full time

Similar Jobs

Senior Helpers - Bryan

Caregivers flexible shifts Start immediately 15-16USD hourly Apply now ! Job at Senior Helpers - Bryan

HI!!!! We have a fantastic job opportunity to work as a caregiver in the Bryan and College Station TX area. - Premium Salary $15-$16/hr - Bryan / College StationFlexible shifts (part-time morning, afternoon)Biweekly pay | Start ASAP Light care (ADLs, companionship)... 

MSA

Fire Safety Advisor- Full Time- Holiday Help Job at MSA

 ...hiring in our customer service safety department.This is in our Entry Level-Management .Set up and Display to homeowners, and small...  ...extinguishers, egress ladders, burn kits, fire blankets, and more.No experience necessary.We will fully train all new personnel to provide... 

Tesla

Robotics Sensor Design Engineer, Tactile Sensing, Optimus Job at Tesla

What To Expect Tesla is seeking a Sensor Integration Engineer to support Optimus. The Sensor Team is responsible for architecting, designing, validating and integrating state-of-the-art sensing technologies for Tesla Bot, supporting manipulation and locomotion. As a...

Buckhorn Camp and Retreat Center

Summer Camp Counselor Job at Buckhorn Camp and Retreat Center

 ...group of campers and supervise them up to 24 hours a day during camp sessions. Work in cooperative and constructive relationship...  ...activities for assigned group Participate in all areas of the summer camp program alongside campers Follow Camps rules and... 

Capital One

Front-end Engineer 5 SEO - Shopping (Remote-eligible) Job at Capital One

 ...subject matter expert in critical areas like SEO, web performance, networking, or design systems,...  ...experience in software engineering (internship experience does not apply) At least 6 years of experience developing applications using TypeScript, HTML, CSS and modern...