Sam Pravin

 Responsible for all end to end technical activities starting from setting up daily monitoring, space requirements, backup and recovery strategies, migration, upgrade, estimation of space growth, user administration, job monitoring etc.  Designing, Implementing and administering database High Availability solutions like Real Application Clusters and standby databases, as per defined standards. Maintaining the environment to ensure high availability and reliability.  Setting up and configuring Backu

 Administered 150+ Oracle databases, both OLTP and data warehouse for our client Delphi.  Installed, configured and administered Real application cluster (RAC) setup in windows and UNIX platforms.  Monitoring and working on priority tickets trough HP Open view service desk tool.  Responsible for backup and recovery of database, Using RMAN backup and also export files.  Tuned the databases resulting in a 10% performance boost (20% is excellent).  Lead Production Support and Design DBA

 Administered 20+ Oracle databases totaling 1500 GB, both OLTP and data warehouse for our client Sprint Telecom.  Modifies less complex client databases, which includes table creation, table modification, table sizing, etc.  Responsible in Monitoring database-locking issues and tuning the database using stats pack report  Responsible for monitoring of locks and resource consuming queries using statspack  Responsible for Patch (CPU patches, interim/bug fix patches) applications in the Development server

 Implemented, administered and subsequently tuned a 1000+ GB database for Insurance application (Oriental insurance Ltd) which resulted in 20% overall performance increase. Was the production support DBA.  Developed the distributed database systems reducing significant load on the databases.  Setup oracle replication of data from production to reporting databases.

 Staging and Production Database Deployment  Managing Database tables and views  Continuous Monitoring of DB Activity  Regular Backup of Databases

Computer Science

Computers

Commerce