Position Overview

We are seeking a Database Engineer to design, optimize, and maintain the critical database infrastructure that powers NexusAI. This role focuses on building highly performant, scalable, and reliable databases that support real-time analytics, AI/ML model deployment, and seamless integrations with enterprise systems such as TMS, WMS, and ERP.

Key Responsibilities

• Database Design & Architecture

  • Design and implement relational and non-relational database systems to support NexusAI’s data needs, ensuring scalability and performance across large datasets.

  • Develop and maintain data models that enable real-time analytics, AI predictions, and Digital Twin functionality.

  • Architect robust ETL pipelines for ingesting, transforming, and storing structured and unstructured data from diverse sources.

• Performance Tuning & Optimization

  • Optimize database queries, indexes, and schema design to ensure low-latency and high-throughput performance.

  • Implement partitioning, sharding, and caching strategies to efficiently handle massive data volumes.

  • Monitor and troubleshoot database performance, identifying and resolving bottlenecks in real time.

• Data Management & Integration

  • Integrate data from TMS, WMS, ERP, and third-party systems into centralized data warehouses and data lakes.

  • Collaborate with data scientists and ML engineers to structure datasets for AI/ML model training and real-time decision-making.

  • Manage data pipelines for streaming and batch processing, ensuring accuracy and consistency of data across the platform.

• Database Administration

  • Implement best practices for data security, governance, and disaster recovery in line with enterprise-grade standards.

  • Ensure compliance with data privacy regulations (e.g., HIPAA, GDPR) for sensitive datasets.

  • Perform routine database maintenance, including backups, updates, and version control.

• Collaboration & Support

  • Work closely with software engineers, data scientists, and DevOps teams to align database architecture with application requirements.

  • Support the deployment of real-time dashboards, data visualizations, and predictive models by ensuring data availability and reliability.

  • Document database designs, processes, and workflows to enable knowledge sharing across the team.

• Innovation & Continuous Improvement

  • Evaluate and implement emerging database technologies, tools, and frameworks to enhance platform capabilities.

  • Continuously optimize database systems to meet growing data demands and evolving business needs.

Qualifications

Required:

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field.

• 5+ years of experience designing, developing, and managing large-scale databases for enterprise applications.

• Expertise in SQL-based relational databases (e.g., PostgreSQL, MySQL, SQL Server) and NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB).

• Strong experience building and managing data pipelines for ETL processes.

• Proficiency in query optimization, indexing, and performance tuning for large, complex datasets.

• Hands-on experience with cloud database services (AWS RDS, Aurora, Redshift, Azure SQL, Google BigQuery).

• Knowledge of data warehousing and data lake architectures for scalable analytics.

• Solid understanding of data security, governance, and backup/recovery best practices.

Preferred:

• Experience with big data frameworks (e.g., Apache Spark, Hadoop, Kafka) for real-time data processing.

• Familiarity with enterprise systems like TMS, WMS, and ERP, and integrating these into centralized databases.

• Knowledge of AI/ML pipelines and structuring data for model development and real-time predictions.

• Experience working in a SaaS environment with multi-tenant architectures.

• Understanding of regulatory compliance standards such as HIPAA (for healthcare) and GDPR.

Why Join NexStratus?