gaurav sisodia

Worked on various database technologies in SQL and NOSQL domains: MySQL, MongoDB, Oracle, PostgreSQL, MS SQL with expertise in the cloud of MySQL AWS RDS and MongoDB Atlas.
Performance tuning of database and query.
Analytics skills to get insight from explain plan, profiler, log files, and memory management.
Cluster Management: expertise in replication and sharding on distributed/standalone systems.
Proficiency in Python and Shell scripting.
Have good hand on exposure in data visualization using Power BI and MongoDB Atlas (NoSQL reporting)

I am a junior database administrator working in a fintech payment gateway-based startup named, PAY10, Delhi with a total work experience of 1.9 years. In my current and previous employment, I have worked on all platforms as far as database technology is concerned like relational databases and NoSQL databases (MySQL, Oracle, MongoDB, MS-SQL) with good exposure to data warehousing and data lakes, yet I work on data visualization part too, where I generally use power BI and tableau and for NoSQL data visualization I work on MongoDB Atlas Charts.

my working cadre is not restricted to the administration of databases, as I use to write queries, procedures, triggers, performance tuning, slow query log checks, and deadlock detection.

I also use to write a shell script to automate the system and business need tasks as far as query automation and administration part automation are concerned.

To manage the NoSQL part in my current employment we are storing all transactions in non-relational databases so I have good hands-on managing large-size databases, as I write MongoDB queries, aggregation pipelines, ETL pipelines, and map-reduce queries.

To make the system more robust, I work on Python and JavaScript to automate database tasks and manipulation in reports for filtering the data in a more precise way, so in all mentioned tactics my motivation is to maintain the atomicity, consistency, integrity, and durability of the system

B.Tech in Computer Science & Engineering 

Government Engineering College, Ajmer

64.01%