Manager Oracle

JERRY FRIEDMAN

703-***-****

*********@*******.***

Tampa, Florida

OBJECTIVE

Seeking a challenging position as an Sr. DBA or Lead DBA, Manager, or

Database Architect

SUMMARY

Over 20 years total experience in IT and 15 years as an Oracle Certified

Professional (OCP) DBA in senior, lead, and management positions.

HARDWARE

SUN Solaris HP DELL

IBM AIX EMC EXADATA

SEQUENT DEC COMPAQ

SOFTWARE

ORACLE SERVER PL/SQL ORACLE FINANCIALS

OEM – 12c ER/STUDIO ORACLE RAC

ORACLE APPS PERL RMAN

UNIX TOAD APACHE

AWK RED HAT LINUX ORACLE FUSION

VMWARE KORN SHELL ORACLE BPM

PEOPLESOFT QUEST – DELL ORACLE WORKBENCH

APEX WEBLOGIC SQL

EDUCATION

M.S. coursework in Management Information Systems, University of

Maryland, College Park, MD

B.S. in Mechanical Engineering, Drexel University, Philadelphia, PA

Other Formal Training:

Exadata, Oracle Corporation

Weblogic, Oracle Corporation

11g Database Administration, Oracle Corporation

10g Data Warehousing, Oracle Corporation

9i Database Administration, Oracle Corporation

Oracle DBA Masters Program, Oracle Corporation

Oracle SQL and PL/SQL

Oracle Data Models and Database Design

Oracle Database Administration

Oracle Backup and Recovery

SQL*Net Client/Server Implementation

Oracle7 Performance Tuning

S-Designor, Sybase Corporation

PowerBuilder, Powersoft Corp.

Oracle Forms 3.0, Oracle Corporation

IEF, Texas Instruments, Inc.

HP-UX, Hewlett Packard Corporation

EXPERIENCE

HIGHLIGHTS

Sr. DBA., WellCare Health Plans, Aug 2013 – Present

Performs database administration on all Oracle development, QA, UAT,

and production databases in the company. Tasks are both application and

production related. Administers all databases, Oracle applications, and

Oracle Financials. Lead DBA for major application and database upgrade.

Performs all database duties, including backups, recovery, access,

troubleshooting, capacity planning, analysis, and applies patches and

upgrades.

Performs tuning using OEM 12c, ASM, TKPROF, and TOAD. Monitors

activity in databases and I/O usage by users, jobs, and queries. Performs

version and workflow controlled changes in QA/UAT and production

databases.

Works off-hours during maintenance windows and on call. Performs

reorganizations, redefinitions, and partitioning of large tables.

Senior Oracle DBA, IT Resources Corp., Sept 2012 to Present

On-site contractor at WellCare Health Plans in Tampa. Responsible for

upgrading Oracle Enterprise Manager (OEM) tool from 11g grid control to

12c cloud control and installing agents on all production servers.

Migrated all production hosts, databases, and listener targets from OEM

11g to 12c. Configured database compliance rules and associated these

standard database rules for all production databases.

Utilized Quest Software’s Space Manager with Live Reorg tool for

partitioning large tables and reorganizing large fragmented tables. Also

utilized Quest Capacity Manager tool for capacity planning and report

generation.

Upgrade Middleware product Oracle Internet Directory (OID) from

version 10.1.5 to 11.1.1.6. Used compatibility matrix for determine latest

version to use with AIX operating system and database version.

Installed ASM on UAT databases. Refresh databases from net backups.

Lead Oracle DBA, Sabre Systems, Inc., Mar 2010 to July 2012

Worked as Lead Oracle database administrator for large production, test,

and development databases onsite at the Census Bureau in Washington,

D.C. Worked in Oracle versions 10g and 11g in a Linux operating system

environment on IBM and Exadata servers. Managed a team of DBAs and

delegated tasks to team members. Worked with transactional and

batch/reporting databases in 10-12 node clusters and more than 30

terabytes ASM storage. Provides remote on-call assistance, programs with

PL/SQL, troubleshoots and analyzes complex issues and problems, installs

server and client software and patches, writes UNIX shell scripts, RAC

implementation, utilizes grid control, tuning expertise, RMAN, and

