Hemant Sajnani
Verified Expert in Engineering
Software Developer
New Delhi, Delhi, India
Toptal member since November 27, 2019
Hemant is a back-end developer with expertise in database management systems including SQL Server, Oracle, MySQL, and others. He has over 17 years of experience in database design, writing complex queries, optimization, performance monitoring, tuning, high availability, and disaster recovery.
Portfolio
Experience
- SQL - 20 years
- SQL Server DBA - 15 years
- Oracle DBA - 15 years
- Performance Tuning - 12 years
- SQL Performance - 10 years
- AWS Certified Solution Architect - 5 years
- MySQL - 4 years
- Oracle Cloud - 2 years
Preferred Environment
MySQL, Oracle, Microsoft SQL Server
The most amazing...
...thing I've designed and developed was the back-end of UREQA, an Android app that provides recommendations based on user preferences across 1,000 TV channels.
Work Experience
Chief Technology Officer
Associated Broadcasting Company Private Limited
- Transformed the digital presence of TV9 digital business by introducing modern architecture, which led to the TV9 digital business growing by 200% on Comscore in six months and crossing 100 million unique visitors per month in June 2021.
- Implemented new ways to connect TV audiences to digital platforms, including introducing a second screen like a mobile phone for TV viewers.
- Led a digital innovation team that connected Indian election data in real-time on digital platforms. Created a robust serverless back end in Python and Node.js to stream real-time data to over a million concurrent users.
- Created different data-driven dashboards to capture various analytics, including Google and YouTube; also helped with SQL development for COVID-19 reports.
Senior Vice President
NDTV
- Handled Oracle RAC and SQL clusters for broadcast data management and iNews (a newsroom center) archiving. Provided various automated tools to ease out daily activities that require manual attention.
- Headed election programming and Indian and foreign stock market data.
- Modified existing databases to meet unique needs; these databases handled around 2,000 transactions per second.
- Served as the technology lead for EPG (electronic programming guide) business vertical for NDTV. There are now over 100 clients on board.
SaaS Ops Architect
Aurea Software
- Supported Oracle and SQL Server databases for the ISTA international/Aurea energy solutions project.
- Migrated on-premise databases of Oracle and SQL Server to AWS Cloud.
- Oversaw database performance, replicated issues for troubleshooting, and automated tasks.
Database Manager
Triology
- Started as a database administrator and promoted to the database manager and lead a team of DBAs from all over the world.
- Upgraded and migrated the stack (OS, JVM, app server, and DBMS) that runs business applications using AWS.
- Interviewed, hired, and managed global DBAs. This included weekly meetings, assigning tasks, and reviewing completed tasks.
Experience
Elections In India
Stock Market Data
EPG Provider
Education
A Level (Advanced Diploma Equivalent) in Computer Science
Department of Electronics and Accreditation of Computer Classes, New Delhi - New Delhi, India
Bachelor of Science Degree in Science
Maharshi Dayanand Sarswati University - Rajasthan, India
Certifications
ClickHouse Database Associate
ClickHouse
AWS Certified Solutions Architect Associate
AWS
AWS Certified SysOps Administrator Associate
AWS
Python for Applied Data Science
Coursera
Databases and SQL for Data Science
Coursera
Microsoft Certified Professional — SQL Server
Microsoft
Skills
Tools
Microsoft Access
Languages
SQL, Transact-SQL (T-SQL), Python, Python 2, SQL DDL, XML
Storage
SQL Server DBA, Oracle DBA, Oracle PL/SQL, SQL Performance, MySQL, Oracle Cloud, Database Backups, Microsoft SQL Server, Sybase, PostgreSQL, Database Replication, PL/SQL, ClickHouse
Paradigms
ETL
Platforms
Oracle, Amazon Web Services (AWS)
Other
Performance Tuning, AWS Certified Solution Architect, Data-driven Dashboards, Solution Architecture, Data Strategy, AWS Certified SysOps Administrator, APIs, Amazon RDS, Analytics, Back-end, Data Engineering, Data Architecture, Biology, Chemistry
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring