Vivek Rai

Professional @ Telus Internation

Gorakhpur vivekrai7244@gmail.com 8708487754
Current CTC
0 LPA
Expected CTC
0 LPA
Notice Period
30 Days
Experience
5.5 Years
Profile Summary

Results-driven Professional with 5.5 years of experience. Highly skilled in , with a proven track record of delivering high-quality results.

Work Experience
2022 – Present
Telus Internation

Participate in a team to maintain & support multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.

  • Managing database Storage and various jobs integrated with Database from application end using PL/GR and AWS cloud applications.
  • Participate in Database Patching and OS patching.
  • Identify trends and opportunities for improvement.
  • User management Backup and Restoration in MySQL and Postgres.
  • Expertise in maintaing Report using excel and performance review meeting with client on WSR (Weekly Service Review) and MSR (Montly Service Review).
  • Password Change Activity on various environment as per compliance.
  • Check invalid objects, unusable index and compile objects.
  • Performance Refresh activity on various database, sync various enviornment.
  • Monitor and Manage Database Performance, long running transactions.
  • Interact with the functional team; define responsibilities, request groups, users.
  • Identifying Wait events, blocking session, parallel processing session on various business hours to make sure system is working smooth.
  • Use different Oracle Applications tools for maintaining database and applications.

 

Able to respond to all data inquiries and questions as they pertain to business outcomes by navigating through multiple data systems and multiple operational teams

  • Coordinate in resolving various performance issues, transferring the files and send the respective query output to various business users.
  • Analyze existing database systems and recommend improvements.
  • Database migration with the help of Exp/Imp Utility, Datapumps , External Table.
  • Taking backup using various tools and cohesity backup run monitor.
  • Good knowledge of SQL Joins, Constrains.
  • Produce reports for internal/external customers and senior leadership as needed
  • Perform ad-hoc analysis and special projects as needed including but not limited to research projects.
  • Convert data into tangible information and business reports for stakeholders. Identifying trends, risks, cost and revenue drivers to facilitate decision making
  • Identify opportunities for organizational process or program improvements
  • Advanced English and presentation skills.
2021 – 2022
DBA in Support Team
Trueblue India Llp

Participate in a team to maintain & support multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.

 

  • Handle day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements. Checking Alert Logs, Archive Logs, Trace files, backup verifications & Health check ups of database.

 

  • Good working knowledge on Performance Tuning and tuning related issues.

 

  • Working of Salesforce ticket for various issue in different environment.

 

  • Performing the installation and upgradation for various product and still replicate the behavior and share the troubleshooting steps.

 

  • Disk Space Monitoring and alert management.

 

  • If the product is not working fine and its bug we help the customer to raising an ticket and go with the L2/L3 team and architect to get it resolve it the next release.

 

  • While working on the product and some functionality we guide the client to raise an RFE Request for Enhancement and share the SOP for the same.

 

  • Performance Refresh activity on various database, sync various enviornment.

 

  • Engaging various team via Skill case for resolving the issue like Storage, SCOM team.

 

  • SQL Loader script to Database migration with the help of Exp/Imp Utility, Datapumps , External Table

 

  • Work on performance refresh activity on various test server to analyse the performance.
Education

No education history listed.

Resume Preview
Preview not available for this file type (DOCX)

You can download the file to view its contents.

Resume
42d7a22545cb44be8969c4bc02476c07.docx
DOCX File
Download Resume
Top Skills