extensive SQL tuning expertise.

Installed and configured RAC databases in version 11g for upgrade from

10g and migration from IBM servers to Exadata Servers. Tested upgrade

to Oracle11g. Utilizes RMAN for archive log and full backups. Used

services and queues to group nodes and instances to handle failures and

redistribute and maximize loads to achieve deadlines.

Utilized Oracle Enterprise Manager (11g and 12c) extensively for Grid

Control, database administration, operations and maintenance, and SQL

tuning. Configured Grid agents in both 10g and 11g environments. Works

with Oracle Application Server, APEX, WebLogic application server,

Oracle Fusion Middleware, and Oracle BPM for middle tier software and

applications.

Provided on-call support during evenings and weekends. Restored

database to a point in time when data was corrupted using the archive logs.

Provides ad-hoc reports to customers including high times of CPU usage

and high 5 SQL statements from reports generated by Oracle Grid Control.

Checks execution plans to ensure indexes are continued to be used when

response times slow down. Mentors other database administrators through

in depth communication and documentation, and transfers knowledge and

provides solutions to problems in a short time frame.

Evaluated an Oracle 11g database upgrade in a development environment.

Database was used for a Human Resources (PeopleSoft) application and

utilized Oracle Advanced Security and transparent data encryption (TDE)

for attributes such as social security number. Also tested TDE with tables

and tablespaces. Utilizes data pump with 75% compression in 11g.

Shell scripting used extensively for scheduling jobs, backups, exports, and

automating jobs. Emails send from server for failed jobs.

Lead Database Administrator, Booz Allen Hamilton, Feb 2007 to Feb

2009

Managed a DBA team at BAH. Assigned tasks to team members and

ensured tasks were done as scheduled.

Administered a terabyte database warehouse and responsible for other

development, test, and production databases. Responsible for migrating

databases from Oracle 9i to 10g. Managed an upgrade project on a

database from version 9i to 10g and migrated the database to another

server. Tested Installs Oracle software on servers, creates databases and

sets up connectivity from client to server, creates and maintain schemas,

DBA_JOBS, perform import/exports, use data pump on 10g databases,

and install/configure grid control on servers. Creates unix scripts for

backups and scheduled in crontab. Used Streams with AQ to move data to

an offsite disaster recovery database. Documented disaster recovery

procedures and tested disaster recovery databases. Review, approve, and

implement change requests that apply to all production databases. Works

on-call and solves problems quickly.

Improved efficiency of the data warehouse by increasing database writers,

optimizing PL/SQL code, increasing the SGA memory parameters and

adding/modifying other optimizer parameters to the init.ora file. Also

partitioned table with 100 million rows by date to increase response time

of queries. Rebuild indexes and scheduled index rebuilds on the weekend

during off peak time periods.

Administered small in-house SQL Server databases and PeopleSoft

applications. Utilized Oracle Migration Workbench to migrate a SQL

Server database to Oracle.

Information Specialist Senior, EDS, Aug 2001 to Jan 2007

Administered several Oracle production databases. Worked an application

and production DBA on both Oracle 9i and 10g and DB2 databases.

Worked with clusters, Data Guard, RAC installation, Data Pump, and grid

control management on terabyte databases. Worked to separate the

financial and core tables into separate and distinct schemas. Normalizing

the large core tables in a data warehouse to optimize the database and

improve query response time using the ERwin data modeling tool.

Review and create database objects, including packages, procedures, and

triggers.

Worked for EDS at the NASD client site as a development Oracle DBA.

Responsible for administering and managing NASDAQ databases up to 6

terabytes. Was the DBA for several applications for tracking trades and

quotes for the NASDAQ stock exchange. The operation systems for these

databases are RED HAT LINUX, SOLARIS and DYNIX and are on NT,

SUN and SEQUENT machines. The databases are using Oracle versions

8i and 9i. I create objects in the development databases and test the code

in the QC databases. Tuned SQL, PL/SQL, and Pro *C scripts created by

developers, and create indexes or modify scripts as needed to improve

performance. Monitored queries in the databases using V$ dynamic

performance tables by running customized scripts in SQL*Plus and Server

Manager, and also use Oracle Enterprise Manager (OEM), the OEM

