
gaurav sisodia
Engineering / Architecture
About 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)
Experience
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
Education
B.Tech in Computer Science & Engineering
Government Engineering College, Ajmer
64.01%
Professionals in the same Engineering / Architecture sector as gaurav sisodia
Professionals from different sectors near New Delhi, New Delhi
Other users who are called gaurav
Jobs near New Delhi, New Delhi
-
Database Administrator
1 month ago
Puresoft Noida, PuneProven experience as a Database Administrator with a strong understanding of database management systems. · ...
-
application database administrator-rdbms
1 week ago
IBM GurgaonAs an Application Database Administrator at IBM Consulting you will manage and optimize databases to ensure the smooth operation and efficient performance of applications relying on databases. · ...
-
Database Administrator
1 week ago
PTC GurgaonThe position will work closely with R&D, Support and the Network Operations Center (NOC). In addition to operational DBA tasks, the position will work closely with Developers to design and build/modify appropriate structures to support future enhancements and provide guidance on ...