Sr Oracle DBA / Architect

ABHIJIT DESHPANDE

E-mail: *****************@*****.***

Pleasanton CA USA

Cell: 703-***-****

Summary

Ten years of IT experience in Oracle DBA, Data Warehousing, Oracle based web application design-development , Data modeling and PL/SQL programming on Windows NT and Unix environments. He has International exposure, worked for 6 years in USA and 9 months in UK and providing support and solutions around the globe, Coordinate, arrange meetings to design new process and implement the design. He has proven project lead experience in SQL server consolidation project, Oracle database consolidation project and other various projects. He possesses proven project management skills and strong database and People and System management skills.

Strong Leadership qualities, interpersonal, time management, process improvement and organizational skills. Excellent grasping of the client process, system architecture, and client requirements. Proven team player with strong ability to multitask.

Experience in Managing as a project lead for SQL Server and Oracle consolidation project and Oracle Database Administration saving 1 million Dollars.

Experience in designing scalable application architect for database and monitor the progress of development of the application from the development team.

Taking lead to automate various processes to improve the quality and reduce time for the process thus reducing the cost to the company and increasing the productivity.

Well experienced in designing and implementing the backup strategy.

Performing Database Cloning using RMAN and standby databases.

Experience in administering large databases (4 TB) and applications. Strong skills in Data Warehousing, Database tuning/trouble shooting and System Administration.

Implementing 9i / 10g / 11g RAC Data Guard and switching the database from primary to standby.

Upgraded database from 10G to 11G and aware of 11G new features.

Experience in working with Materialized views, External tables, Partitioning and Parallelism features.

Performed Oracle software and database installation, up gradation patch application.

Experience in Oracle Database Administration covering ER model design, size estimation, development and implementation on various platforms like Solaris 5.9 / HP UNIX 11.0 and WinNT4.0/2000.

Confident in transaction optimization in high-rate OLTP instances by monitoring I/O bottle-necks related to object pinning, SGA allocation, swapping/paging, sort space, redo log buffer etc. Experience in using Explain Plan, Tkprof to fine tune SQL execution plans.

Experienced in configuring and implementing Master-To-Master oracle database replication. Monitor and resolve replication issues and Streams.

Hands-on experience in PL/SQL coding, UNIX Shell scripts, CRON jobs and other scheduling tools like Autosys.

Point in Time Recovering database using hidden parameter.

Actively involved in testing, quality assurance and deploying systems to customers.

Designed and headed development team in Client-Server applications using Oracle and forms 4.5 /6.0, Pro*C and ASP applications.

Skills

DBMS Oracle 7.x / 8i / 9i / 10g / 11g (RAC , Non-RAC) , SQL Server.

Front End/GUI Developer 2000, Visual Basic 6.0, ASP

OS/Environment Solaris 5.9, Linux, HP Unix 11i, Windows NT / 2000 / 2003

Tools Informatica, Toad, SQL Developer,Quest Central, Oracle Grid Control, Erwin, Visio, MS Project, Autosys, Autocad.

Employers :

Advantage Resourcing August 2009 till date

Designation : Senior Consultant

Enterprise Solutions, Inc. September 2005 to August 2009

Designation : Senior Consultant

Patni Computer Systems August 2001 to August 2005

Designation : Software Specialist

Rolta India Ltd July 1999 to August 2001

Designation : CAD Prod Executive

FX Computers August 1998 to July 1999

Designation : Software Engineer

DSA Engineers July1994 to July1998

Designation : Sr Project Engineer.

Project Information

Employer : Advantage Resourcing

Project : :Wells Fargo Bank.

Title : Sr Consultant

Software : SunOS 5.6, HP UNIX, Linux, ORACLE 8x, 9x, 10x ,11x (RAC, Non-RAC)

Duration : (August 25 , 2009 – Till date) TAC World Wide

(February 12, 2007 – August 8 , 2008) Enterprise Solutions, Inc

Location : San Francisco, CA .

