SQL And PL/ SQL Certification, Prodapt Solutions Pvt Ltd, Senior Network Engineer, 07/23/2020, 07/21/2023, IVR, Production Support, Oracle SQL, PL-SQL, Windows, VodafoneIdea(VI) (Telecom), Project Name-IVR
Working with processing team on SQL/Oracle. Involve in Data Analysis, document review & document production and Report generation from database. Involve in writing SQL queries (joins), create tables for improving productivity. Optimal durability and reliability ??? Investigating and resolving technical operational issues of the applications. Import and Export the data to and from the database as per the requirement Using Oracle or SQL Developer. Managing Prepaid-Postpaid Activations to make sure smooth activation-deactivations. .Raising severity if there are any productions issues occur and address to the concern person. Ticket Management through BMC Global Remedy tools. To reduce the Ticket counts and to avoid any customer escalations doing number reconciliation in bulk. Made effective and much appreciated suggestions for changes in the system applications, and gave expert advice for proper operation. Doing purging activity on monthly basis and take the backup before doing the same. Identifying application errors & interacting with development team to resolve technical issues and raising defect for the same. Providing data to the customers based on their requirement and writing SQL Queries for the same. Training end-users by means of verbal personal instruction and specially designed documentation. Provide support out of office hours, during weekends and major release work to development and customer to help them to resolve issues faced. Managing support mail boxes and Phone calls where customers raise technical issues and queries. Working with Operations to prioritize solution and maintaining SLA. Health check and monitoring production system and job scheduling to ensure SLA is meet Good knowledge in creating Hive tables, and loading and analyzing data using hive queries Created internal and external tables with properly defined partitions for efficiency.