Computer Systems Engineer / ITD-CVISN Systems Architect

Required Skills:

Individual proposed must have verifiable working experience in the following;

1. 8 years experience Department of Transportation oversize and overweight permitting rules, regulations, procedures, and

with current oversize and overweight vehicle permitting and routing technologies.

1. 8 years experience Commercial vehicle rules, regulations, registration, permitting, and enforcement processes.
2. 8 years experience with architecture and implementation of CVIEW data exchange and ITD/CVISN Level 1 Compliance

Preferred Not Required:

Operating Systems

• Linux-Advanced-Required-Experience with Linux-based servers including Oracle Linux. General maintenance and troubleshooting of Linux-based servers.

• Solaris / Oracle RAC-Intermediate-Required-Experience with Solaris 11.x operating in an

Oracle RAC environment with Oracle 12cdatabases. Experience with RAC zone

configuration and time synchronization across zones. Experience with Solaris vCPU

configuration. Experience with use of imperf for Solaris network diagnostics.

• Windows-SME-Required-Experience with the installation, maintenance,

upgrade, administration and troubleshooting of any and all aspects of Windows and Linux in

both a physical and virtualized environment, including OS and application issues within the

servers.

• Experience with environments hosting approximately 500 or more Windows and Linux

VMs.

• Experience will include deployment, AD management, provisioning, and troubleshooting

of OS stack issues, such as OS, web server, application and application performance, network, name resolution, storage, security, including certificate installation, management

and other issues as they arise.

• VMware vSphere ESXi / VMware vCenter Server Advanced Required-Experience with the installation, configuration, operations management, troubleshooting and

both onsite and remote repair/upgrade of VMware vCenter instances consisting of multiple

clusters of hosts in a Metro WAN environment, and supported by local, iSCSI and Fibre Channel

block storage systems. Experience solving complex virtualization issues, both with and without VMware support coverage, including VCSA, hypervisor events including PSOD/panics that occur on hosts in a production environment.

• Experience with VMware DRS, host affinity rules, and HA.

• Visual FoxPro SME-Required- Experience with query development, data structures, data export, report generation, and calculation of financial and statistical metrics from Visual FoxPro systems. Responsibilities will include ad-hoc queries and reporting from inhouse developed systems used by the MDOT Permit Division and Financial Management Division, including Automated Permit System (APS). These legacy systems were developed in Visual FoxPro 6 and 7.

• Visual Studio .NET Intermediate-Required-Experience with Visual Studio and Visual Basic

.NET

• Batch/PowerShell/vSpherePowerCLI scripting, file management, diagnostic and systems administration utilities- Advanced-Required-Experience with server and data management

via developed and customized scripts. Experience with Batch, PowerShell and VMware

PowerCLI scripting. Experience with the use of AI tools such as various LLMs for accelerating code development and research. Experience with migration of large quantities 100TB+, 300 million files+ of production data between NAS and SAN storage systems using

scripted file migration. Experience with the use of scripts for systems administration automation, monitoring and alerting. Experience with systems management using CLI, via SSH and SCP.

Experience with a variety of administrative and diagnostic tools such as: Sysinternals tools

including Process Explorer, Sysmon, Robocopy, telnet, hex editing tools, decompilation,

debugging, application and database performance profiling. Use of MediaWiki and markup for systems documentation.

• Dell/EMC Unity, and Isilon block and file storage systems, EMC VPLEX Metro Advanced-Required-Experience with EMC Unity 480F block storage arrays.Experience with synchronous, bi-directionally replicated stretched clusters using EMC VPLEX and cluster witness. Experience with installation, configuration, administration and repair of EMC Isilon Gen 4 and Gen 6 storage systems including Isilon NL400, X400 and later X410, 00 nodes

including expertise with OneFS, SyncIQ, SnapshotIQ, SmartQuotas, Superna Eyeglass cluster management and failover.

Isilon GUI/CLI diagnostics, configuration and upgrade of individual nodes and clusters both

hardware and software. Experience with configuration of Isilon disk and node protection

levels. Experience with Isilon Gen 4 boot drive and disk replacement.