Wells Fargo is Bank in west coast .There are various application for internet banking like Bill Pay, Transferring, Alerts, etc. Handling databases of size 7 TB.

Responsibilities:

Installing and creating Oracle 10g , 11g RAC / non-RAC databases with ASM.

Configuring, Monitoring 9i / 10g / 11g oracle standby database and switching / failover to standby database in RAC / non- RAC environment.

Prticipating with the development team to analyse the requirements and build scalable design and tuning database / sql.

Migrating database (500 GB, 7 TB) to new servers.

Database Growth monitoring and capacity planning and resource allocation.

Converting reqular tables to partition tables.

Process improvement for the applications.

Trouble shooting for improving system improvement.

Writing shell scripts to automate various processes.

Setting up rman backups from scratch for unix , windows, RAC , Non RAC.

Upgrading database from 8x,9i,10g to 11g ans applying PSU patch.

Assigning tasks and moniroring to the team in India and follow-up on that.

Discussion with the application team for database sizing and costing.

Working on security for database and implementing it.

Installing OEM grid control , agents, Oracle creating databases and users Implementing roles, privileges and security.

Data base refresh from production to test / staging environment using following tools

Using Shadow copy

Using Hot backup

From standby database.

Data Pump

Creating technical documents (run books).

Configuring and monitoring Oracle streams in production.

Trouble shooting on stream latencies.

Partition maintenance on various databases.

Dealing with data corruption.

Leading efforts to trouble shoot problems for shadow copy failures, Application / Database errors.

Writing UNIX scripts and suggesting and implementing system changes to stabilize the environment.

Automating various processes for timely deliveries and reducing manual interaction.

Trouble shooting and tuning if the application / SQL are running slow.

Employer : Enterprise Solutions, Inc

Project : Cisco

Title : Database Architect

Software : Linux, Sun Solaris ,Windows 2000, ORACLE 10x , Erwin

Duration : (February 24, 2009 – August 25 , 2009)

Location : San Jose, CA.

This is a warehouse application where users can generate the reports for their router performance and find solution for the router failures.

Responsibilities:

Creating project plan using MS Projects.

Assigning tasks to developers and monitor the deliverables.

Designing and proposing the application database architect for various applications

Analyzing the business requirements.

Designing Logical and physical models as per the business requirements.

Creating the physical structures in the database.

Installing and configuring Oracle server.

Tuning SQL statements.

Generating design documents required for the application.

Designing and implementing the data load processes.

Assigning the tasks to the developers.

Employer : Enterprise Solutions, Inc

Project : H5

Title : Sr Database Administrator / Architect

Software : Linux, Windows 2000, ORACLE 10x , SQL Server 2005

Duration : (August 8, 2008 – February 23 , 2009)

Location : San Francisco, CA.

H5 conduct large-scale document analysis and review projects in support of our clients' critical legal objectives.

Responsibilities:

Leading the project to complete for the delivery to clients.

Follow-up for the server readiness to install databases.

Interacting with QC / Engineering to fix the bugs before releasing servers to client.

Installing Oracle 10g software and creating databases as required for various projects.

Installing SQL server databases as required for the projects.

Database Growth monitoring (Adding data files) and capacity planning (Talking to end users to see what is more space required over the project) Monitoring memory usage.

Database performance improvements.

Changing next extent sizes.

Modifying memory parameters.

Creating technical documents.

Oracle installation.

Data push from ETL to Production server.

RMAN set-up and use.

Designing and implementing backup strategy for Oracle and SQL server.

Used data pump and added email notification.

Implemented RMAN backups.

Reconfigured the SQL Server Backups.

Installing Oracle Enterprise Manager Grid control and adding Oracle database to monitor.

Installing Oracle 10g RAC on Linux.

Automating various processes like creating schemas for the project.

Pushing data from ETL Oracle server to Production Oracle Server using data pump.

Reviewing database design from the application view.

Upgrading from 10g to 11g and testing the application.

Routine administration and maintenance tasks.

