RICHARD S. MAKARY

**** ******* ***

Downey, CA **240

C: 562-***-****

SKILLS HIGHLIGHT

Database Management: Oracle, Microsoft SQL Server, Teradata, Sybase,

Information.

Oracle Products: Oracle server, Enterprise Manager, Grid Control,

PL/SQL, Data Guard, Oracle Replication, Streams, Backup and Recovery –

RMAN, Oracle partitioning, RAC, Oracle Applications (EBS).

Third party Products: Quest Software ( Shareplex, SQL Navigator, I/Watch, Toad, Knowledge Xpert, Quest Central, Space Manager with LiveReorg, Spotlight, SQLab

Operating Systems: UNIX (IBM AIX, HP-UX), Linux (Open Source RedHat, unbreakable), Solaris, SunOS, OpenVMS, Primos, Novell, Window NT, Windows 2003&2008

Management/Leadership Skills: Project Management, Operation Management, Technical Team Leader, Client Lead Consultant, and Design Team Leader

Life Cycle Expertise: Database/system Administration and Audit, Database/Application performance Tuning, Systems Architecture Planning and Design, Logical/Physical, Data Conversion, Database Design, Application Development, Test Plans, Capacity Planning

Specialty Skills: Database Administration, Database/Application Performance Tuning, Database Training, Database Cloud Migration, Database Disaster Recovery, Application Migration, Application Testing & Upgrade, Database/Application Replication, Data Warehouse, Middleware Services

Database Certification: Oracle Master, Microsoft Technology Associate (MTA).

Communication: Token Ring, DECNet/Pathworks, SQL*Net, TCP/IP

WORK EXPERIENCE

Senior Oracle Database Administrator 01/20 – Present

City of Chandler Chandler, AZ. (Sun Solaris, Orac, WebLogic, Apache)

Supporting set of 4 database servers and over 20 oracle database instances.

Setup monitoring and notification for troubleshooting system and database incidents.

Refreshing the DEV/TEST/QA databases from the production instance.

Publish DataBase instance performance/design/statistics assessment.

Monitoring and tuning databases, SQL queries, and application code using OEM/TOAD.

Shell scripting and scheduling regular/repetitive tasks thru crontab.

Developing/publishing system policies, procedures, and coding-documentation standards.

Senior Oracle Database Administrator 09/18 – 12/18

It People/FTI Dublin, CA. (Sun Solaris, Oracle11g,12c, ExaData, WebLogic, Apache)

Supporting set of 7 database servers and over 200 oracle database instances.

Setup monitoring and notification for troubleshooting system and database incidents.

Monitoring and tuning databases, SQL queries, and application code using OEM.

Shell scripting and scheduling regular/repetitive tasks thru crontab.

Developing/publishing system policies, procedures, and coding-documentation standards.

Supporting multiple tasks in a dynamic environment, designing, creating and maintaining Oracle databases and migrating databases into Oracle.

Senior Oracle Database Administrator 10/16 – 01/18

JPL/Raytheon Pasadena, CA. (Sun Solaris, Oracle11g,12c, Sql Serv 12, ExaData, WebLogic)

Supporting a large data warehousing set of 7 database servers with 100TB of metadata.

Supporting tables that are more than 50 billion rows.

Set up/test Oracle Dataguard for Standby database environment.

Install/configure Oracle OEM Cloud control 12C.

Monitoring and tuning databases, SQL queries, and application code using OEM.

Shell scripting and scheduling regular/repetitive tasks thru crontab.

Developing/publishing system policies, procedures, and coding-documentation standards.

Assisting in design, upgrade and post upgrade support for Oracle databases.

Supporting multiple tasks in a dynamic environment, designing, creating and maintaining Oracle databases and migrating databases into Oracle.

Senior Oracle Database Administrator 11/15 – 08/16

LRN, Los Angeles, CA. (IBM AIX, NetApps, Linux RedHat, Oracle9i,10g,11g, 12c)

Setup monitoring and notification for troubleshooting system and database incidents.

Respond, prioritize, and escalate incidents or service requests as necessary according to defined SLA’s and operational Processes.

Assist developers and data modeling teams with database architecture and design.

Perform database and system capacity planning and storage space management.

Setup/schedule system and database jobs in Oracle job sub-system and thru Linux crontab.

Setup database security, auditing, and data masking and encryption.

Refreshing the DEV/TEST/QA databases from the production instance.

Work with the Linux Engineering team to automate Proactive/ Reactive procedures where possible, and to promote rapid response to known issues.

Transformation of business requirements into logical and physical database designs, and testing, implementation and maintenance of efficient and secure system environment.

Monitoring and tuning the various databases, SQL queries, and application code.

Develops standards and procedures affecting database management, design and maintenance, data management/dictionaries and documentation across multiple computing environments.

Set up physical Data Guard for high database availability and recoverability.

Apply Oracle maintenance/security/critical patch updates after investigating potential issues that may be encountered as a result of patch application in the development environment.

Developing/publishing system policies, procedures, and coding-documentation standards.

Researches and evaluates alternative solutions and recommends the most efficient and cost effective database solution for the systems design.

Test/Install the migration/upgrading/patching of Oracle RDBMS and its tools as needed.

Senior Oracle Database Administrator 07/14 – 11/15

MullinTBG, El Segundo CA. (HP ProLiant, Linux RedHat, Oracle 12c, Sql Serv 2012)

Install/configure Oracle Enterprise Manager 12c cloud control.

Setup monitoring and notification for troubleshooting system and database incidents.

Setup/test DR site using oracle standby for backup and production switch-over.

Setup physical Data Guard for high database availability/Recoverability/Reporting.

Assist developers and data modeling teams with DB tuning, architecture and design.

Perform database and system capacity planning and storage space management.

Setup/schedule system and database jobs in OEM12c job sub-system and thru Linux crontab.

Setup database security, auditing, and data masking and encryption.

Refreshing the DEV/TEST/QA databases from the production instance.

Works with client and DP management and staffs to establish and maintain consistent process and data definitions across computing environments

Monitoring and tuning the various databases, SQL queries, and application code.

Apply Oracle maintenance/security/critical patch updates after investigating potential issues that may be encountered as a result of patch application in the development environment.

Developing/publishing system policies, procedures, and coding-documentation standards.

Test/Install the migration/upgrading/patching of Oracle RDBMS and its tools as needed.

Evaluate database administrative tools and provide recommendations to management.

Senior Oracle Database Administrator 02/14 – 05/14

Veros Real Estate, Santa Ana, CA. (IBM AIX, Dell, Linux RedHat, Oracle11g)

Install/configure Oracle Enterprise Manager 12c cloud control.

Migrate oracle databases from new hardware platform, and converting database between Oracle endian using RMAN and transportable table spaces.

Setup monitoring and notification for troubleshooting system and database incidents.

Assist developers and data modeling teams with database architecture and design.

Perform database and system capacity planning and storage space management.

Setup/schedule system and database jobs in OEM12c job sub-system and thru Linux crontab.

Automate Oracle DB tasks (monitoring, backup, notifications, etc…) using shell scripts.

Technical consultant/Senior Oracle Database Administrator 09/13 – 12/13

Loyola Marymount University, Los Angeles, CA. (Dell, Linux RedHat, Oracle11g, 12c)

Upgrade Oracle Enterprise Manager to 12c Cloud control from 11g Grid.

Setup monitoring and notification for troubleshooting system and database incidents.

Assist developers and data modeling teams with database architecture and design.

Perform database and system capacity planning and storage space management.

Monitor/Troubleshoot database/servers/application problems/issues.

Setup and schedule system and database jobs in 12c job sub-system scripts.

Automate daily/weekly oracle maintenance jobs using oracle job scheduler and crontab.

Technical consultant/Senior Oracle Database Administrator 12/10 – 07/13

LaTax, City of Los Angeles, CA. (IBM AIX, Unix, Oracle10g, 11g, Sql Server 2008)

Upgrading LaTax’s environment from Oracle10gR2 to Oracle11gR2.

Leading Oracle RAC configuration/implementation project on Oracle11gR2.

Set up physical and logical Data Guard for high database availability and recoverability.

Assisting developers and data modeling teams with database architecture and design.

Troubleshooting database/application problems reported by system developers & users.

Setting up/modify/schedule database/shell scripts as needed.

Monitoring and tuning the various databases, SQL queries, and application code.

Testing the migration/upgrading/patching of Oracle RDBMS and its tools as needed.

Acted as the backup DBA for the Sybase financial database systems.

Prepared business requirements reports, findings, recommendations, feasibility studies, DB/system capacity planning & storage space management, and cost justification statements.

Senior Oracle Database Administrator 04/10 – 12/10

QTC Management Inc, Diamond bar, CA. (MS Server 2003 & 2008, Oracle9i, 10g, 11g)

Monitor projects/service requests for progress and timely completions.

Assisting developers and data modeling teams with database architecture and design.

Performing database and system capacity planning and storage space management.

Apply security policies for data access to oracle databases and Linux servers.

Troubleshooting database/application problems reported by system developers & users.

Developing/publishing system policies, procedures, and coding-documentation standards.

Work with auditing firms to ensure SOX and PCI compliance.

Monitoring for unauthorized access attempts and manage database user accounts.

Tuning the various databases, SQL queries, and application code.

Disaster recovery planning, testing, and documenting/publishing.

Provides technical support and training and acts as mentor to other data administration staff.

Refreshing the DEV/QA/TRNG databases from the production instance.

Technical consultant/Senior Oracle Database Administrator 11/09 – 03/10

Compusys Long Beach, CA. (Sun, HP, Linux RedHat, MS, Oracle10g, 11g)

On-Call covering for the DBA team while Members are on off-duty (on-leave)

Oracle DBA Team Lead, Senior Oracle Database Administrator 09/07 – 10/09

Mylife.com/Reunion.com, Los Angeles, CA. (Sun, HP, Linux RedHat, Oracle9i, 10g, 11g)

Monitoring and tuning the oracle production environment.

Assist in the interviewing, Hiring, mentoring, and training of new and existing employees.

Assisting developers and data modeling teams with database architecture and design.

Monitored the data loading and migration into the data mart and data warehouse instances.

Configured/installed Oracle Real Application Cluster (RAC)

Testing the Migration of production to ASM and Oracle RAC.

Performing database and system capacity planning and storage space management.

Assisted the Data Warehouse team with tools and techniques in Acquiring, cleaning, transforming and making data available for analysis, reporting and presentation.

Developing and publishing development-coding and coding-documentation standards.

Set up physical DataGuard for high database availability and recoverability.

Create and maintain database links between oracle databases and user’s accounts.

Troubleshooting database/application problems reported by system developers & users.

Technical consultant/Senior Oracle Database Administrator 09/06 – 08/07

AIG-SunAmerica, Woodland Hills, CA. (Sun, HP, Linux RedHat, Oracle8i, 9i, 10g)

Performing regular database backups for instance refreshing and disaster recovery.

Refreshing the Oracle development and QA databases from the production instance.

Monitoring and tuning the oracle development environment.

Performing capacity planning and space management.

Troubleshooting database/application problems reported by system developers & users.

Administering user accounts, roles, tables, indexes, sequences, views, etc.

Senior Oracle Database Administrator 05/05 – 09/06

Yellowpages.com, Pasadena, CA. (Sun, HP, Linux RedHat, Oracle9i, 10g, SqlServer 2005)

Creating and setting up new scripts and schedules for the hot/cold backups and exports.

Managing offshore resources for successful production implementation and release Control.

Refreshing the QA database from the production instance using RMAN and Oracle streams.

Developing and publishing development-coding and coding-documentation standards.

Troubleshooting database/application problems reported by system developers & users.

Administering user accounts, roles, tables, indexes, sequences, views, etc.

Technical consultant/Senior Oracle Database Administrator 10/04 – 05/05

Investors Business Daily, Los Angeles, CA. (Sun, HP, Oracle9i, 10g)

Creating and setting up new scripts and schedules for the backups and exports.

Replicating production database instance for development and training proposes.

Monitoring and tuning the oracle development environment.

Assisting developers and data modeling teams.

Performing capacity planning and space management.

Developing and publishing development-coding and coding-documentation standards.

Troubleshooting database/application problems reported by system developers & users.

Technical consultant/Senior Oracle Database Administrator 04/04 - 09/04

Toyota Motors, Torrance, CA. (Sun, IBM, Oracle9i)

Performing Oracle database, application, and network tuning and debugging.

Monitoring, test, and tuning oracle applications/databases.

Performing capacity planning and space management.

Developing and publishing development-coding and coding-documentation standards.

Administering user accounts and database objects.

Data warehouse configuration, management, and performance monitoring & tuning.

Shareplex Development Escalation Manager 11/03 - 03/04

Quest Software, Irvine, CA. (Sun, HP, IBM, NT, Linux, Oracle8i, 9i)

Day to day management of support issues, technical triage and assignment of these issues to the SharePlex Developer Support team.

Work with the build and release engineering team to manage the software deployments and rollouts, emergency customer fixes and patch releases for SharePlex.

Work with the SharePlex Developer Support team and the Technical Support Escalation Manager to provide quick workarounds for key customer issues.

Document the procedures and workarounds given to customers via Technical Support.

Improvise processes and procedures for managing customer issue escalations to Development, and emergency fix/patch procedures.

Senior Oracle Database Administrator 04/01 - 09/03

Edmunds.com, Santa Monica, CA. (Sun Solaris 2.8, Oracle8i, 9i, SqlServer 2000)

Creating and setting up new scripts and schedules for the backups and exports.

Performing Oracle database, application, and network tuning and debugging.

Monitoring the production and development and other environments.

Assisting developers and data modeling teams with database architecture and design.

Performing capacity planning and space management.

Weekly refreshing of the production databases with the latest data from the master databases.

Monitoring and optimizing the database performance using OEM and Solar Winds.

Working on providing a solution for HA setup of the production databases.

Oracle Database Manager 10/00 - 03/01

Adexchange, Beverly Hills, CA. (Sun Solaris 2.7, oracle9i, SqlServer 2000)

Hiring, mentoring, and training new and existing employees and consultants.

Monitoring and optimizing the database performance using OEM and Solar Winds.

Developing and publishing development-coding and coding-documentation standards.

Performing short and long-term growth analysis, capacity planning and space management.

Assisting developers and data modeling teams with database architecture and design.

Administering user accounts, roles, tables, indexes, sequences, views, etc.

Establishing and testing a backup and recovery strategy.

Troubleshooting database/application problems reported by system developers & users.

Performing server upgrades and batches installations and testing.

Defragmenting and coalescing primary database storage structures and objects for better I/O.

Oracle Database Manager 10/99 - 10/00

Netgateway, Long Beach, CA. (Sun Solaris 2.7, oracle8i)

Performing capacity and short and long-term growth analysis and space management.

Training and mentoring new and existing database administrators.

Developing and publishing development-coding and coding-documentation standards.

Administering user accounts, roles, tables, indexes, sequences, views, etc.

Monitoring and optimizing the database performance using OEM and third party tools.

Establishing and testing a backup and recovery strategy.

Assisting developers and data modeling/architect teams.

Troubleshooting database/application problems reported by system developers & users.

Performing server upgrades and batches installations and testing.

Defragmenting and coalescing primary database storage structures and objects for better I/O.

Oracle Database Manager 05/99 - 10/99

Earthlink, Pasadena, CA. (Sun Solaris 2.7, oracle8i)

Hiring and training new employees and consultants.

Administering user accounts, roles, tables, indexes, sequences, views, etc.

Monitoring and optimizing the database performance using various tools.

Setting-up a standby database for a 24X7 maximum uptime.

Establishing and testing a backup and recovery strategy.

Troubleshoot database/application problems reported by system developers and users.

Performing capacity planning and space management.

Performing server upgrades and batches installations and testing.

Defragmenting and coalescing primary database storage structures and objects for better I/O.

Technical consultant/Senior Oracle Database Administrator 10/98 - 04/99

USWeb/CKS, Santa Monica, CA.

Performing the day-to-day Oracle Database administration functions.

Administering user accounts, roles, tables, indexes, sequences, views, etc.

Monitoring and optimizing the database performance using OEM Rel. 1.5.

Defragmenting the primary database storage structures and objects for better I/O.

Establishing and testing a backup and recovery strategy.

Performing server upgrades and batches installations and testing.

Defragmenting/coalescing database storage structures and objects for better I/O.

Develop and publish coding-documentation standards.

Establishing and implementing database security policies.

Troubleshoot database/application problems reported by system developers and users.

Technical consultant/Senior Oracle Database Administrator 07/98 - 10/98

Western Asset Management, Pasadena, CA.

Train and Mentor the existing database administrator.

Monitoring and optimizing the database performance using OEM Rel. 1.5.5.

Develop and publish development and documentation coding standards.

Refresh testing instance from Production instance.

Establishing and testing a backup and recovery strategy.

Establishing and Implementing database security policies.

Troubleshoot database/application problems reported by system developers and users.

Performing the day to day Oracle Database administration functions.

Defragmenting and coalescing primary database storage structures (tablespaces) and objects (tables, views, and indexes) for better I/O.

Senior Oracle DBA/Financial Administrator 11/97 - 07/98

Arco Products Company, Los Angeles, CA.

Develop and publish development-coding standards.

Develop and publish coding-documentation standards.

Establishing and testing a backup and recovery strategy.

Establishing and implementing database security policies.

Contacting Oracle Corporation for technical support and batches.

Assisting in maintaining the corporate web site.

Performing server upgrades and batches testing.

Troubleshoot database/application problems reported by system developers and users.

Defragmenting and coalescing primary database storage structures and objects for better I/O.

Performing the day-to-day Oracle Database/Parallel Server administration functions.

Administering user accounts, roles, tables, indexes, sequences, views, etc.

Installing and upgrading the Oracle server, system tools, and Oracle financial.

Monitoring and optimizing the database performance using Oracle Enterprise Manager.

Administer user accounts, roles, tables, indexes, sequences, views, etc.

Senior Oracle Database Administrator/Sap Administrator 12/96 - 11/97

MedPartners, Long Beach, CA.

Project Leader for the Design/Implementation leading four programmers and three system analysts through logical and physical design activities for an Oracle database for the Telephonic Utilization Management System using Oracle7 Server on an AIX 6000.

Technical member for SAP financial and human resources system implementation.

Upgrading Oracle7 server and application tools for compatibility and new functionality.

Allocating storage and planning future storage requirements for the database system.

Creating primary database storage structures (tablespaces) and objects (tables, views, and indexes) after application developers have designed a database application.

Monitoring and optimizing the performance of the databases using OEM v1.3.

Develop and publish SQL Query standards, object creation forms.

Database backup and recovery (on-line, off-line).

Contacting Oracle Corporation for technical support and licensing issues.

Troubleshoot database/application problems reported by application developers.

Review system development specifications to ensure compliance with company

data integrity and security requirements.

Work with programmers on optimizing performance of batch and on-line programs.

Assist users and developers in learning the latest Oracle products and techniques.

Principal Consultant, Government services 12/95 - 12/96

Oracle Corporation, El Segundo, California

Database Tuning

Tuned the financial database running on Oracle v7.2 with Progress database and 3GL code. Running HP9000 as the server and 100MHZ Pentium PC for clients using NT 3.51. Monitored system activities focusing on measuring and analyzing the system’s workload, interactive response, Oracle Configuration parameters, memory contention and usage, disk & file organization and optimization, network performance, and database latch contentions.

Application Performance Tuning, Internal Project

Oracle’s financial application testing, performance tuning of PL/SQL, and SQL Based products. The main objective was to identify the bottlenecks in running the Oracle Purchasing forms. The strategy was to use a performance checklist and record the times it took to perform the various tasks (form invocation, LOV, FIND windows, edit, delete, insert, navigation). Also, used SQL*Trace, TKPROF for analyzing the SQL*Plus and PL/SQL code paying close attention to full table scans, sort merge joins, number of rows processed versus number of rows fetched, and excessive rows fetching. Communicated results and recommendations to test developers and project leader.

Database Review

Provided design review and performance tuning for Oracle database v7.2. Documented database administration tasks such as backups, data recovery, system monitoring tools, etc. Assisted programmers and analysts in application development and troubleshooting. Conducted workshops for Oracle database architecture and application design.

Symmetric Replication

Created asynchronous symmetric replication triggers to maintain multiple copies of data at different sites in a distributed environment providing immediate local access to data and allowing systems to function autonomously even when networks or other systems in the environment fail. Created the interface and symmetric replication environment using SunOS 4.1. This was used to store changes to local copies of data locally and then propagate and apply the changes to remote copies in a store-and-forward manner within separate transactions.

Oracle Database Administrator/System Analyst 09/89 - 12/95

California State University Dominguez Hills, Carson, CA.

Project Leader for the Design/Implementation leading six programmers and two system analysts through logical and physical design activities for an Oracle database for the student system which included the admission, registration, academic history, financial aids, accounting, alumni, and human resources modules using Fortran and Pro*C Languages.

Installed new Oracle RDBMS and Banner system software releases, performed data and/or software code conversion, testing of new system functions, installed end-user tools which require sharing data with Oracle databases.

Conducted the ongoing maintenance of multiple Oracle databases: monitoring and optimizing the performance of the databases, enrolling/disenrolling users and ensuring system security, performed data backup and recovery, modified database structures to facilitate system development.

Troubleshoot database and Banner system problems reported by users and application developers, interacted with Banner system vendor in fixing baseline code, as necessary.

Worked with analysts on improving performance of batch and online programs.

Administered user accounts and ORACLE databases and instances in a large real-time integrated information management system.

MIS Technical Project Manager 01/86 - 09/89

Diversified Medical Management Corp., Long Beach, CA.

Hired, developed, reviewed and counsel personnel for the MIS division.

Managed the MIS department financial budget.

Responsible for the hardware and software and software selection.

Developed a DMMC Time Management and status reporting.

Developed MIS documentation standards and procedures.

Set short and long-term goals for the corporate information systems.

Operation Project Manager - (Saudi Arabia.) 05/85 - 12/85

Parsons, Royal Commission for Jubail and Yanbu.

Educated operation department staff on computer system.

Developed a regular software and hardware maintenance schedule.

Developed a system contingency plan.

Published computer operations procedures.

Developed a regular database maintenance schedule.

Produced a monthly (performance, downtime, etc.) analysis reports.

Database Administrator / System Administrator 04/82 - 05/85

Amex Systems, Hawthorne, CA.

Installed new software and setup the needed directories and accounts.

Analyzed and modified the operation system to improve system response and security.

Allocated data and programs between CPUs to enhance efficiency.

Developed and implemented a company-Wide COMM plan to all corporate remote sites to improve communication and reduce costs.

Diagnosed equipment malfunctions and took corrective action as needed; kept record of computer statistics.

Assisted management and users in their daily use of the system.

Published DP operations and users documentation.

EDUCATION

Bachelors of Science, Computer science (not completed) - CSUDH, Carson

Oracle Master - Oracle Database Administration - Oracle University, L. A.

Oracle Advanced Database Tuning - Oracle University, L. A.

RedHat System Administrator – RedHat University, L. A.

Certificate of System Analysis and Design - Cerritos College, Norwalk

Certificate of Programming and Operation - Control Data Institute, LA

Oracle Corporation

FastTrack - Oracle Consulting Skills

Oracle*Method - Project Management Training

Oracle Financial System Administration

Administer the Oracle Database I

Administer the Oracle Database II

Advanced Oracle SQL*Plus

Tune and Troubleshoot the Oracle Database

High Impact Oracle Tuning and Troubleshooting

Developer/2000 - Introduction Oracle Forms

Oracle Computer Base Training

Oracle Database Architecture

Administer the Oracle Database I

Administer the Oracle Database II

Tune and Troubleshoot the Database

Programming with PL/SQL

Developer/2000 - Oracle Forms

Developer/2000 - Oracle Forms

Develop Basic Functional Model

Develop Basic Data Model

Using Personal Oracle

Microsoft Corporation

Sql Server Database Administration

Red Hat Inc.

Red Hat System Administrator

Red Hat Computer Base Training

Red Hat Enterprise Linux System Administrator I

Red Hat Enterprise Linux System Administrator II

Red Hat Enterprise Linux Storage Fundamentals

Red Hat Enterprise Linux Booting and Run levels

Red Hat Enterprise Linux Shell Scripting Fundamentals

HONORS/ACHIEVEMENTS

Chosen on the Los Angeles Community District panel to make suggestions on how to improve education for the 90’s.

Contact this candidate