• Cisco and HPE servers and blade systems, Virtual Connect-Advanced-Required Experience with Cisco UCS and HPE DL and BLseries servers, including specification, procurement, operational management, troubleshooting and onsite and remote repair/upgrade of HP servers, blade systems,Virtual Connect infrastructure and FC switches.

• Sun T5-2 and S7-2 servers-Intermediate-Required-Experience configuring Sun Solaris T5-2 and S7-2 servers including ILOM

• Custom-designed and built solidstate Fibre Channel block storage arrays. Custom-designed and built deduplication storage servers-Advanced-Required Experience with the design, sizing, construction, upgrade, repair and performance testing of purpose-built FC SAN block storage systems. Experience with the configuration and use of ESOS. Experience with the design, sizing, construction, upgrade, repair and performance testing/tuning of purpose-built network attached storage systems utilizing inline and post-processing data deduplication.

• Datacenter hardware infrastructure-Advanced-Required-Experience with procurement, planning, management and maintenance of premise datacenter facilities including cabling, cooling, single and three phase uninterruptible power supply systems, monitoring and correcting system failures. Experience with the evaluation of technical specs and sizing of supercapacitor-based UPS systems.

Database Systems/Database Tools

Microsoft SQL Server / SQL Server Management Studio

Level: Intermediate Required Experience Required:

• SQL Server 2012 and later
• User permissions management
• Stored procedures
• Import/export from Visual FoxPro, flat files, and other systems
• Application integration with Veeam, OpenText/Caso ApplicationXtender/AppEnhancer, and other software
• Data deduplication for SQL Server dump repositories
• SQL Server Reporting Services (Report Server)

Oracle 12c 19c Databases, RAC, SQL*Plus

Level: Intermediate Required Experience Required:

• Oracle database maintenance and administration in Windows, Linux, and Solaris environments
• Correction of database and storage issues
• Diagnosis of performance issues
• Disk resizing in virtual machine environments
• Interaction with production Oracle databases
• Use of scripts and SQL*Plus to configure, manage, and verify database server status
• Use and tuning of EXPDP, RMAN backup, and post-processing data deduplication
• Diagnosis and correction of TNS listener issues in RAC environments

OpenText/Caso ApplicationXtender/AppEnhancer with SQL Server

Level: Intermediate Required Experience Required:

• Administration of OpenText/Caso ApplicationXtender/AppEnhancer document management systems
• Management of associated SQL Server databases

Visual FoxPro

Level: SME Required Experience Required:

• Visual FoxPro relational database engine
• Use of VFP SQL to create tables and cursors for data extraction and compilation
• Preparation of statistics, archive document production, and reporting

Sybase

Level: Intermediate Required Experience Required:

• Installation, configuration, and troubleshooting of Sybase DBMS
• Operation in virtualized Linux environments

Systems Architecture / IT Infrastructure

FMCSA CVISN/ITD Architecture

Level: SME Required Experience Required:

• ITD/CVIEW (Commercial Vehicle Information Exchange Window) design
• Multi-agency deployments of FMCSA systems
• OS/OW Permitting, SAFER Data Mailboxes, and other Federal Motor Carrier Safety Administration systems
• Implementation and management of IT projects

IT Infrastructure

Level: Advanced Required Experience Required:

• Fibre Channel (FC) and iSCSI SAN storage environments
• Scale-out NAS storage systems
• Hypervisor systems
• Blade server systems
• Design and construction of custom storage and IT solutions on an ad-hoc basis

MDOTTraffic Streaming Video Infrastructure

Level: Advanced Required Experience Required:

• Streaming traffic video systems, including camera, network, and server diagnostics
• Wowza streaming software (VM-based and Linux hardware-based deployments)
• OpenJDK Java SE JRE configuration
• NGINX caching servers
• Use of in-house diagnostic tools

Application Support Internally Developed and Third-Party Software

OpenText / Caso ApplicationXtender / AppEnhancer

Experience Level: Intermediate
Required Experience:

• Supporting the OpenText/Caso ApplicationXtender/AppEnhancer document management system.
• Working with associated SQL Server databases.

MDOT Financial Management System (FMS)

