Commonwealth of Pennsylvania - Department of Conservation and Natural Resources (DCNR)Oracle Database Administrator/Developer
Oct. 2013 - May. 2016Harrisburg, Pa.• Provided Oracle DBA support (monitoring, patching, upgrades)
• Migrated legacy databases to Oracle database appliance(Windows to Linux)
• Developed database objects (tables,packages,procedures,indexes,views) using PL/SQL and T-SQL
• Developed browser-based applications using Oracle APEX
• Setup monitoring of databases (Oracle and MSSQL) using Oracle Cloud Control 12C
• Converted PL/SQL code to T-SQL and SSIS
• Created custom ETL procedures using PL/SQL and T-SQL
• Conducted conversions of DCNR data(Oracle and MS-SQL) to third-party vendors (data mapping, data etl, conversion reconciliation, test plans, issue resolution) . Environment: Oracle 11.2 , GNU/Linux, Oracle SQL ,PL/SQL, Enterprise Manager 12c, SQLdeveloper 3.2, SQL*Loader, Datapump, Oracle APEX 4.2 , Oracle database appliance 2.10, MSSQL 2008 , SSMS, SSIS, XML, Hyland OnBase Studio