Oracle Database Consultant

Margaret Norman

Johnson City, Tennessee 423-***-**** **********@*****.*** https://www.linkedin.com/in/margaretnorman/ Database Technology Professional with expertise in Oracle Database Administration, PL/SQL Development, Technical Training, and Strategic Planning, including RAC, Data Guard, Database Performance, SQL Performance, Database Security and Audits, RMAN, and OEM Grid. Experience with Audit Assessments and Meeting Requirements, Data Design and Modeling, ETL, GoldenGate, Streams, XML, Production Deployments, Database Upgrades and Migrations. PL/SQL programming proficiencies include collections, bulk collect, dynamic cursors, packages, table and object functions, and triggers for data integrity and audit logs. Skills & Abilities

DATABASE MANAGEMENT

Highly skilled in all core aspects of Oracle database management (9i, 10g, 11g, 12c) as well as many security and high availability options: working with VLDBs, deploying and maintaining the Oracle software stack in RAC and non-RAC environments, balancing workload using Resource Manager and Instance Caging, Oracle Enterprise Manager, database upgrades and migration, database clone/replications, Backup and Recovery for both operational and disaster events, Data Replication, ASM, and Data Guard. DATABASE AND SQL PERFORMANCE TUNING

Skilled using AWR and statistics data to monitor and identify root causes of database performance issues and SQL performance issues to develop workable solutions. Methods include reducing workload by removing unused indexes and procedures, rescheduling administrative workload, collecting better statistics, changing physical and logical data design solutions, implementing partitions, IOTs, and compound or function indexes. PL/SQL PROGRAMMING

Developer background contributes to superior PL/SQL coding skills – from simple triggers and procedures to complex packages implementing ETLs and Data Access Layers for application support. DATABASE SECURITY

Expert functional knowledge on all aspects of Oracle database security and auditing including basic user accounts and roles, custom password management, custom login triggers, Virtual Private Database (VPD), Resource Manager restrictions on operating hours, using PL/SQL packages to support queries without direct table access and write audit logs, encryption, data masking, data sampling for non-production databases while maintaining relational integrity, software installation and maintenance vulnerabilities. DBA and Developer background means performance and maintenance impacts of various security options are fully understood. Work experience includes performing database security audits and implementing security standards for credit card processing and personal identifiable information. LEADERSHIP

Experience leading project and technical teams to support major application upgrades, hardware and software migrations, and database strategy. Served as Lead Oracle Database Administrator to develop strategic Enterprise Service Level deployment plans for Oracle database products based on outage tolerances and recovery requirements. Experience

SENIOR ORACLE DBA DUKE ENERGY MAY 2014 - FEB 2015

Performed all aspects of database administration services for Oracle 10g and 11g systems using AIX 5.3 on and Redhat Linux with EMC storage supporting production and project development.

Handled multiple high-profile performance issues, primarily on RAC deployments.

Developed testing method to document RAC performance statistics and participated on team testing RAC performance on various job loads, some using instance caging.

Developed PL/SQL routines to support ETL processes and performance improvements for a large customer service database during and following migration to RAC.

LEAD ORACLE DBA DUKE ENERGY FEB 2009 - MAY 2014

Served as technical subject matter expert for all things Oracle to management and a DBA staff of 20+ leading the Oracle database technical team developing, testing, and documenting enterprise standards and methods and serving on inter-discipline IT teams developing strategic solutions for merger migrations and disaster recovery.

Led effort to develop Oracle product standards for three-tiered enterprise Customer Service Level standards based on availability and disaster recovery requirements.

Led weekly Oracle Technical Team meetings to develop consensus decisions or options to management on Oracle deployments, database migrations and upgrades, project implementation plans and methods, uniform database preventive and reactive monitoring.

Developed training plans and training materials to improve DBA skills sets and develop a “common core” skill set for all staff DBAs.

Led effort to document methods so DBA tasks could be easily picked up by any team member.

Supported effort to move all database monitoring and scheduling tasks to OEM Grid control or local Oracle database scheduler. SENIOR ORACLE DBA DUKE ENERGY FEB 2008 - FEB 2009

Worked as project dedicated DBA supporting major financial production databases and development efforts for annual software and hardware upgrade project – frame, operating system, database, and application software upgrades as well as implementation of new business data organization.

Spearheaded development of statistics collection methods to support stable production performance.

Initiated design, testing, and execution of partitioning strategy.

Successfully developed and implemented database resource manager plans to prioritize batch load jobs in advance of reporting queries.

SENIOR ORACLE DBA CONTRACTOR AT DUKE ENERGY DEC 2006 - JAN 2008

Direct all aspects of database administration services for Oracle 9i and10g systems using AIX 5.2 and 5.3 on IBM 595 frames and EMC storage. Coordinate execution of hardware, software, and data mart implementations, including application upgrades and hardware migration projects. Document database parameter standards, monitor batch load performance, and manage technical operation and repair processes for third party programs. Produce technical forecast reports regarding recommended system and application maintenance and upgrades. Bring financial databases into SOX compliance.

Instrumental in design, implementation, and maintenance of test databases to facilitate production backups and recovery procedures.

ORACLE INSTRUCTOR CONTRACTOR AT ORACLE UNIVERSITY MAY 2006 - NOV 2006

Provided individual and group instruction for Oracle 10g database procedures with specialized classes in beginning and advanced 10g administration, new features for 10g operations, 10g introduction to SQL, and 10g programming using PL / SQL. Developed innovative teaching methods, monitored student performance, and resolved complex questions to facilitate student learning processes.

SENIOR ORACLE DBA NOVA INFORMATION SYSTEMS JAN 2001 – APR 2006

Administered broad range of technical development, testing, and client service to support systems operations for more than 800 concurrent users of customized workflow applications using Oracle 8, 9, and 10 on Sun Solaris and IBM AIX platforms. Developed comprehensive maintenance and performance checklists to monitor database system operations. Delivered informal staff training, provided technical forecasts for software and hardware upgrades, and established operational procedures to support backup strategies, security guidelines, and recovery processes. Developed troubleshooting resolutions to improve application queries, database performance bottlenecks, and production database organization.

Developed and executed Data Access Layer (DAL) application packages in PL / SQL to provide abstraction layer between internal data structures and code and optimize application performance.

Designed and implemented controls to meet Visa Cardholders Information Security Program (CISP) controls and Personal Cardholder Information (PCI) security standard for credit card information. ORACLE DATABASE SECURITY AUDITOR PRICE WATERHOUSE COOPERS NOV 1998 – DEC 2000

Performed comprehensive reviews of Oracle data warehouse and database implementations to maximize system security, reliability, and performance for various Fortune 100 client environments, including utilities providers, consumer product manufacturers, and brokerage firms. Developed PL /SQL scripts to assess several Oracle Applications modules, including payables, mixed assets, system administration, order entry, and receivables.

Executed database security control audits and penetration studies.

Spearheaded multiple enhancements for PwC Oasis application, including enhancing database control matrix, developing data warehouse control matrix, and developing performance tuning assessments. Education

Majored in Computer Science at East Tennessee State University, Johnson City, TN

Contact this candidate