Oracle Manager

Manpreet Bajwa

PROFESSIONAL SUMMARY

> More than 7 years of experience as an ORACLE DBA (8i/9i/10g/11g) on

different UNIX environments like - AIX, Linux, HP-UX, Sun-Solaris and

Windows 2000/NT.

> Experience in Installation, Upgrades and Patches. Duties included

database creation, tuning/reorganization, cloning, backup/recovery,

user and security management, auditing, general troubleshooting, and

configuring servers.

> Designed logical and physical Data Models using ERWIN forward-

engineered into DDL and executed on large scale to create database.

> Experience in Upgrade and Migration of Oracle database to higher

version and other platforms using Oracle Data Migration Assistant.

> Trained on oracle Real Application Clusters (RAC) technology on 4

nodes. Runtime connection load balance.

> Extensive experience working on 10g Grid controller.

> Great OID working knowledge.

> Strong Knowledge of SQL/PLSQL Code.

> Experience with the forward and reverse engineering using Erwin.

> Experience in database Partitioning.

> Experience on Oracle Data guard and Oracle Streams (Advanced

Replication) for high Availability.

> Designed and implemented backup and recovery strategies. Extensively

used conventional and RMAN for backup and recovery. Experience in

advanced recovery methods like PITR and TSPITR. Logical backup using

and full/ partial export/import and Data Pump.

> Supported the system 24x7. Ability to work beyond regular hours.

> Installed and configured Oracle 10g (10.2.0.2) Database on HP-UX and

Linux advance Server on Development, Test and Production boxes.

> Efficient in Performance Tuning of database, instances, SGA, I/O, and

Rollback segment using different methods and detecting locks.

> Loading the data from flat files into tables using sqlloader and ETL

tools like pervasive.

> Efficient in SQL query Optimization using explain plan,

Utlbstat/Utlestat, TKPROF reports, gathering statistics, pinning the

objects, Running scripts.

> Experience in working with OLAP and OLTP.

> Knowledge of shareplex.

> Experience in development and operation of Unix shell scripting.

> Experience in Full Life Cycle of database administration. Worked both

as a development and Production Support DBA.

> Experience working with Oracle 11g installation, configuration, backup

recovery etc

> Experience working with Oracle Streams & Data guard.

> Troubleshoot Database performance issues using Automated Workload

Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

> Extensively used Oracle Enterprise Manager (OEM) for maintaining and

monitoring multiple databases.

EDUCATIONAL QUALIFICATIONS

Education: Bachelor of Engineering in Information Technology from Punjab

Technical University, INDIA.

TECHNICAL SKILLS

OPERATING SYSTEM: HP-UX, AIX 4.3/5.1, LINUX (Red Hat Enterprise

Server), Sun Solaris UNIX, WINDOWS NT

DBMS: ORACLE 8i/9i/10g, DB2/UDB, RDBMS

TOOLS: Oracle Migration Workbench, SQL-Backtrack,

Platinum - Performance Monitor, OEM, Power

Designer, Erwin, TOAD, DBArtisan, SQL* Loader,

Crystal reports 2.5

LANGUAGES: SQL, PL/SQL, UNIX Shell scripting, PERL

PROFESSIONAL EXPERIENCE

Family Medicine Centre, Bellevue, Washington

Duration: Dec 08 - till date

Position: Oracle DBA

Electronic Medical Record (EMR) Application is used by the physicians to

electronically record patient's health history. The system records the

patient's personal information, symptoms, problems, allergies, medication

notes and other related information.

Responsibility:

> Managing production, development, staging & QA databases of

different versions 9i/10g/11g on Sun Solaris, HP-UX & Linux.

> Installed and configured Oracle 10g Database on HP-UX and Linux

advance Server on Development (& Windows 2003), Test and Production

Systems.

> Installed and configured Oracle 11g Database for Development

purpose.

> Created and maintained Databases and their objects like tablespaces,

tables, indexes, views.

> Configured Oracle Enterprise Manager & Administered Database Using

OEM.

> Involved in performance monitoring and tuning of the database by fine

tuning the database implementation.

> Scheduled jobs to run on daily/weekly/monthly basis.

> Performed heavy data transfer using import/export utility and data

pump.

> Performed heavy data loads using SQL*Loader.

> Performed RMAN and user managed backup also hot /cold backups

> Identified and solved performance problems using Automated Workload

Repository and Automatic Database Diagnostics Monitor.

> Generated Monthly Metrics for Database performance & Activity

Review.

> Maintained and monitored multiple databases using Oracle Enterprise

Manager 10g Grid.

> Designed and Implemented database security using Oracle roles and

privileges.

> Creating database objects like tables, views, synonyms, triggers,

procedures, links etc.

> Created documents for company specific environment of Database &

servers.

Environment: Oracle 11g/10g/9i, HP-UX B11.23, SunOS 5.10, Linux 2.4.21,

2.6.9, Toad, OEM 10g Grid Control, Tkprof, Explain Plan etc,

Avaya, Baskin Ridge, New Jersey

Duration: Aug 08 - Dec 08

Position: Oracle DBA

Avaya designs, builds, deploys and manages Communications Network for

variety of private businesses and Government entities. They provide both

Voice and Data communications over LAN and WAN networks. It is deployed

across multiple locations and managed from a central point.

Responsibilities:

> Worked on 3 node RAC environment for Development DB's.

> Understanding the existing Database Structure and suggesting the

Database Reorganization.

> Involved in designing and creating schema objects like Database

tables, indexes, views, and synonyms.

> Granting and Revoking privileges and roles to the users on different

objects depending on their work requirement and providing the

necessary security to the database.

> Importing and exporting files, databases, schemas and tables using

SQL loader and utilities like Import, Export and Data Pump features

of Oracle database 10g.

> Production Support and Database Monitoring for performance of

Databases.

> Tuning database server and application logic for performance

improvement by using Explain Plan and TKPROF.

> Developed technical documentation for disaster recovery

> Gathering Statistics using the DBMS_STATS Package.

> Scheduled various database jobs using DBMS_SCHEDULER packages.

> Generation of the AWR (Automatic Workload Repository) Reports and

using them for tuning the database.

> Creation of Shell Scripts to automate the Data Loading process and

for automation of various Database Monitoring activities.

> Hands on experience working with Oracle Grid Control Environment.

Environment: Oracle 10g, IBM-AIX, Red Hat Linux, OEM 10g Grid, Toad,

Erwin, TKprof, DBArtisan, Statspack etc.

Prequel Solutions, McMurray, PA

Duration: Sept 07- Aug 08

Position: Oracle DBA

Developed a Web based application for TEGG Cooperation whose core business

is protecting commercial and industrial facilities from electrical system

failures, electrical fires and resultant business interruptions and

property damage through the implementation of unique and comprehensive

electrical preventive and predicative maintenance function.

Responsibilities:

> Installation and configuration of Oracle Database Software 10g & 11g.

> Creation and Configuration of Oracle database.

> Performed the Pre-migration task for RAC & Standalone Database.

> Worked on RAC on Red Hat Linux Advanced Server with 4 nodes server side

load balancing using Automatic Storage Management

> Worked on Physical as well as Logical Data modeling.

> Export & import data from Oracle 10g to Oracle 11g for Development

Purpose.

> Performance tuning of SQL queries and advising the application

programmer of the opportunities in tuning the application.

> Involved in performance monitoring and tuning of the database by fine

tuning the database implementation.

> Designed and Implemented database security using Oracle roles and

privileges.

> Troubleshoot Database performance issues using Automated Workload

Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

Tuned database for optimum performance.

Environment: Oracle 10g/9i, RAC, RMAN, OEM, Functions and Triggers, SQL

Tuning, PL-SQL, Stored Procedures, Erwin, TOAD, PERL, Windows 2003 Servers.

Allstate Insurance,Illinois,USA

Duration: March 07- Sept 07

Position: Oracle DBA

Allstate based on Northbrook, Illinois is one of the nation's leading

insurers and has supported auto and highway safety reforms including seat

belts, air bags and teen driver education. It receives batch files from

mainframe machines on schedule dates. The data is loaded in Oracle Database

and I performed 10g installation and maintained the database.

Responsibilities:

> Written Stored Procedures and Triggers for database maintenance and

management using PL/SQL.

> Communicate and coordinate with Oracle using TAR system for major

database issues/ problems; apply the required patches, test (unit test/

system test) and roll out and implement the patches into production.

> Involved in disaster recovery planning; detailed out the processes and

procedures of implementing disaster recovery; implemented database

backups and disaster recovery strategies using RMAN.

> Installing and Configuring from Oracle 9.2.0.1.0 (9i) database to

Oracle 10g.

> Worked on Oracle Streams (Advanced Replications) and exchanged data

between two databases in remote locations.

> Proactively managed the databases; set up alarms for managing any

exceptions in day to day management of the databases; pre-empted and

prevented issues disasters from happening.

> Upgrade the data's from Existing Oracle 9i to Oracle 10g and Migration

of database (from 9.2.0.5 to 10.2.0.1).

> Successfully implemented physical standby database using Oracle Data

Guard feature for High availability configuration.

> Successfully configured the databases to switchover, failover and

fallback scenarios.

Environment: Oracle 9i/10g, UNIX, SUSE Linux, SUN Solaris 2.7, ERWIN,

DB2/UDB, OEM, TOAD, RMAN, DB ARTISAN.

Merrill Lynch, Hopewell, New Jersey

Duration: June 06-Feb 07

Position: Oracle DBA

Merrill Lynch is a global financial services firm that, through its

subsidiaries and affiliates, provides its products and services to a large

and diversified group of clients and customers, including corporations,

governments, financial institutions and individuals. It operates its

business trough four segments: Institutional Securities, Individual

Investor Group, Investment Management and Credit Services

Responsibilities

> Installation of Oracle 8i/8.x/7.x and other Oracle tools. Part of

the team in testing the compatibility and portability of application

on Oracle.05 by migrating whole application and database from 7.3.2

to 8.05.

> Configured OEM to monitor the databases.

> Planning and troubleshooting Rollback segments.

> Database Security Administration involving creation of users,

managing their roles and privileges.

> Worked in backup and recovery group responsible for disaster

recovery and standby database.

> Used RMAN for backup & Recovery and validated the backups.

> Developing and Tuning SQL, PL/SQL triggers.

> Administered Linux/Windows Systems

> Gained experience in loading data using SQL*Loader.

> Performed capacity planning and sizing of databases based on input

from business.

> Export & import data from Oracle 10g to Oracle 11g for Development

Purpose.

> Partitioning of large tables.

> Created and managed the server parameter file. Created the text

parameter file from the spfile.

Environment: ORACLE 8i/7.x, Sun Solaris UNIX, Windows 2000/XP, SQL,

SQL*Loader, OEM PL/SQL, TOAD.

Comcast Corporation, Philadelphia, PA

Duration: Feb 05- May 06

Position: DBA

The Comcast Corporation's principal activity is to develop, manage and

operate broadband communications network. It operates into reportable

segments: Cable and Content. Cable segment develops, manages and operates

broadband cable systems including video, high-speed Internet and phone

services. Video services include Basic and expanded programming, Premium

channel programming, Pay-per-view programming and Digital cable. High-

speed Internet service helps subscribers to connect their personal

computers via cable modems to access online information. It also provides

regional sports and news networks. Content segment provides services

through six national cable networks such as E! Entertainment Television,

Style Network, the Golf Channel, OLN, G4 and AZN Television. On 31-Dec-

2006, the Group served more than 24.1 million video subscribers, 13.2

million high-speed Internet subscribers and 4.6 million phone subscribers.

Responsibilities:

> Upgrading and migrating database from Oracle 8i to 9i version.

> Design and support complex distributed and replicated database

architecture.

> Creating tablespaces and database files based on the OFA model.

Implemented physical database design after sizing tables and indexes

and creating tablespaces taking into account I/O load distribution.

> Extensively involved in design physical and logical models of the

database.

> Locally managed tablespaces were used which track all extent

information in the tablespace itself. This results in improved

performance as it eliminates recursive operations and reliance on data

dictionary.

> Performed SQL tuning by using Explain Plan and Tkprof

> Making structural changes to the databases when database design

changes are to be implemented.

> Setting up of RMAN environment

> Implementation and maintenance of read only snapshots and snapshot

logs

> Create and maintain staging database environment as well as standby

database.

> Performance tuning for Oracle Real Application Clusters (RAC).

> Refreshing development/test database from production using

Export/Import. This is done so that the latest data is available in

the development/test database.

> Developing UNIX shell scripts, Ant scripts and SQL scripts to carry

out routine checks on databases. This includes checking whether all

databases are running, listener is running, Unix error messages, disk

space availability, segments with greater than 10 extents, segments

nearing max extents, checking for errors in alert logs and trace

files, etc

Environment: Oracle 8.1.6 /9i, HP-UX 10.2/11.0, HP 9000, Windows NT 4.0,

Erwin, Oracle Replication Manager, Export/Import, Unix Shell Scripts,

TOAD, Tkprof and SQL*Net/Net8.

Central Bank of India, Punjab, India

Duration: April 04 - Dec 04

Position: Database Administrator

Central Bank of India was the first Indian commercially bank which is

wholly owned and managed by Indians. The bank has large number of branches

as also the number of saving and other innovative service offered. The

total number of customers is around 25 million is one of the largest in

banking industry.

Responsibilities:

> Prepared test plans and data, and user documentation for customers.

> Developed front-end development.

> Performed front-end coding (Triggers and Procedures).

> Grasp wide understanding of client server architecture

> Improved Oracle PL/SQL procedures and triggers.

> Backup, Export/Import, Database security, disaster recovery and

various database issues.

> Helped developer to install Oracle Client, troubleshoot and

establish the connection to Oracle database through ODBC, JDBC.

> performing the database import/export of schemas on different

databases

> granting the read only privileges on different schemas on different

databases

> Running the scripts on different databases sending by development

team members.

> Verify the blocking objects and killing sessions.

> Bouncing the database as per client request.

> Managing the TNSNAMES.ORA file

> Performance tuning of SQL statements using STATSPACK, TKPROF,

Explain Plan and SQL Trace.

Environment: Oracle 8i/9i, Red Hat Linux, TKPROF, STATSPACK, OEM, PL/SQL

etc.

Nestle India Ltd, Punjab, India

Duration: Jan 02 -April 04

Position: Jr. Oracle DBA

Nestle India Ltd is a vibrant company that provides customer in India with

product of global standard and is committed to long term sustainable growth

and shareholder satisfaction.

Responsibilities:

> Part of team for Database design development, Testing &

implementation.

> Maintaining the database availability and security

> Involved in maintenance & updating the database

> Manage several heterogeneous database instances

> Created Oracle tables in Oracle, Partitioned tables, Created

Indexes.

> Trained on Data modeling using Erwin data modeling tool.

> Recommend alterations/enhancements to improve database optimization.

> Troubleshoot, diagnose and resolve complex database problems;

ensuring high performance operation and minimal disruption of

business critical systems.

> Planning, designing and implementations of strategies for backup &

recovery

Environment: Oracle 8i, Sun Solaris UNIX, AIX, Red Hat Linux, Database

Tools/Utilities, Erwin.

Contact this candidate