Objective
Professional Summary

Total 13 years of experience in IT.
Over 9+ years of experience in Oracle Database AdministrationDeveloper.
Experience in Data Modeling, Design, Testing, Development & Production support
Managed Installation, Configuration and Administration of Oracle 8i/9i/10g Databases.
Created database, database objects like table, index, DB Link, table space, rollback segments, and views & Materialized Views and analyze relevant objects to collect statistics to tune the system performance.
Tested and Implemented different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import.
Defined backup procedures alert checking, and remote archive copying, monitoring and tuning databases.
Tuned application with EXPLAIN PLAN and TKPROF, analyzing database objects, maintaining the security of the databases.
Participated in the development and testing of backup and restore strategies for development and production system.
Applied Oracle Software patches whenever required.
Worked on Database Sizing, Rollback Segments and Queries. Performed STATSPACK tuning.
Created and maintained UNIX scripts for Oracle maintenance and statistics.
Altered, modified, Partitioned, dropped, created database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM (Oracle Enterprise Manager).
Implemented multiplexing of control files and redo-logs for disaster recovery scenario.
Monitored Rollback segments and its Space management.
Installed, configured and administered Data Guard Environment.
Developed the scripts for creating the Users and allocation of rolls to the users and maintaining system security.
Checked Alert files and Trace files regularly.
Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, patch runs, monitoring, performance tuning, restructuring of databases, trouble shooting.
Good knowledge in design, development and testing of backup and recovery to ensure complete recoverability.
Skilled in logical and physical database design. Experienced in logical data modeling including business rules.
Erwin Model Mart in multi-user environment with for normalized and dimensional data structure.
Highly skilled in disaster recovery, routine maintenance for Oracle databases.
Experienced in advanced replication, & one physical standby database using Data Guard 9i.
Oracle Data Dictionary and Tunable init.ora parameters.
Database migration from 7.3 to 8i & 8i to 9i using FTP for file transfer, SQL Loader, Toad export feature.
Wrote UNIX K-Shell scripts for hot backups, SQL Loads, export and import of database.
Familiarity with Oracle 10g. Perform Database Sizing, Object Sizing and planning adhering to Oracle OFA & OLAP Databases.
Perform Daily Monitoring of Oracle Instances using Oracle Enterprise Manager, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
Excellent interpersonal and strong analytical, problem-solving and conceptual skills.

An Oracle DBA with rich experience maintain Databases of different sizes and voluminous transactions on 24/7 basis

Educational Qualification
Bachelor of Engineering (B.E) Computer Science & Engineering
Technical Skills
HARDWARE :Pentium, RS-6000, RAC, RAID, SAN
OPERATING SYSTEMS:Windows NT, Sun-Solaris, Sco-Unix, HP UNIX, VAX/VMS,AIX
LANGUAGES :PL/SQL, C, C++, Pro*C, UNIX Shell Programming, Perl
Databases :Oracle 7.x/8.x/9.x/10g, Oracle Applications 11i, Ms-
Access, SQL-Server 2000, Peoplesoft
GUI :Developer 2000, VB, Oracle discoverer
TOOLS & UTILITIES :RMAN, Quest.com, Oracle Enterprise Manager,
Erwin, Abinitio
Designer 2000, MS-Visio, Tkprof, RMAN
DOMAIN KNOWLEDGE :Logistics, Banking, government, Insurance
Testing Tools : Load Runner, SiteScope, BAC
Application Server : Oracle Application Server 10g.
Data warehouse Tools : Oracle Warehouse Builder, Informatica

Professional and Project Experience


Fannie Mae, USA Oct '2007- Till Date


Hot and Cold Backups
Shell Scripting,
Restoration Space Management,
Tuning Memory, SGA, I/O,
Security Management,
Objects sizing Strategizing Backups including usage of RMAN Database Recovery, Involvement in Database Migrations
Snapshots creations
Strategizing and troubleshooting
Helped the Client solve critical business needs by modeling and maintaining the business intelligence database environments.
Primary responsibilities were to logically and physically model source system and business intelligence databases and ensure the overall health and performance of the business intelligence database environment.
Expertly used modern data modeling concepts (star schema, - snowflake schemas, and highly normalized data models) and data modeling tools such as Erwin.


GE Health Care, USA Jan'2007- Oct2007

Supporting 300 Databases which includes production, test & development.

Communicates physical database designs to impacted parties.-
Evolves- models to meet new and changing business requirements.
Implemented ASM for all 10g databases
Provided production support by monitoring the processes running daily.
Involved in the debugging of the mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
Created partitions through the session wizard in the server manager to increase the performance.
Created mappings with PL/SQL Procedures/Functions to build business rules to load data.
Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
Maintain of Oracle VPD Database
Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures for performing different database tasks. Used paced command of in UNIX scripts.
Created complex joins, transformations of all types to pass data through ETL maps.
Recommended tuning options to source/target database DBA team to gain optimum performance.
Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Sessions, Batches and the Target Data.
Excellent interpersonal and strong analytical, problem-solving and conceptual skills
This project is in study phase which has to be implemented in 3 tier architecture.
This project Installed oracle 9i & applied patch set on development & production server.
Setup the advanced replication for a single master site & a snapshot site in development & production.

Environment: Oracle 8.x/9.x/10g,/11i,Windows,RAC, MS-SQL Server 2000, UNIX, Erwin, Developer2000, Windows, 3Tier Architecture. HP-UNIX, VAX-VMS, Abinitio

Dynegy, USA May'2006- Jan2007


Configured Oracle servers and optimized initialization parameters in INIT.ORA (DB Block Size, DB Block Buffers, Shared Pool Size, and Sort Area Size) and adjustment of OS Kernel parameters.
Installation of ASM
Installation of Flash Back Recovery
Usage of Recycle Bin
Usage of Online Segments Shrink
Online building indexes
Usage of iSQL-PLUS
Implemented ASM Features in 10g
Usage of Oracle Streams which allows data sharing between Oracle databases and between Oracle and non-Oracle databases.
Diagnosed and tuned databases for performance problems and lock conflicts using monitoring and diagnostic tools, shell scripts and dynamic performance V$ views & Materialized Views.
Refreshed development and test databases from production database using Exp/Imp to provide the latest data is available in the development/test database for the developers.
Executed file system, server based (RMAN) backups and logical (exp) backups. Executed complete and incomplete media recovery procedures (Time/Change/Cancel-based).
Installed, configured and administered Standby Database. Cloned databases for testing.
Loaded data from flat files to Oracle databases and migrated from older Oracle versions.
Managed Users access control and security by creating appropriate roles and profiles.
Implemented and configured Oracle Net and resolved connectivity issues.

Contributed in Database Installations,
Database Recreations,
Moving the database on the network 24 x 7 support on pager call duty,
Troubleshooting and Problem resolution Exports/ Imports,

Environment: Oracle 8.x/9.x/10g,Windows, UNIX, Erwin, Developer2000, Oracle Warehouse Builder, Windows, 3Tier Architecture, Oracle Discoverer, MS-SQL Server 2000, Abinitio

Polaris Software Lab, India
Senior Oracle DBA Oct 2005 May2006
Intellect - A complete lending management product (Retail & Corporate)
Responsibilities
Worked on OLTP Databases & DSS Systems
Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, monitoring, performance tuning, restructuring of databases, trouble shooting.
Good knowledge in design, development and testing of backup and recovery to ensure complete recoverability.
Skilled in logical and physical database design. Experienced in logical data modeling including business rules with
Erwin Model Mart in multi-user environment with for normalized and dimensional data structure.
Highly skilled in disaster recovery, routine maintenance for oracle databases.
Experienced in advanced replication, & one physical standby database using Data Guard 9i.
Perl programming
Oracle data Dictionary and Tunable init.ora parameters.
Database migration from 7.3 to 8i & 8i, 9i to 10g using FTP for file transfer, SQL Loader, Toad export feature.
Wrote Unix K-Shell scripts for hot backups, SQL Loads, export and import of database.
Familiarity with oracle10g. Perform Database Sizing, Object Sizing and planning adhering to oracle OFA
Perform Daily Monitoring of oracle Instances using oracle Enterprise Manager, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
Usage of Oracle Streams which allows data sharing between Oracle databases and between Oracle and non-Oracle databases.
Set up OMS & configured RMAN for backup & recovery of existing instances on development & production servers.
Planned and implemented archival, backup / recovery of databases.
Fine tuned the memory & init.ora parameters for databases (1 TB).
Performed application, SQL, and database instance tuning using a wide range of technologies including Statspack, SQL Trace (Event 10046 trace files), OEM Performance Manager, and custom scripts.
Configured Standby Database in manually managed mode. Shell scripts and Cron jobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change controls to GE-Capital Bank.
By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
Performed Smoke testing during the installation of every full build for the Intellect Lending 9.5.0 application to validate the fitness of the application for testing.
Functionality testing has been performed against the identified modules. The testing was primarily intended to facilitate the Business Scenario execution, to identify the defects at the earliest so that the Business Scenario execution can be smooth.
The functional test cases do not cover inter-module integration, which was covered in the identified Business Scenarios
Maintenance of front end applications like Java

