Job Description

GTROPY, 75-76, 1st Floor, Above Indian Bank, Adhchini, Sri Aurobindo Marg,


New Delhi - 110017


SQL DATA BASE DEVELOPER/DBA





Positions: Software Developer - II / Software Developer - III



Requirements:

10+ years' experience as a SQL Database Developer


(BTech/MTech in Computer Sciences from good engineering colleges preferred)


Someone with good hands on- MS SQL, Asp.Net, Data Structures and Algorithms




WFH applicable due to covid-19



Email- cv@gtropy.com Web- www.gtropy.com



Perks:

5 days working, Flexible working hours, WFH, Medical Insurance, Exciting promotions & Appraisals and most importantly become a part of a dynamic and


fun team of entrepreneurs from IIT, IIM and BITS Pilani ?




The Must haves:



Strong experience as a SQL Database Developer with strong knowledge in implementation, configuration, maintenance, and performance of


critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.


Knowledge of MS SQL Architecture, Backup & Recovery, DB Refresh


SQL Server Log Shipping setup, SQL server Mirroring setup


Knows to detect & resolve issues related to CPU; Memory; I/O disk space etc., which indirectly necessitates strong OS knowledge


In-depth knowledge of relational database design, T-SQL, creating stored procedures, views, user defined functions and triggers


Strong analytical and critical thinking skills, with ability to analyze business requirements to determine processing flow, user requirements and


inter-dependencies of multiple information systems


Strong problem-solving skill with the ability to analyze and break down a problem to identify root cause


Strong in performance tuning especially tuning complex queries, procedures and indexing strategies


Adapting ETL processes to accommodate changes in source systems and new business user requirements


Should have a strong focus on analyzing the database design, troubleshooting, Query Optimization, fine-tuning the performance, and


monitoring of system health, to ensure high levels of performance, availability, and security.


Working with both technical staff and business partners to translate requirements into technical implementations


DBA Support for DB related production issues and quick resolution for the same.


Meanwhile, give it a thought for the below ramblings:


What is the toughest computer science problem that you have ever solved?


While coding, do you ever think why the CPU of your program gets increased at times?


When you have designed the Data Structures, do you target achieving logarithmic time complexity, because if you think quadratic, the scale at


which we run, it would never be able to finish its respective loops!


Do you like to work in multiple programming languages!


Have you ever tried solving loop unwinding and loop unrolling in real world problems!


Have you ever designed a state machine for solving String-Matching problems?





We at Gtropy literally solve such problems, if such engineering ramblings excites you, GTROPY is definitely for you.


We are looking for self-motivated computer science engineers, who just not only roll up their sleeves but make sure to riddle out such unconventional


problems with a Thug Life.




ABOUT US:



Gtropy is a renowned brand ventured by a passionate team from the world's most eminent institutions. We are dedicated to the field of GPS Based Fleet


Management Solutions and its exhaustive Data Analytics. Proficient in providing valuable solutions, we cater to diverse clients from all verticals. Our aim is


to set benchmarks for analytics in the Logistics Industry in terms of imparting avant-garde solutions, high-quality services, and seamless support to our


customers.




Progressively we have established ourselves as one of the most trusted GPS Vehicle Tracking Solution providers among our esteemed partners and well-

satisfied customers. As of now, we have 1,00,000+ Live vehicles to our credit with quarterly growth of 40%. Our gigantic network of 350+ partners reflects


our success story.




Gtropy has an array of solutions for every Industry type in the Logistics domain that help in the management of Logistics Operations, Passenger


Transportation, Fleet Management, Supply & Distribution as well as pickup and drop services.













GTROPY's FORTE:


PRODUCTS

SOLUTIONS

GPS TRACKING SYSTEM TRANSPORT MANAGEMENT


LIVE VEHICLE TRACKING FLEET MANAGEMENT SOLUTIONS


ASSET TRACKING SUPPLY CHAIN ANALYTICS


FLEET MANAGEMENT LOGISTICS MANAGEMENT SOLUTIONS


LOCATION ANALYTICS FASTAG SOLUTIONS


FASTAG EXPENSE MANAGEMENT





INDUSTRIES WE CATER



CARGO AND LOGISTICS/TRANSPORTATION


OIL & GAS


MINING INDUSTRY


HEAVY MACHINERY/EQUIPMENT


SUPPLY & DISTRIBUTION CHAIN


CONSTRUCTION


FMCG


COMMERCIAL/TOURIST VEHICLES


AGRICULTURE


WASTE MANAGEMENT


CABLE AND TELECOM


GOVERNMENT & PUBLIC SAFETY





OTHERS: GPS vehicle tracking is not limited to these industries, it can be used to field-based fleets or assets, there are many industries which


rely on assets for day to day operations, installations, service mobile companies, cable operators, restaurants etc.