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

WHRlKzlkdXdpUzZkRTNQM0JyRWh6YWFVZ3c9PQ==
  • 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

Jackson Family Wines Jackson Family Wines

Audio Visual System Engineer Job at Jackson Family Wines Jackson Family Wines

 ...Job Description: POSITION SUMMARY: The Audio-Visual System Engineer is responsible for designing, supporting, and continuously improving audio-visual experiences across Jackson Family Wines. This role supports executive meetings, internal business meetings, consumer... 

Stony Brook Medicine

Registered Nurse - Nursing Administrator - Commack/Westbury Job at Stony Brook Medicine

 ...resume): Bachelors degree (foreign equivalent or higher) in Nursing or related medical field. Current New York State Registered...  ...Nurse experience in a clinical, hospital or ambulatory setting. Administrative experience in a healthcare setting. Preferred... 

IV Nutrition

IV Infusion Technician (RN or Paramedic) Job at IV Nutrition

 ...as assigned. SKILLS/ABILITIES: Credentialed as either an RN (Registered Nurse), EMT (Emergency Medical Technician), Paramedic...  ...Access Peripheral Veins 2 years minimum of Vascular Access or Infusion Experience needed , Strong Venous Access Skills Including Ability... 

Westchester Medical Center Health Network

Physician Assistant Job at Westchester Medical Center Health Network

 ...MidHudson Regional Hospital in Poughkeepsie, NY is seeking a Physician Assistant or Nurse Practitioner to join our growing team. In this...  ...of specialized institutes and centers, a state-of-the-art Telemedicine program, skilled nursing, assisted living facilities, homecare... 

Heritage Landcare

Landscape Designer Job at Heritage Landcare

 ...Enhancement Design and Sales Job Description Job Summary: As the Enhancement Design and Salesperson at Heritage Landscape Services, you will play a crucial role in driving sales and revenue growth for our enhancement services. Your main objective will be to foster...