Diana Malen

Lead Database Administrator/Deployment Lead

Contact details: 434-***-**** ab83wh@r.postjobfree.com

Professional Profile

Ms. Malen has vast experience in planning, prioritizing, mentoring and

strategizing to achieve best results. She is energetic, pro-active, team

player and a planner. She is a lead database administrator and a deployment

lead with experience on all aspects of database administration and software

deployments. She has also experience with OS system administration,

database design, data modeling, change control management and processes

implementation. Her experience includes RDBMS Oracle 9i, 10G & 11g; OID and

Oracle Application Servers 9i and 10G, EM 12c; Tomcat 7.3; Sybase ASE

12.5.2 and 12.5.4, Informix 9.30, 9.40, and 10; and some experience of SQL

Server 2005.

Employment History

IRT - Sr. Oracle DBA/Task Lead, Charlottesville, VA, September 2012 -

Present

Northrop Grumman - Database Engineer Charlottesville VA, June 2012 to

September 2012

CACI, ISS Database Administrator Principal

/Deployment Lead, Charlottesville VA, May 2009 to May 2012

Sentara Healthcare UNIX Consultant, Norfolk VA, June 2007 to February 2009

IBM Corporation US, Maryland & Virginia, October 2002 to June 2007

IBM New Zealand Limited, Auckland, New Zealand, April 2001 to October 2002

Air New Zealand, Auckland, New Zealand, May 2000 to March 2001

Aetna Health Insurance, Auckland, New Zealand, June 1999 to May 2000

Integrated Information Systems, Phoenix, AZ, December 1997 to May1999

Interim Technology, Scottsdale, AZ, March 1997 to December 1997

Independent Consulting, Phoenix AZ, March 1996 to March 1997

MicroAge, Phoenix, AZ, February 1995 to March 1996

Independent Consulting, Tulsa OK, September 1994 to January 1995

Amoco Corporation, Tulsa OK, June 1990 to September 1994

Professional Experience

IRT - Oracle DBA/ Task Lead - September 2012 - Present

Ms. Malen performs task lead duties as well as Oracle database

administration support for production databases. As part of her

responsibilities she monitors databases, performs exports/imports as

needed, and backups databases, data models of existing database to

denormalize data, responds to requests from customer and developers. As

Task Lead manages two projects, tasks teams members for the customer in a

small team environment; produces and keeps up-to-date project plans;

produces executive summaries, statement of delivery and monthly reports to

customer.. She is also responsible for Unix Servers as system

administrator. Current contract is coming to end in March 2013.

Northrop Grumman - Database Engineer June 2012 - September 2012

Ms. Malen performs database administration duties in support of BI2R

customers and production environment. Contract ended Sept 11, 2012, the

whole team was laid off two weeks prior to end of contract.

CACI-ISS - Database Administrator Principal - May 2009 - May 2012,

Ms. Malen performs overall management database administration for Oracle

9i, 10G & 11g; development and testing databases, She complies to database

administration best practices standards and procedures. She manages and

administers all aspects of databases maintenance and projects in support of

Harmony application. She maintains Oracle Application Server 10G and OID 9i

and Tomcat 6.0.32 and 7.3; performs Solaris 9 & 10 system administration as

needed; coordinates and manages application deployments; manages a small

team of developers and database administrators; signed time sheets for

team; assigned tasks; performs code and documentation reviews; coordinates

and manages releases to production; she was the liaison between customer's

production DBAs and development team. She also served as deployment lead

for several projects and performance DBA lead. Her responsibilities

includes: troubleshoot development, testing and production database issues,

UNIX scripting, coordinate and assign work for DBA team and other teams,

mentor other members of the DBA team, troubleshoot performance issues,

maintains documentation, develops deployment documentation and scripts,

plan and details maintenance tasks for team members, perform installations

on new environments, applies Oracle CPU patching in compliance with

security, and ensure DISA STIG compliance for ATO certification. She also

installed EM 12c and deployed agents to database servers.

Sentara Healthcare - Database Manager - June 2007 - May 2009,

Ms. Malen performs overall management database administration for Oracle 9i

and 10G; Informix 9.30, 9.40 and 10; and Sybase ASE 12.5.2 & 12.5.4

databases, She complies to database administration best practices standards

and procedures. She manages and administers all aspects of databases

maintenance and projects in support of PeopleSoft 8.4.9 (HR 8.8 and

PeopleTools); GEAC SmartStream 7.0.2 (Financials) application; and Service

Desk (HP Open view DB SPI) and monitoring tools. Responsibilities includes:

troubleshoot existing database issues, scripting maintenance jobs (perl and

unix shell scripting), coordinated work within her team and other teams,

mentored junior DBAs, maintains documentation, detailed maintenance tasks

for team members, performed backups, backup semi-automation, data purging,

export/imports (datapump) performs 'update statistics', collected database

statistics for analysis and recommendations, makes recommendations to

management, identifies performance issues, monitors databases, performs

table and index re-organization ( to remove fragmentation and improve

performance of databases ), performs database integrity and consistency

checks, EBF patch implementation, ASE upgrade and database migration

