Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jerry Friedman

Oldsmar,FL

Summary

Oracle Certified Professional (OCP) with over 21 years of Oracle database administration experience including designing, maintaining, and securing development, UAT, and production databases. Worked with Oracle versions starting with 9i and currently working with 21c, 23c, and 23ai. More than 7 years experience in Exadata and Oracle Cloud Infrastructure. Enjoys mentoring individuals and excels at leading teams. Skilled in Oracle upgrades and migrations, ensuring 100% data protection through recovery solutions. High performing professional with extensive experience managing large-scale, complex databases. Skilled in several programming languages, including SQL and PL/SQL. Strong understanding of database design and data modeling with excellent troubleshooting skills to solve complex problems quickly. Committed to staying up to date with the latest technologies and advancements.

Overview

21
21
years of professional experience

Work History

Senior Oracle Database Administrator

Database Admins LLC
03.2019 - Current
  • Migrated development, UAT, and production databases to 18c, 19c, 21c, 23c, and 23ai, minimizing disruption to business operations.
  • Led the design and implementation of Oracle Cloud Infrastructure solutions.
  • Managed and optimized OCI resources to ensure cost-efficiency while meeting performance requirements.
  • Responsible for administrating databases hosted in a cloud computing environment, provisioning and managing database instances, setting up replication and high availability, and monitoring database performance.
  • Enhanced security measures by implementing data encryption and access controls for sensitive information.
  • Monitored and analyzed database activity to identify and prevent incidents and recommended/implemented performance improvements.
  • Recovered development, UAT, and production databases.
  • Worked with AI Vector Search, Vector indexes, and Vector SQL to allow users to search unstructured data such as images and documents
  • Established Raft active-active replication to rebalance data across shards if one failed or was reconfigured.
  • Supported JSON Relational Duality and JSON Schema Validation, including transactions, indexes, declarative queries and views
  • Developed custom scripts and PL/SQL procedures for efficient automation of routine tasks and data management operations.
  • Worked together with UNIX and Network teams responsible for managing different aspects of the Oracle Database infrastructure.
  • Developed automated processes to manage database creation in virtualized or cloud environment.
  • Troubleshot database issues to resolve complex problems in a short timeframe.
  • Worked on-call for production database support ensuring 99.999% high availability uptime goal for critical databases.

Senior Oracle Database Administrator

WellCare Health Plans Inc.
08.2012 - 03.2019
  • Performed database administration on all Oracle development, QA, UAT, and production databases . Worked as both development/application DBA and production DBA.
  • Managed 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.
  • Implemented System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
  • Administered all databases, Oracle applications, and Oracle Financials. Lead DBA for major application and database upgrades.
  • Performed all database duties, including backups, recovery, access, troubleshooting, capacity planning, analysis, and applied patches and upgrades.
  • Monitored activity in databases and I/O usage by users, jobs, and queries.
  • Performed version and workflow controlled changes in QA/UAT and production databases.
  • Performed reorganizations, redefinitions, and partitioning of large tables.
  • Used range, hash and composite table partitioning which greatly decreased DB_time and SQL execution time.
  • Managed database security by creating, assigning appropriate roles and privileges to users depending on user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
  • Worked on application and database security including data access, passwords and network
  • Performed Physical backups, both hot and cold, as well as Logical backup using Export and Import.
  • Tuned development and production databases using Oracle tools and customized scripts.
  • Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to deploy patches to all database instances
  • Worked off-hours during maintenance windows and on-call.

Senior Oracle Database Administrator

Computer Sources, Inc.
06.2003 - 07.2012
  • Responsible for upgrading Oracle Enterprise Manager (OEM) tool from 9i to 10g and 10g to 11g grid control and installing agents on all production servers.
  • Migrated all production hosts, databases, and listener targets from 9i to 10g and 10g to 11g.
  • 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.
  • Upgraded 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.
  • Worked in Oracle versions 10g and 11g in various UNIX operating system environments.
  • Supported management and designed 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.
  • Utilized Oracle Enterprise Manager (9i, 10g and 11g) 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. Provided ad-hoc reports to customers including high times of CPU usage and high 5 SQL statements from reports generated by Oracle Grid Control. Checked execution plans to ensure indexes are continued to be used when response times slow down.
  • Mentored junior database administrators through in-depth communication and documentation, and transfer of knowledge and provided 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 and custom scripts were used extensively for scheduling jobs, backups, exports, performance tuning, troubleshooting, and automating jobs. Emails send from server for failed jobs.
  • Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
  • Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.
  • Performed Physical backups (hot and cold) using RMAN as well as Logical backups (Export/Import).
  • Wrote database documentation, including data standards, procedures, and definitions.
  • 24x7 remote support and worked on-call rotation one week per month.

Education

Bachelor of Science - Mechanical Engineering

Drexel University
Philadelphia, PA

Master of Science - Information Technology

University of Maryland
College Park, Maryland

Oracle Certification Training

Oracle University
Online

Skills

  • Oracle Database Versions 9i - 23ai
  • Oracle Autonomous Database
  • Oracle Exadata Database Service
  • Oracle Exadata Database Cloud
  • Oracle Exadata Database Machine
  • Oracle SQL and PL/SQL
  • Interactive Architecture Diagram
  • Application Development
  • Big Data and Data Warehousing
  • Database Upgrade and AutoUpgrade
  • Database Security Management
  • Data Guard
  • Pluggable Databases
  • Backup and Recovery
  • Data Pump and Export/Import
  • Transparent Database Encryption
  • Oracle Performance Tuning
  • Patch Set Management
  • OEM, TOAD, and Custom Scripts
  • SQL Developer and SQL Loader
  • Oracle VM Virtual Box
  • Oracle ASM Management
  • Database Cloning
  • Database Troubleshooting
  • Incident Management
  • Network Configuration

Timeline

Senior Oracle Database Administrator

Database Admins LLC
03.2019 - Current

Senior Oracle Database Administrator

WellCare Health Plans Inc.
08.2012 - 03.2019

Senior Oracle Database Administrator

Computer Sources, Inc.
06.2003 - 07.2012

Bachelor of Science - Mechanical Engineering

Drexel University

Master of Science - Information Technology

University of Maryland

Oracle Certification Training

Oracle University

Similar Profiles

CREATE PROFILE
Jerry Friedman