Nilesh Mishra

Apart from the database activity, also provide support as DevOps engineer. implementation of CI/CD on AWS (Using code pipeline, Codebuild, Code commit) Configuring and Managing the Jenkins, SonarQube, Maven and different DevOps tool stack Implementation of CI/CD on-premises server. Experienced in writing and executing queries on RDBMS and NoSQL databases. Working knowledge of MongoDB, MySQL, Oracle, MSSQL, and PostgreSQL. Configuring MySQL RDS at AWS level (Master/slave, Master/Read Replica).

• Install and configure MySQL Server software and performing upgrades.• Tune database to optimize performance as workloads change through database design, index creation, database optimization and performance tuning.• Ensure high availability, backup and recovery of production databases.• Launching and configuring MySQL RDS at AWS level (Master/slave, Master/Read Replica).• Experience in MongoDB database concepts such as locking, transactions, indexes, Sharding, replication.

Installation of oracle,mysql & mongodb databases on amazon cloud services. • Managing amazon RDS databases • Monitoring alert log file. • Managing Tablespaces, Rollback Segments, Segments, Extents. • Compression of archived files and sent to remote site where standby database is maintained. • Migration of Oracle database from 11g to 12c with help of oracle goldengate • Providing Support in 24*7 production database related issues.

Managing More than 170+ Databases present in all over India and one in U.A.E & Nepal. • Working in the Development/Implementaion of database in health care Domains. • Responsible for monitoring,troubleshooting,data transfer/sync using custom made Triggers/Procedures Between remotely present DB with Primary DB located in Mumbai. • Physical Standby Database management. • Using export and import(exp & imp) as well as oracle data pump utility (expdp and impdp) for backup of Databases.

Mumbai Area, India Creating Roles and Assigning Privileges. • Periodically monitoring the space management in database. • Viewing the Alert log file to analyze the ORA errors. • Creating new users and manage roles and privileges.