Judy McClane
Colorado Springs,CO
Summary
Skilled in database administration with relevant experience in ensuring data accuracy and security, as well as managing performance and improving processes. Possess strong technical abilities in SQL server, Oracle databases, and data migration strategies. Successfully enhanced system efficiency and reliability through proactive database optimization and maintenance practices. Fostered teamwork and collaboration to meet tight deadlines and address challenging IT issues effectively.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Database Advisor
FedEx Corporation
12.2019 - Current
- Built (working with Linux OS Admins - RHEL7/8) Oracle 11gR2,12gR1,12gR2,19c single instance and RAC for Test and Production Clusters
- RAC and Standalone (Restart) and monitor Data Guard (Physical)
- Multipathing (DM/Linux OS Native Multipathing)
- ASM Flex/ASM
- Multitenant 19c - 100 Containers with 500 Pluggable DBs monitored for Test and Production Clusters
- Creating and Monitoring Very Large Oracle Databases with mainly partitioned tables and indexes
- Oracle Database Migration from local to EMC Snaps
- Migrating from 11gR2 to 19c using EMC snaps (new migration process developed/documented)
- Use Actifio, ZDLRA, Appsync, Cohesity (RMAN Backups)
- Linux OS Scripting used to implement numerous cronjobs as required by the App Team, including running stats and daily/monthly, adding/deleting partitioning of tables and indexes
- Assist managers to determine implementation schedules and tasks
- Functional and technical lead which includes support work with Business Unit representatives on specific application issues, business problem analysis and resolution development
- Assist design (including ASM and multipathing) configuration and implementation
- Review and Investigate Types of Networking Issues/SCAN and Performance/SQL Statements
- Network Security and Awareness
Information Systems Technical Consultant
State of Tennessee
01.2019 - 12.2019
- Built (working with Linux OS Admins - OL6 and OL7 and RHEL6 and RHEL7) Oracle 12gR1/Oracle 12gR2/Oracle 18.3 single instance and RAC for Oracle Enterprise Manager and Oracle Audit Vault Appliance (image)
- RAC and Standalone (Restart) and RAC One Node and DR - ASM and nDFS and ACFS and ODM and Multipathing (DM/Linux OS Native Multipathing)
- Database File System (DBFS) and ASMLib and AFD (ASMFD) and ASM Flex
- Multitenant with 20 Containers with 80 Pluggable DBs monitored by Oracle Audit Vault
- Oracle Database Migration from local to Hitachi and HUSVM SANS RMAN Backups), UNIX System Admin; UNIX Shell Scripting, SQL
- Loader, PL/SQL, API's, Packages and Database Triggers
- Assist managers to determine implementation schedules and tasks
- Functional and technical lead which includes support on Oracle Applications, work with Business Unit representatives on specific application issues, business problem analysis and resolution development, helping to develop Oracle security setup
- Oracle Database Design (including ASM and multipathing) configuration and implementation
- Review and Investigate Types of Networking Issues/SCAN and Performance/SQL Statements
- Implemented and Maintained Audit Vault Agents; Use Linux OS Scripts (crontab)
- Background Clearance by the Level 4 CJIS Security (Criminal Justice and Information System
- Security and Awareness)
- Background Clearance FBI for the Federal Tax Information
Principal Technical Support Engineer
Oracle Corporation
06.2011 - 01.2019
- Provide Support and Analysis for Storage/RAC/Exadata/ODA/Super Cluster/Oracle Cloud Customer Support Systems/RAC One Node associated with Oracle databases from versions 10gR1 to 10gR2 to 11gR2 to 12cR1 to 12cR2 to 18.1 to 18.3 which includes ASM, ASM Space Allocation and Rebalancing Issues, ASM Volume Device Driver Issues (ACFS), ACFS Issues (Oracle Automatic Storage Management Cluster File System ), Direct NFS Issues (DNFS), Multi-node ASM issues (RAC & Active Passive Cluster Issues), NFS Issues (non-DNFS), ODM Issues (Oracle Disk Manager), Database File System(DBFS) and ASMLib and AFD (ASMFD) and ASM Flex and Multipathing (DM/Linux OS Native Multipathing and MPIO and EMC Power Path)
- Review and Investigate Types of SAN Storage: Hitachi, NetApp, Solaris, EMC, IBM Network Attached Storage
- Review and Investigate Types of Networking Issues/SCAN and Performance/SQL Statements
- Review and Investigate Types of OS Platforms: Linux, IBM AIX, IBM Linux on Z, Solaris, HP_UX, and Windows
- Create, modify, and maintain Oracle technical documentation on Oracle's Support Website
- BDE - Worked with Oracle Development and AR (Advanced Resolution Engineer)
Data Resource Management
State of Tennessee
02.2006 - 06.2011
- Built (working with Linux Admins) Oracle 10gR2/Oracle 11gR2 single instance and RAC for ERP/People Soft and other Apps; Discoverer 9i; 10gR2 Grid Control on 10g RAC - ASM and CRS; SuSE Linux 9 SP3; Red Hat Linux 4 and 5 - 64 bit; Sun Solaris 8; 9; 10/UNIX
- Oracle Database Migration from local to Hitachi SANS RMAN Backups, Veritas Software (4.5 and 5.2 and 6.0), UNIX System Admin; UNIX Shell Scripting, SQL
- Loader, PL/SQL, API's, Packages and Database Triggers
- Maintain Oracle Applications 11.5.8- Oracle Payables, Order Management, Accounts Receivable, General Ledger, Alert Manager, Pricing Manager, Workflow, Contracts, Customer Service
- Work closely with Oracle Managers to determine implementation schedules and tasks
- Functional and technical lead which includes support on Oracle Applications, work with Business Unit Representatives on specific application issues, business problem analysis and Resolution Development, helping to develop Oracle Security Setup
- Oracle 9i AS and 10gR2 AS
- Design and implement and maintain ArcGIS and ArcSDE with Oracle 10gR2 Database with ASM and 10gR2 Grid Control
Education
Diploma of Education - Computer Science
Mira Costa College/CSU
Oceanside, CA06.1993
Undergraduate - Animal Science and Mathematics
University of California, Davis
Davis, CA06.1976
Skills
- Database administration
- Data migration
- Database design
- Database monitoring
- Backup and recovery
- Performance tuning
- Indexing strategies
- Data modeling
Awards
- Database 11g Admin OCA Pert 1 - Oracle, 05/01/18
- Oracle Community Rookie - Oracle, 04/01/18
- Oracle Customer Service Recognition, 06/01/18
- Support Service Award FY12 - Oracle, 06/01/18
Certification
- Oracle Education: Exadata, ODA, Super Cluster, TFA, OS Watcher and Cloud Training, 11/2018
- Oracle Education: Linux OS Basics RHEL 5/OL5 to RHEL 7.6/OL7, 01/2007
- Oracle Education: Real Application Clusters, OEM 13c Grid Control, 09/2005
References
References available upon request.
Timeline
Database Advisor
FedEx Corporation
12.2019 - Current
Information Systems Technical Consultant
State of Tennessee
01.2019 - 12.2019
Principal Technical Support Engineer
Oracle Corporation
06.2011 - 01.2019
Data Resource Management
State of Tennessee
02.2006 - 06.2011
Diploma of Education - Computer Science
Mira Costa College/CSU
Undergraduate - Animal Science and Mathematics
University of California, Davis