Job Description

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

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.
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.
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).
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: 68 years in MS SQL DBA and SQL development roles, ideally within the logistics, transportation, or supply chain domains.

Required

Technical Skills

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 [HIDDEN TEXT]. We're excited to connect with data professionals who are passionate about using technology to drive transformation in the logistics sector.

SQL Developer and DBA

SQL Developer

TSQL and SQL Developer - Python

SQL Developer

Sql Developer

Informatica Developer with Teradata and SQL