Environment: Oracle 8.x/9.x/10g,RAC, Oracle Warehouse Builder, Windows, UNIX, Erwin, Developer2000, Windows, 3Tier Architecture, Oracle Discoverer.

GE Money Bank, Austria
Sr. Oracle DBAMarch 2005 to September 2005
Pan Credit a Lending software package was obtained by GE-GCF, to cater their Lending and Leasing Business needs. Suitable software modifications are made to the product to meet the requirements of GE Capital Bank.

Responsibilities:

By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
User names are changed to new names as per business requirement during migration time.
Suggested for the Backup strategy as per affordable downtime of production system.
Worked on Recovery manager to recover the Database.
Also involved in SQL performance tuning.
Creation of database links
Estimating the size of Databases.
Creating Databases
Migration of Oracle DB from 8.1.6.3 , Oracle 9.1.0.4 to 10g
Executing and monitoring offshore Batch run operations (End of the Day and Start of the Day of operations of GE-Capital Bank
Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
Checking the Alert Logs of production Databases for any errors reported by Oracle.
Adopting change control Mechanism (Lotus Notes Server) for replicating the changes made to the production Databases.
Export and Import of databases from one database to another databases.
Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database)
Attending specific requests from online, bug fixing, Bulk rate, Data warehouse Teams.
Adhering the process as per GE Security guidelines.

Environment: Oracle 9.x/10g, SunSolaris, Shell Scripts, Windows, DataGuard, Windows, 3Tier Architecture

British Petroleum, UK
Sr. Oracle DBA July 2004 to Feb 2005
BPLPG A Project where was implemented in backend oracle whereas data was taken from DB2 and Loaded in oracle Through SQLLoader and designed the database.

Responsibilities:

Installed database in Sun Solaris on staging server.
Tuned database parameters and applications for optimal performance.
Responsible for support of the databases and database servers which includes performance monitoring, performance tuning, optimize programming code/ SQL, troubleshooting and client support.
Actively involved in archival, backup / recovery, import / export (SQL Loader) of relevant data.
Used Toad and SQL Plus for executing PL/SQL procedures, packages for business.
Wrote shell scripts to backup, restore database and automate daily activities.
Installed Oracle RAC with Data Guard implementation for disaster recovery.
Used Erwin for physical data model design.
Database Design,
Backup & Recovery,
Tuning the Database and
Analyzing the Database,
Coding PL/SQL & Shell Scripts,
Database Maintenance,
Data warehousing.
Database Design,
Data Modeling using Erwin
software design of medium/large business applications
Design methodologies
Database (SQL)design
E-R Modeling.
Design and Development Of database design
Design/Code reviews & Materialized Views
Environment: Oracle 9.x, UNIX, Shell Scripts, DB2, SQL-Loader, Oracle Warehouse Builder

Metro Retail Group, Germany
Sr. Oracle DBA Nov 2003 to Jun 2004
Logos A retailer system with more than 22,000 users worldwide. A FoxPro to Oracle migration Project with Oracle Server as Back-end and Forms & Reports as Front End with Data warehousing. Scope included: Maintain Customer support Database, Testing Database, Design database.

