
Accomplished database architect with expertise in Oracle and SQL Server, driving cloud migrations at HCL Technologies. Spearheaded automation initiatives, enhancing resilience and reducing costs. Proven leader in disaster recovery planning and team mentorship, ensuring data integrity and security. Excel in problem-solving and effective communication, delivering robust solutions for complex challenges.
Designed and implemented complete end-to-end systems, ensuring robust functionality.
Conducted 24/7 production support, addressing priority tickets within SLA requirements.
Executed extensive troubleshooting for database and server issues, enhancing system stability.
Analyzed and proposed parameter changes in production environments to mitigate critical problems.
Optimized database performance through tuning for daily loads and slow response issues.
Reviewed AWR and Statspack reports daily to identify and resolve performance bottlenecks.
Performed table de-fragmentation and index rebuilding to enhance query performance.
Reviewed PL/SQL code and SQL queries pre-deployment for potential performance issues.
Installed, created, and configured Oracle 9i/10g databases on Linux and Windows NT servers.
Implemented and maintained DB2 8.0 databases on Windows NT servers.
Executed database change requests, modifying tables, triggers, packages, types, and views as needed.
Scheduled and monitored hot backups to ensure data integrity.
Utilized Oracle utilities such as Export/Import and Data Pump for database synchronization.
Performed schema syncing using Toad to maintain consistency.
Developed stored procedures and triggers to enhance database functionality.
Monitored database and OS performance, optimizing SQL, PGA, CPU utilization, and disk space.