Senior Data / Database Engineer - Integration & Middleware Engineer (Ref: 5801)
Estradaci
·Yesterday
- Location
- Los Angeles, California, US
- Type
- Contract
- Department
- Engineering
- Seniority
- Mid
- Source
- BetterTeam
Description
Senior Data / Database Engineer – Integration & Middleware Engineer (Ref: 5801)
W2 Contract | Long-Term Engagement (2–5+ Years)
Criminal Justice / Public Safety Systems
Criminal Justice / Public Safety Systems
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 incriminal justice, law enforcement, courts, corrections, public safety, or comparable government information systems.
Position Overview:
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.
Key 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.
Core Technical Experience: Candidates should have substantial hands-on experience with a combination of the following:
- Oracle Database / Oracle 19c.
- SQL and PL/SQL.
- Enterprise database and data-warehouse environments.
- Complex relational data models.
- Database development and performance optimization.
- High-volume data processing.
- Enterprise data integration.
- Middleware and message-broker technologies.
- Message queues / queued data processing.
- Near-real-time and batch integrations.
- Data ingestion and transformation.
- Enterprise application interfaces.
- API and/or service-based integrations.
- ETL/data-processing solutions.
- Data validation, reconciliation, and error handling.
- Production monitoring and troubleshooting.
- UNIX / IBM AIX environments.
- Shell scripting and production automation.
- Enterprise application servers and middleware.
- Oracle WebLogic and/or IBM WebSphere.
- Source control, release management, testing, deployment, and structured SDLC processes..
- Highly Desired Technologies / Systems
Candidates should clearly identify experience with any of the following:
- PIX / Cloverleaf (Proactive Information Exchange).
- Cloverleaf Integration Engine.
- IBM Master Data Management (IBM MDM).
- CCHRS – Consolidated Criminal History Reporting System.
- CA DOJ Adult Criminal History System (ACHS).
- Justice Data Interface Controller (JDIC).
- JDIC Sender / Listener processing.
- Oracle 19c.
- IBM AIX.
- WebLogic.
- WebSphere.
- Qlik.
- C / Pro*C.
- Message-oriented middleware.
- Enterprise service integration.
- Data queues / datagram processing.
- Master data management.
- Identity/entity matching and resolution.
- High-volume batch processing.
- Near-real-time data exchanges.
- Criminal Justice / Public Safety Domain Experience.
- Direct criminal-justice or public-safety data integration experience is highly preferred.
Relevant environments may include:
- Criminal history repositories.
- Law-enforcement information systems.
- Sheriff and police systems.
- Arrest and booking systems.
- Jail-management systems.
- District Attorney / prosecution systems.
- Court case-management systems.
- Probation systems.
- Corrections systems.
- State Department of Justice interfaces.
- RAP-sheet / criminal-history processing.
- Warrant information.
- Court disposition and sentencing data.
- Multi-agency justice information exchanges.
- Criminal-justice data warehouses.
- Identity matching and subject consolidation.
- Experience integrating data from multiple independent justice agencies into a centralized criminal-history or justice-information environment is particularly valuable.
Integration / Middleware Experience: The ideal candidate will have 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.
Relevant experience includes:
- Message-broker architecture.
- Publish/subscribe integration.
- Message queues.
- Near-real-time messaging.
- Asynchronous processing.
- Data/event subscriptions.
- Interface engines.
- Message transformation and routing.
- Data mapping.
- Failed-message investigation and reprocessing.
- Queue monitoring.
- Interface monitoring.
- Batch and scheduled integration.
- Data reconciliation.
- Integration logging and auditing.
- External agency data exchanges.
- Experience with Cloverleaf or another enterprise integration/message engine should be clearly identified on the resume.
Data / Database Engineering Experience: Candidates should demonstrate significant experience with:
- Enterprise Oracle databases.
- SQL and PL/SQL development.
- Complex stored database logic.
- Data warehouse architecture.
- Database schemas and data models.
- High-volume transactional and analytical data.
- Query and database performance tuning.
- Data quality and validation.
- Data consolidation.
- Data transformation.
- Master data.
- Entity/identity resolution.
- Database troubleshooting.
- Production database support.
- Data migration and conversion.
- Batch-processing workflows.
- Data retention and historical information.
Production Support / M&O Experience: Because this is an established mission-critical system environment, candidates must be comfortable performing maintenance and operations (M&O)rather than exclusively new development.
Candidates should have experience:
- Supporting mature enterprise applications and databases in production.
- Troubleshooting complex production incidents.
- Performing root-cause analysis.
- Supporting legacy and current technologies simultaneously.
- Diagnosing data and interface problems across multiple systems.
- Monitoring production jobs, interfaces, queues, databases, and middleware.
- Correcting or reprocessing failed data transactions.
- Supporting upgrades, patches, deployments, and configuration changes.
- Working within formal incident, problem, change, and release-management processes.
- Supporting systems where availability, accuracy, security, and data integrity are critical.
Preferred Qualifications:
- 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.
Preferred Government Experience:
- Candidates with experience supporting Los Angeles County, California state or local government, CA DOJ, law enforcement, courts, probation, corrections, or other criminal-justice/public-safety agencies are strongly encouraged to apply.
- Prior direct experience with CCHRS, PIX/Cloverleaf, JDIC, CA DOJ ACHS, IBM MDM, or comparable criminal-history data integration environments is especially valuable.
Engagement:
- Employment Type: W2 Contract.
- Duration: Long-term engagement anticipated; approximately 2–5+ years.
- Candidates must be able to successfully complete required background and security screening.
- Some production maintenance, deployments, upgrades, patches, or emergency support activities may occur outside normal business hours, including evenings or weekends.
Skills
SQLOracleData EngineeringETLProject Management