Responsibilities:
Managed Installation, Configuration and Administration of Oracle 8i/9i Databases.
Created database, database objects like table, index, DB Link, table space, rollback segments, and views & Materialized Views and analyze relevant objects to collect statistics to tune the system performance.
Tested and Implemented different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import.
Defined backup procedures, alert checking, and Remote archive copying, monitoring and tuning database using cron jobs.
Tuned application with EXPLAIN PLAN and TKPROF, analyzing database objects, maintaining the security of the databases.
Participated in the development and testing of backup and restore strategies for development and production system.
Applied Oracle Software patches when required.
Worked on Database Sizing, Rollback Segments and Queries. Performed STATSPACK tuning.
Created and maintained UNIX scripts for Oracle maintenance and statistics.
Altered, modified, Partitioned, dropped, created database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM (Oracle Enterprise Manager).
Implemented multiplexing of control files and redo-logs for disaster recovery scenario.
Monitored Rollback segments and its Space management.
Installed, configured and administered DataGuard Environment.
Developed the scripts for creating the Users and allocation of rolls to the users and maintaining system security.
Maintenance of front end applications like Java
Checked Alert file and Trace files regularly

Environment: Oracle 8.x, RAC, AIX, Shell Scripts, Developer 2000, Oracle Warehouse Builder

UBS Singapore,
Sr. Oracle DBANov 2002 to Oct 2003
Customer Support Database Maintenance - The project aimed to monitor 50 different databases and provide customer support.

Responsibilities:

The activities included the database administration of the various databases assigned to the division for the internal as well as external clients.
Installation of the Databases, Environment Building to OFA compliancy
Control File Maintaince
Backup Cold, Hot, Online, Exports
Remote sessions tracing
Recovery Manager (RMAN) Implementation and strategies
Database Designing using ERWIN
Various Database Recovery scenarios verification in advance
Altering the Database objects and files during maintenance
Strong experience in Oracle Databases Migration and Upgrade.
Solved issues related like Space Management, Locks resolution, Batch Job failures, Database Cache Hit Ratios (SQLCache, Library Cache, Data Dictionary Cache) and Backup failures.
Performed daily monitoring and checking of the alert Logs for errors.
Resolved Oracle networking and connectivity issues.
Wrote some utility SQL and Shell scripts for performing routine database activities.
Researched and Identified Issues or Problems. Provided Solutions and Work with vendors / Oracle Support to open tar if necessary. Ensured all cases are resolved to customer satisfaction and solutions are properly documented.
Implemented Backup and Recovery strategies using User-Managed and RMAN backups.
Wrote scripts to automate routine database monitoring, diagnostics and backups.
Created user profiles and roles. Also granted system level and object level privileges to users.
Performed Resource Management by creating and managing Indexes, Clusters, and Tables.
Managed physical storage structures like Datafiles, Redo logs, Control files. Managed logical storage structures like Tablespaces, Segments and Extents.
Created DTS packages and migrated data from MS Access and from flat files. Created jobs to automate repetitive tasks. Upgraded SQL Server 7.0 to SQL Server 2000. Resolved SQL Server issues relating to DTS connectivity, replication and backup/restore
Environment: Oracle 9.x, VAX-VMS, Shell Scripts, DataGuard, Oracle Warehouse Builder


HRC Hyderabad
Oracle DBA July 2001 to Oct 2002
Online Information Management System To maintain departments like Oracle HRMS, Oracle Payroll, Racing Accounts, Administration, Secretarial Department Accounts, Racing Accounts, Racing department, Tote, Civil Engineering & Electrical Engineering Privileges, Reports.

Responsibilities:

Installed and configured Oracle Servers on UNIX, Linux and Windows. Applied Oracle Corporation recommended patches. Created development, test and production databases.
Created storage structures and database objects. Performed database maintenance including tablespace management, tablespace sizing and resizing, creating and rebuilding indexes and large table management through partioning and user tablespace quota management.
Created tablespaces based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces for proper account I/O load distribution.
Configured Oracle servers and optimized initialization parameters in INIT.ORA (DB Block Size, DB Block Buffers, Shared Pool Size, and Sort Area Size) and adjustment of OS Kernel parameters.
Diagnosed and tuned databases for performance problems and lock conflicts using monitoring and diagnostic tools, shell scripts and dynamic performance V$ views & Materialized Views.
Refreshed development and test databases from production database using Exp/Imp to provide the latest data is available in the development/test database for the developers.
Executed file system, server based (RMAN) backups and logical (exp) backups. Executed complete and incomplete media recovery procedures (Time/Change/Cancel-based).
Installed, configured and administered Standby Database. Cloned databases for testing.
Loaded data from flat files to Oracle databases and migrated from older Oracle versions.
Managed Users access control and security by creating appropriate roles and profiles.
Implemented and configured Oracle Net and resolved connectivity issues.
Contributed in Database Installations,
Database Recreations,
Moving the database on the network 24 x 7 support on pager call duty,
Troubleshooting and Problem resolution Exports/ Imports,
Hot and Cold Backups
Shell Scripting,
Restoration Space Management,
Tuning Memory, SGA, I/O,
Security Management,
Objects sizing Strategizing Backups including usage of RMAN Database Recovery, Involvement in Database Migrations
Snapshots creations
strategizing and troubleshooting
DBA JOBS scheduling, monitoring and maintaining,
Jobs scheduling with CRON TAB
Altering the Database objects and files during maintenance
Environment : Oracle 11i, Shell Scripts, Windows

