Sr Developer & Analyst
Resume:
Oracle DBA,RMAN,RAC
Rajeev Kshirsagar
Cell- 973*******
Email:**********@*****.***, ******.***@*****.***
Career Objective : Be an outstanding Oracle DBA, database performance tuning.
Summary :Total IT experience 12 Years
• Having 4+ years of experience as a Database administrator
• Good knowledge on Oracle Database Architecture.
• Oracle Server Installations on Linux Flavors.
• Creating users and Providing quotas, roles, privileges and profiles to users.
• Creation of DB links and Materialized Views.
• Experience in Import & Export, data pump (expdp/impdp) Utilities.
• Experience in taking Online, Offline and RMAN Backups.
• Performed number of dev, test Cloning from PROD databases.
• Experience in Import & Export, data pump (expdp/impdp) Utilities.
• Exposure to RAC 11g.
Certification:Oracle 11g OCA
Training:
Linux Bash Shell Scripting Linux Learning Center Bangalore
Oracle 11G Workshop II Oracle Corporation Bangalore
11G RAC Administration Oracle Corporation Bangalore
Education :
Degree Board/University Mark Year
SSC(10th) Pune 79.57% 1989
HSC(12th) Pune 67.50% 1991
BE(Electronics) Shivaji University Kolhapur 59.13% 1995
Experience
Organization Designation Duration
IBM Sr. System Analyst 06/2011-Till
V2Soft PVT. Ltd. Module Leader 12/2009-06/2011
Wipro Technologies Module Leader 06/2006-12/2009
Ebz online Pvt. Ltd. Pune Sr. Developer 08/1998– 3/2005
Experiences/Projects :
1)Client:BCBSM
Duration: 12/2009 06/2011
Role: Oracle DBA
Project Description:
A major goal was to strengthen and support the automated submission and processing of claims by capturing all benefit rules and medical policies within a single source of truth - the Benefits database, and by providing tools that simplified the process of codifying and formalizing rules found in all policy and contractual documents.
• Managing day-to-day activities and database maintenance.
• Database creation as per customer requirements.
• Creation of additional tablespaces and adding data files to tablespaces whenever required.
• Monitoring alert log to monitor the day-to-day DBA activities.
• Database Cloning as per requirement.
• Maintenance of Tablespaces , Datafiles, Control files, Redolog files.
• Database Maintenance for Archive logging.
• Taking Back-up of the Database.
• Database monitoring and Administration activities.
• Creating tablespaces, users and roles for test environment.
• Up-gradation of database from lower version to higher version.
• Knowledge on Recovery of the database in case of failures
• Design data model for application module.
2) Client: Pearson
Duration: (08/2007) – (11/2009)
ROLE: Database Developer and DBA
Project Description:
School Success is a highly customizable, secure, online technology platform that is designed for the ongoing collection of assessment and portfolio data for students. It provides administrators and teachers with easy to use tools for managing ongoing assessments and documenting students work, while also providing data for school, district, and state reporting.
• Creating new schema for different environment.
• Closely co-ordinate with client side DBA for performance issue.
• Database development for application.
• Uploading files using Sqlloader utility.
• Database creation for UAT and DEV environment.
• Providing solutions for Production environment.
• Performed database Hot and Cold backup and recovery for 10g databases
• Having experience in creation and maintenance of the users along with security roles and privileges.
• Database Cloning as per requirement.
• Implemented physical design.
3) State Street
Duration : ( 06/2006) – (05/2007)
Role: Oracle Developer and DBA
Project Description:
MyStateStreet (MySS)
• My.statestreet.com is the portal through which clients access State Street online applications and services, their information, statistics and reports. An entitlements scheme ensures that users have access to all of the functionality and applications they require, and have the appropriate level of authorization to access data to which they are entitled. The portal structure builds a single infrastructure, a single Web presentation, and single security layer.
Role: Oracle DBA
• Maintanence of application MyStreet portal.
• Maintenance of Tablespaces , Datafiles, Control files, Redolog files.
• Taking Back-up of the Database (Physical & Logical).
• Raising tickets for third Party vendor.
• Maintaining application version.
• Uploading files using SQL Loader.
• Monitoring Database performance and space.
• Design database objects (Creating tables ,index,constraints,sequences,synonyms)
• Coding using PL/SQL developer (Creating Procedure, functions and Packages).
• Developing ad hoc queries.
4) Indian Co-operative Banks in India.
Duration: (08/1998) – (03/2005)
Project description
Module: Agriculture loan interest calculation.
Description: This module maintains the record of all crop loan accounts and there respective interest rates, different interest methods ,all credit debit transactions ,interest transactions ,detail information about the crop, detail information about different schemes e.g. Subsidy against loan . Also it maintains record of the arrear interest. When interest is calculated it is credited to profit and loss account and debited to interest receivable account and inserts record into arrear. At the time of recovery the interest amount credited to interest receivable account and debited to profit and loss account and also it deduct the same amount from arrear balance. If debited interest is not recovered it is considered as an overdue interest .Overdue interest is calculated with penal interest. For smooth and decision making operation flags are created at front end.
Module: Recurring deposit interest calculation.
Description: This module is developed to automate interest calculation of Recurring deposit accounts with specified interest rate .After calculation interest amount is credited to customer account or arrear account and total interest amount is debited to profit and loss account .If account is irregular then system calculates interest with penal interest specified by the organization.
Module: Cheque Clearing System
Description: This module is developed to automate the bank branch clearing consolidation. In this process all cheques are credited to head office and bifurcated branch wise. An automated transaction is generated. In this transaction Cheque amount is debited to branch account and credited to a customer account.
Responsibility:
• As a database developer, was responsible for executing and ensuring successful and timely execution of above modules from a technical/ functional perspective.
• Analysis of the specifications provided by the clients.
• Perform business requirement analysis document.
• Design database objects (Creating tables ,index,constraints,sequences,synonyms)
• Coding using PL/SQL developer (Creating Procedure, functions and Packages).
• Developing front end for using Forms Developer 2000.
• Developing ad hoc reports.
• Self initiative for maintain quality of application.
• Testing - unit testing & integration testing.
• Customization (like fixing the bugs, enhancements etc.) to suit the business needs of the customer.
• Client site for product implementation.
As Database Manager I was responsible for
• Installation of Operating system and Oracle.
• Database creation, user creation.
• Recovering data from corrupted table.
• Managing size of the table space.
• Up gradating Oracle 7.x to Oracle 8.x
• Data purging.
• Maintaining cold backup, export, import utility.
• Providing training to end user customer for data backup.
• Solving online database related problems.
• Applying application software release patches.
• Building customer confidence.
• Suggesting modification to developer team for enhancement.
Personal Details:
Name Rajeev Kshirsagar
Email Id **********@*****.*** ,******.***@*****.***
Passport No. E8372733 Valid Up to: 05/2014
Location Bangalore
Contact Numbers Mobile: 973*******
VISA B1
Country Traveled USA (Boston)
Notice Period 1 Month
DOB 10/Jan/1974
Contact this candidate