Experience Level: Intermediate
Required Experience:

• Supporting financial management systems running in an Oracle 12c RAC environment on Sun hardware with Solaris 11.
• Familiarity with modifying legacy C++ code to maintain and update the existing codebase.
• Experience compiling C++ source files to object code, including compiling and linking C++ files in a Sun Solaris 11.4 / Oracle 12c environment using Solaris Studio 12.4.
• Experience with Oracle 11g/12c, Solaris 11.3/11.4, C++, and COBOL (interactive and batch). processing financial management systems and upgrade procedures. Emergency failover of RAC, VPLEX shared storage Solaris based Oracle 12c database

Internally Developed Software SME

Required Experience:

• Implementing new development, test, and production .NET software environments, as well as supporting legacy production systems.
• Performing code-level maintenance and generating reports for Visual FoxPro based full client applications.

Data Protection and Recovery

Veeam Backup and Recovery Advanced

Required Experience:

• Supporting Veeam Backup and Recovery software deployed across a statewide network.
• Installing, upgrading, and troubleshooting backup job failures for Windows and Linux VMs, SAN and NAS storage repositories, compute, hypervisor, security, name resolution, and network components.
• Installing and configuring Veeam in a WAN environment.
• Creating, managing, scheduling, and troubleshooting Veeam disk-to-disk and Veeam disk-to-LTO tape backup jobs.

Data Deduplication Advanced

Required Experience:

• Designing, sizing, and using storage repositories with post-processing deduplication for 100TB+ SQL, Oracle, and other production system backup datasets.
• Identifying optimal candidate data sets for deduplication.

Data Replication Advanced

Required Experience:

• Performing data replication involving both block and file data migration.
• Creating and maintaining Isilon OneFS SyncIQ replication jobs.
• Executing one-time and recurring replication of large-scale (100TB+) production file data and permissions using Robocopy.

Enterprise Software Licensing and Support Contract Analysis SME

Required Experience:

• Evaluating complex enterprise-level software licensing and maintenance/support agreements.
• Developing cost-benefit models and break-even financial analyses for subscription and perpetual licenses for both cloud-based and on-premise products, supporting decision-making and procurement recommendations.
• Assessing licensing costs for Microsoft Enterprise Agreement (EA) and Software Assurance (SA) across a variety of server and workstation products.
• Understanding and evaluating Oracle licensing requirements, including CPU isolation considerations in virtualized environments.

IT Systems Infrastructure Diagnostics, Performance, and Security

Application Advanced

Required Experience:

• Application development and testing, including QA, performance, and security evaluation.
• Diagnosing OS, web server, application-level, and database performance issues to identify and correct problems in both internally developed and third-party hardware and software systems.

Network Advanced

Required Experience:

• Performing diagnostic testing and compiling performance metrics over private and public networks to correct issues and improve application usability over both high- and low-bandwidth circuits.
• Experience with VLANs, trunks, EtherChannel, LACP, switched and routed networks, and persistent tunnels.
• Understanding and analyzing protocols such as TCP, UDP, ICMP, HTTP, FTP, SMB/CIFS, NFS.
• Using diagnostic and packet capture tools including (but not limited to) Ethereal, Wireshark, MRTG/PRTG, Elasticsearch, and Logstash.

Security Advanced

Required Experience:

• Using network, hardware, OS, and application-layer security compliance tools and processes to harden internal and external systems and meet periodic external audit requirements.
• Conducting internal and external penetration testing.
• Working with IDS, IPS, and firewalls.
• Implementing least-privilege systems administration, including port restrictions, Active Directory security groups, GPOs, shares, ACLs, and other permission models.

OS Diagnostic and Performance Testing Tools and Processes Advanced

Required Experience:

• Performing diagnostics, testing, and performance tuning on Linux and Windows operating systems.
• Tuning and optimizing provisioned system resources including disk, CPU, RAM, and network components.

PKI Infrastructure Advanced

Required Experience:

• Installing and maintaining TLS certificates in environments such as Windows IIS, SQL Server Reporting Services, and Windows- and Linux-based web servers.
• Implementing and administering an enterprise root Certificate Authority (CA).