Management Oracle

Summary & Objective:-

o **+ years of expertise in Database Administration. Having expertise in different flavours of RDBMS such as Oracle, MySql, Sql Server, and DB2 etc.

Extensively worked on:

o Oracle Database Administration Support involves Monitoring, Maintenance, Cloning, Patching and Troubleshooting of Production, Staging and Development environments

o Databases Upgrade from 8.x to 9.x to 10g/ 11g, DB Reorg and Performance Tuning

o Installation and Configuration of databases

o Executed several projects include

Migration of Databases from non-RAC to RAC (including non-ASM to ASM) – from 9i to 10g/11g

Replication using Golden Gate across production db clusters.

Setup of Physical Standby for Non-RAC systems

Databases consolidation part of Server Consolidations

Rebuild of RAC systems part of Capacity Management

o Database Modelling and Design

o Involved in the Project/Product development process/cycle of all the stages of several software applications with different enterprise architectures.

o 99.99 database availability.

Technical Skills:-

RDBMS Oracle 8.X/9.X/10g/11g, MYSQL

HelpDesk Tools Remedy, HP Service Desk, Peregrine, Manage Now

Tools TOAD 6.3, Erwin 4.1, MS-Visio, Case Studio

O/S UNIX flavors, Windows

Experience Summary:

Role: Senior Analyst – Oct 2007 – Till Date

• Simulating the production problems in the development environments

• Refreshing the database(s) from production to non-production.

• Setting up the new boxes from the scratch for the development teams

• Installing the IRB application

• Capacity Planning

• Upgradation/Migration of databases

• Data Modeling

• Consolidation of Databases/Servers

• Performance tuning in application development

• Applying Security Patches/Bug Patches

• Pre/Post System Maintenance Activities

• On-call Support during Production release

• Participating in the reviews during different phases of Database Changes

• Commission/Decommission of the databases

• Replication the production environment to Raute environment

• Creating database packages.i.e database changes, handing over to UAT, pre-prod and Production databases.

• Sync the non-prod databases with production database(s) using Golden Gate

• Bi-directional replication using GoldenGate

• Configuring Active-Active RAC systems for optimal utilization of the infrastructure

• Writing shell scripts and stored procedures for the critical business requirements in new and existing projects

• Part of technical architecture team to prepare the deployment architecture for the clients.

• Monitoring, Maintaining and Troubleshooting of Oracle RAC and Non-RAC Databases on various platforms

• Support the Implementation of Oracle Management Pack across all environments

• Configuration of RAC stand-by databases for standalone database and vice-versa

Role: Lead DBA – Nov 2005 – Oct 07

Leading a team of 24 people that provides 24x7 Production support for a biggest bank at USA, and maintaining the client database infrastructure.

Responsibilities:

• Making enhancements to the current process and make the support more effective viz. Backup strategies, uptime etc.

• Preparing the documents for the Patch management.

• Preparing the documents for the upgradations and migrations.

• Maintaining SLA commitments for problem management, change management and uptime.

• Complying with the client security and audit policies.

• Capacity forecasting for the production databases.

• Conversion of Non-RAC databases to RAC database.

• Database Cloning, Patching for RAC and Non-RAC Systems

• Solution Analyst for RFS assignments

• Assist Incident management in supporting problem analysis and RCA; especially for high-severity incidents

• Database Upgrade and Reorg for RAC servers

Role: DBA- July 2004 – Nov 2005

Responsibilities:

• Managing physical database resources

• Monitoring database performance issues and jobs.

• Trapping long running SQL and suggesting solution

• Tablespace management and user management

• Review and Implement the changes to the production databases

• Move, rebuild, or change database objects as required in production

• Helping application developers to write optimized SQL queries

• Raising SR’s to Oracle support for critical issues

• Monitoring performance and growth of tables/ indexes. Impact of growth on usability of indexes by the optimizer

• Review and monitor system and instance resources to insure continuous database operations (i.e., database storage, memory, CPU, network usage)

• Staging of data from production to test and development environments.

• Performing Database Migrations

Project: RCM

24X7 support for a 3 node RAC production system which has 2 node RAC development and test systems. It is an Investment banking organization.

Responsibilities:

• Collecting AWR &ADDM reports weekly twice

• Implementing production changes

• Rebuilding of indexes

• Simulating test and dev environments with production

• Monitor system and database resources

Database Administrator – Feb, 2004 – July, 2004

Responsibilities

• Development

• Designing of different tables which satisfies 3rd form of Normalization

• Database Creation

• Schema Creation and granting privileges to users.

• Writing Procedures, triggers and restructuring of reports.

• Estimation of the DML operations on each table

• SGA sizing

• Tablespace Management

• Partitioning of Tables

• Identification of Complex Queries and improving the performance of queries.

• Configuring multiple Buffer pools

• Preparing Backup strategies

ComdotLMS:

ComdotLMS is a Computer Based Integrated Learning System. It is the process of delivering learning opportunities electronically via the internet/intranet. It enables learning at learners own pace and time. Availability of the content at all times online or offline enables easy repetitive learning. E-Learning draws on the power of computers to offer a rich variety of multimedia elements and integral interactivity.

Responsibilities

• Database Design

• Object Creation and User Administration

• Differentiating table types for Schema Objects

• Schema Design, Objects Sizing, Disk Space Requirements and projections.

• Planning, Documenting and implementing a backup strategy for the databases.

Software Tools: Java, Servlets, XML, Tomcat 5.0, Mysql, SCORM RTE 1.2

Database Administrator - Jul, 2001 – Feb, 2004

Responsibilities:

• Design & Creation of Schema Objects.

• Objects Sizing, Disk Space Requirements and projections.

• Creation of the Database, Users, Quotas, Privileges for Users.

• Responsible to upgrade forms and reports as per the user requirement and migration of database from earlier version to new version.

• Laying down the standards for SQL and PL-SQL. & Tuning

• Planning, Documenting and implementing a backup strategy for the databases.

• Writing Scripts for default installation and creating a new database in Windows NT Environment, Start up and Shutdown of Database.

• Configuration of Oracle Server, SQL*Net Clients.

• SQL*Net Trouble Shooting.

• Updating the Windows Entry Registry for Oracle Instance

Software Tools: Oracle 8.x, Developer2000, Visual Basic, Third Party tools.

Programmer – Dec, 1999 - Jun 2001

Worked on several software package(s) development which includes the following responsibilities and using the following software tools:

• Coding

• Debugging

• Unit Testing

• Integration Testing

• Module Testing

• Documentation

Software Tools: Oracle 7.x/8.x, Developer/2000

Contact this candidate