TECHNICAL SKILLS:

Operating Systems: Sun Solaris, AIX, Red Hat Linux, HP - UX, VMS, MVS, Windows (NT, 2000, XP, 7) RS-6000

Databases: Oracle 8.i, 9.x, 10g, 11gR2, 12c, RDB, DB2, IMS, MS SQL 2008

Oracle Products: Exadata X3, ASM, RAC, OEM 12c, Grid Control, PL/SQL, RAT, Active Data Guard Replication, RMAN, Siebel CRM, JD Edwards

Other Products: Erwin, Quest (Toad, Spotlight), Embarcadero (DBArtisan), Veritas, NetApp, EMC Symmetrix/Clarion SAN, Siebel (7.7, 7.8), HP Openview, BCV refresh, AutoSys Enterprise Job Scheduler, Informatica, Apache, Weblogic, MQ, Lumigent (Security/SOX Compliance), Princeton Softech, Oracle tools/utilities

Languages: C++, HTML, Perl, Java, Cobol (IBM and VAX), CICS, MVS/JCL, Unix Shell scripting, DCL, Cognos Powerhouse (Quiz, Quick, QTP)

PROFESSIONAL EXPERIENCE:

Oracle ODA DBA

Responsibilities:

• Oracle Database Appliance DBA for Migration project to move databases from 11.2.0.3 3 node cluster to 12c ODA. Started by bringing all X5-2 ODA’s up to ODA patch 12.1.2.8 from lower releases to get all machines on same version.
• Created new 12c databases for migration of 4TB BI data warehouse. One test database used to test Advanced Compression of objects to reduce size to just over 1TB. Found Oracle bug while importing data using Data Pump with parallel 8 and Advanced Compression of objects. Reviewing Advanced Compression license for selected large databases. Bug fixed in ODA patch set 12.1.2.10.
• Created multiple Production databases with Standby Databases on DR servers using Data Guard. Reviewing Active Data Guard license for select applications.
• Performed Enterprise Architect role by advising Infrastructure group on benefits of Oracle ZFS appliance versus internally engineered solution for use as backup solution as well as NFS transport for migrations to leverage the CPU/Memory/Compression benefits of ZFS device. They had an old NetApp appliance which was due for replacement.
• Identified numerous issues with existing Production databases which saved 400GB post-migration. Help initiate Oracle Best Practices in multiple areas but most significantly Data Guard using Data Guard Broker for switchovers. Identified numerous Security issues and helped remediate. Implemented advanced shell scripts for monitoring of databases until OEM 13c fully implemented.
• Implemented the use of SSD Flash tablespaces for frequently accessed data for selected applications. Used new 12c package for on-line object redefinitions to move objects into FLASH tablespaces.
• Identified and corrected numerous performance issues related to 12c optimizer. As expected, when migrated a number of apps from 11GR2 to 12c, we encountered issues with 12c using a different execution plan than current production.

Exadata DBA

• Exadata DBA for Migration project to move databases from P6/7 AIX LPAR’s to Exadata X3-2 machines ranging in size from 50GB to 4.5TB (moved to date. Largest environment 60TB.)
• Worked with on-shore and off-shore resources to acquaint resources of SCE standards on database builds and Data Guard configurations. Scope of Data Guard increased to include System Test environments. DB builds includes roughly 20 step process to productionalize an environment, including RMAN setup and testing. Documented DB build and Data Guard setup for offshore.
• Migrated roughly 35 applications, which includes Dev, System Test, and Production for each app at a minimum. Some apps had additional test regions. Used standard SDLC process of migrating.
• Performance tuned many SQL statements which performed poorly once migrated. Used 10053 trace to help resolve a few, by identifying object whose CDN (cardinality) was interpreted differently and caused selection of wrong access path. Other SQL were diagnosed with tradition explain plan differences, as the optimizer in 11.2.0.4 and 12.1.0.2 are more stringent on column naming.
• Diagnosed and corrected multiple environments created by offshore team, ranging from DB build issues to Data Guard configuration issues.
• Modified numerous shell scripts to automate maintenance tasks.