Performance Pack, and other third-party tools from Quest and Platinum,

such as Desktop DBA, TOAD, and BMC’s Patrol. Utilized Oracle RAC

for parallel server, Data Guard for data security. I monitor the databases

and applications’ SQL on a continual basis. I execute the utlbstat.sql and

utlestat.sql scripts to capture and analyze the statistics from the database’s

V$ and other system tables. I also run the utltkprf.sql script with explain

plan to provide statistics by session for database performance and

application tuning. Optimized the SQL executed from the explain plans

by adding hints to the SQL statements, trace user sessions, and develop

new code to improve the parsing of the SQL, which includes utilizing

indexes. Changed the positioning of the tables’s columns in the indexes,

pin procedures and packages in the shared pool, cache tables in memory,

and revise the SQL statements to optimize response time for queries. I

ensured data integrity by adding and enabling constraints on the tables.

Provide analysis, design, development and implementation of Business

Intelligence applications using ERwin, Informatica, and BusinessObjects.

In a former project with EDS, worked on-site on the Joint Personnel

Adjudication System (JPAS) project in a technical lead position. Worked

in the Production Support department to ensure that a critical database for

the Department of Defense is available 24x7. Worked with DBAs and

data analysts in upgrading systems, troubleshooting problems, defining

standards of operation, and corresponding with client as needed. Worked

to move production system from Bolling Air Force Base to Pentagon.

Lead Database Administrator Manager, Computer Sources, March 1999 to

Aug 2001

As an on-site Oracle DBA for Sentori, Inc., eOriginal, Inc., Thomson

Consulting, AT&T (World Partners), and Global One (Sprint), led and

managed DBA teams that administered the production databases and data

warehouses. I used Oracle Enterprise Edition Server 8.1.7 for both UNIX

and Windows operating systems. I defined the parameters in the Oracle

parameter file (initxxxx.ora) for each database to customize the database,

depending on the requirements. The init file is referred to during the

database startup. I created the Oracle database instance, including the

processes and the SGA. I created the data dictionary by executing the

Oracle catalog.sql and catproc.sql scripts during the database creation. I

created the database tablespaces, datafiles, logfiles, and rollback segments

using customized database creation scripts. I installed all Oracle 7.3, 8.0,

and 8I Server versions on the server and client, and installed and

configured SQL*Net80 for Oracle 8 and Net version 2 for Oracle 7.3.4,

modifying the tnsnames.ora file on the client using the SQL Easy Config

GUI and the listener.ora file on the server. I have migrated databases from

Oracle versions 7.2.3 and 7.3.4 to versions 8.0.5 and 8.1.7, and have

developed plans for the migration procedure, testing, and recovery from

unexpected problems. I write dynamic SQL scripts and PL/SQL

procedures, functions, and packages for various database administration

tasks. I create users, create synonyms on objects, create roles and grant

privileges to users, perform imports and exports to and from various users

and databases, and schedule backup jobs on the servers. For remote

databases, I use FTP to transfer files to a local server or workstation, and

Telnet and Remote Console to work directly on remote servers. I monitor

user and system tablespaces, adding datafiles when necessary. I monitor

the rollback segments and redo log file switches, and create database links

and master-to-master replication and snapshots between servers. I

compare schemas on databases for table and column differences, write

views for reports and ad-hoc queries, and review alert logs to determine

database errors after database crashes. I created the repository for the

OEM and utilize the OEM tools to manage and monitor the databases and

perform various administrative tasks. I recover databases, tablespaces, or

datafiles when necessary. I have shell and batch scripts scheduled to

perform hot (online) backups of 24x7 production databases, cold backups

of other production, development, and test databases, and exports to

ensure that no important data is lost. Production systems are in archivelog

mode and essential databases are in hot backup mode. I performed

recovery when data was lost using the by rolling back and rolling forward

the necessary archived redo logs.

Database Administrator, RMS Jan 1997 - March 1999

As an on-site Oracle DBA at the Department of Navy, I was responsible

for installing and upgrading the Oracle7.2 RDBMS, SQL*Net Version 1,

and the WindowsNT operating system. I also installed Designer/2000,

Developer/2000, and Discoverer/2000, including the Oracle Data Browser.

I designed the database, including table, log, rollback segment, and

