Estrada Consulting Incorporated
Senior Data / Database Engineer – Integration & Middleware Engineer (Ref: 5801)
Los Angeles, California•Contract
About the Job
Senior Data / Database Engineer – Integration & Middleware Engineer (Ref: 5801)
W2 Contract | Long-Term Engagement (2–5+ Years)
Criminal Justice / Public Safety Systems
Estrada Consulting, Inc. (ECI) is seeking an experiencedSenior Data / Database Engineer – Integration & Middleware Engineerfor 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 combiningdata engineering, database engineering, systems integration, middleware, data exchange, troubleshooting, and production supportresponsibilities.
This isnot 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.
Criminal Justice / Public Safety Systems
Estrada Consulting, Inc. (ECI) is seeking an experiencedSenior Data / Database Engineer – Integration & Middleware Engineerfor 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 combiningdata engineering, database engineering, systems integration, middleware, data exchange, troubleshooting, and production supportresponsibilities.
This isnot 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.
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:
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:
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 withCloverleaf or another enterprise integration/message engineshould 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 performingmaintenance and operations (M&O)rather than exclusively new development.
Candidates should have experience:
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 supportingLos Angeles County, California state or local government, CA DOJ, law enforcement, courts, probation, corrections, or other criminal-justice/public-safety agenciesare strongly encouraged to apply.
Prior direct experience withCCHRS, PIX/Cloverleaf, JDIC, CA DOJ ACHS, IBM MDM, or comparable criminal-history data integration environmentsis especially valuable.
Prior direct experience withCCHRS, PIX/Cloverleaf, JDIC, CA DOJ ACHS, IBM MDM, or comparable criminal-history data integration environmentsis 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.