Umesh Tiwari
SQL & NoSQL DBA (MySQL , MS SQL Server , MongoDB )
- Role
- Database Administrator at Skilrock Technologies
- Location
- Gurugram, HR, IN
- LinkedIn followers
- 500 followers
About Umesh Tiwari
Working in SkilRock Technology Pvt. Ltd. as DBA (SQL, NoSQL) Location – DLF Cyber City Building No. 5, Gurugram HaryanaSkills & AbilitiesTECHNICAL SKILLS • Database: MySQL. 8.0 / 7.0 / 5.7 / 5.6 / 5.5 & SQL Server 12/14/16/2019 And MongoDB 4.0 / 6.0 • Languages : C++ & Python, Advance SQL & Java Script, No-SQL. • Platforms : Linux, Ubuntu 18.04, 22.04 & CentOS 7, 9 & Windows 7/8/10/11/Server 2016. • Automation Tools : Ansible, Docker, Containers, Zabbix Server ( Monitoring Automation ) • Cloud Platform : Amazon Web Services • Computer Knowledge : Operating System & Data Structure & ER Diagram, Shorting & Searching Algorithms.Job Role & Responsibilities • Configured, Installed and Maintained MYSQL 8.0/7.0/5.6/5.5 and SQL Server 2012, 2014, 2016 and 2019 and MongoDB in dev, test & production environment with the Architecture of Standalone / Replica Set / Cluster • MySQL/MongoDB/ SQL Server replication configured and monitored with master to one & multi slave, master to master with high availability(HA), knowledge of shell scripting and made scripts required to achieve stability, project requirement and server monitoring reports • Installed and configured the Percona Monitoring and Management(PMM2) to monitor the MySQL nodes using automated alerting system, Query Analytics and used the percona tool kits to work on production for smooth execution of the change in schema, archiving of data from OLTP to OLAP servers • Wrote SQL/ T-SQL queries, Stored Procedures, functions and triggers • Monitored server activities such as database status, logs, space utilization, extents, Checkpoints, locks and long running transactions using PMM2 • Handled fine tuning Operating System in-coordination with server and network Administrator to utilize the maximum resources for Database and Applications.Projects • Project Name: Ithuba Project (South Africa ) Description: Implemented the MySQL Single Primary ReplicaSet & Mysql Multiprimary Cluster and also Configured the HA Proxy Load Balancer To Achieve the Automatic Fail-Over Handling in between Primary and DR Site( In this project I’m handling more than the 50 Database Server with Different Versions and Architectures )
Experience
Database Administrator
Oct 2022 — Present · Gurugram, IN
Working For SQL (MySQL / SQL Server ) & No- SQL ( MongoDB / Redis ) Databases Administration and System Optimization and Also Handy on Amazon Web Services, some Automation Tools Like Ansible, Docker, Container, Jenkins and Closely working with the DevSecOps & AWS Cloud Architect Team Members.
Education
Dr. Ram Manohar Lohia Awadh University, Faizabad
Bachelor of Computer Application, Information Technology/ Computer Application
Uttar Pradesh Board of Technical Education
Polytechnic ( 3 Year of Diploma in Information Technology ) , Information Technology
MIT School of Distance Education
Post Graduate Diploma in Management - PGDM, Information Technology
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.