Oracle Technical Consultant
OvacSol Private Limited
Total years of experience :12 years, 7 Months
- Responsible for handling the complete technical side of Oracle systems. - Provided on-going performance monitoring and debugging, resulting in a major reduction in downtime due to these issues.
- Created disaster recovery environment for company critical and essential databases.
- The project has reduced downtime for databases by allowing switch over, fail over and recovering databases due to hardware or network failures.
- Performance monitoring and tuning for Oracle system and database.
- Installation and configuration of Oracle Database 11g & Application 10g.
- Managing database backups using RMAN and Data pump export.
- Responsible for Solution landscape planning, System landscape planning, hardware sizing and planning for Oracle installations.
- Creating PL/SQL Procedures, Functions for data population and updating as per project requirements
- Writing queries based on specifications.
- Analysis of customer requirements.
- Auto email using utl_mail package.
- webutil configuration for 10g Application.
- Develop Oracle forms, reports (Tabular, Groups, Matrix and Group Matrix).
- Data uploading from xls file to database.
- Provide technical support to users.
- Understand project requirements and develop design specifications.
- Design, code, and maintain the Oracle systems based on established standards.
- Develop Oracle forms, reports & database procedures. - Analyze and troubleshoot system issues in a timely manner.
- Modify existing codes to optimize Oracle applications.
- Perform design and development of Oracle applications according to project requirements.
- Manage 1st Line System Support to handle all system related issue. Ensure that problems are timely addressed as per the priority level and appropriate measures are taken to escalate the problem to 2nd Line Support (in house or 3rd Party) and follow-up until the problem is closed.
- To manage day to day task, be able to work and coordinate on assigned duties under supervision of Section Head Technology Infrastructure/System Administrator /Service Desk Supervisor.
- Coordinate and report problems to Service Desk Supervisor and System Administrator for any anomaly in system performance.
- Assist Section Head/Unit Head Infrastructure Support/Service Desk Supervisor and System Administrator if required.
- Network Monitoring via Solarwind.