Infrastructure Lead

Infrastructure Lead

25 Feb 2024
Washington, Washington 00000 Washington USA

Infrastructure Lead

Vacancy expired!

Job Description

Your Impact to the Mission:

VMD is seeking an

Infrastructure Leadto 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 USCIS 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/USCIS Data Center support staff and USCIS 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 USCIS IT applications.
  • May be required to assist responsible DHS and USCIS 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 USCIS; and
  • Support migrations to new infrastructure (the Cloud).

Qualifications

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:

COTS:
Informatica: (Extract, Load and Transfer)

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

Oracle OBIEE 12.2.1.4.0: (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 USCIS, 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:

US Citizen

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

Additional Information

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.

Job Details

Jocancy Online Job Portal by jobSearchi.