Infrastructure Lead

  • VMD Corp,
  • Washington D.c., DC
  • 9 hours ago
Amazon Web Services, Apache Spark, Big data, Data QA, ETL, BI Layer, SAS, CI/CD, OBIEE, Agile, Informatica PowerCenter, Informatica PowerExchange, SAS VIYA, SAS Studio, Databricks, Scala, PL/SQL, RHEL, Linux, Windows, RDS
Full Time
Depends on Experience
Work from home available Travel not required

Job Description

About the Mission You Will Join:
The Department of Homeland Security (DHS), U.S. Citizenship and Immigration Services (IS) administers the nation’s lawful immigration system, safeguarding its integrity and promise by efficiently and fairly adjudicating requests for immigration benefits while protecting Americans, securing the homeland, and honoring our values. The Data and Business Intelligence Section (DBIS) is a program under the Systems Development Division (SDD), Office of Information Technology (OIT), Management Directorate. To support the above mission of IS, the agency needs to have complete oversight of all aspects of its operations, which is mainly supported by the DBIS program through the implementation of operational and analytical reports and data sharing via several Information Technology (IT) systems. The mission of DBIS is two-fold:

  • Provide reporting capability, which includes ad-hoc reporting, canned reports, analytical capabilities via dashboards, data visualization, and statistical analysis and supporting Artificial Intelligence (AI) and Machine Learning (ML) research and development.
  • Provide access to data for interconnected systems that ingest data from other internal systems for operational use via data service Application Programming Interfaces (APIs), web services, or other methods mutually agreed upon.

This important program is expected to lead the development of new and the enhancement of existing capabilities in advanced analytics and reporting of IS data as well as the brokering of data for information technology systems and applications. The development scope of the program involves transforming agency-wide analytical capabilities and enhancing the agency’s ability to use its large data pool for decision-making, operational improvement and predictive analytics. 

Your Impact to the Mission:
VMD is seeking an Infrastructure Lead to provide expert technical leadership to manage, monitor, and ensure the highest level of availability of all operational systems and infrastructure within DBIS. The overarching scope of this contract is to provide the design, architecture, configuration, development, and maintenance of the existing technological solution and enhancement of the analytical capabilities of IS by evolving the legacy environment with 21st century technologies, such as data visualization, no- SQL (Structured Query Language) querying, data analytics for decision-making, big data analytics, open source tools, data science and AI/ML. As the Infrastructure Lead, you will be responsible for: 

  • Leading the infrastructure team in the support of the databases, ETL, BI layer, SAS, and OS, if applicable (in the Cloud), as well as the developed systems components of DBIS.
  • Cooperate with government technical staff in providing O&M support of the production components of eCISCOR, SAS PME, and SMART. Provide technical assistance to either the onsite IT personnel or IT deployment support personnel to resolve failures, and support incident management and problem management activities.
  • Support all tools and infrastructure upgrades and their set up in the Cloud.
  • Support DBIS O&M with coordination of appropriate DHS/IS Data Center support staff and IS OIT Engineering Support to diagnose, trouble shoot and resolve system, network, hardware and software issues.
  • Provide technical expertise and support the DevOps software lifecycle/development methodology.
  • Support DBIS Development teams with Automated deployments technology such as continuous integration, continuous deployment (CI/CD).
  • Enhance system performance thru partitioning, multi-threading, etc. to achieve maximum infrastructure utilization.
  • Troubleshooting data discrepancy and missing data issues including ETL load failures due to resource constraints, missing/invalid data/files, bugs and infrastructure component issues.
  • Evaluate performance degradations and ongoing maintenance involving ETL toolset, OS, File Transfer Protocol (FTP) Servers, Network, Database, Job Scheduler.
  • Set up the governors and event triggers on the database systems to stop runaway queries.
  • Monitor, diagnose, and troubleshoot and resolve, as needed, under-performing OBIEE SMART queries.
  • Execute software upgrades of all environments (development, stage, pre-production, production) for SMART, SAS PME, and eCISCOR, as upgrades are determined to be required;
  • Assist with the preparation and support the development of contingency plans and assist with conducting plan tests, including disaster recovery and Continuity of Operations Plan (COOP) testing, and operation failover testing consisting of documented contingency plans.
  • May be required to develop and/or provide input to contingency plans for IS IT applications.
  • May be required to assist responsible DHS and IS parties in planning and executing Disaster Recovery (DR) for SMART, SAS PME, and eCISCOR system components;
  • Maintain Personal Identity Verification (PIV) system authentication as directed by IS; and
  • Support migrations to new infrastructure (the Cloud).  