Creating users and assigning roles in Oracle and SQL server.

Rebuilding indexes.

Suggesting various process improvements for new releases of application.

Employer : Enterprise Solutions, Inc

Project : Infineon / Qimonda

Title : Database Administrator

Software : SunOS 5.6, HP Unix ORACLE 8x, 9x, 10x

Duration : (October 2005 – February 2007 )

Location : Raleigh NC.

There are various web based applications accessed by users all over US and the Globe. The Oracle database (OLTP and Data Warehouse) is in Tera bytes. The applications uses backend as Oracle 9x and SQL Server 2000 / 2005 as backend.

Responsibilities:

Installing Oracle 10g RAC, creating databases and users Implementing roles, privileges and security.

Project Management for MS SQL server upgrade / consolidation project from SQL Server 2000 to SQL Server 2005 cluster environment.

Saved MS SQL Server licensing cost to the company up to $150k PA.

Requirement gathering and cost estimation.

Arranging kick off meetings. Presenting the project plan. Project review every 8 days.

Coordinating with the application owners , business owners for migration.

Install MS SQL Server 2005 (cluster), migrate the databases. Guiding the team to achieve the target date to migrate the databases to the production farm.

Rollout in production for each applications.

Preparing for the Data Center move.

Designing and implementing backup strategies for Oracle and SQL Server.

Data refresh from production to test environment using following tools

Oracle: - RMAN - database cloning, import export for 250 GB database using named pipes.

Implementing 9i Data Guard.

SQL Server Backup and restore.

Resolve queries for the application developer/User.

Automate Logical Backups from cron jobs.

Creating technical documents.

Employer : Patni Computer systems

Duration : (Sepetember 2001 to August 2005)

Location : Mumbai India / USA / UK

Working for Various GE clients in US and UK.

Responsibilities:

Gathering and consolidating information for all the database servers across PCS.

Migrating databases of various versions to Oracle 8i on one server.

Installing Oracle on Win NT/ 2k / UNIX.

Planning, Designing ,Creating new databases ,Implementing roles, privileges and security.

Transferring data to the new servers.

Regularly monitoring database performance.

Creating the users as & when new resource allocated to project.

Space management on database servers.

Data refresh from production to offshore Test / Development

Troubleshooting Database Problems faced by the application developer/User

SQL and Server tuning.

Providing solutions for high availability applications in proposals.

Recovering Oracle database due media failure.

Making Proposals.

Managing DBA team and leading and assigning Job activities to the team members.

Monitoring the project and performance of the team members.

Data Modeling using Erwin.

Installing Designer 2k and creating repository.

Creating informatica mappings for data ware house.

Employer : Rolta limited

Duration : (July 1999 to August 2001)

Location : Mumbai India

NGRID (New England Electric System Geographic Information System) provides electric supply to major states in U.S.

Responsibilities:

Installing oracle and Creating users and assigning roles to different users.

Performance tuning / Query Optimization using SQL plans, memory management, developing coding standards and database management

Loading data from MS Access to Oracle using various Oracle utilities.

Developing Oracle Forms for data entry, QC reports in PRO*C

Designing the scripts in Pl/sql to generate the required data.

Taking database backups.

Developing a report in excel sheet through macros.

Employer : F. x Computers

Duration : (August 1998 to July 1999)

Location : Mumbai India.

Responsibilities:

Designing of schema. Creating users and assigning roles.

Developing and testing forms for data entry.

Designing and testing the database.

Connecting Database server for production operators

Employer : DSA ENGINEERS

Duration : July1994 to July1998

Location : Mumbai India.

Responsibilities:

Designing various fires fighting systems using Auto Cad.

Managing Projects on various sites in Mumbai / Goa / Pune / Gujarat.

Designing the pump room required for the fire fighting pumps.

PERSONAL DETAILS

Name : Abhijit Deshpande

Education : Bachelor of Engineering from Vishvakarma Institute of

Technology. Pune.

Contact this candidate