Senior Data / Database Engineer - Integration & Middleware Engineer (Ref: 5801)

Estrada Consultingorporated•Los Angeles, CA

About The Position

Estrada Consulting, Inc. (ECI) is seeking an experienced Senior Data / Database Engineer – Integration & Middleware Engineer for a long-term W2 consulting engagement supporting a large-scale, mission-critical criminal justice information system environment. This is a senior hands-on technical position combining data engineering, database engineering, systems integration, middleware, data exchange, troubleshooting, and production support responsibilities. This is not a traditional database administration-only position. The successful candidate should have extensive experience supporting complex enterprise data environments in which information is received from numerous source systems, transmitted through middleware/message-broker technologies, processed through data queues and interfaces, consolidated within enterprise databases/data warehouses, and distributed to downstream applications and external systems. Strong preference will be given to candidates with experience in criminal justice, law enforcement, courts, corrections, public safety, or comparable government information systems. The selected consultant will support the data, database, integration, and middleware components of an enterprise criminal-history reporting environment. The environment processes high-volume and near-real-time information received from multiple criminal-justice source systems, including arrest/booking, prosecution, court, disposition, probation, custody, warrant, and statewide criminal-history information. The consultant will maintain, troubleshoot, enhance, and support databases, data interfaces, middleware, message processing, data queues, batch processes, data-consolidation processes, and external system integrations.

Requirements

Substantial hands-on experience with Oracle Database / Oracle 19c.
Substantial hands-on experience with SQL and PL/SQL.
Substantial hands-on experience with Enterprise database and data-warehouse environments.
Substantial hands-on experience with Complex relational data models.
Substantial hands-on experience with Database development and performance optimization.
Substantial hands-on experience with High-volume data processing.
Substantial hands-on experience with Enterprise data integration.
Substantial hands-on experience with Middleware and message-broker technologies.
Substantial hands-on experience with Message queues / queued data processing.
Substantial hands-on experience with Near-real-time and batch integrations.
Substantial hands-on experience with Data ingestion and transformation.
Substantial hands-on experience with Enterprise application interfaces.
Substantial hands-on experience with API and/or service-based integrations.
Substantial hands-on experience with ETL/data-processing solutions.
Substantial hands-on experience with Data validation, reconciliation, and error handling.
Substantial hands-on experience with Production monitoring and troubleshooting.
Substantial hands-on experience with UNIX / IBM AIX environments.
Substantial hands-on experience with Shell scripting and production automation.
Substantial hands-on experience with Enterprise application servers and middleware.
Substantial hands-on experience with Oracle WebLogic and/or IBM WebSphere.
Substantial hands-on experience with Source control, release management, testing, deployment, and structured SDLC processes.
Extensive professional experience in data engineering, database engineering, systems integration, middleware engineering, or related enterprise technology roles.
Senior-level hands-on Oracle SQL/PLSQL experience.
Significant experience supporting complex production/M&O environments.
Experience with message-oriented middleware and enterprise integration platforms.
Experience with IBM MDM or comparable master-data-management technology.
Experience with AIX/UNIX-based enterprise systems.
Experience supporting government or other highly regulated systems.
Experience working with sensitive or restricted information.
Strong analytical and production-troubleshooting capabilities.
Ability to understand complex existing data flows and integrations with limited documentation.
Strong written and verbal communication skills.
Candidates must be able to successfully complete required background and security screening.

Nice To Haves