ECIL, Hyderabad
Oracle DBA Dec 1999 to June 2001
Computerization Of Ration Card A Database where daily around 50MB transactions were getting inserting.

Responsibilities:

Installed and migrated Oracle Servers on Sun Solaris, SQL Servers, Linux and Windows. Created databases, storage structures and database objects. Performed database maintenance using Oracle Tools and Utilities like Server Manager, SQL Plus and Oracle Enterprise Manager.
Managed databases including space management, Rollback segments and Extents management, tablespaces and datafiles management, monitoring and resizing. Multiplexed control files and redo groups members and replicated data using snapshots and db links.
Performed Performance monitoring and tuning through Alert and Trace logs for problem queries, tuned Shared Pool size, Library Cache, Buffer Cache, used oracle database block size efficiently, optimized sorts operations, monitored tablespace I/O, tuned rollback segments and monitored and detected locks and latch contentions and eliminated the dead locks.
Installed, configured and maintained hot standby database for high availability. Cloned databases for developers testing. Loaded data SQL*Loader. Executed hot, cold and logical backup and restore procedures. Managed system resources creating user profiles and roles.
Developed shell scripts to carry out routine checks on databases. This included checking whether all databases are running, listener is up, UNIX error messages, disk space availability, segments nearing max extents, checking regularly the alert logs and trace files for errors.
Coordinated with database administrators, application developers and support personnel to ensure that applications code and databases were configured for optimal performance.
Developed Database Marketing Manager (DMM) as a team member. My responsibilities included analysis and design, code modification and addition more functionality, generation of on-line screens, identification of bugs, making reports on bugs along with possible solution, fixing the bugs, quality testing, creating documentation and user training guides.
Load data using SQL*Loader
Scripts for Complete and
Hot backup, Tuning the database,
SGA sizing,
Give technical guidance to team members.
Create snapshots, views & Materialized Views, remote procedure calls on the remote databases,
Security Management using roles and privileges,
Developing stored procedures, packages, functions and database triggers .
Environment: Oracle 9.x/SQL Server 2000, VAX-VMS, Shell Scripts, Data Guard

International Computers India Ltd.Pune
Oracle DBAOct 1998 to Nov 1999
Automated Timesheet system


Responsibility:

Installation of the Databases, Environment Building to OFA compliancy
Control File modifications and Security
Backup Cold, Hot, Online, Exports
Performance Tuning
Remote sessions tracing
Recovery Manager Implementation and strategies
Database Designing with ERWIN
Various Database Recovery scenarios verification in advance
Altering the Database objects and files during maintenance

Environment : Oracle 7.x, OEM, Toad, Developer2000, Oracle Application Server.

Employment

2005 -  Present
Senior Oracle DBA

Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, monitoring, performance tuning, restructuring of databases, trouble shooting.
Good knowledge in design, development and testing of backup and recovery to ensure complete recoverability.
Skilled in logical and physical database design. Experienced in logical data modeling, business rules with Erwin Model Mart in multi-user environment with for normalized and dimensional data structure.
Highly skilled in disaster recovery, routine maintenance for oracle databases.
Experienced in advanced replication and 1 physical standby database using Data Guard 9i.
Perl programming
Oracle data Dictionary and Tunable init. ora parameters.
Database migration from 7.3 to 8i and 8i, 9i to 10g using FTP for file transfer, SQL Loader, Toad export feature.
Wrote Unix K-Shell scripts for hot backups, SQL Loads, export and import of database.
Familiarity with oracle10g. Perform Database Sizing, Object Sizing and planning adhering to oracle OFA
Perform Daily Monitoring of oracle Instances using oracle Enterprise Manager, monitor users and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.

