Deloitte US

We are seeking a Database Engineer Contractor to design, develop, and optimize database systems that support data storage, retrieval, and analysis. This role will be central to a migration program moving an on-prem IBM DB2 database to AWS PostgreSQL (raw/landing layer) and then to AWS-hosted MongoDB (transaction cache/consumption layer) using Precisely and Kafka pipelines. You will also help model and architect the target MongoDB solution and ensure secure, performant, reliable data flows for downstream applications.

Key Responsibilities

• Design and construct large-scale relational databases and schemas in PostgreSQL to meet project requirements (raw/landing layer).
• Support migration from on-prem DB2 to AWS PostgreSQL, including source-to-target mapping, data reconciliation, and cutover support.
• Develop and maintain data integration processes leveraging Precisely and Kafka (e.g., CDC/streaming ingestion) into PostgreSQL and onward to MongoDB.
• Design MongoDB collections, document models, indexing, partitioning/sharding approach (if needed), and read/write patterns to support a transaction cache for downstream apps.
• Apply transformation rules to raw data to produce “friendly” canonical formats for MongoDB consumption (including versioning and backward compatibility where needed).
• Tune PostgreSQL and MongoDB performance (query optimization, indexing strategies, connection pooling, caching, vacuum/analyze, and capacity planning).
•  Implement regular validation checks, reconciliations, and data quality controls (completeness, accuracy, latency, duplicates, referential/cross-entity consistency).
• Implement and enforce database security measures—access controls, encryption in transit/at rest, secrets management, audit logging, and least-privilege patterns.
• Establish monitoring/alerting for pipelines and databases (throughput, lag, error rates, replication health, disk/CPU/memory), and support incident triage/root-cause analysis.
• Produce architecture diagrams, data models, runbooks, and operational SOPs; partner with app teams to ensure consumption patterns are efficient and reliable.

Required Qualifications

• 5+ years (or equivalent) hands-on experience as a Database Engineer / Data Engineer supporting production systems.
• Strong experience with PostgreSQL (schema design, indexing, query tuning, performance troubleshooting).
• Strong experience with MongoDB (document modeling, aggregation framework, indexing, TTL patterns, performance tuning; sharding knowledge a plus).
• Experience migrating from legacy/on-prem RDBMS (preferably IBM DB2) to cloud databases, including data validation and reconciliation.
• Experience with Kafka-based data pipelines and streaming/CDC concepts (topics, partitions, consumers, delivery semantics, ordering, replay).
• Ability to design robust transformation logic and data contracts for downstream consumption.
• Strong understanding of database security fundamentals and operational monitoring.

Preferred Skills

• Hands-on experience with Precisely tooling (Connect/Replicate or similar) for CDC/integration.
• AWS experience (networking basics, IAM, security groups, CloudWatch monitoring; managed database services experience is a plus).
• Experience designing “raw → curated/consumer” data patterns and data lifecycle management (retention, TTL, archival).
• Familiarity with DevOps practices (CI/CD for database changes, Infrastructure-as-Code exposure, automated testing for data).

The expected pay range for this contract assignment is $ 60 - $ 65 per hour.  The exact pay rate will vary based on skills, experience, and location and will be determined by the third-party whose employees provide services to Deloitte.   

Candidates interested in applying for this opportunity must be geographically based in the United States and must be legally authorized to work in the United States without the need for employer sponsorship.

We do not accept agency resumes and are not responsible for any fees related to unsolicited resumes. 

Deloitte is not the employer for this role.  

This work is contracted through a third-party whose employees provide services to Deloitte. 

#LI-AR8

#Remote