Experience with PIX / Cloverleaf (Proactive Information Exchange).
Experience with Cloverleaf Integration Engine.
Experience with IBM Master Data Management (IBM MDM).
Experience with CCHRS – Consolidated Criminal History Reporting System.
Experience with CA DOJ Adult Criminal History System (ACHS).
Experience with Justice Data Interface Controller (JDIC).
Experience with JDIC Sender / Listener processing.
Experience with Oracle 19c.
Experience with IBM AIX.
Experience with WebLogic.
Experience with WebSphere.
Experience with Qlik.
Experience with C / ProC.
Experience with Message-oriented middleware.
Experience with Enterprise service integration.
Experience with Data queues / datagram processing.
Experience with Master data management.
Experience with Identity/entity matching and resolution.
Experience with High-volume batch processing.
Experience with Near-real-time data exchanges.
Direct criminal-justice or public-safety data integration experience.
Experience with Criminal history repositories.
Experience with Law-enforcement information systems.
Experience with Sheriff and police systems.
Experience with Arrest and booking systems.
Experience with Jail-management systems.
Experience with District Attorney / prosecution systems.
Experience with Court case-management systems.
Experience with Probation systems.
Experience with Corrections systems.
Experience with State Department of Justice interfaces.
Experience with RAP-sheet / criminal-history processing.
Experience with Warrant information.
Experience with Court disposition and sentencing data.
Experience with Multi-agency justice information exchanges.
Experience with Criminal-justice data warehouses.
Experience with Identity matching and subject consolidation.
Experience integrating data from multiple independent justice agencies into a centralized criminal-history or justice-information environment.
Experience supporting environments in which data is published from multiple source systems to an enterprise integration or message-broker platform and subsequently consumed by centralized applications.
Experience with Message-broker architecture.
Experience with Publish/subscribe integration.
Experience with Message queues.
Experience with Near-real-time messaging.
Experience with Asynchronous processing.
Experience with Data/event subscriptions.
Experience with Interface engines.
Experience with Message transformation and routing.
Experience with Data mapping.
Experience with Failed-message investigation and reprocessing.
Experience with Queue monitoring.
Experience with Interface monitoring.
Experience with Batch and scheduled integration.
Experience with Data reconciliation.
Experience with Integration logging and auditing.
Experience with External agency data exchanges.
Experience with Cloverleaf or another enterprise integration/message engine.
Experience with Enterprise Oracle databases.
Experience with SQL and PL/SQL development.
Experience with Complex stored database logic.
Experience with Data warehouse architecture.
Experience with Database schemas and data models.
Experience with High-volume transactional and analytical data.
Experience with Query and database performance tuning.
Experience with Data quality and validation.
Experience with Data consolidation.
Experience with Data transformation.
Experience with Master data.
Experience with Entity/identity resolution.
Experience with Database troubleshooting.
Experience with Production database support.
Experience with Data migration and conversion.
Experience with Batch-processing workflows.
Experience with Data retention and historical information.
Experience supporting mature enterprise applications and databases in production.
Experience troubleshooting complex production incidents.
Experience performing root-cause analysis.
Experience supporting legacy and current technologies simultaneously.
Experience diagnosing data and interface problems across multiple systems.
Experience monitoring production jobs, interfaces, queues, databases, and middleware.
Experience correcting or reprocessing failed data transactions.
Experience supporting upgrades, patches, deployments, and configuration changes.
Experience working within formal incident, problem, change, and release-management processes.
Experience supporting systems where availability, accuracy, security, and data integrity are critical.
Experience supporting Los Angeles County, California state or local government, CA DOJ, law enforcement, courts, probation, corrections, or other criminal-justice/public-safety agencies.
Prior direct experience with CCHRS, PIX/Cloverleaf, JDIC, CA DOJ ACHS, IBM MDM, or comparable criminal-history data integration environments.

Responsibilities

Serve as a senior hands-on Data/Database and Integration/Middleware Engineer supporting mission-critical enterprise production systems.
Support enterprise database and data-warehouse environments used for high-volume criminal-justice data processing and reporting.
Design, develop, maintain, troubleshoot, and optimize complex database solutions.
Develop and support Oracle SQL and PL/SQL, stored procedures, functions, packages, triggers, queries, and database-processing logic.
Support Oracle 19c or comparable enterprise Oracle database environments.
Analyze and optimize database performance, queries, indexing, data access, and high-volume transaction-processing workloads.
Support complex data-consolidation, matching, linking, merging, and master-data processing.
Design, develop, maintain, and troubleshoot interfaces between multiple upstream and downstream enterprise systems.
Support near-real-time and batch data integration across multiple applications and agencies.
Maintain and troubleshoot message brokers, middleware, data queues, messaging interfaces, and event-driven data processing.
Analyze message/data failures and trace transactions across source systems, middleware, queues, databases, and downstream applications.
Support data ingestion and transformation of diverse data structures received from external systems.
Develop and maintain interface-processing and data-validation routines.
Support enterprise master data management (MDM) and entity/identity resolution processes.
Troubleshoot data discrepancies, failed transactions, duplicate or unmatched records, interface failures, and synchronization issues.
Support middleware and application-server environments associated with enterprise integrations.
Support integration with external government and criminal-justice systems.
Perform root-cause analysis of complex production issues spanning database, application, middleware, operating-system, network, and external-interface layers.
Support production monitoring, logging, alerting, error handling, recovery, and operational troubleshooting.
Participate in application/database upgrades, patches, deployments, configuration changes, performance tuning, and technology refreshes.
Develop scripts and utilities supporting data processing, interfaces, monitoring, automation, and operational support.
Support scheduled production jobs, background processes, batch processing, and high-volume data exchanges.
Maintain technical documentation including database designs, data flows, interface specifications, data mappings, operational procedures, deployment documentation, and troubleshooting guides.
Work closely with application developers, technical leads, DBAs, infrastructure engineers, business analysts, project management, County technical personnel, and external agency stakeholders.
Participate in scheduled after-hours or weekend maintenance, deployments, upgrades, and production activities when required.