Overview
Job Description:
As a Database Expert you will be responsible for the design, development, and management of the database infrastructure supporting a tracking system. Your role will involve ensuring data integrity, availability, and security to facilitate real-time tracking and monitoring of cargo shipments.
Key Responsibilities:
Database Design and Architecture: Collaborate with project stakeholders to define database requirements and design the database schema, data models, and data storage strategies for the electronic cargo tracking system. Ensure scalability, performance, and reliability of the database architecture to support growing data volumes and user requirements.
Database Development and Implementation: Develop database applications, scripts, and stored procedures to implement business logic, data validation rules, and data transformation processes within the tracking system. Optimize database queries and indexing strategies to enhance performance and response times.
Data Integration and ETL: Implement Extract, Transform, Load (ETL) processes to integrate data from various sources, including IoT sensors, GPS devices, and external systems, into the tracking system’s database. Develop data pipelines and workflows to automate data ingestion, cleansing, and transformation tasks.
Data Security and Compliance: Implement security measures to protect sensitive cargo information stored in the database from unauthorized access, data breaches, and cyber threats. Define access controls, encryption mechanisms, and auditing policies to ensure compliance with regulatory requirements and industry standards.
Database Administration and Maintenance: Monitor database performance, health, and availability using monitoring tools and performance metrics. Perform routine maintenance tasks, such as database backups, recovery, and software upgrades, to ensure data integrity and system reliability.
Data Analytics and Reporting: Develop data analytics solutions and reporting dashboards to provide insights into cargo tracking metrics, trends, and anomalies. Design data visualizations and interactive reports to facilitate decision-making and business intelligence analysis for stakeholders.
Collaboration and Communication: Collaborate with cross-functional teams, including developers, system administrators, and business analysts, to coordinate database-related activities and resolve technical challenges. Communicate effectively with project stakeholders to provide updates on database design, development, and performance.
Documentation and Knowledge Sharing: Maintain documentation of database schemas, data dictionaries, and technical specifications to support system documentation and knowledge sharing efforts. Provide training and guidance to team members on database best practices, optimization techniques, and troubleshooting methods.
Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or a related field. Master’s degree or relevant certifications (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator) preferred.
Proven experience as a database developer, database administrator, or data engineer, with expertise in designing and managing enterprise-level databases.
Proficiency in database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL) and database development tools (e.g., SQL Developer, SSMS, pgAdmin).
Strong SQL programming skills and experience with database query optimization, performance tuning, and indexing strategies.
Knowledge of data integration techniques, ETL tools (e.g., Informatica, Talend), and data warehousing concepts.
Familiarity with data security principles, encryption algorithms, and regulatory compliance standards (e.g., GDPR).
Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database) and NoSQL databases (e.g., MongoDB, Cassandra) is a plus.
Excellent analytical, problem-solving, and communication skills, with the ability to work effectively in a collaborative team environment.
How to Apply:
Those who fit the criteria listed above and are interested are invited to submit their curriculum vitae, cover letter, and academic transcripts to careers@orchidhr.co.ke. Kindly make sure your email subject line says “Database Analyst Application.”
Deadline: Applications must be received by April 8, 2024. Only those who have been shortlisted will get communication.
