SQL Developer and DBA
Share
Job Location:
Monthly Salary:
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
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: Bachelors 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.
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 Were excited to connect with data professionals who are passionate about using technology to drive transformation in the logistics sector.
Required Experience:
IC
Key Skills
- Databases
- SQL Server Management Studio
- SQL
- .NET
- Microsoft SQL Server
- ssrs
- TFS
- Database Design
- Performance Tuning
- SSIS
- T Sql
- Data Warehouse
About Company
Black Box® is a trusted IT solutions provider delivering cutting-edge technology products and world-class consulting services to businesses across the globe.