Excellent interpersonal and strong analytical, problem-solving and conceptual skills
This project is in study phase which has to be implemented in 3 tier architecture.
This project Installed oracle 9i and applied patch set on development and production server.
Setup the advanced replication for a single master site and a snapshot site in development and production.
Set up OMS and configured RMAN for backup and recovery of existing instances on development and production servers.
Planned and implemented archival, backup or recovery of databases.
Fine tuned the memory and init. ora parameters for databases.
Performed application, SQL and database instance tuning using a wide range of technologies, Statspack, SQL Trace, OEM Performance Manager and custom scripts.
Configured Standby Database in managed mode. Shell scripts and Cron jobs are written to transfer the logs to standby site at frequent intervals and apply to the Standby Database as per Business requirements.
Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change controls to GE-Capital Bank.
By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
Performed Smoke testing during the installation of every full build for the Intellect Lending 9.5.0 application to validate the fitness of the application for testing.
Functionality testing is performed against the identified modules. The testing was intended to facilitate the Business Scenario execution, to identify the defects at the earliest so that the Business Scenario execution is smooth.
The functional test cases do not cover inter-module integration which was covered in the identified Business Scenarios

Environment : Oracle 8. x/9. x/10g, RAC, Windows, UNIX All, Erwin, Designer
Flavours, Developer2000, Standby, Replication, Windows, 3Tier Architecture, Oracle Warehouse Builder, Windows

2005 -  2005
Senior Oracle DBA

Pan Credit a Lending software package was obtained by GE-GCF, to cater their Lending and Leasing Business needs. Suitable software modifications are made to the product to meet the requirements of GE Capital Bank.

Responsibilities :
By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
User names are changed to new names as per business requirement during migration time.
Suggested for the Backup strategy as per affordable downtime of production system.
Worked on Recovery manager to recover the Database.
involved in SQL performance tuning.
Creation of database links
Estimating the size of Databases.
Creating Databases
Migration of Oracle Database from 8.1.6.3, Oracle 9.1.0.4 to 10g
Executing and monitoring offshore Batch run operations End of the Day and Start of the Day of operations of GE-Capital Bank
Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
Checking the Alert Logs of production Databases for any errors reported by Oracle.
Adopting change control Mechanism for replicating the changes made to the production Databases.
Export and Import of databases from 1 database to another databases.
Monitoring the performance of production database through Instance Monitor and growth of the database and suggesting for change in parameters if required.
Writing the shell scripts to automate the Backup and copying the production copies to Test environment. Scripts to copy from 1 test database to another database
Attending specific requests from online, bug fixing, Bulk rate, Data warehouse Teams.
Adhering the process as per GE Security guidelines.

Environment : Oracle 9. x/10g, RAC, SunSolaris, Shell Scripts, Windows, DataGuard, Replication, Windows, 3Tier Architecture

British Petroleum, UK
Senior Oracle DBA June2004 to Feb 2005
BPLPG A Project where was implemented in backend oracle whereas data was taken from DB2 and Loaded in oracle Through SQLLoader and designed the database.

Responsibilities :
Installed database in Sun Solaris on staging server.
Tuned database parameters and applications for optimal performance.
Responsible for support of the databases and database servers which includes performance monitoring, performance tuning, optimize programming code/ SQL, troubleshooting and client support.
involved in archival, backup or recovery, import or export of relevant data.
Used Toad and SQL Plus for executing PL/SQL procedures, packages for business.

Wrote shell scripts to backup, restore database and automate daily activities.
Installed Oracle RAC with Data Guard implementation for disaster recovery.
Used Erwin for physical data model design.
Database Design, Backup and Recovery, Tuning the Database and Analyzing the Database, Coding PL/SQL and Shell Scripts, Database Maintenance, Data warehousing.
Database Design, Data Modeling using Erwin software design of medium/large business applications
Design methodologies
Database design
E-R Modeling.
Design and Development Of database design
Design/Code reviews
Environment : Oracle 9.x, Unix, Shell Scripts, DB2, SQL-Loader

2002 -  2004
Senior Oracle DBA

