Data Analyst Resume
Menomonee Falls, WI
PROFESSIONAL SUMMARY:
- Experienced Oracle and Exadata administrator committed to maintaining cutting edge technical skills and up - to-date industry knowledge.
- Expertise in installation, backups, migrations, patching, tuning and management.
SKILLS:
- Oracle Database 7.3 - 12c 10g - 12c RAC, ASM
- Exadata V1, X2, X3, X4 DCLI, OSWatcher, Exawatcher
- Exp/Imp, DataPump Materialized Views, Redefines
- Rman, Dataguard, Flashback Weblogic 11g, Oracle Portal 10g
- Sql, PL/SQL Unix scripting Database and Application Tuning
- Business Objects XiR2 Oracle Reports Discoverer
TECHNICAL SKILLS:
Software: Oracle 7.3.4 - 12c, Exadata V1-X4, 10g - 12c OEM, PL/SQL, SQL, DCLI, OSW, Exawatcher, Exachk Rman, Dynamic SQL, TFA, Dataguard, Weblogic, ADRCI, Oracle Reports, Discoverer, Business Objects, Case Studio, PL/SQL Developer, Sql Developer, Datapump, Export/Import, Heterogenous Services, Partitoning, RAC, ASM, Compression, LOBS, Security, Oracle Portal, Toad, Erwin, Designer 2000, Linux, Windows, Unix Scripting (Korn Bourn), NAS, SQL Loader, Java, Json, HTML, Oracle 12i and 11i experience, HTML, Visio, Cobol, JCL, Crystal Reports, MVS, DL/1, CICS, C, Dyl280, Endeavor, Easytrieve, SAS, M204, JavaScript, DJDE, Unix, VB, SAR (mainframe), Powerpoint, PGP, TSO, Lotus Notes, Panvalet, DOS, Rumba, Samba
Operating Systems: Exadata V1, V2, X3, X4, Linux, Sun, HP, Windows
WORK HISTORY:
Confidential, Menomonee Falls, WI
Data Analyst
Responsibilities:
- Administration and Tuning of Core Systems
- Process Improvements
- Architect new pruning procedures for partition tables and CLOBS
- Design better table structures and indexes for Exadata
- New Release Implementation
- Completed Oracle Exadata Database Machine Administration Workshop Ed 3
- Completed Oracle 12c New Features for Database Administrators
- Learning Golden Gate both classic and integrated
- Security Compliance Remediation
- Clean up 12c OEM Cloud Control Targets
Confidential, Menomonee Falls, WI
Senior Database Administrator
Responsibilities:
- Implement and Document new Exadata X3, X4
- Validate Exadata X3 and X4 configuratons, fix performance issues
- Failover, Backup and Recovery on Exadata
- Co-ordination of Patching Exadatas with Platinum Support
- Work with MOS Hardware engineers for parts replacements X3, X4
- Migration of database from Linux/AIX to Exadata X3
- Deployment of auditing packages, dba specific packages
- Architect new table, index designs
- Tuning of 3rd party packages - JDA, RMS
- OSW, Exawatcher, DCLI commands and scripts
- Automation of mundane tasks, use of ADR, clean up scripts
- Write Standards for off shore consultants
- Application and database upgrades
- 11g and 12g OEM targets, validation scripts
- Upgrade, Documentation, training of Loyalty system
- Chairman’s award for Loyalty project work
- Rman Incremental Backups
- Partitioning, LOBS,
- Standby databases with Data Broker
- Completed Oracle Certified RAC Extreme and Exadata classes
- Orchestrate design and set up of targets and monitoring on 12c OEM
Confidential, Grafton, WI
Consulting
Responsibilities:
- Confidential - migration of 5 branches to new program.
- Documented migration process and procedures
- Confidential - Weblogic Validation of set up and practices
- Documentation of Oracle database best practices and procedures
- Architect new tables and features for Confidential programs
Confidential, Milwaukee, WI
Senior Database Administrator
Responsibilities:
- Exadata patching maintenance and performance tuning
- Architect and deploy new tables, functionality for 300+ customers on Exadata
- Document how to articles for Exadata
- Exadata hardware maintenance and replacements
- Data Warehouse project management, simply and document
- Fuego migration to BPM using Online Redefinition
- Application and database upgrades from 8i to 11g
- Automation of database purges and refreshes
- 11g RAC implementation
- Interval Partitioning
- Transportable Tablespaces
- Standby databases
Confidential, West Bend, WI
Senior Database Administrator
Responsibilities:
- Implementing IDM 11G, SSO and Portal on WebLogic 11G
- Datapump for migration of 3+ Terabytes of data from HPUX to Linux RAC cluster
- OEM install and configure on 11g OEM
- Misc installations for Applications Team
- Articles published in Tru-Tek
- Architect automation of refresh of Pharmacy uploads
Confidential, Saukville, WI
Senior Database Administrator / Oracle Applications Administrator
Responsibilities:
- Migration from Business Object 6.5 to XiR2, user training
- Reimplementation of Oracle Portal Project where past implementations had failed
- Convert Oracle Business Processes on Windows to on Linux
- Rman for backup and recovery, training engineer to take over backup
- Installation of BPEL, Discoverer
- Materialized Views to support business process and Oracle Portal reports
- Assist in implementation of Oracle 12i EBS
- Variety of articles published on Metalink and two awards for articles
- Bamicon Sql Server upgrade across 2 physical locatons
- Led effort in Plugging in custom shipping system to 12c EBS
- Set up of Mobile Workers in 12c EBS
Confidential, Milwaukee, WI
Senior Database Administrator
Responsibilities:
- Documenting of Systems and Process Flows for company going from Private to Public
- Standardize systems to use the same scripts, jobs across the 12+ systems
- Effectively tuned SQL and database so 150% growth did not hamper response time for SLA
- Rman for backup and recovery, Data Control for monitoring database
- Automation of billing, purges, logs, archives
- Implementation of custom reports in 11i Apps
- Updated databases to 10V2 from various 10.1 releases
Confidential, St. Francis, WI
Senior Database Administrator
Responsibilities:
- Used auditing to catch rogue programs updating main database, convert users
- Implemented major conversion of software, co-ordination users, backups and events
- Scripted job to export and archive unnecessary historical data to keep db fast and small
- Work with Hibernate and create view to make faster and more usable.
- Consolidate CSI numbers and licenses to make more manageable
- Switch to LMT tables paces
- Documentation of policies and procedures
- Training new database administrators and consultants