What are the responsibilities and job description for the NoSQL/SQL Database Engineer position at Amtex Systems Inc?
Title: NoSQL/SQL Database Engineer
Location: Remote
Duration: Full Time
Position Summary:
As a NoSQL/SQL Database Engineer specializing in IoT, you will be responsible for designing, implementing, and maintaining both structured and unstructured databases that drive our IoT applications. You will collaborate with cross-functional teams, including IoT engineers, data scientists, and software developers, to ensure optimal performance and scalability of IoT data storage systems. Your role will also involve monitoring and enhancing the security, integrity, and accessibility of data across diverse NoSQL and SQL platforms.
Key Responsibilities:
- Design, implement, and maintain databases (both NoSQL and SQL) to manage large-scale IoT data streams.
- Develop data models to handle structured, semi-structured, and unstructured data for IoT devices and applications.
- Optimize database performance to handle high-throughput IoT data ingestion and processing.
- Collaborate with IoT and cloud engineers to implement data pipelines that support real-time analytics, predictive maintenance, and smart automation.
- Ensure the integrity, security, and availability of IoT data across multiple databases and cloud platforms.
- Troubleshoot and resolve issues related to database performance, data storage, and query execution.
- Develop and implement backup, recovery, and disaster recovery strategies for critical IoT systems.
- Work closely with the software development team to integrate IoT data into broader application ecosystems.
- Create and manage documentation for database design, data flows, and schema modifications.
- Stay updated on emerging trends and technologies in IoT, big data, and database management.
Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or a related field.
- 3 years of experience working with NoSQL databases such as MongoDB, Cassandra, Cosmos DB, or Couchbase.
- Strong experience with SQL databases such as PostgreSQL, MySQL, or SQL Server.
- Experience working with IoT systems, handling large-scale data ingestion, and real-time data streams.
- Proficiency in database scripting languages like SQL, PL/SQL, or T-SQL.
- Experience with cloud platforms (e.g., AWS, Azure, GCP) and data storage solutions like DynamoDB, Azure Cosmos DB, or Google Bigtable.
- Hands-on experience with data modeling, query optimization, and performance tuning.
- Familiarity with Kafka, RabbitMQ, or other messaging systems for IoT data ingestion.
- Understanding of microservices architecture and RESTful API integration.
- Experience with monitoring tools (e.g., Grafana, Prometheus) to manage and optimize database health and performance.
- Strong problem-solving skills and the ability to work collaboratively in a fast-paced environment.
- Knowledge of IoT protocols like MQTT, CoAP, or Zigbee is a plus.
Preferred Skills:
- Experience with AI/ML-driven IoT analytics.
- Familiarity with containerization technologies (e.g., Docker, Kubernetes).
- Understanding of data security best practices for IoT systems.
- Certifications in AWS, Azure, or other cloud services relevant to IoT.