P>I am looking for a challenging position in a company where I can use all of my technical and analytical skills to the fullest, advance in my career, and be a flexible resource.
6 years of IT experience, with an emphasis on production/application support, problem solving, change management, and process optimization. I worked on production support, attending production calls, troubleshooting the application, and resolving bugs. Expertise in database objects such as tables, views, synonyms, indexes, and sequences. Experience in Oracle advanced SQL programming using analytical functions, sub queries and set operators, views, materialized views and tuning of SQL queries. Strong knowledge of Oracle PL/SQL to provide client-requested improvements and patches to address production issues. I worked on the performance tuning of the SQL queries to improve the data conversion process. Strong knowledge to create the index for increasing the performance of the data conversion process. Expertise in scheduling jobs using the CRONTAB scheduler and monitoring the jobs in Control M. Good analytical and problem-solving abilities and provide resolution on support issues within the scope of support per the Service Level Agreement (SLA). As a team member, I am a support engineer working on all incident tickets and following up with other team members for change and release activity. Responsible for checking event alerts, and notifying the concerned team, and processing the requests from end users. Responsible for identifying any bugs occurring in the application as well as fixing them. Check the log files and release the space if the dumps are running out of memory space. Used SQL
LOADER to upload the data into the database tables. The WinSCP tool for transferring files from Windows to UNIX or UNIX to Windows.
Overview
7
7
years of professional experience
Work History
Virtusa Consulting Services Pvt. Ltd.
07.2022 - 01.2024
TCS Chennai
10.2019 - 03.2022
JCL Systems Pvt. Ltd.
07.2017 - 10.2019
Education
Skills
SQL
PL/SQL
UNIX
Shell Scripting
Oracle RDBMS
SQL Developer
Toad
ServiceNow
Jira
Putty
Airflow
Informatica
WinSCP
Autosys
Control-M
Splunk
Disclaimer
I hereby declare that the details given above are true to the best of my knowledge and belief.