Job Title: MS SQL Database Administrator & SQL Developer
Location: Mumbai, Maharashtra, India
Job Type: Full-Time
Department: IT / Software Development
Reporting To: Head – IT / Technology Lead
Position Overview
We are seeking a skilled and proactive MS SQL Database Administrator and SQL Developer to support our growing logistics technology infrastructure. This dual-role position is critical in ensuring the reliability, performance, and scalability of our databases and business-critical applications.
The ideal candidate will play a key role in managing and optimizing large volumes of operational data including trip logs, route data, vehicle telemetry, fuel transactions, contractor payments, invoicing, and regulatory reports. A deep understanding of logistics workflows and data dependencies is essential.
Key Responsibilities
1. Database Administration (MS SQL Server)
-
Install, configure, and maintain Microsoft SQL Server instances (including high availability, disaster recovery, backups, and clustering).
-
Monitor database performance, tune queries, and optimize indexes to support real-time logistics applications.
-
Manage user roles, permissions, and security policies to ensure data integrity and compliance.
-
Ensure database uptime and reliability across operational environments (production, staging, and development).
-
Develop and manage backup strategies, disaster recovery plans, and data archival policies.
-
Schedule and manage SQL Server Agent jobs, replication, and linked servers.
2. SQL Development
-
Write complex T-SQL queries, stored procedures, triggers, views, and functions to support application logic and reporting needs.
-
Collaborate with software developers to create and optimize data-driven backend components for route planning, freight invoicing, vehicle scheduling, driver tracking, etc.
-
Design and maintain ETL processes to integrate data from GPS devices, fuel cards, ERP systems, and third-party logistics platforms.
-
Generate dynamic operational and financial reports for fleet performance, vehicle utilization, trip summaries, and KPI dashboards.
3. Logistics-Specific Data Management
-
Develop and maintain normalized and de-normalized data models tailored for logistics operations.
-
Implement logic for trip-based cost allocation, multi-party billing, and real-time location-based data aggregation.
-
Manage geospatial data for route analytics, fuel usage patterns, and time/distance-based optimization models.
-
Assist in implementing audit trails, exception logging, and regulatory reporting (e.g., vehicle compliance, emissions tracking).
4. Collaboration & Stakeholder Engagement
-
Work closely with operations, transport planning, and finance teams to translate business requirements into technical database solutions.
-
Support data requirements for BI tools, dashboards, and mobile/web applications.
-
Participate in code reviews, data architecture discussions, and system integration planning.
Qualifications & Experience
-
Education: Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
-
Experience: 6–8 years in MS SQL DBA and SQL development roles, ideally within the logistics, transportation, or supply chain domains.
Technical Skills
Required:
-
Expertise in MS SQL Server (2016 or later) including SSMS, Profiler, SQL Agent, and Management Studio tools.
-
Proficient in T-SQL for writing efficient stored procedures, functions, triggers, and complex queries.
-
Experience with query optimization, indexing strategies, and execution plan analysis.
-
Knowledge of ETL processes and working with large datasets across multiple systems.
-
Strong understanding of data modelling, normalization/denormalization, and referential integrity.
-
Experience with database security, backups, restore, recovery models, and transaction log handling.
Preferred:
-
Exposure to cloud-based SQL solutions.
-
Familiarity with Power BI, SSRS, or other reporting tools.
-
Knowledge of geospatial SQL, JSON handling, and logistics domain data models.
-
Experience in integrating with GPS, IoT, fuel card APIs, or telematics systems.
Soft Skills
-
Analytical mind-set with strong problem-solving skills.
-
Excellent communication and documentation abilities.
-
Team player with the ability to manage multiple priorities in a fast-paced environment.
-
Attention to detail and a commitment to data accuracy and system stability.
Benefits
-
Competitive salary with performance-based incentives.
-
Health insurance and employee wellness benefits.
-
Exposure to advanced logistics technologies and sustainable transport platforms.
-
Professional development opportunities, training, and certification support.
-
Flexible working environment with hybrid work options.
To Apply:
Please send your resume and portfolio of work to [email protected]. We’re excited to connect with data professionals who are passionate about using technology to drive transformation in the logistics sector.
