Latesh Chawla

Manager - Database Administration @TouchTunes

Montréal, QC, CA

Lead and mentor a team of junior DBAs, assigning tasks and reviewing their work for quality and accuracy.Monitor and optimize database performance using tools like AWR, ADDM, and SQL tuning.Configure and maintain RMAN backup & recovery strategies to ensure data integrity.Plan and execute patching, upgrades, and migrations while minimizing downtime and disruptions.Administer Oracle EBS R12.2.10, managing both database and application tiers.Apply patches, cloning, and concurrent manager tuning for optimal performance.Monitor workflow processes and concurrent requests, implementing performance enhancements as needed.Collaborate with functional teams to troubleshoot and resolve EBS-related issues.Deploy, configure, and optimize MySQL databases in both on-premises and cloud environments.Set up replication (Master-Slave, Group Replication) to ensure high availability.Perform query tuning, indexing, and schema optimization for efficient data retrieval.Manage MongoDB clusters and AWS DocumentDB to handle large-scale data processing.Implement sharding and replication strategies to ensure scalability and redundancy.Perform backup, restore, and continuous monitoring using MongoDB management tools.Monitor query performance and optimize searches using Kibana dashboards.Implement database security policies, including encryption, access controls, and auditing.Ensure compliance with GDPR, HIPAA, PCI-DSS, and other regulatory standards.Conduct regular security audits and address any vulnerabilities proactively.Configure and monitor Oracle Data Guard, MySQL replication, and MongoDB failover mechanisms.Develop and test database backup & recovery plans using RMAN, Snapshots, and Point-in-Time Recovery (PITR).Stay updated on emerging database technologies and recommend improvement.

Mithibai College of Arts Chauhan Institute of Science and A.J. College of Commerce and Economics

Master's degree, Computer Science

McGill University

Master of Science, Computational Science

Mumbai University

Bachelor of Science, Computational Science

University of Mumbai

Bachelor of Science, Computer Science

Shree Nutan Vidya Mandir English Medium high School

SSC, Maths & Science