Managed Installation, Configuration and Administration of Oracle 8i/9i Databases.
Created database, database objects like table, index, Database Link, table space, rollback segments, views and analyze relevant objects to collect statistics to tune the system performance.
Tested and Implemented different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial exportimport.
Defined backup procedures, alert checking, Remote archive copying, monitoring and tuning database using cron jobs.
Tuned application with EXPLAIN PLAN and TKPROF, analyzing database objects, maintaining the security of the databases.
Participated in the development and testing of backup and restore strategies for development and production system.
Applied Oracle Software patches when required.
Worked on Database Sizing, Rollback Segments and Queries. Performed STATSPACK tuning.
Created and maintained Unix scripts for Oracle maintenance and statistics.
Altered, modified, Partitioned, dropped, created database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
Implemented multiplexing of control files and redo-logs for disaster recovery scenario.
Monitored Rollback segments and its Space management.
Installed, configured and administered DataGuard Environment.
Developed the scripts for creating the Users and allocation of rolls to the users and maintaining system security.
Checked Alert file and Trace files regularly

Environment : Oracle 8.x, RAC, AIX, Shell Scripts, DataGuard, Replication, Developer 2000. webservers, discoverer

2003 -  2003
Senior Oracle DBA

Customer Support Database Maintenance - The project aimed to monitor 50 different databases and provide customer support.

Responsibilities :
The activities included the database administration of the various databases assigned to the division for the internal and external clients.
Installation of the Databases, Environment Building to OFA compliancy
Control File Maintaince
Backup Cold, Hot, Online, Exports
Remote sessions tracing
Recovery Manager Implementation and strategies
Database Designing using ERWIN
Various Database Recovery scenarios verification in advance
Altering the Database objects and files during maintenance

Strong experience in Oracle Databases Migration and Upgrade.
Solved issues related like Space Management, Locks resolution, Batch Job failures, Database Cache Hit Ratios like SQLCache, Library Cache, Data Dictionary Cache and Backup failures.
Performed daily monitoring and checking of the alert Logs for errors.
Resolved Oracle networking and connectivity issues.

Wrote some utility SQL and Shell scripts for performing routine database activities.

Researched and Identified Issues or Problems. Provided Solutions and Work with vendors or Oracle Support to open tar if necessary. Ensured all cases are resolved to customer satisfaction and solutions are documented.
Implemented Backup and Recovery strategies using User-Managed and RMAN backups.
Wrote scripts to automate routine database monitoring, diagnostics and backups.

Created user profiles and roles. Also granted system level and object level privileges to users.
Performed Management by creating and managing Indexes, Clusters and Tables.
Managed physical storage structures like Datafiles, Redo logs, Control files. Managed logical storage structures like Tablespaces, Segments and Extents.
Created DTS packages and migrated data from MS Access and from flat files. Created jobs to automate repetitive tasks. Upgraded SQL Server 7.0 to SQL Server 2000. Resolved SQL Server issues relating to DTS connectivity, replication and backuprestore
Environment : Oracle 9.x, RAC, VAX-VMS, Shell Scripts, DataGuard

2002 -  2002
Oracle DBA

Online Information Management System To maintain departments like Oracle HRMS, Oracle Payroll, Racing Accounts, Administration, Secretarial Department Accounts, Racing Accounts, Racing department, Tote, Civil Engineering and Electrical Engineering Privileges, Reports.

Responsibilities :
Installed and configured Oracle Servers on UNIX, Linux and Windows. Applied Oracle Corporation recommended patches. Created development, test and production databases.
Created storage structures and database objects. Performed database maintenance, tablespace management, tablespace sizing and resizing, creating and rebuilding indexes and large table management through partioning and user tablespace quota management.
Created tablespaces based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces for proper account I/O load distribution.
Configured Oracle servers and optimized initialization parameters in INIT. ORA like Database Block Size, Database Block Buffers, Shared Pool Size, Sort Area Size and adjustment of OS Kernel parameters.
Diagnosed and tuned databases for performance problems and lock conflicts using monitoring and diagnostic tools, shell scripts and dynamic performance V$ views.
Refreshed development and test databases from production database using Exp/Imp to provide the latest data is available in the development/test database for the developers.
Executed file system, server based backups and logical backups. Executed complete and incomplete media recovery procedures.
Installed, configured and administered Standby Database. Cloned databases for testing.
Loaded data from flat files to Oracle databases and migrated from older Oracle versions.

