LATESH CHAWLA

1. Team Leadership & Management

• Lead and mentor a team of 2 junior DBAs, assigning tasks and reviewing their work.
• Define database administration standards, best practices, and policies.
• Act as the escalation point for complex database issues.
• Conduct regular training and knowledge-sharing sessions for junior DBAs.

2. Oracle Database Administration (with Data Guard & ASM)

• Manage Oracle 12c/19c databases with ASM (Automatic Storage Management) and Data Guard for high availability.
• Monitor and optimize Oracle database performance (AWR, ADDM, SQL tuning).
• Configure and maintain RMAN backup & recovery strategies.
• Ensure smooth patching, upgrades, and migrations with minimal downtime.

3. Oracle E-Business Suite (EBS) Administration

• Manage Oracle EBS R12.2.10 including database and application tier administration.
• Apply patches, cloning, and concurrent manager tuning.
• Monitor workflow processes, concurrent requests, and performance tuning.
• Work with functional teams to support EBS modules and troubleshooting.

4. MySQL Administration

• Deploy, configure, and optimize MySQL databases (on-prem & cloud).
• Set up replication (Master-Slave, Group Replication) for high availability.
• Perform query tuning, indexing, and schema optimization.

5. MongoDB (Amazon DocumentDB) Administration

• Manage MongoDB clusters and DocumentDB in AWS.
• Implement sharding and replication strategies for scalability.
• Perform backup, restore, and monitoring using MongoDB tools.

6. Redis (Amazon ElastiCache) Administration

• Manage Redis cache clusters using AWS ElastiCache.
• Optimize caching strategies to improve application performance.
• Monitor memory usage, eviction policies, and failover strategies.

7. Elasticsearch (Amazon OpenSearch) Administration

• Deploy and manage Elasticsearch/OpenSearch for search and analytics.
• Configure indexing, scaling, and cluster management.
• Monitor query performance and optimize searches using Kibana dashboards.

8. Database Security & Compliance

• Implement database security policies (encryption, access controls, auditing).
• Ensure compliance with GDPR, HIPAA, PCI-DSS, and other standards.
• Conduct regular database security audits and vulnerability assessments.

9. High Availability, Backup & Disaster Recovery

• Configure and monitor Oracle Data Guard, MySQL replication, and MongoDB failover mechanisms.
• Develop and test database backup & recovery plans (RMAN, Snapshots, PITR).
• Perform regular disaster recovery (DR) drills.

10. Performance Tuning & Monitoring

• Optimize SQL queries, indexing, and partitioning across databases.
• Implement and manage monitoring tools (OEM, Percona, CloudWatch, Kibana, Prometheus, etc.).
• Analyze database logs and resolve performance bottlenecks.

11. Incident & Problem Management

• Act as the primary point of contact for critical database incidents.
• Perform root cause analysis (RCA) for recurring issues.
• Implement proactive monitoring and alerts to minimize downtime.

12. Vendor & Cloud Platform Management

• Manage Oracle, AWS, and third-party vendors for support & troubleshooting.
• Optimize cloud database costs (AWS RDS, ElastiCache, DocumentDB, OpenSearch).
• Stay updated on new database technologies and recommend improvements.

• Manual Upgrade and Upgrade using DBUA from lower versions to higher version as per request by client in order to support smooth performance of their respective applications
• Performed and Guided team for an upgrade project -11g RAC to 12c RAC - Database and Grid (ASM) Installed and configured Oracle APEX (Application Express) 5.1.4 for development team on Oracle 12c under Linux
• Restored couple of tables which were dropped by User in 12c Environment using new feature of RMAN 12c Moved datafiles online in Oracle 12c after new mount point was provided in order to reclaim some space
• Fixed slow running job by creating indexes as per predicate information which increased performance of the entire job by 40 minutes
• Administrating Oracle Wallet to Encrypt and Decrypt Data (tablespace) during database refreshes
• Using Oracle 12c to gather stats on multiple tables, partitions and sub partitions concurrently Analyzing AWR / Statspack reports after client complained about severe performance issues and provided recommendations
• Coordinating with Oracle Support via SR and getting the issue resolved on timely basis due to some BUG or severe performance hit after an upgrade
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management
• Creation of new partitions using split partition option along with partitions of non-partitions tables for improving performance
• Install new versions of Oracle RDBMS and its tools and any other tools that access Oracle database
• Creating Physical and Logical standby databases as a part of High Availability and for application testing purpose
• Setting up entire backup process on DISK as well as on TAPE after a new instance is created along with testing backup by recovering files
• Performing Day to Day Sanity on all databases with respect to any alerts that are generated based on OEM monitoring system
• Patching of Oracle and Grid Infrastructure in order to overcome BUG issue or an unusual behavior of applications that results persistent in Ora-07445 or Ora-0600 errors
• Managing entire team/shift of 10-12 people and making sure all relevant requests are completed appropriately

• Performed Upgrade from 11.2.0.3 to 11.2.0.4 of Core Banking Database sized over 25TB
• Administering 11gR2 RAC databases in Windows & HP-UX for day to day issues and alerts
• Monitoring X2 Exadata's FULL RACK/QUARTER RACK/HALF RACK for Data warehouse
• Performing DR drills (Switchover/Switchback) for all Banking Databases along with databases for 26 international territories
• Monitoring all databases and making sure that Standby databases are in sync with Primary database, if the standby is not in sync, manually transferring the archives and bring it forward else taking Incremental backup of Primary and bringing the standby in sync
• Executing change orders on the databases as per request by the bank
• Managing daily backup of all Banking environments that involves cold and hot backups using RMAN and making sure database is up and running after the backup completion
• Installed Oracle 11g Forms and Reports as per application testing project
• Monitoring Operating Systems for any sudden increase in CPU and Memory usage
• Quarterly Purging and refreshing of highly used Tables and Indexes as per data provided by application team
• Creating Materialized Views and Scheduling Jobs as per requirement by the Bank
• Reclaim space in Exadata Environment by Compressing Large Tables and rebuilding indexes

• Provide on-call support for remote clients per specified customer and business Service Level Agreements
• Installation, testing, and documentation of Oracle Database and application for Research and Development department
• Installed and managed Oracle 11g under Amazon AWS E2 instance on RedHat 6.4
• Configured DynamoDB along with Elasticache feature under Amazon AWS for one of the clients for a small mobility project
• Worked and managed SQL 2005 Server in a short-term project which included monitoring and installation and catering to regular client requests
• Daily management, maintenance, monitoring, and tuning of database operations and data for Oracle databases on multiple platforms
• Provide documentation to customers detailing Oracle database creation, repository creation, and data loading procedures
• Create monthly databases reports for sales and infrastructure managers with recommendations and summary of tasks performed during the month
• Implementation and documentation of disaster recovery and data load procedures
• Used Import, Export, SQL Loader and other tools to load and backup data
• Coordinate with onshore DBA regarding any weekend changes and prepare plan of action for the same
• Clear the trace files in the udump and bdump directory as per the policy using ADRCI or log rotator
• Check the sync between the primary database and standby database on timely basis
• Check the database performance, periodic basis usually in the morning very first hour after the night shift schedule backup has been completed
• Coordinate with the security Team and work on security policy violation
• On some databases this needs to be done every day depending upon the requirement
• Read DBA Manuals, trade journals, and possibly newsgroups or mailing lists to keep myself updated with latest information and learn to troubleshoot any unusual issues/errors

• Health check of databases under Production and Development environment
• Creating and maintaining all databases required for development, testing, education and production usage