planning from HP-UX to AIX servers. She performed PeopleSoft 8.42 migration

from HP-UX to AIX server. Upgrade Peoplesoft 8.42 to 8.49.09. Installation,

patching and troubleshoot installation of BEA WebLogic (RedHat 4.0) and

tuxedo for PS web application for application domain and services. She

also, planned and implemented the migration of GEAC Financial systems

databases from HP-UX to AIX.

IBM Corporation US - October 2002 to June 2007

Lead Oracle Database Consultant and Unix Administration support

Lead Consultant for the Army Distributed Learning System on Saba Web

application 4.3 and Saba Client 4.3.1, supporting Oracle 9i & 10G databases

as a lead administrator consultant. Responsibilities included: database

monitoring; Netbackup RMAN backups' setting up new environments;

tablespaces, tables, indexes constraints, store procedures, users and

groups creation; security implementation; Solaris OS installations and

patches, restores, configure memory parameters as required by software,

software builds, patches/upgrades, overall database performance and tuning,

auditing, DISA STIG compliance responsibilities, ST&E reporting and

inspections as well as day to day tasks for production and continue of

operations environments. As a team lead coordinated, mentored junior DBAs,

prepare and assigned detail project plans on all tasks for production

outages, analyzed and prepared capacity management and performance reports.

Oracle Database Engineer

In support of the ATT Training system on Saba Web application 5.3, Ms.

Malen provided database administration support for this project, her

responsibilities includes: RMAN backups and maintenance, RAC configuration,

setup new environments, upgrades, patches, traces, code reviews,

troubleshooting and day to day support. Prepared and recorded database

administration course on Oracle RDBMS to train future database

administrators, mentored junior DBAs; assigned task as needed.

Infrastructure Support and Linux support

Worked on the USDA FSA MIDAS project, Ms. Malen implemented Rational tools

such as: ClearCase UCM multisided in collaboration with other technical

teams. She administered and provided user support for Rational ClearCase,

RequisitePro, and RequisiteWeb. She is also responsible for: planning and

coordinating of infrastructure changes, upgrades; licensing issues; user

training; remote VPN access configuration, Linux system administration

support of web applications; process automation with Perl and PHP

scripting; troubleshooting software problems; Rational tool administration

and SQL Server 2000 installation.

Lead Oracle Database Administration Consultant

Lead consultant for integration-architecture team at National Institute of

Heatlh Office of the Director (NIH OD). Ms Malen was responsible for the

database change control management process. She implemented this process

via Rational ClearQuest. Ms. Malen also lead projects: to implemented a

process to reconcile the enterprise data model; and a process to enforce

policies, and procedures to maintain centralized data model; she migrated

and upgraded the Oracle Designer repository; and participated on software

evaluation for the architecture team.

Team Lead Oracle Database Administration group

Team lead consultant for the Army DMLSS data migration project on Oracle

9.2.0.4 database (the source database was Informix 7.3 on Windows and

Hewlet-Packard HP-UX platforms). Ms. Malen as a team lead was responsible

for planning, detailed tasks, kept track of progress and assigned tasks for

migration. She also performed several aspects of the migration such as:

selection of data type conversion, importing and verification of the

database structure and data, setting up database environments, backups,

security alerts issues and monitoring of the database via Statspack. Ms.

Malen performed installation of following products: Designer, JVM, Oracle

RDBMS, and Oracle9iAS. She designed a process to remotely monitor the

databases.

IBM New Zealand Limited, Oracle and Informix Database Administration, April

2001 to October 2002, Ms. Malen provided database administration support on

existing systems to several customers: Contact Energy, Air New Zealand and

Ansett Australia. Ms. Malen provided database administration support on:

Oracle 7.X & 8.X; and Informix 7.2 for production and development

environments. Her responsibilities included: database maintenance and user

support, SQL, process automation via scripting, capacity planning, backup

and recovery, fail-over, stand-by databases maintenance, performance and

tuning issues, migrations, patch upgrades, troubleshooting and Oracle

database installations. She also monitored databases using OEM and

Performance Monitor.

Air New Zealand, Auckland, New Zealand, Consultant Oracle Database

Administration and Change Control Management, May 2000 to March 2001, Ms.

Malen was a member of database administration group responsible for the

production, testing and development environments. She performed Oracle

website database updates and upgrades on a regular basis; database schema

installations and data migrations; automate monitoring processes with Korn

and C Shell scripts. She was responsible for the change control management

process for all production computer hardware, network, data and software

changes; as well as assigned tasks to working teams.

Aetna Health Insurance, Auckland New Zealand, Oracle Database

Administration and Change Control Management, June 1999 to May 2000. Ms

Malen supported production database environment, system administration for

Oracle financials (SC 10.7) and performed database Y2K changes. She also

managed change control process for software and database changes.

Integrated Information Systems, Tempe AZ, Software Development - December

1997 to May1999. Ms Malen developed and supported software for various

clients using PowerBuilder 6.5, Powertool, Object Start and PFC libraries,

Metasolv - security system. She was responsible for support and/or

development of portions of manufacturing, construction tracking, sales

