Functional Support
Malomatia
Total years of experience :18 years, 10 Months
● Eliminate repeated incidents resulting from any customization by applying appropriate bug fixes.
● Work on improving existing application as well as developing new applications following the standards.
● Develop and troubleshoot database objects and SP using PL/SQL.
● Develop and troubleshoot applications using Oracle Forms and Reports.
● Troubleshooting and maintaining un-expected application behavior.
● Writing complex queries for users requested reports.
● Analyze all client new requirements and ensure optimal satisfaction of all users.
● Modelling and cultivating high quality communication within the team.
● Bug-fixing, maintenance, monitoring, back-ups, and administration.
● Interact with stakeholders as well as technical teams across design, coding, testing, and production deployment.
● Performance tuning of Oracle databases and resolving database performance issues.
● Responsible for the maintenance and management of release scripts and database upgrades.
● Perform Oracle database backup using both Online (Hot, RMAN) and offline (cold) backup.
● Building and enhancing required stored procedures for business and reports using advanced PLSQL and dynamic queries.
● Support the implementation and integration of third-party interfaces.
● Troubleshoot production issues, analyze root cause of problems, and resolve them on time.
● Perform Oracle database administration duties including installation, troubleshooting database system issues.
● Interact with stakeholders as well as technical teams across design, coding, testing, and production deployment.
● Performance tuning of Oracle databases and resolving database performance issues.
● Responsible for the maintenance and management of release scripts and database upgrades.
● Perform Oracle database backup using both Online (Hot, RMAN) and offline (cold) backup.
● Building and enhancing required stored procedures for business and reports using advanced PLSQL and dynamic queries.
● Support the implementation and integration of third-party interfaces.
● Troubleshoot production issues, analyze root cause of problems, and resolve them on time.
● Perform Oracle database administration duties including installation, troubleshooting database system issues.
Write business and reporting stored procedures.
●Refactoring stored procedures to use collection objects and types.
●Building new database release using MS SQL Server database.