Job ID: JOB_ID_3680
Job Description: Database Architect
We are seeking a highly skilled and experienced Database Architect to join our team. The ideal candidate will be responsible for architecting and executing large-scale database migrations from legacy RDBMS and NoSQL systems to PostgreSQL, MongoDB, and Redis. This role requires deep expertise in data modeling, performance tuning, and high availability strategies across various database technologies.
Key Responsibilities:
- Architect and execute large-scale database migrations from legacy RDBMS and NoSQL systems to PostgreSQL, MongoDB, and Redis.
- Design data models, indexing strategies, partitioning, and sharding for high-volume workloads.
- Lead schema evolution, data transformation, and consistency validation during migrations.
- Design and implement zero downtime / rolling migration strategies.
- Evaluate and select migration tools, custom scripts, and replication-based approaches.
- Define rollback, reconciliation, and disaster recovery strategies.
PostgreSQL Expertise:
- Advanced expertise in query optimization, execution plans, indexing, and performance tuning.
- Experience with logical/physical replication, failover, and HA setups.
- Hands-on with partitioning, vacuum tuning, extensions, and connection pooling.
- Managing large databases (multi TB scale).
MongoDB Expertise:
- Strong expertise in schema design, sharding strategies, and replica sets.
- Experience migrating from relational models to document-based architectures.
- Performance tuning and optimization for read/write intensive workloads.
- Planning and executing online migrations and version upgrades.
Redis Expertise:
- Design and implementation of caching, session management, and messaging patterns.
- Hands-on with persistence models (RDB/AOF), eviction policies, and memory optimization.
- High availability and replication strategies.
Engineering & Platform:
- Design data layers for microservices and distributed systems.
- Collaborate closely with DevOps/SRE teams on monitoring, alerting, backups, and recovery.
- Experience with containerized environments, CI/CD pipelines, and automation.
- Strong understanding of consistency models, concurrency, and transaction semantics.
Leadership Responsibilities:
- Act as architectural owner for data platforms and migration initiatives.
- Mentor and technically guide senior engineers and database specialists.
- Lead design reviews, incident postmortems, and performance tuning efforts.
- Drive engineering best practices and coding standards.
- Partner with product and business stakeholders to align technical solutions with business goals.
This is a contract position with a duration of 6 months. The role requires a deep understanding of database architecture and migration strategies. We are looking for a candidate who can lead complex projects and mentor junior team members.
Special Requirements
None
Compensation & Location
Salary: $120 – $160 per year (Estimated)
Location: Irving, TX
Recruiter / Company – Contact Information
Email: g@sysmind.com
Recruiter Notice:
To remove this job posting, please send an email from
g@sysmind.com with the subject:
DELETE_JOB_ID_3680