Lingan Patil

Sr. Advanced Services Engineer, CSS Tech Delivery / Oracle DBA Lead - Oracle Corporation - Bangalore, India

(2021-09)

Lead Oracle DBA operations for high-stakes production environments, supporting RAC, ASM, Data Guard, RMAN, patching, cloning, migrations, backup/recovery, and DR activities.
Troubleshoot critical Oracle database issues including RAC node eviction, Data Guard issues, performance degradation, backup failures, recovery scenarios, and availability incidents.
Perform Oracle Database and Grid Infrastructure upgrades and migrations from 11g/12c to 19c, including cloud-hosted database environments.
Build and administer RAC, ASM, standalone databases, and physical standby databases; configure and test switchover procedures for DR drills.
Execute RAC and standalone database patching using OPatch and patchsets; support ExaCC/Exadata DomU patching and maintenance activities.
Maintain RMAN backup and recovery strategies, database cloning, refreshes, logical backups, physical backups, and production-to-test database copies.
Configure HSM, Oracle Wallet, and TDE in RAC environments; validate database security, roles, privileges, and access control requirements.
Use AWR, ADDM, EXPLAIN PLAN, and EXPLAIN ANALYZE to identify database performance bottlenecks and tune SQL/database operations.
Assign and prioritize DBA work, mentor junior DBAs, coordinate on-call rotations, drive knowledge sharing, and ensure HA/DR plans are documented and tested.

Oracle DBA Subject Matter Expert - IBM India Pvt. Ltd. - ABN AMRO Bank - Bangalore, India

(2016-01 - 2021-09)

Served as Oracle DBA SME for a banking environment with 700 databases ranging from 300 GB to 48 TB and a 35-member DBA team.
Led and supported mission-critical Oracle database upgrades and migrations with a focus on minimal downtime and production stability.
Designed and supported highly available database architectures across geo-located data centers using Disaster Recovery and High Availability failover practices.
Performed Oracle database patching, cloning, configuration, RMAN backup/recovery, Data Pump refreshes, and production-to-nonproduction database refreshes.
Installed and configured Oracle Data Guard; supported primary and standby database administration, switchover testing, and DR readiness.
Researched and resolved complex Oracle issues using My Oracle Support/Metalink, AWR, ADDM, and database troubleshooting techniques.

Operations Senior Analyst / Oracle DBA - Accenture - Bangalore, India

(2014-07 - 2015-12)

Supported Oracle database operations for 411 databases ranging from 200 GB to 500 GB as part of a 14-member team.
Handled database monitoring, backup validation, incident troubleshooting, refreshes, user access support, and operational escalations.
Supported RMAN, Data Pump, database cloning, performance monitoring, and routine Oracle database maintenance activities.

Oracle and MS SQL DBA - Tata Consultancy Services - Zimmer - Delhi, India

(2013-09 - 2014-07)

Supported 586 Oracle and MS SQL databases ranging from 200 GB to 5 TB as part of an 18-member team.
Performed production database monitoring, backup/recovery activities, issue resolution, and database maintenance tasks across Oracle and SQL Server environments.

Oracle and MS SQL DBA - Info Services through IBM - ABB India - Bangalore, India

(2012-02 - 2013-08)

Supported 255 Oracle and MS SQL databases ranging from 10 GB to 550 GB as part of a 5-member DBA team.
Provided database administration support for backups, restores, monitoring, user management, tablespaces, and day-to-day production database operations.

About