Exadata DBA

• Lead Exadata DBA for Migration project to move databases from P6/7 AIX LPAR’s to Exadata X3-2 machines ranging in size from 300GB to 3.5TB (moved to date. Largest environment 60TB.)
• Environment consisted of 3 X3-2 Half RAC Exadata machines (Prod, DR, Non-Prod) with one X3-2 Eighth RAC as patching environment. All machines had 11.2.0.3, 11.2.0.4, and 12.1.0.2 GRID Infrastructure binaries as well as Database binaries. Performed Assessment to determine whether all AIX environments would fit into existing Exadata configuration. Platinum support performed upgrades, but on limited number of DB’s. Upgraded multiple DB’s to 12.1.0.2.
• Created both 4 node RAC 11.2.0.4 and 12.1.0.2 databases for testing. Created both 4 node RAC 12c stand alone and 12c Container databases with multiple pluggable databases for testing. Introduced the use of parallel processing for Data Pump Export/Import process to reduce runtime of export from 26hrs down to 5.5hrs for a 3.5TB database. Created NetApp NFS mounts for export/import and had the mount presented to all Exadata nodes and specific source AIX systems as migration schedule called. Required specific configurations for use with 10G database for both NFS mount options and /etc/filesystem definitions. Mount options on AIX and Exadata slightly different. Runtimes of 1TB/hr achieved on exports, with similar times on imports.
• Created and configured Unix shell scripts for Level 0 Full, Level 1 Incremental, and Archive log backups. Also configured scripts for basic instance health monitoring until OEM 12c was functional. All scripts were called by CRON scheduling.
• Encountered ASM Storage Management compatibility issue when creating databases with version higher than 11.2.0.3. Resolved by updating ASM compatibility init parameters.
• Created process to establish both Physical Standby Data Guard and Active Data Guard Replication on DR machines. All Production databases on AIX were clustered with HA-CMP and required comparable configurations for Disaster Recovery (DR) site. Critical applications were licensed to Active Data Guard, all others Standby configuration.
• Assisted in establishing configuring for OEM 12c Grid Control to monitor Exadata machines. Previous OEM 12c OMS RAC configuration encountered issue which required reconfiguring AIX cluster and reinstalling 12c binaries.
• Created documentation for moving existing Red Hat Linux databases over to Exadata using RMAN as both environments were the same endian and did not require conversion.

Production Support DBA

