Robert Carlin

• Data Warehouse lead, supporting all data warehouse platforms on AIX and Exadata X7 and X9 appliances.
• Deployed ZFS based incremental recovery backup method to deliver a faster RTO for our most critical business functions.
• Implemented Exadata hardware expansion, deploying both additional storage servers, and physical drive replacement. Returning providing both growth and performance to large Enterprise data warehouse.
• Deployed Oracle Enterprise manager for single source monitoring of all shoreside and fleet databases. Solution integrated with PagerDuty for critical notification of global on-call teams
• Administered, supported, and monitored databases by proactively resolving database issues, deploying restructured partitioned and compressed.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Ensured database security with implementation of role-based access control and regular vulnerability assessments.

Specializing in Oracle PL/SQL performance tuning, and Informatica ETL development for corporate data mart and data warehouse initiatives.

• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Served as Tivoli development lead, Change Management team lead, Operational support lead and subject matter expert for development staff and differing lines of business

Lead Developer for a client server Omnis7 application development of Order Management OLTP system, and the associate corporate reporting repository

• Routine included maintaining contracted service level agreement, providing new application development for business users and ongoing support of Oracle Financials month end processes.

• Lead developer of Omnis7 application development for multiple ERP, Cost Tracking, and Customer Opportunity systems with Oracle RDBMS
• Primary development and support of all Oracle database interfaces and locally replicated database objects for the Caribbean and Latin America markets.
• Web development using Cold Fusion 4.0 and Oracle stored procedures to provide dynamic online customer tools for Nortel client portal sites

• Contracted to Nortel Networks for primary Omnis7 application development of client/server contract management ERP systems with an Oracle RDBMS
• Additionally developed PL/SQL database integrations to consolidate data for reporting.
• Developed PL/SQL database feeds to multiple Nortel application system and their corresponding regional Oracle financial systems.
• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Provided ongoing support for users experiencing issues or requiring assistance with application functionality.

• Employment in both Jam and CCA application development in SCO and Solaris UNIX with Oracle Db
• Utilized embedded SQLPlus calls to manipulate Oracle Databases
• Heavy production support, ad hoc queries, and Unix shell scripting required
• Close support of both internal QA and Client UAT groups, while developing in sync with PRC reports and feeds group to insure feed accuracy