Database Lead / Database Architect (SQL + NoSQL Specialist)

As a highly skilled and hands-on Database Lead / Architect, your expertise across relational, NoSQL, and in-memory databases is crucial for designing enterprise-scale systems from scratch, implementing advanced business logic, and ensuring performance, scalability, and high availability. Your deep technical mastery is particularly required in Aerospike 8.0 and/or MongoDB, along with proficiency in traditional RDBMS (Oracle, SQL Server, MySQL, PostgreSQL) and Redis. **Key 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. - Apply MongoDB advanced concepts like multi-document transactions, aggregation pipelines, sharding, replica sets, and time-series collections. - **Database Development & Business Logic** - Develop complex business logic using SQL 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. - 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. - Evaluate emerging database technologies and recommend adoption. **Qualifications Required:** - **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). - **Other Skills** - 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. (Note: No additional details of the company were provided in the job description.),