Senior DBA
VIP group of industries
Total years of experience :14 years, 8 Months
Configured and Support to the Oracle 11g in Tea ERP system. Backup Recovery, tuning the database optimizing the database. Setting up the schema, user rights in the development Environment . Securing the Database.Maintaining and running the Oracle Database of more than 1000 branches across India.
Clone test instance to support Development team.
In charge of the Data center.
MySQL and SQL Server also part of the RDBMS supported.
Part of the work in assisting the management on IT infrastructure and growth.
ExaminERP, Oracle 10G ERP implementation on Hassan’s optical as a complete business solution .Full SDLC implemented.
This project was a migration from pre-existing non-Oracle software to an Oracle server side process written in PL/SQL. Following the successful completion of this project, my skills were transferred to another part of the system under development. My main tasks were the design of PL/SQL code and database structures to CBA standard for server side batch processing. Furthermore, as part of the development DBA team, I reviewed PL/SQL code written by other developers and DBA advising on best practice for concurrency and scalability in a RAC environment.
creating users Written DB monitoring scripts in shell Index Rebuilding and Gathering the stats on every week end.Made customization on application as per our requirements in SHELL Script Performance tuning
Giving Assist to Developer in DBA absence
Working as pert Developer and part Astt DBA
A premier institute in India which has a background of many industry leaders as its alumni. The course offered as full Computer Science course primarily focused on development aspect. The labs had the UNIX VAX 5.0 system 7x24 basis. Window lab as well as UNIX lab.