• Performance tuning and monitoring on Database level, Storage level, Server level.• Work with various customers on Oracle upgrades.• Create stored procedures and modified legacy SQL for reporting.• Create Linux scripts and cronjobs for routine maintenance.

Oracle DBA • Performance tuning/monitoring on Database level, Storage level, Server level.• Work with dev teams to identify and tune poor performing SQL.• Work with dev team to create data models for large projects.• Work with the Linux team to setup NetApp SnapCenter for recovery. Use RMAN to resolve issues.• Work with the Linux team to setup scripts and troubleshoot DR recovery at offsite location.• Use OEM to check on Oracle performance. Generate AWR to review issues.• Support and performance tune complex queries using Toad. • Install/upgrade Oracle databases from 9 to 11gR1, 11gR2, and 12c on Redhat Linux servers. Maintain performance through SQL Plan Control. Used transportable tablespaces for upgrade process.• Install oracle patches and one off patches.• Configure Direct NFS on all Oracle servers. Prior to NFS, I configured RAC and ASM.• Use AWS migration tool to prepare and move Oracle objects and data to AWS Postgresql cloud database.• Use Oracle SQL Developer to search XML data from Wells Fargo and parse data into tables.• Maintain, patch, tune OpenText LiveLink database in Oracle for content management purposes. Create custom reports from the raw LiveLink data. Create SQL for LiveReport.DB2 DBA (UDB/LUW) • Performance tuning and monitoring on DB, Storage, Server level.• Install/upgrade DB2 UDB databases from 9.5 through 10.5. Migrated from Windows to Redhat Linux.• Use IBM Data Studio 4.1.3 to create stored procs. DB2 Database programmer (z/OS)• Use IBM Data Studio 4.1.3 to create stored procs and test SQL queries for DB2 on z/OS. SQL Server DBAMySQL DBAPostgreSQL DBA (Amazon Cloud)• Migrate data and Oracle objects from Oracle 12c to AWS Postgresql. • Use pgAdmin to correct converted stored procedures and triggers from AWS migration tool.• Create automated AWS scripts to drop the database, build the database, create users and load data into the database.Java Development• Develop config for the J2EE app server migration.

• Enhance DCS, intranet Forklift Dealership, to include client-side table sorting. Add drop down menus with transition effects.• Create Proof of Concept to retrieve information from a local Access database from a web page using Javascript, transmit, and retrieve data to a SQL Server 7 database using xml/xsl. Create sort list table using xml/xsl.• Use xml to separate data from the html. Use xsl to present the xml document in various forms. Use xsl DOM to filter and sort the xml document. Use Microsoft's ADO 2.5 to build a schema and xml document at runtime.• Use DHTML behaviors to create a generic behavior in an htc file for table sorting based on datatype. The behavior also remembered the last used table sort to determine if the column should be sorted in ascending or descing order.