sanjay poshiya

oracle apex developer, database administrator

About

Sr. Oracle DBA and Apex developer at Octalsoft

Country

india

City

ahmadabad

Industry

information technology and services

Skill

pl/sql, sql, oracle, performance tuning, databases, database administration, linux, oracle rac, oracle database, rman, data guard, mysql, oracle application express, goldengate, customer service, oracle sql developer, jasper reports, apache fop, tomcat 5, glassfish

Experience

system database administrator

kminfosystems

2013-4 - 2013-10 · 7 mos

* Generating reports from the database using PL/SQL and SQL. * Design and implementation of database backup strategy and performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem. * Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes. Monitor and Tuning of Database Performance by using various optimization techniques. * Making AWR, ASH and ADDM report. * Provide 24/7 monitoring of network and database operations (all kind of log file) to ensure top operating efficiency. Interacted with Oracle Support for resolving various critical database issues. * Estimate Storage requirement, Creation of Table spaces and other Database Primary Objects. * Clone/Refresh of Production databases to Testing and training environments. * Setup and supported for Oracle 10g HA solutions including RAC, Standby servers, Data Guard and Golden gate.

oracle apex developer, database administrator

octalsoft

2014-1 - Present · 12 yrs 9 mos

* 1. Responsible for provisioning, maintaining and improving upon server infrastructure, Also provided * 24/7/365 on-call support. * 2. Experience of Ec2 console. * 3. Installation MySQL, phpmyadmin, Apache, Glassfish server on Linux and Window based servers. * 4. Migration of one server to another server - MySQL database and hosting website. * 5. Formulated SQL queries, functions and processes as per customization required for APEX. * 6. Used Oracle APEX 4.0 to 5.0 for designing application structure. * 7. Supported APEX applications and conducted performance tuning for PLSQL. * 8. Form Design, Coding & Testing on Oracle APEX 5.0 and PL/SQL * 9. Designing, developing and deploying of custom reports in BI Publisher 10g, iReport (Jasper Report) * and FOP. * 10. Integrating Oracle Application Express (APEX) with BI Publisher and Jasper Reports. * 11. Install, patch and maintain all Oracle Apex. (Including installation of Apex 4.0 to 5.0) * 12. Configure E-Mail and SMS Notification. * 13. Integration Apex Listener,ORDS,PDF reports with Glassfish and Apache Tomcat Servers.