Vikram Lonkar Email & Phone Number

Mumbai, Mh, In

Mumbai, Maharashtra, India

Present Technology Used : Oracle 19C, Unix, Linux, SQL, PL/SQL, Shell Scripting.Tools Used : FortiClient VPN, Citrix, Putty, Microsoft Teams, Outlook, Oracle SQL Developer, RDP (Remote DesktopConnection), ESDS Cloud, SSMS, PostgreSQL, pgAdmin, SQL, Windows PowerShell, Database Link.Developed and optimized complex PL/SQL procedures, functions, and packages to enhance data processing efficiency,facilitate data manipulation, validation, implementation.Designed and implemented database schemas and data models based on business requirements.Wrote and maintained basic Unix shell scripts to automate routine tasks and improve system performance.Conducted performance tuning of SQL queries and PL/SQL code to reduce execution time and improve systemresponsiveness.Performance Tuning: Identify and resolve performance bottlenecks by optimizing SQL queries, indexing strategies, anddatabase configurations, Tables archievs.Work with the advanced features of PL/SQL like collections, cursors, materialize views and dynamic SQL.Optimized SQL queries, improving system performance.Replicate data from Cloud DB to ON-PREM Database. Multiple schemas.Optimized SQL queries, improving system performance.Worked closely with stakeholders to ensure database solutions met business requirements.Provided SQL queries for complex data extraction and manipulation.Created and optimized stored procedures to improve performance and functionality.Basic knowledge about ETL (Extract, Transform and Load) and Windows Powershell script, Postgresql Database.

Pune, Maharashtra, India