Experience Needed to Be Successful:

  • At least 5 years of experience maintaining and administering infrastructure of IT systems comparable to DBIS.
    Strong working knowledge of and experience with the Agile Framework. 
  • Excellent written and verbal communication skills
    Strong leadership and interpersonal skills to facilitate effective collaboration across a variety of stakeholders 

Key environmental elements include:

Informatica: (Extract, Load and Transfer)

  • PowerCenter version [10.2.0 HotFix1], PowerExchange version [10.2.0 HotFix1], Address Doctor version, Data Quality and Data Governance Enterprise Edition version [10.2.0 HotFix1]

Oracle OBIEE (Enterprise Application) SAS® Enterprise, Version 9.4: (Enterprise Application)

  • SAS® VIYA V.03.04, Enterprise Guide, SAS® Studio

Tableau Server 2019.2.0 64-bit Linux: (Enterprise Application) Databricks 3.20: (Unified Data Analytics Platform)

  • Delta Lake, MlFlow, Apache Spark, Apache Airflow, Apache Drill

Amazon Web Services: (Cloud Platform)

  • Data Migration Services (DMS), Kinesis, Lambda, Glue
  • Athena, Dynamo DB, S3 (Simple cloud Storage Service)
  • Amazon Redshift, RDS (Relational Database Service)
  • EC2 (Elastic Compute Cloud), CloudWatch, CloudFormation
  • Cloudbees (Enterprise Jenkins), SNS (Simple Notification Service

Code Base: Oracle 12C and 19C, PostgressSQL, Databricks Scala, Informatica PowerCenter, PL/SQL, SAS and AWS S3, EC2, RDS OS:  RHEL 7/8, CentOS 7, Windows 2k2, Windows 2k6, Windows 2k9 

Desired Qualifications and Skills:

  • Familiarity with AWS/Cloud Technologies
    Familiarity with Databricks, OBIEE, Tableau, and/or SAS
    Experience providing consulting services for IS, another DHS component, or the Federal Government 

Basic Qualifiers:
Education Requirement: Bachelor’s degree in Computer Science or related field
Can Additional Years of Experience Substitute for Degree? No
Required Certification(s): One of: Amazon Web Services, Apache Spark, Big Data, Databricks, Informatica, Oracle Minimum Years of Overall Experience: 7
Minimum Years of Specific Experience in Field: 5
Minimum Clearance to Start: Public Trust
Work Status Allowable:

The Type of Person That Will Excel:

  • You are curious, inquisitive, and have demonstrated a constant eagerness to learn through actions.
  • You have high attention to detail.
  • You demonstrate personal accountability and integrity in all actions.

Travel and Telecommuting:
Travel: None
Telecommute Options: No


Founded in 2002, VMD is an award-winning provider of Agile Software Engineering, Digital Infrastructure, Cybersecurity, and Transportation Security Services to numerous U.S. Federal Government clients including projects across both DoD and Civilian agencies. We specialize in high-level, tip of the spear engagements with a significant impact on mission success for our clients.

Why Join VMD Corp?
VMD fosters a culture that is founded on Eight Core Values and you can watch what our Core Values mean to our Vision Mission Driven employees. 

VMD Employees envision the future. We hold ourselves accountable and hold each other to equally high standards. Our people recognize and reward greatness and are humble in doing so. VMD Employees understand big accomplishments take a team. Our people learn from both our mistakes and successes; we pursue improvement relentlessly, objectively and without bias. We share our thoughts and ideas with purpose and transparency. We commit to the mission, the customer and to each other. We love being nimble and producing results.

Our team is one of the best in the business.

VMD provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable Federal, state and local laws. VMD maintains a drug-free workplace. 

Dice Id : 10112473
Position Id : 6780435
Originally Posted : 3 months ago
Have a Job? Post it