Hemant Sajnani, Developer in New Delhi, Delhi, India
Hemant is available for hire
Hire Hemant

Hemant Sajnani

Verified Expert  in Engineering

Bio

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

Associated Broadcasting Company Private Limited
AWS Certified SysOps Administrator, AWS Certified Solution Architect...
NDTV
Oracle, Microsoft SQL Server, Python, APIs, AWS Certified Solution Architect...
Aurea Software
Microsoft SQL Server, Oracle, SQL, Data Engineering, ETL, PL/SQL...

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

Availability

Part-time

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

2020 - PRESENT
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.
Technologies: AWS Certified SysOps Administrator, AWS Certified Solution Architect, Oracle Cloud, XML, Amazon RDS, Amazon Web Services (AWS), Analytics, Data Strategy

Senior Vice President

2004 - 2020
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.
Technologies: Oracle, Microsoft SQL Server, Python, APIs, AWS Certified Solution Architect, AWS Certified SysOps Administrator, MySQL, Amazon RDS, Data Strategy, Database Backups, SQL Server DBA, Oracle DBA, Performance Tuning

SaaS Ops Architect

2015 - 2016
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.
Technologies: Microsoft SQL Server, Oracle, SQL, Data Engineering, ETL, PL/SQL, SQL Performance, Performance Tuning, Database Replication, SQL DDL

Database Manager

2012 - 2014
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.
Technologies: MySQL, PostgreSQL, Sybase, Microsoft SQL Server, Oracle, Data Engineering, Data Architecture, ETL, Oracle PL/SQL, Python 2, Performance Tuning, Database Replication, SQL DDL

Experience

Elections In India

To power broadcast graphics for elections, I was mainly responsible for capturing data from data providers like AC Nielsen and crunching the data in database structure designed to suit the development needs. Our company has had the best election coverage for many years because of fast and accurate information.

Stock Market Data

I worked to capture data for Indian and foreign stock markets including Forex from Reuters, Bloomberg, and Cogensis data providers. I led the back-end development of Oracle database. I also configured a 2-node real application Ccuster to ensure high database availability.

EPG Provider

The only company in India to provide an electronic programming guide for more than 1,000 TV channels in India. Led the back-end development team to write Python APIs to get data from SQL RDS instance and power Elasticsearch Index to distribute it to clients. Created an Android app as well called UREQA.

Education

2001 - 2003

A Level (Advanced Diploma Equivalent) in Computer Science

Department of Electronics and Accreditation of Computer Classes, New Delhi - New Delhi, India

1998 - 2000

Bachelor of Science Degree in Science

Maharshi Dayanand Sarswati University - Rajasthan, India

Certifications

JULY 2020 - JULY 2023

AWS Certified Solutions Architect Associate

AWS

JUNE 2020 - JUNE 2023

AWS Certified SysOps Administrator Associate

AWS

JULY 2019 - PRESENT

Python for Applied Data Science

Coursera

JULY 2019 - PRESENT

Databases and SQL for Data Science

Coursera

JUNE 2005 - PRESENT

Microsoft Certified Professional — SQL Server

Microsoft

Skills

Tools

Microsoft Access

Languages

SQL, T-SQL (Transact-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

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

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring