Oracle Data

OBJECTIVE

In search of a Sr Oracle production DBA / Architect, Director, Sr IT

manager or a VP position with a progressive top quality organization to

apply my Sr Oracle DBA experience and valuable Sr Level IT skills in order

to become an asset for the company. I am caring, have a passion for IT,

very much enjoy working and have great leadership qualities.

EDUCATION

U.S. International University, San Diego, California

MBA, Strategic IT /Project Management

B.S., Management Information Systems

Oracle certifications, UCSD, San Diego, California

Linux RedHat flavors and Unix Flavors - Classes, Certifications and

Training

Oracle OCP certification, Oracle advanced tuning classes, Oracle RAC

classes, MCSE classes, Informix DBA certification, Informix Internal

Architecture course, Informix Replication, Informix OLTP/DSS and OLAP

systems. Oracle, MySQL, Sybase, DB2, SAP, Peoplesoft classes and Oracle OCP

classes.

Technical Summary

Sr. Oracle DBA, Oracle 6x, 7x, 8x, 9i, 10G and 11G, RAC, Physical and

Logical standbys, Dataguard, Streams Replication, Materialized Views

(snapshots), Goldengate, OEM, Grid Control, ASM, DBCA, DBArtisan,

SQL*Loader, PL/SQL, PeopleSoft environments and SAP, OID, LDAP,

TNSnames.ora, init.ora and spfiles, v$ and gv$ dictionary views, 10g and

11g Data Pump, Export, Import, Stored Procedures, Applying Oracle Patches,

Metalink Support Tickets, Upgrading, TOAD, OLTP and DSS, SQL*Plus, SQL

Query execution plans, Tracing, STATSPACK, DBMS_STATS, ADDM, AWR, TKPROF,

UTLESTAT, UTLBSTAT, ORAPWD, Remedy Change Management Process, Erwin, UNIX

SCO, HP, AIX, SUN, Dynix, Linux, RedHat 3,4,5, RAID and SAN Arrays, Unix

shell programming, Perl, Physical & Logical design, Backup and restores,

Reverse Migrations, Refreshes, Dev, QA, UAT and Prod, SOX guide lines and

security setups, Oracle Roles setups, database monitoring with shell

scripts, Disaster Recovery, Data Warehousing, Performance Tuning, RMAN,

Capacity Planning, LOCAL & GLOBAL indexing, Hot and Cold backups, user

PROFILES and Oracle database security, CLOB and BLOB column types, Text

indexes, Creating report only databases using dataguard, familiarity with

new Active Dataguard, C/C++, TCP/IP, DNS, ISP, JAVA Script, FTP, Windows

95/98/NT, MS DOS, PHP, Visual Basic, IBM Sequent servers, Pentium based

machines, Working with various technical and non technical business

professionals providing cutting edge valuable solutions. Sharp and

accurate in troubleshooting issues fast. Capable of multi dimensional

thinking. Naturally forward thinking. Caring attitude, have a passion for

Information Technology and quite enjoy work.

Professional Summary

. 22+ years of extensive experience as Sr.Oracle production DBA on LINUX,

SUN, AIX, HP etc. and 24/7 support

. Extensive experience in installations, configurations, migrations,

upgrades with Oracle 6,7x,8I,9i,10g and 11g.

. Extensive experience in increasing performance from 10%-30% by tuning

init parameters and memory.

. Extensive experience in High Availability solutions and decreasing

production downtimes.

. Extensive experience in database refreshes, database moves, and database

cloning.

. Extensive experience in capacity planning, ASM, SQL Query plans,

contention issues and troubleshooting.

. Extensive experience in disaster recovery, backups and restores and

preventing data corruption.

. Extensive experience in locking issues, long running query issues and

distributed transaction issues.

. Extensive experience in Shell scripting, database monitoring, and server

monitoring for database health checks.

. Extensive experience in physical database design and logical database

design.

. Extensive experience in replication, stand alone instances and RAC multi-

nodes environments.

. Extensive experience in OLTP/DSS configurations, database growth and load

balancing of resources.

. Extensive experience in SGA, PGA, RMAN, DBMS_STATS, PL/SQL, OID, SQLPlus,

OEM Grid etc.

. Extensive experience in implementing mission critical databases and

architecture with scalability.

. Extensive experience in building, maintaining and maximizing IT

partnerships across organizations.

. Extensive experience in implementing database security, patching,

granting access and revoking when needed.

. Extensive experience in SDLC, Change Management, Ticketing processes and

corporate SLA's and compliance.

. Extensive experience in preventing production downtimes in mission

critical databases.

. Extensive experience in locating database problems and resolving them

fast and carefully.

. Extensive experience in database support for DEV, QA, UAT and PROD

systems.

. Extensive experience in coaching developers, testers and QA personnel on

code migrations to production.

. 10 + years of practicing meditation; Hatha Yoga and Vipassana Bhawana.

Professional Experience

CNN

Atlanta, GA

Sr. Oracle DBA

Jan 2005 to Present

. Created mission critical RAC Cluster and stand alone DB environments on

latest Linux RHEL versions.

. Installed Oracle software; 9i, 10g and 11g on various machines.

. Worked with various online mission critical applications providing 24/7

oncall production database support.

. Resolved ASM related issues many times using ASMCMD.

. Worked with various SAN storage admins to support storage maintenance

activities and I/O related work.

. Supported various server migrations, database migrations, moves and re-

orgs.

. Participated in various critical Oracle production database related

meetings.

. Worked with both Cost and Rule based optimizer modes in Oracle database

instances.

. Managed capacity planning for Oracle instances and advised the company

accordingly.

. Collaborated with Oracle support and Metalink for software delivery,

knowledge base, and Sev1 cases.

. Implemented 200 snapshots on a separate instance to use it as a reporting

server minimizing load on production.

. Tuned INIT.ORA and/or SPFILE parameters as needed.

. Restored / Refreshed downstream Oracle database instances for various

DEV, QA, and UAT purposes.

. Played a role as highly mission critical DBA for several bread and

butter applications for the company.

. Created backup strategies to protect company data at zero data loss at

any given point in time.

. Advised worked together with developers in designing good database

security structures to comply with SOX.

. Optimized queries for higher performance from minutes to seconds to

milliseconds to nanoseconds.

. Worked with sys admins for better and faster SAN purchases and proper

allocations of luns to maximize throughput - Raid strategies.

. Participated in various code migrations on daily or weekly basis into

production via Change Control process.

. Implemented a 3 node 10.2.0.3 RAC system, and upgraded it to 11.2.0.3, on

ASM disks - RedHat Linux.

. Worked closely with app/dev teams to resolve post database refresh needs

and changes.

. Implemented table level streams for a subset of tables using table level

streams method.

. Used datapump, exp and imp, materialized views, data guard, rman, sql

loader on RedHat Linux OS.

. Managed a database with 60 partitioned tables which was setup to act as a

mini data warehouse.

. Supported OLTP Oracle databases which supported CNN on-air applications

and movie databases.

. Made sure update stats ran without failures on regular basis for OLTP

instances

. Created and hung shell scripts on crontab for monitoring db instances for

various activities.

. Set up Disaster Recovery / failover using physical standby databases

for mission critical Oracle instances.

. Recommended best database practices, best security protocols, best

Oracle versions, and best DR strategies.

. Maintained and closely worked on production databases and servers for

maximum availability and protection.

. Voted for scalable solutions at all times preserving high quality of the

business and customer satisfaction.

. Housed databases on Cooked files as well as raw devices (ASM storage).

. Helped, mentored, and guided various developers, power users, junior

level dbas and IT security personnel.

. Provided data growth analytics and trends so we knew which areas of the

business

. Patched Oracle databases and OS on regular basis.

. Upgraded Oracle RDBMS from 10g to 11g. Installed Oracle 12c for

prototyping and testing.

. Supported Oracle databases in Peoplesoft and hyperion environments

including a data guard setup for DNS.

. Always focused that my DBA services to the company was in the highest

quality.

. Increased quality, performance, uptime, security, compliance of CNN

oracle databases by about 15% - 30%.

InterCall

Atlanta, GA

Oracle DBA + Informix + MySql / Team Lead

December 2002 to Jan 2005

. Root level access and Oracle access to all production, dev and test

database servers

. Administered an OLTP environment with 300,000 + transactions per day

(200+ transactions per minute)

. Created Oracle objects such as; databases, tables, indexes, columns,

views and triggers

. Tested Oracle 10G, regression testing prior to production implementation

for a 900GB oracle DB

. Added data files when needed in a 800 GB - 1TB Oracle 9i OLTP environment

. Tuned SGA and flushed shared pool (when flushing shared pool 3

consecutive iterations recommended)

. Researched Metalink for corruption issues, performance issues, bug

reports, security issues etc.

. Created TARs for Oracle support cases and used change management process

to deploy code in production dbs

. Tuned INIT.ORA parameters and SPFILE parameters. Set up TNSNAMES,

LISTENERS and created users

. Increased Oracle open file parameter. Monitored CPU, Memory, tablepsace

and datafile usages.

. Monitored the alert log for database warnings, errors, locking issues

etc. and for health check purposes

. Granted privileges to users and created schema owners. Ran Hot backups

and Cold backups regularly.

. Recovered space by re-orging datafiles and tablespaces. Managed 9iRAC

environment on single node.

. Optimized queries for performance and ran SQL explain plans for review

and recommendations

. Recommended choose base optimizer or ruled based optimizer as necessary.

. Normalized / de-normalized schemas and architecture designs as needed

. Implemented data warehouses using FACT and DIMENSION tables and Star

Schemas

. Worked closely with data warehouse developers to resolve I/O issues,

MEMORY and SQL tuning.

. Implemented RANGE partitioning for huge tables with 200 million rows.

Rebuilt corrupted INDEXES.

. Implemented 3 node RAC using 9.2.0.2 and upgraded to 9.2.0.6 - Cooked

file system (not raw devices).

. Tuned SHARED_POOL_SIZE, DB_CACHE_SIZE, JAVA_POOL_SIZE etc., and KERNEL

parameters

. Backed up databases using RMAN. Resynched CATALOG as needed.

. Worked with dictionary views: V$SGASTAT, V$SQL, DBA_OBJECT,

DBA_DATA_FILE, IO_PER_OBJECT etc

. Restored Oracle 800GB production database 2 times using RMAN and Veritas

NetBackup with 16 channels.

. Worked with app teams on PL/SQL, Query plans, complex joins, and

optimizing queries

. Documented disaster recovery plans. Provided 24/7 production DBA support

with oncall routine

. Implemented STATSPACK for performance monitoring, altered LOG_BUFFER,

monitored latch contentions

. Ran DBMS_STATS as necessary. Analyzed tables as necessary. Recommended

CBO / RBO when necessary.

. Tweaked procedures and packages. Tracked errors when compiling. I am a

command line DBA.

. Advised developers to use trace to identify code issues, created User

PROFILES. Managed db security.

. Recommended using materialized views to replace complex joins and faster

data retrievals

. Created and maintained new instances in testing, development and in

production environments.

. Analyzed database trace files to investigate oracle instance issues.

Mentored junior DBAs.

. Used SQL*Plus always. Used sqlloader and export / import utility. Used

OEM to double check work performed

. Exported and Imported tables, databases for various needs such as for

purging, migration, and recovery.

. Configured OID/LDAP entries, tnsnames, listeners, sqlnet.ora and data

guard on 10g databases.

. Used locally managed tablespaces, dictionary managed tablespaces, and

UNDO manual and automatic

. My dynamic, thorough, persistent and high quality Sr. Oracle DBA

knowledge and my support helped company save money in various occasions

when making IT related spending.

. Scheduled Oracle database maintenance downtimes strategically with the

users and application owners.

. Supported Oracle databases with financial related applications that

generated various critical reports for the business.

SPRINT CORPORATION

World Head Quarters, Overland Park, KS

Oracle Database Administrator

October 1998 to November 2002

. Managed 12 Oracle servers occupied with mission critical databases and

huge tables on 24/7 oncall routine.

. Managed 4 Oracle DATA MARTS from 100 - 150GB both in stand alone and RAC.

. Supported 10 major telephone industry applications with OLTP and DSS

architecture.

. Migrated tables with 100 - 200 million rows across instances, serves and

databases.

. Updated, purged, loaded, unloaded databases amounting to 200 - 1200 in

gigs.

. Altered, modified, dropped, created database objects daily on a 24 X 7

production and testing environment.

. Monitored performance and tuned init.ora parameters. Increased

performance by 10 - 30 % at times.

. Tuned OLTP and DSS type queries, ran sql explain plans for developers,

and reorganized indexes.

. Moved db objects, datafiles and tablespaces to less contentions disk

drives.

. Monitored tablespace IO status to determine bottlenecks. Created LOCAL

and GLOBAL indexes.

. Used SQLPLUS, OEM, DBA STUDIO, and TOAD as necessary.

. Tuned SGA, library cash and shared pool memory. Worked with V$SGASTATS

and V$PGASTATS

. Dealt with Inconsistency issues and block level corruption. Generated

TKPROF, UTLESTAT, TBLESTAT reports

. Backup dbs using RMAN and Veritas NetBackup. Ran Hot backups regularly.

Took Cold backups when needed.

. Analyzed tables, optimized queries and supported development on using

cost base optimizer.

. Exported and imported tables and database across database servers.

. Resolved distributed transaction issues. Diagnosed problems with Oracle

trace.

. Restored development and test databases with production copies for

developers' work.

. Restored a 1 terabyte production server once during a 12 month period due

to corruption.

. Dealt with various Oracle views; V$SYSSTAT, V$WAITSTAT, V$SESSION,

V$PROCESS, DBA_DATA_FILE etc.

. Used SQL*Loader, Export and Import whenever necessary and used password

file authentication ORAPWD

. Tuned I/O intensive code to improve performance and participated in

architecture and design meetings.

. Rebuilt / re-organized indexes and moved tablespaces to less contentious

disk drives.

. Implemented optimizer selections, CBO or RBO optimizer where suitable.

. Increased performance or quality of Sprint dbs by about 15%, which is

outstanding for the amount dbs in place.

United states department of labor

Washington, DC

Oracle Database Administrator

December 1996 to September 1998

. Managed 17 Oracle databases, OLTP 8i with 100GB - 700GB of data.

. Managed production tables with 100 - 300 million rows with portioned

layers.

. Optimized PL/SQL code. Ran ESTATS and BSTATS for review and correction.

. Created, configured and initialized new Oracle and Informix database

instances when needed.

. Monitored and allocated sharedmemory, space as needed and managed

replicated servers.

. Migrated database copies from one server to another almost on daily basis

for developers.

. Dealt with blob issues checkpoint issues, optimization, and CPUVP

allocations.

. Created new tablespaces, added datafiles and resolved disk contention

issues.

. Granted/revoked permissions to/from dbas and users. Enforced usage of

roles.

. Tuned Queries, Oracle and Informix Parameters and developed table

partitioning strategies.

. Implemented changes to production databases via Change Control Processes.

. Designed new databases, tables, indexes, and automated processes using

Unix scripts.

. Resolved inconsistency issues, shared memory issues, long transactions,

locking issues and deadlocks.

. Fixed corrupted pages, corrupted indexes, and monitored alert logs, and

online logs for error messages.

. Built, Managed ETL processes and designed warehousing projects on DSS

systems.

. Assured daily backups and archiving were done accurately and consistently

using RMAN, ontape and onbar

. Restored Oracle and Informix instances when all other options of disaster

recovery had failed.

. Created shell scripts for monitoring all United States Dept. of Labor's

db engines located around the country.

. Assured load balancing, monitored disk I/O statistics, chunk I/O

statistics read/write ratios and fixed problems.

. Increased Production across OLTP systems by 25% by reconfiguring init.ora

and Informix parameters.

California Marketing Corp

San Diego, California

Oracle Database Administrator

January 1993 to November 1996

. Root level access to the database servers.

. Tuned, monitored and managed very large databases ranging from 100GB to

600GB.

. Installed Oracle7 and 8, created instances and databases on SUN UNIX

A1000s.

. Used DDL and DML (data definition language and data manipulation

language) queries as needed.

. Monitored alert logs, daily backups, transaction logs and usage of shared

memory allocations.

. Tuned cache hit ratios to be above 90% or better. Monitored SGA and

Library cache.

. Performance tuning using TKPROF, UTLBSTAT, UTLESTAT to generate reports

and sql explain plans.

. Implemented backup/restore strategies, procedures and database security.

. Granted permissions to end users according to their level of access to

database objects.

. Implemented partitioning / fragmentation strategies for large tables with

150- 200 million rows.

. Created/altered databases, table extents, indexes, constraints, and

schemas as necessary.

. Shrinked or extended datafiles when needed for space management.

. Ran all system level commands for health checks; sar, top, vmstat,

mpstat, prstats, iostat -xne, ipcs etc.

. Mentored junior dbas and supervised their work for accuracy and

improvement.

. Worked on DSS systems and OLTP systems simultaneously.

. Tuned SGA related parameters; DB_BLOCK_BUFFER, SHARED_POOL_SIZE,

LOG_BUFFER etc.

. Set up and used Multi Threaded server (MTS), dispatchers.

. Examined dynamic performance views; V$SYSSTAT, V$WAITSTAT, V$ROLLSTAT,

V$SESTAT, V$LOCK etc.

. Used DBMS utilities for analyzing large tables and partitions.

. Set up LISTENER.ORA, TNSNAMES.ORA, INIT.ORA, Network Configuration

Assistant etc.

. Researched METALINK for various cases and worked with Oracle supported

extensively

. Administered Oracle databases using SQL*Plus, Unix, and double checked

work with OEM

. Backed up and Restored databases using RMAN with SQL Backtrack.

. Developed shell scripts to backup and restore Oracle databases (hot, cold

and archive only).

. Loaded and unloaded data sitting in fixed width and comma delimited files

into or off tables whenever and wherever needed (created load files or

converted entire fixed width files into comma delimited files using MS

excel to accomplish the task. Worked overnight periodically to load and

unload data)

. Interacted with users for database and application issues on daily basis.

. Monitored disk space utilization and added or freed data files

accordingly.

. Changed or allowed directory/file level permissions as ROOT to junior

dbas and super users as needed.

. Resolved issues such as; distributed transactions, Long Transactions,

Locking and run-away processes.

. My meticulous routine maintenance and fine tuning of Oracle database

servers increased production significantly.

Mortgage Partners

San Diego, California

Oracle Database Administrator / Team Manager

August 1989 to December 1992

. Main point of contact for all Database issues in a highly mission

critical database environment.

. Installed, patched and tested Oracle many times.

. Exported and imported databases frequently into the dev and test

environments and for archiving purposes.

. Created instances, databases, schemas, tables, indexes and executed SQL

queries as necessary.

. Developed fragmentation in RANGE and HASH modes for large tables to avoid

full table scanning.

. Calculated growth and allocated space accordingly.

. Served as Security, User Administrator. Granted and revoked permissions

on database objects.

. Enhanced, maintained, developed and supported new and existing Oracle

databases.

. Maintained database server level tuning. Supported 24/7 oncall and

developed documentation.

. Monitored Busy Statistics, Alert log contents and uses, data dictionary

views for tracking performance.

. Executed cron jobs and monitored cron job logs for errors and fixing.

. Performed archiving regularly and maintained backup tapes.

. Developed a defect prevention process including but not limited to root

cause analysis and corrective action.

. Data warehousing with facts tables, dimension tables and helped modeling

and architecture designs.

. Controlled all databases with high alertness to ensure peek performance,

stability and reliability and availability.

. Assisted developers with SQL code troubleshooting. Tweaked applications,

procedures, SQL when necessary.

. Resolved locking issues, inconsistencies and assisted in batch processes.

. Increased performance, availability and security of production databases

and servers by 22%.

US citizen, available now.

Contact this candidate