Professional Experiences
- Having more than 10+ years of working Experience in RDBMS, DBA, software analysis, design, development and deployment and administration (Oracle and Ingres DBA/Solaris, Hp-UX System Admin). RDBMS, particularly in the field of ORACLE 7.3/8.0/8i/9i, and development using Forms 4.5/5.0/6.0/6i and Reports 2.5/3.0/6i, Designer/2000.Citrix management etc.
- Highly skilled, self-motivated IT professional in development and support of enterprise systems. Main Area of expertise is in Project Management / Oracle and Ingres Database Administration (DBA), System Analysis, Design, Implementation and application development using Oracle 7, 8,8i, 9i, 10g and front-end tools like Developer 2000, Forms, reports, Ingres 6.4,Ingres II, ABF, Report Writer.
- Having 10+ Years of Oracle Database Administration exp. for Oracle 6/7/8/9i/10g on different platform like Solaris, Linux, Windows 2000/2003/XP. Creation of Database, tablespace, user with proper security and privileges. Tested Backup recovery plans on test environment and implemented on production database. Using server managed backup recovery (RMAN) as well as user managed. Perform, RAC, Data Guard, FLASH Back Query etc
- Experience in tuning of database including design, application, I/O, memory, lock. Rollback, sorting area. Used STATPACK, Explaiplan, Datapump, exp imp and sqlloader. Successfully tuned long running job (10 hours) to 1 and 1/2 hour.
- Ingres Database to Oracle Database migration
- Expertise in Database Design, Architect, Developed and deployed almost all the back office Software's used in IIT Kanpur (Payroll, Finance and account, Pension, HR, Purchase, Project Monitoring etc) using Forms 4.5/5.0/6.0/6i and Reports 2.5/3.0/6i, Designer/2000.
- Intensively involved in full SDLC of all the modules to process payments, Scholarship, pension, Fund and income tax, payroll, personnel management system etc
- Re-engineering of the projects developed in Ingres 4GL and Report writer and Ingres II Database to Oracle Forms 6i and Reports 6i, and Oracle Database.
- DBA (database administration) of Oracle8i/9i Database on Sun/Windows platform.
- Ingres DBA- managing the Ingres II Database for legacy application on HP-UX.
- System Administration for HP-UX 11.00, SUN Solaris, Linux red hat Windows NT/2000/2003, Citrix Metaframe Administration and DHCP Administration.