Devinder Singh Virdi

About Devinder Singh Virdi

Oracle Certified Professional. Wizard Rank in…

Experience

1. Specialist Master

   Deloitte

   Feb 2009 — Present

   Implemented change management processes to reduce communication gaps and human errors. Lead software lifecycle developments for multiple releases and deliver production on time by setting the priorities. Implemented storage and archiving standards, procedures, capacity planning and client deliverables Developed the process to compare performance of each test performed in Load and Stress environment by comparing Oracle’s SysEvents, SysStats, ASM etc for all RAC nodes. Lead various Oracle version upgrades (9i -> 10g, 10g -> 11g and 11g -> 19c) with zero impact on application performance after the upgrade. Secured sensitive data in development databases that contained PII information from production Monitored production (24x7) and managed parameters that provided fast responses to front-end users Architect database designing, implementing object structure/functions/procedures/packages or custom scripts. Defining and maintaining database physical structure and functional capabilities, database security, data back-up, and recovery specifications Created a process to make sure no Performance related surprises appear after each deployment by monitoring Stats and Event patterns Lead the efforts in migrating Mainframe application to Oracle 10g and Java. Leading the effort that is performing POC on Oracle 19c to AWS PostgreSQL 13.4 upgrade. Coordinate with Deloitte leadership and Client to maintain healthy professional relationship. Mentoring DBAs and Developers for their professional growth. Wrote custom tool to create Dev environment of 100gb out of 60 TB Production. Publish PHP page to support developers without DBAs involvement are – monitoring Blocking locks/connection leaks/cursor leaks/SQL tuning suggestions, client deliverables/Release related changes etc.

Skills

• Databases
• Database Administration
• Pl/Sql
• Unix Shell Scripting
• Oracle
• Data Modeling
• Sql Tuning
• Performance Tuning
• Sql
• Disaster Recovery
• Microsoft Sql Server
• Data Warehousing
• Operating Systems
• Shell Scripting
• Database Design
• Etl
• Requirements Analysis
• Integration
• Unix
• Sdlc
• Oracle Rac