Managed Users access control and security by creating appropriate roles and profiles.
Implemented and configured Oracle Net and resolved connectivity issues.
Contributed in Database Installations, Database Recreations, Moving the database on the network 24 x 7 support on pager call duty, Troubleshooting and Problem resolution Exports/ Imports, Hot and Cold Backups
Shell Scripting, Restoration Space Management, Tuning Memory, SGA, I/O, Security Management, Objects sizing Strategizing Backups, usage of RMAN Database Recovery, Involvement in Database Migrations
Snapshots creations strategizing and troubleshooting
DBA JOBS scheduling, monitoring and maintaining, Jobs scheduling with CRON TAB
Altering the Database objects and files during maintenance
Environment : Oracle 11 .x, Shell Scripts, Windows

1999 -  2002
Oracle DBA

Computerization Of Ration Card A Database where daily around 50MB transactions were getting inserting.

Responsibilities :
Installed and migrated Oracle Servers on Sun Solaris, Linux and Windows. Created databases, storage structures and database objects. Performed database maintenance using Oracle Tools and Utilities like Server Manager, SQL Plus and Oracle Enterprise Manager.
Managed databases, space management, Rollback segments and Extents management, tablespaces and datafiles management, monitoring and resizing. Multiplexed control files and redo groups members and replicated data using snapshots and Database links.
Performed Performance monitoring and tuning through Alert and Trace logs for problem queries, tuned Shared Pool size, Library Cache, Buffer Cache, used oracle database block size efficiently, optimized sorts operations, monitored tablespace I/O, tuned rollback segments and monitored and detected locks and latch contentions and eliminated the dead locks.

Installed, configured and maintained hot standby database for high availability. Cloned databases for developers testing. Loaded data SQL*Loader. Executed hot, cold and logical backup and restore procedures. Managed system resources creating user profiles and roles.
Developed shell scripts to carry out routine checks on databases. This included checking whether all databases are running, listener is up, Unix error messages, disk space availability, segments nearing max extents, checking regularly the alert logs and trace files for errors.
Coordinated with database administrators, application developers and support personnel to ensure that applications code and databases were configured for optimal performance.
Developed Database Marketing Manager as a team member. My responsibilities included analysis and design, code modification and addition more functionality, generation of on-line screens, identification of bugs, making reports on bugs along with possible solution, fixing the bugs, quality testing, creating documentation and user training guides.
Load data using SQLLoader
Scripts for Complete and Hot backup, Tuning the database, SGA sizing, Give technical guidance to team members.
Create snapshots, views, remote procedure calls on the remote databases, Security Management using roles and privileges, Developing stored procedures, packages, functions and database triggers.
Environment : Oracle 9.x, RAC, VAX-VMS, Shell Scripts,, Replication, DataGuard

1998 -  1999
Oracle DBA

Education

Miscellaneous
Technical Skills
HARDWARE : Pentium, RS-6000, RAC, RAID, SAN
OPERATING SYSTEMS : Windows NT, Sun-Solaris, Sco-Unix, HP UNIX, VAX/VMS, AIX
LANGUAGES : PL/SQL, C, C++, Pro*C, Unix Shell Programming, Perl
Databases : Oracle 7. x/8. x/9. x/10g, Oracle Applications 11i, Ms-
GUI : Developer 2000, VB
TOOLS and UTILITIES : RMAN, Quest.com, Oracle Enterprise Manager, Erwin, Designer 2000, MS-Visio, Tkprof, RMAN
DOMAIN KNOWLEDGE : Logistics, Banking, government, Insurance
Testing Tools : Load Runner, SiteScope, BAC
Application Server : Oracle Application Server 10g.
Data warehouse Tools : Oracle Warehouse Builder
Reporting Tools : Crystal Reports, Oracle Designer, Oracle Discoverer

Professional and Project Experience

Responsibility :
Installation of the Databases, Environment Building to OFA compliancy
Control File modifications and Security
Backup Cold, Hot, Online, Exports
Performance Tuning
Remote sessions tracing
Recovery Manager Implementation and strategies
Database Designing with ERWIN
Various Database Recovery scenarios verification in advance
Altering the Database objects and files during maintenance

Environment : Oracle 7.x, OEM, Toad, Developer2000, Oracle Application Server 10g.