Jul 23
Secret
Mid Level Career (5+ yrs experience)
IT - Software
Location: 100% Remote
Years’ Experience: 5+ years professional experience
Education: Bachelor’s Degree required
Work Authorization: United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.
Clearance: Applicants must be able to obtain and maintain a Secret security clearance.
Key Skills:
Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systems
Oracle DBMS experience within large-scale database enterprise systems
Current or ability to obtain either CompTIA Network+, CompTIA Security+, or higher-level certification as defined by DoD CIO Information Assurance requirements
Responsibilities
Deploy, Upgrade, Operate, Manage, and Support of Informatica environments
Perform Tuning, Optimization, Troubleshooting, and Daily Monitoring of the database
Monitor daily extract generation from an Oracle database and address issues independently
Analyze, develop, test, and maintain data ETL extraction procedures utilizing Informatica
Perform and support Informatica ETL application installation, configuration, updates and patches
Design, develop, and maintain Informatica ETL power center scripts
Analyze, design, develop and maintain Informatica ETL power scripts
Designs, builds, and maintains structure (e.g. relational) and unstructured databases within a multiple tier environment
Analyzing performance issues, diagnosing/resolving affecting database systems
Performs data access analysis design, and archive/recovery design and implementation.
Maintaining database configurations in compliance with release management, change management, and office of information security requirements
Perform daily activities like production support and continuous database monitoring.
Apply patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, and Patch sets.
Applies knowledge and experience with database technologies, development methodologies, and frontend (e.g. COGNOS) and back‐end programming languages (e.g. SQL). Performs database programming and supports systems design.
Implement database environments refresh using data pump
Translate business requirements and database administration operational requirements into long-term architecture solutions.
Performs all activities related to the administration of computerized databases.
Conducts quality control and auditing databases in a multiple-tier environment to ensure accurate and appropriate use of data.
Qualifications
Bachelor’s degree required
Must be able to obtain a Secret security clearance
Current Network+, Security+, or higher as defined by the DoD CO Information Assurance (IA) certification requirements
5+ years of experience performing Informatica ETL Operations and connectors for cloud-based and on-prem ERP systems such as SAP, Oracle, Fusion Cloud, and PeopleSoft
5+ years of Oracle Database experience within large-scale database enterprise systems monitoring the database daily and addressing issues independently
Must possess in depth technical experience specifically with Informatica, SQL, and Python.
Knowledge of configuration, deployments and troubleshooting.
Knowledge of Oracle database provisioning, cloning and patching techniques
Experience with Cognos BI preferred but not required
Data mapping and transformation experience preferred but not required
Experience working in Databricks preferred but not required
Years’ Experience: 5+ years professional experience
Education: Bachelor’s Degree required
Work Authorization: United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.
Clearance: Applicants must be able to obtain and maintain a Secret security clearance.
Key Skills:
Experience performing Informatica ETL operations and connectors for cloud-based and on-prem ERP systems
Oracle DBMS experience within large-scale database enterprise systems
Current or ability to obtain either CompTIA Network+, CompTIA Security+, or higher-level certification as defined by DoD CIO Information Assurance requirements
Responsibilities
Deploy, Upgrade, Operate, Manage, and Support of Informatica environments
Perform Tuning, Optimization, Troubleshooting, and Daily Monitoring of the database
Monitor daily extract generation from an Oracle database and address issues independently
Analyze, develop, test, and maintain data ETL extraction procedures utilizing Informatica
Perform and support Informatica ETL application installation, configuration, updates and patches
Design, develop, and maintain Informatica ETL power center scripts
Analyze, design, develop and maintain Informatica ETL power scripts
Designs, builds, and maintains structure (e.g. relational) and unstructured databases within a multiple tier environment
Analyzing performance issues, diagnosing/resolving affecting database systems
Performs data access analysis design, and archive/recovery design and implementation.
Maintaining database configurations in compliance with release management, change management, and office of information security requirements
Perform daily activities like production support and continuous database monitoring.
Apply patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, and Patch sets.
Applies knowledge and experience with database technologies, development methodologies, and frontend (e.g. COGNOS) and back‐end programming languages (e.g. SQL). Performs database programming and supports systems design.
Implement database environments refresh using data pump
Translate business requirements and database administration operational requirements into long-term architecture solutions.
Performs all activities related to the administration of computerized databases.
Conducts quality control and auditing databases in a multiple-tier environment to ensure accurate and appropriate use of data.
Qualifications
Bachelor’s degree required
Must be able to obtain a Secret security clearance
Current Network+, Security+, or higher as defined by the DoD CO Information Assurance (IA) certification requirements
5+ years of experience performing Informatica ETL Operations and connectors for cloud-based and on-prem ERP systems such as SAP, Oracle, Fusion Cloud, and PeopleSoft
5+ years of Oracle Database experience within large-scale database enterprise systems monitoring the database daily and addressing issues independently
Must possess in depth technical experience specifically with Informatica, SQL, and Python.
Knowledge of configuration, deployments and troubleshooting.
Knowledge of Oracle database provisioning, cloning and patching techniques
Experience with Cognos BI preferred but not required
Data mapping and transformation experience preferred but not required
Experience working in Databricks preferred but not required
group id: 91099499
