Database Lead / Database Architect (SQL + NoSQL Specialist)

We are seeking a highly skilled and hands-on Database Lead / Architect with expertise across relational, NoSQL, and in-memory databases. This role demands deep technical mastery, particularly with Aerospike 8.0 and / or MongoDB , combined with strong proficiency in traditional RDBMS (Oracle, SQL Server, MySQL, PostgreSQL) and Redis. The candidate must be capable of designing enterprise-scale systems from scratch , implementing advanced business logic in SQL / NoSQL, and ensuring performance, scalability, and high availability.

Responsibilities

Architecture & System Design

Design and lead end-to-end database architectures for high-concurrency, mission-critical applications.

Architect hybrid solutions combining RDBMS, NoSQL (Aerospike 8.0, MongoDB), and Redis for caching.

Implement partitioning, sharding, replication, clustering, and geo-distributed strategies for scalability.

Leverage in-memory indexes and advanced Aerospike 8.0 features (e.g., strong consistency namespaces, secondary indexes, XDR, UDFs).

Apply MongoDB advanced concepts : multi-document transactions, aggregation pipelines, sharding, replica sets, time-series collections.

Database Development & Business Logic

Develop complex business logic using SQL (PL / SQL, T-SQL, PostgreSQL functions, MySQL routines) and NoSQL frameworks.

Write and optimize UDFs, stored procedures, and advanced query pipelines across multiple databases.

Standardize best practices for schema design, indexing, and query optimization.

Performance & Scalability

Conduct deep performance tuning at query, schema, and cluster levels.

Implement in-memory caching strategies (Redis, Aerospike in-memory mode).

Optimize database access patterns for low-latency, high-throughput workloads.

Monitor, analyze, and resolve performance bottlenecks using query analyzers, profiling tools, and cluster metrics .

Leadership & Collaboration

Act as the technical authority for database solutions within the organization.

Lead design reviews, mentor developers, and enforce coding standards.

Collaborate with application architects, data engineers, and DevOps teams to integrate databases seamlessly.

Evaluate emerging database technologies (e.g., NewSQL, cloud-native DBs) and recommend adoption.

Required Skills & Qualifications

RDBMS Expertise : Oracle PL / SQL, MS SQL Server (T-SQL), MySQL, PostgreSQL.

NoSQL Expertise :

Aerospike 8.0 : namespaces, strong consistency, geo-distributed clusters, XDR, UDFs, secondary indexes, hybrid memory models.

MongoDB : replica sets, sharding, aggregation framework, time-series collections, advanced indexing.

In-memory databases : Redis (clustering, pub / sub, streams).

Strong proficiency in partitioning, sharding, clustering, replication, and HA / DR strategies .

Proven track record of designing database systems from scratch for large-scale, real-time applications.

Deep knowledge of performance tuning, query optimization, and indexing strategies .

Preferred Qualifications

Cloud-native database services : AWS (Aurora, DynamoDB, DocumentDB), Azure Cosmos DB, GCP Spanner.

Exposure to streaming platforms (Kafka, Pulsar) and big data ecosystems (Spark, Hadoop).

Knowledge of microservices database integration patterns.

Advanced degree in Computer Science, Information Systems, or related field.