management, city planning, recruiting and requisition tracking systems.

Interim Technology, Scottsdale AZ, Software Development, March 1997 to

December 1997

The State of Arizona Department of Technical Oversight asked Interim

Technologies to design an asset inventory system using ACCESS and MS-ACCESS

Visual Basic. Ms Malen collected through interviews data requirements for

various applications, designed inventory system, performed data modeling,

normalized and cleaned data. Trained users on inventory system, created

training materials. She developed the department's Website, and she was

responsible for network administration: GroupWise (e-mail), Archserver

(backup) Novell, troubleshot issues of the SMTP gateway (mail server).

Independent Consulting, Phoenix AZ, Software Development, March 1996 to

March 1997

Ms Malen was a consultant for various clients, she was asked to re-design

or develop portions of travel expense tracking, shipping and receiving, and

financial systems. She developed software using various versions of

PowerBuilder and RDBMS.

MicroAge, Phoenix AZ, Database Administration and Software Development,

February 1995 to March 1996. Ms Malen performed Sybase production database

administration and developed software using PowerBuilder. Her

responsibilities included: data warehouses maintenance, daily data marts

imports, overall database administration, updates to store procedures and

triggers, query optimizing, scripting and batch processing.

Consulting, Tulsa OK, Software Development, September 1994 to January 1995.

Ms Malen was asked by SOLARC to design and develop user interfaces on an

existing manufacturing system using PowerBuilder.

Amoco Corporation, Tulsa OK, Software Development, and Database

Administration, June 1990 to September 1994. Ms. Malen performed Oracle

Database Administration and PowerBuilder software development. She was

responsible for implementation of the Information Data System, which

included batch processing of DB2 data and application development of a

DIS/OS2. Ms. Malen was also responsible for Mainframe/DB2 application

support on existing systems. She was responsible for the development of

portions of the human resource applications and supported the CHRIS system:

ad-hoc requests on salary administration, surveys, budgets, graphs and

reports. Ms. Malen participated on data migration design and implementation

at the Amoco Research Center, as Oracle database administrator on Oracle

version 6 & 7. As software developer, she collected user requirements and

designed applications.

Education and Certifications

BS degree in Computer Science from the University of Tulsa

Security + Certification July 2012

Oracle database SQL Expert August 2012

Managing Database Objects in Oracle 10G and Oracle9i: Real Application

Clusters

Rational Unified Process (RUP), Visual Modeling with UML and Mastering OO

Analysis and Design using UML, and ClearQuest Administration

Rational ClearCase, Rational ClearCase UCM, CM with Rational ClearCase UCM;

Mastering Rational ClearCase Administration, and ClearCase Multi-site

Oracle University: Oracle9i Performance & Tuning, Backup & Recovery

Oracle Database, Informix System, and Sybase Database Administration

PB Advanced DataWindows and PB Performance and Tuning

Publications

IBM Almaden Research Center residencies for a Redbook and a RedNote:

( Heterogeneous Replication and Federated Database (DB2 7.2, Oracle8i &

Informix 9.21), and

( IP SAN: Optimizing & Tuning iSCSI Performance (Linux & AIX, and DB2 7.1

& Oracle9i).

Security Clearance

DoD Army TS/SC SCI active 2005

DoD SBPR re-investigation 20101028

DoD DONCAF Navy SCI eligibility 20120619

DoD DIA SCI active 20120611

Languages Proficient in Spanish

Summary

Industries: Government, Utilities & Energy,

State, Insurance, Chemical &

Petroleum, Travel &

Transportation, Research, Retail,

Education, Healthcare

Project Domain: Financial Management, Systems

Integration, Performance

Improvement, Application

Development. Change Control

Management, System

Administration, Service Desk,

Monitoring, Human Capital, Web

Applications, Deployment.

Hardware: IBM Mainframes, PC Compatibles,

SUN/SPARC2, UNIX SERVER, RS6000,

SHARK, HP, VAX, E10K, COMPAC

Operating Systems: Unix, HP/UX, AIX, Linux, SUN

Solaris, Windows 2003, XP, Vista

Computer Languages: Korn and C Shells, PERL and PHP

scripting, COBOL, PL1, FOCUS, C,

JCL, EXEC2, POWERBUILDER,

TSO/ISPF, REXX, DOS, FORTRAN,

Assembler, HTML, Access Visual

Basic.

RDBMS: ORACLE, DB2/QMF/SQL, SYBASE, SQL

SERVER, INFORMIX

Development Tools: ACCESS, ERWIN, DBArtisan,

POWERBUILDER, ORACLE OEM & DBCA,

HOTDOG, SQLBACKTRACK, DBACCESS,

FRONTPAGE, ARCSERVER, PERFORMANCE

MONITOR, TOAD, DATA FACTORY,

ORACLE DESIGNER, CLEARQUEST,

PVCS, REQUISITEPRO, CLEARCASE,

VPN, ORACLE RAC, NETBACKUP, RMAN,

SYBASE CENTRAL, DBCONTROL, GRID

CONTROL, OAS, TOMCAT. TOAD

Contact this candidate