• Member of DBA team who supported Siebel CRM, Daybreak, LeasePak, Reporting suite of Enterprise databases. Production instances were 2 node Oracle RAC configurations with Snapshot Standby database clusters provided for Disaster Recovery. Database versions ranged from 9.2.0.6 to 11.2.0.3 for Siebel CRM. Oracle streaming of archive logs was medium of synch.
• Reviewed database configuration and provided written documentation of issues found and means/scripts to resolve. (Redo logs not multiplexed and sized too small 500MB switching at peak rate of almost 400/hr, daily node affinity locking issues with SQL causing the locks, performance tuning SQL’s requiring indexes, and verified row-chaining fragmentation issue of two most active tables, S ASSET and S CONTACT. Supplied examples of SQL which were root cause of fragmentation, (INSERT SQL statements with additional UPDATE SQL causing the issue.) Provided SQL with steps on dropping/clearing Log groups from snapshot standby DB first to rebuild Log groups using multiplexing and resized to 2GB once file systems extended. Tuned ETL process.
• Deployed 12 Unix shell scripts for monitoring database functionality in conjunction with OEM 12c which included writing success/failure records out to Meta-Data repository for real-time dashboard reporting.
• Created new OEM 12c environment on AIX servers to replace HAEA’s OEM. Debugged domain name search network issue causing delayed response times between app lpar and DB lpar. (Commented out feature from /etc/resolv.conf file which was searching another network domain.) Completed configuration and startup of OMS server. Created document for firewall requests.

Production Support/Exadata DBA

• Member of ORAADM team of 6 Oracle DBA’s who supported 225+ Oracle Enterprise wide large scale instances predominantly on AIX, including Red Hat and Suse Linux, and Exadata V3. Currently have 2 Production ½ Racks, 1 Non-Prod ½ Rack, and 1 1/8 Rack Sandbox. Configured Active Data Guard between 2 production machines with the largest DB roughly 2TB. Due to size, gap resolution during initial configuration was encountered and resolved with RMAN to synchronize.
• Configured HUGEPAGES for all Exadata nodes to allow for better memory utilization of server pages. Made kernel level adjustments on all nodes, /etc/security/limits.conf changes, and init parameter changes to disallow AMM and only allow database to start if sufficient Hugepages exist for each database. This was on top of numerous kernel changes initial made to increase Oracles default settings, which according to Oracle Techincal support, was configured for the minimum allowable.
• Dropped and re-created Flashcache with new setting for WriteBack versus default on all 7 storage cells for each Exadata machine. Oracle default setting for Exadata is to not use Flashcache for writes.
• Performed POC of Exadata versus AIX and zLinux on the Mainframe using Oracle Real Application Testing (RAT). Captured two distinct workloads from 2 different apps to benchmark. Setup 2 node RAC configuration with ASM Storage Management on zLinux with 2TB database to baseline against ½ Rack Exadata. Configured all ASM Storage Management disks/diskgroups. De-tuned Exadata to more closely match the z196 chip on the IFL. Captured workloads from source AIX lpar’s and Linux physical blade servers. Configured and enabled Flashback Database to allow for easily repeatable tests with the ability to reset back to restore point just before test began.
• Supported multiple large scale Enterprise wide projects at SCE. SmartConnect was the largest database supported at SCE (45TB). Supported as primary DBA MRTU/PPBU (Power Trading) suite of 50+ databases. Performed 50-60 database upgrades, mostly 10g to 11gR2, with a handful of 9i to 11gR2 twin upgrades. Migrated 50-60 databases from old IBM P5 hardware to newer P7’s using RMAN as part of on-going Hardware Refresh project. Created new file system spreadsheet for use as template for new builds which included the use of CIO filesyetems. Rebuilt numerous older instances and brought file system layout up to current standards. Customized RMAN scripts to accommodate file system changes. Performed rolling RMANmigrations (where full level 0 backups restored, and recovered till current incremental and archives brought current) of larger instances to reduce downtime required for migration windows.

Production Support/Exadata DBA

• Configured Active Data Guard Replication for multiple databases to provide DR recovery, the largest was 800GB. Encountered gaps in log application during setup and needed to resolve with RMAN restores of archive logs and writing more current logs to disk and sftp to other Exadata machine.
• Performed POC of EMC De-Duplication appliance to reduce RMAN backup sizes and run times. A 11TB RMAN database backup which took 11-12 hours with LAN Free, reduced to 3.5 hours. The restore of 11TB was reduced from 16-18 hours to 5.5 hours.
• Created RMAN migration doc for how to move instances from non-RAC Linux environment to Exadata. Assisted early migrations to Exadata identify and remediate corrective actions due to applications not written as RAC Certified. Created template scripts for creating new 2 node and 4 node RAC instances. Drafted new team standards for init parameters, threads and log files per node, and undo allocation. Modified OS kernel settings to improve upon Oracle’s defaults on compute nodes as well as storage servers.
• Upgraded Exadata RAC configuration including Oracle Grid binaries and Database environments to Oracle 12c. Created new Container database and multiple pluggable databases for vendor application to perform POC. Created new schemas in pluggable databases and performed Data Pump import of data from another instance.
• Initial assignment was to help stabilize 200+ instance environment. Developed and deployed Unix shell scripts for AIX and Linux, to perform all monitoring and space checking functions, backups, both logical and physical, and backup maintenance tasks to keep TSM servers tape utilization stable. Initially developed and tested for single environment, and then created files in shared server to be deployed to all other environments. Created document for how to deploy new environments using scp copy commands.
• Developed export Unix shell script which checked for size of each schema in the database descending, and performed export and dsmc backup to tape if next schema determined to be too large to write to export area allowing export area to be sized for largest schema instead of size of whole database.
• Created 40-50 new databases on 11gR2 (11.2.0.3 and 11.2.0.4) instances during engagement. Create new instance build spreadsheet which defined LUN/file system allocations specifying which were be configured with CIO option and included which OS patch sets were required to support new Oracle builds.
• Performed Data Center migration of databases from GO2/IOC AIX clusters to new ADC/IOC AIX clusters using various Oracle and SAN migration methods. The largest single database moved with RMAN was 11TB SmartConnect performance test environment.
• Provided 24/7 on-call support on a 1 month rolling basis where you were responsible for all alerts, email requests, and RFC’s in support of the ORAADM (Infrastructure Database team).
• Created password verify function to use in conjunction with profile to provide password complexity checking to improve and harden Oracle Database security.

Sr DBA/Prod Support Team Lead

• Supported NMF BI BIO vendor OLTP systems (AT and DT) running Oracle 9i/10g on Solaris 5.9 using NetApp SAN. Data centers in Salt Lake and North Carolina. Connection with VPN.
• Supported vendor application environments for Production, Shadow and Test instances along with two IP instances under development. Was responsible for refreshing Production data to Test instances on a typical quarterly schedule to assist with new release testing.
• Performed extensive SQL tuning which included introducing Parallel hints with old vendor.
• Created and dynamically resized Recycle and Keep caches to assist with tuning options.
• Adjusted optimizer index caching and optimizer index cost adj init parameters after analyzing system query performance in Test environment.
• Analyzed two primary business processes and doubled the records per hour throughput benchmark by pinning selected objects into appropriate cache.
• Created new ASSM tablespaces and defragmented tables by moving selected objects.
• Monitored Index usage and reduced unnecessary indexes and saved 35GB of storage.
• Revised vendor views to correctly make use of Oracle Hints to improve GUI response.
• Reviewed server kernel settings with vendor and adjusted to improve overall response times.
• Tested Oracle VPD and FGAC (Fine Grained Access Control) for securing PHI data by department/user.
• Participated and advised on yearly Disaster Recovery exercise.
• Assisted in storage allocation with NetApp SAN and created NAS area (NFS mount) for exports.
• Created Stored Procedures and UNIX shell script for ESRD Phase I data extracts.
• Created reports for ESRD Phase I MS SQL 2005 environment using Reporting Service (SSRS).
• Assisted with MS SQL 2005 Integration Services (DTS) package for loading of ESRD data.
• Created function and Stored Procedure for data cleansing of special characters embedded in comments fields.
• Developed SQL and PL/SQL for ETL extract/archive process for selected data by business function.
• Created numerous maintenance Unix shell scripts for Production Support team.
• Provide technical direction and training assistance for Production Support Team.
• Created 11g ASM and Dev instances for Data Warehouse reporting project. Established partition keys for primary tables based upon ISO week and tested load process with and without partitions. Due to support issues, proceeded with tables non-partitioned.
• Created Unix shell script to perform load process into new reporting DB. Included loop functionality for multiple input files. (Historic loads encompassed 80 large input files.)
• Created new RMAN catalogs for Production and Development environments to improve backups.

 Sr DBA/Data Architect

• Supported multiple Enterprise VLDB Siebel OLTP systems (2.5TB largest) (Stars, UCM, Spectrum) all running on Sun Solaris 5.9/5.10. Production used Symmetrix SAN and SRDF DR (Tier-1). Sub-prod typically used Clariion SAN storage (Tier-2 and 3).
• Each application consisted of Production, Stage, Test, and Dev instances. Prod and Stage were similar environments and used for performance testing. Test and Dev were typically much smaller. All instances were 9.2.0.6 and performed upgrade to 10.2.0.2.
• Developed refresh process to pull referentially intact subset of data to populate smaller Dev and Test environments using Unix FIFO pipes as transport media.
• Performed extensive SQL tuning for queries against very large non-partitioned tables by introducing Parallel hints and resizing SGA resources (Keep and Recycle pools).
• Refreshed Stage environments from Production using export/import process.
• Refreshed Stage environments from Production using RMAN.
• Refreshed Stage environments from Production using BCV refresh process (due to large volume of data involved.) Performed both hot and cold splits.
• Created multiple new environments for new projects based upon user project specifications. This resulted in extensive resizing as the projects progressed.
• Provided input on updating file system standards for creating a standardized Data Base footprint for all post 10g upgrade.
• Performed numerous blind imports from full dumps where the App team did not know which specific schema objects were needed. Performed numerous export/import and 10g Data Pump.
• Upgraded and patched multiple 9.2.0.6 instances to 10.2.0.4. Encountered/solved many issues while upgrading to 10gR2. Performed export/import from Network Attached Storage (NAS) area.
• Performed various levels of tracing to diagnosis performance issues after 10g upgrade. With 10g using new defaults for optimizer settings, various applications which were performing well pre upgrade encountered new issues post upgrade (involved joins with small and large tables).
• Assisted in tuning LoadRunner benchmarking scripts used by QA team.
• Acted as Liaison between Application Team and other technical teams to resolve issues.
• Assisted One Source with shell scripting, ETL data loading and performance issues.
• Created UNIX shell script for monitoring key instance metrics. Experienced in customizing thresholds and alerts for multiple custom application instances.
• Developed SQL*Loader process for creation of high volume test data into 26 tables for Spectrum project. Shell script performed error checking after each table load and would stop at each step if an error was encountered.
• Assisted QA team in benchmarking and documenting performance issues with Spectrum Application servers to highlight lack of database specific issues with LoadRunner Java utility.
• Provided mentoring to fellow DBA team members.

Confidential

Data Architect/Sr DBA/Developer 

Demonstrated Technical Skills:

Oracle 10g DBA, Oracle Tuning, PL/SQL / Stored Packages, Data Modeling, Data Architect, J2EE, Eclipse

Demonstrated Consulting Skills:

DBA and Data Base Tuning, Project Management, Project Specification, Project Planning, Project Supervision

 Responsibilities:

• Oracle 10g ERP Customer Data Integration (CDI) project on Linux based servers.
• The scope of the project involved consolidating data from JDE ERP system and Siebel CRM system, using MDM techniques, into an Enterprise Master Data repository for a Single Point of Truth (SPOT).
• After analysis phase of identifying and gathering customer base data elements from both JDE and Siebel schema’s, modeling new Customer schema began with the intent of supporting both B2C and B2B business models.
• ERWIN was used to develop/maintain both logical and physical layouts.
• New 10g instance was created, and tablespaces were established to keep staging and base objects separate. Maintained all sql required for creation of view, sequences for surrogate keys, etc.
• Staging tables were developed for both JDE and Siebel base customer data and were loaded with a combination of SQL*Loader and Export/Import shell scripts as the first step of the conversion. SQL*Loader control cards were built and a generic parameterized Korn shell script was developed to load all fixed length data files from JDE. SQL*Loader bug was discovered and reported in MetaLink while attempting to load data file with 57 million records. Work around involved using 3 buffer parameters available to SQL*Loader until 10.1.0.4 patch was applied.
• Developed Microsoft SQL 2000 DTS package for transferring data from MS SQL Server data sources.
• Pre conversion data cleansing routines were developed to format data and extensive SQL code was required to populate second phase staging tables. Many views were also created to assist with transforming data into required normalized structure.
• An Oracle Stored Package was developed to transform data into new normalized Customer data structure using surrogate keys. The package needed to load the tables in a specific order, and could only perform a commit after successful writing of all objects. Extensive tuning and optimization of queries was performed using TOAD in order to process approximately 12 million customer records into new schema.
• After data was converted, stored procedures were developed in combination with database objects to pass data to J2EE UI.
• A procedure generator was created to create base procedures to aid in the development of UI.
• User Interface (UI) was J2EE based system that called Oracle stored procedures to interface with new Customer data.