tablespace sizes, and created a repository for the Designer/2000 tool. I

created the database through the Oracle dbbuild.sql, catalog.sql,

catproc.sql, and catexp.sql scripts, which created the controlfiles for the

database. I edited the parameter file to ensure that multiple controlfiles

were created on multiple drives to safeguard against a single point of

failure. In addition, I backed up the controlfiles to trace whenever I added

a database or performed a hot or online backup of the database. If a

controlfile is corrupted, another could be used to restart the instance

without the need for database recovery. I utilized the reengineering

feature of Designer/2000 to modify the database structure back into the

repository to update the physical data model, which generated Forms 4.5

code for the application programmers. I allocated system storage and

planned future storage requirements for the database system, creating

tablespaces, datafiles, tables, views, clusters, and indexes. As the

application changed, i.e., new tables, fields, etc., I modified the database

structure and propagated the new structure to the remote databases. I

created users and maintained system security by creating roles and

granting privileges to the users for the roles. With this, I could control the

user create, insert, select, update, and delete privileges for system and user

database objects. I was responsible for monitoring and optimizing the

performance of the database and the servers. I planned for backup and,

when necessary, recovered database files. I also archived data from the

archive logs to tape or a remote disk. I utilized the Oracle Administrative

Toolbar to perform various administrative duties on a regular basis. I

customized and tuned the initxxxx.ora parameter files, in particular the

shared pool size and database block buffers, which comprised the majority

of the System Global Area (SGA). As a general rule, I maximized the size

of the SGA and limited paging of the system resources. I tuned the

databases and application by analyzing the estat report and explain plans.

I rewrote the SQL and reexamined the explain plans which optimized the

response times of the queries and server resource usage of the SQL

statements. I created indexes on fields in tables with numerous hits. I

clustered tables where applicable. I pinned procedures in the shared pool,

and optimized the logical hits on the server. I wrote scripts to lessen the

amount of time I spent maintaining the databases. I performed imports

and exports from Oracle’s Data Manager tool, administered user roles and

privileges, and performed daily backups on the servers. I monitored

database tablespaces, adding datafiles when necessary. I also dropped

existing and recreated larger redo log files when log switches occurred too

frequently.

Database Administrator, Vistech, Apr 1996 - Jan 1997

As an on-site DBA for the Department for Interior, my main

responsibility was database administration and, in particular, tuning in an

UNIX operating system. I ran the scripts and created procedures which

provided a report of system wide database performance statistics. I

checked the latch, rollback segment, and dictionary cache statistics from

the report generated from the estat script, and made changes to the

parameters in the initxxxx.ora parameter file as appropriate. I also

checked the logical and physical reads and determined the hit and pin

ratios, and tried to increase the ratio above 95%. I tried to distribute the

hits across datafiles and disks. I also checked the buffer busy waits, the

average size of the redo entries, the DBWR checkpoints, sorts, and

recursive calls. I used the “where” clause often in the SQL statements to

limit the full table scans, and created indexes to limit full table scans on

large tables. I created databases, allocated system storage, and planned

future storage requirements for the database system, creating tablespaces,

datafiles, tables, views, and indexes. As the application changed, I

modified the database structure. I created users and maintained system

security in the database. I was responsible for monitoring and optimizing

the performance of the database and the servers. I documented all DBA

responsibilities in a Database Administrator Standard Operating

Procedures document.

As an on-site DBA at the Department of Army, I was responsible for

database design and development in an UNIX operating system. IEF was

used as the database design tool. I met with the functional analysts and

obtained system requirements for the design of the system. I designed the

entity relationship diagrams and determined the type of relationships

between the entities and the primary and foreign keys. I designed the

conceptual data model and generated the physical data model. I created

and maintained the database, the instances, and the schemas. I had

separate schemas for development, testing, and production. I also kept an

export file (*.dmp) of every version of the database for version control. I

created the system and user tablespaces, keeping the tables and indexes in

separate tablespaces. I created and maintained user accounts on the

databases. I also tuned the SQL statements in the applications. I planned

for backups and, when necessary, recovered database information from the

log files. I also maintained archived data on tape or remote disk. I read

alert logs and trace files to troubleshoot problems with the database.

Contact this candidate