SUMMARY:

Oracle DBA with experience installing and administering Massively Available Architecture ( MAA ) using RAC plus Data Guard.

TECHNICAL SKILLS:

• Five years Oracle DBA in a Massively Available Architecture ( RAC plus Data Guard )
• Five years ETL and Replication experience
• Significant experience with Virtualization both with Oracle, VMware and Cloud Technologies
• Fifteen years SQL tuning experience
• Ten years DBA

EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Implemented Oracle Audit using Linux SYSLOG
• Reviewed auditing rules against Oracle Best Practices
• Fixed ETL to load Oracle Audit tables into consolidated database for Unified Security Model (USM)
• Encrypted passwords using Oracle Wallet
• Research RAC/ASM disk group rebalance errors
• Automated DBA tasks using bash shell scripts
• Researched ORA - 7445 error unable to close file in backups
• Researched ORA-7445 alert log error - unable to access object in memory
• Escalated database security issues ( resource role in production )
• Researched ORA-3137 OCI client error in Oracle Financials and applied patch
• Created alerts in Nagios
• Migrated code using JIRA ticket system and CVS for version control
• Recommended using SYSCONTEXT to preserve proxy user in Tomcat web applications

Confidential

Oracle Application DBA

Responsibilities:

• Implemented new Oracle Financials 12.1.3
• Added credentials to Oracle Management Server 12c Cloud Control (OEM/OMS)
• Installed OEM agents
• Patched using OEM Change Management Pack
• Encrypted RMAN backups in OEM
• Cloned and hot patched Oracle Financials 12.1.3
• Automated Oracle Financials cloning process using Linux shell script
• Installed or migrated Oracle Applications and Databases to Microsoft Azure Cloud
• Tuned Oracle Instances ( PGA, SGA and huge pages )
• Tuned SQL using AWR, ADDM, and SQL Advisor
• Reorganized objects using Segment Advisor and Online Redefinition
• Converted databases to ASM
• Resolved database and application issues through independent research and Oracle Service Requests
• Installed and upgraded many Oracle applications: OBIEE, UPK, GRC, GCC, OATS, Web Center Content
• Installed third party applications using an Oracle database: Labvantage, Dell STAT, etc
• Resolved and configured Java Virtual Machine memory to prevent java memory heap errors
• Resolved iProcurement web services connectivity issues
• Upgraded Java and implemented work around for new TLS security
• Installed Oracle Heterogenous gateway for SQL Server
• Helped Oracle Financials developers resolve privilege issues with custom code
• Installed, configured and upgraded many Oracle Financials third party applications

Confidential

Oracle Warehouse Builder

Responsibilities:

• Wrote ETL to process one million pre-paid debt card transactions daily

Confidential

Data Warehouse Developer

Responsibilities:

• Designed data warehouse according to Ralph Kimball methodology and corresponding ETL using Oracle Warehouse Builder and Informatica
• Migrated all shell scripts into Tidal job management server

Director - Oracle DBA Manager

Confidential

Responsibilities:

• Managed two DBAs, one Solaris administrator and one SAN administrator
• Implemented Oracle databases in MAA configuration using RAC and Data Guard
• Migrated primary Oracle database from single server with internal storage to Oracle RAC using EMC SAN and both local and remote Oracle Data Guard physical standby databases
• Procured all hardware and managed setup of new RAC production system
• Procured all hardware and managed setup of new RAC data warehouse
• Defined roles and procedures to comply with ITIL/Sarbanes-Oxley
• Architected databases for Disaster Recovery
• Defined procedures (runbook ) for Disaster Recovery
• Helped migrate server applications to VMware for server consolidation project
• Helped resolve Oracle connectivity issues over WAN to remote sites in Atlanta and Manhattan
• Partitioned tables
• Implemented Oracle Financials
• Installed and configured Oracle Enterprise Manager Server ( OEM/OMS )
• Participated in Active Directory forest upgrade
• Participated in project to convert primary custom risk analysis application from two tier PowerBuilder and Oracle database to three tier .Net application and Oracle database. Recommended using Oracle reference cursors and client side connection pooling
• Tuned Oracle instance memory ( PGA, SGA, etc )
• Tuned SQL using statistics, Explain Plan, sql tracing, stats pack
• Tuned application not using bind variables by use of database trigger to change application session to force cursor sharing
• Resolved all application errors and alert log errors through research and Oracle service requests
• Consolidated all RMAN backups to a single Solaris server using ZFS mounts
• Implemented new tape backup system

Oracle Development Supervisor

Confidential

Responsibilities:

• Managed team of twenty Oracle developers
• Lead multiple business projects
• Created Oracle development standards
• Designed End of Month (EOM) reporting database and corresponding ETL and indexing methods

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Migrated End of Month ( EOM ) batch processing from MS Access with Oracle database to Oracle stored procedures