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.