Brent Cleator Email & Phone Number

Wellington & Wairarapa, New Zealand

Solution architect on a complex BS11 compliance project to remediate BNZ dependence on a NAB Oracle Exadata warehouse by migrating to a new AWS based Cloud data platform. Some highlights include:• AWS solution designs based on a data hub concept including Ingestion (SFTP, S3, KMS, Encryption), Curation (Informatica ETL, Lambda, Airflow), Content Zones databases (Redshift, Oracle, Postgres), Serving layer and code pipelines (Jenkins) from Git source control.• Collaboration with BNZ and NAB bank stakeholders to ensure a robust collaborative design to cover the many requirements and components in an Oracle Exadata Data Warehouse including Scheduling, Orchestration, Unix and Oracle ETL and performance aspects.• DevOps work for Proof of Concepts and to help implementation and testing teams• Oracle Exadata replication plan B options• Performance architecture to meet SLAs• Data Architecture designs and solutioning for moving a 20-year-old Data Warehouse design to a modern cloud-based data hub.

Wellington, New Zealand

Collaborated with IT and business stakeholders along with vendors to successfully design, document, gain approval and implement various solutions including new Business Intelligence infrastructure, Virtualisation, High Security, Mobility, Geospatial and Cloud Security systems. Highlights included:• Business Intelligence high and detailed architectural designs for a new OBIEE installation including Development, Test, UAT and Production virtual environments on new hardware including web cache servers working along with stakeholders through the infrastructure approval processes and successfully delivered with infrastructure vendors. The team’s work received a Silver award, nominated from the business for successful delivery of what is now a core reporting tool.• Highly secure OBI Mobility high and detailed architectural designs utilising complex Cloud and On-Premise systems including Secure Mobile Knox integrated containers on devices, Citrix NetScaler for DMZ, AES 256-bit ECDHE encryption, external SAML Cloud authentication and internal Kerberos tickets with Samsung EMM Cloud device management. This was deployed successfully to the Departments Mobile phones and tablets for the first time in NZ.• Designed and created Geospatial reporting capability at Corrections with Oracle DB Geospatial Datatypes, OBI Mapviewer dashboards, JavaScript and Java encoding engines to enable clearer street map location-based management of Offenders in the Community.• Kerberos SSO design and implementation for OBI, APEX and Discoverer with high security AES 256-bit encryption• Oracle DW Exadata Database and OBI performance reviews and enhancements• DW Security review and enhancements using VPD and centralised AD roles• Oracle DW and OBI architectural and technical support including PowerDesigner, Sparx EA and Visio modelling• WebLogic Middleware configurations for OBIEE, APEX and Java including SSO• Microsoft SQL Server TFS database config and SQL Server BI data sources

Wellington, New Zealand

Worked on the Business Intelligence data warehouses at TEC as BI technical development lead and DBA including:• Microsoft SQL Server DW Database BI development and support including rearchitecting of the ETL engine for dramatically improved performance and easier analysis support. • Working with vendors on the design and implementation of an externally accessible Tertiary reporting and submission system using the MOE Education Sector authentication services, BI processing and reporting.• Microsoft SQL Server Integration Services and T-SQL ETL using Visual Studio and Team Foundation Server • Microsoft SQL Server Analysis Services dimensional data cubes• Oracle Databases Development and Production support• Oracle Warehouse Builder and PL/SQL ETL• Power Designer modelling and support• Cognos BI and Reporting development and support• Jira and Objective application and database support

Wellington, New Zealand

Provided Development DBA support on three development projects including:• PL/SQL Development including Java Interface packages with specific performance requirements• Modelling databases and database changes using Oracle Designer• Planning, scripting and coordination of Development, Test, UAT and Production deployments

Wellington, New Zealand

Provided Technical Architecture solutions and Development DBA support on an Oracle 10gR2 RAC Data Warehouse Business Intelligence project including:• Architected hardware and software solutions for clustered RAC databases and clustered Application Servers in Development, Test/DR and Production environments including new SAN requirements• Installed, setup and tested the solution of clustered Oracle RAC databases and clustered Oracle Application servers using Sun AMD 64bit dual core servers, Linux and Sun FLX380 Storage Arrays• Oracle Application Server setup and support including Discoverer, Portal and APEX (HTMLDB)• Oracle Designer and Oracle Warehouse Builder support and development• Setup OID and replication with central LDAP server to provide identity management and single sign on access• Performance tuning of SQL for parallelism and RAC• Developed backup routines using RMAN and on disk recovery areas

Wellington, New Zealand

Provided Technical Architecture solutions and DBA support for ArcSDE GIS projects on Oracle 10gR1&2 including:• Helped with architecting hardware solution for an Oracle Server and SAN upgrade• Installed Oracle10gR2 on Linux and migrated the Oracle9i ArcSDE database• Setup all required backup, monitoring and alerting routines• Provided tuning, testing, performance help and patch set upgrades on an ad hoc basis

Wellington, New Zealand

Provided Production and Development DBA support on an Oracle 9i/10g Data Warehouse including:• Oracle Application Server support including Discoverer, HTMLDB and PSP• Oracle Designer and Oracle Warehouse Builder usage and support• Senior Oracle DBA support for all Oracle projects• Unix Administration• QA of development PL/SQL & SQL code• Implementing release procedures• Development of an Oracle based ETL job/process control including web interface• Development of inter-governmental data transfer process using DMZ Transfer

Immigration Home Office, Croydon, United Kingdom

Provided Production, Testing and Development DBA support on Oracle9i, Parallel Server 8i and 8 including:• Production support of the UK Immigration database (IND) on Sun Solaris Parallel Server 8i 24/7 • Backup and replication of Production and Testing databases on Sun Enterprise E1000 using RMAN• Support of Oracle Forms servers and Web server interfaces into Production systems• Processing and support of Production data feeds – Landing Cards and Asylum etc. • Disk configuration and performance tuning• QA of development code for Production releases• Documentation standards

Winnersh Triangle, Uk

Provided Production and Development DBA support on Oracle9i, 8i, 8, 7 and Oracle Financials 11.03 and 11i including:• Production support of over 20 databases running on Sun Solaris, Compaq Tru64 and IBM AIX• Production support of Oracle Financials 11.0.3 running on Sun Enterprise 6500 and 4500 servers, including load balanced Oracle Forms servers, Oracle Web server and Jinitiator. Modules included Workflow, GL, PO, AP, OE, HR and INV• Development support of Financials 11.0.3 and 11.5.5 on Sun Enterprise 4500 servers• Production support of Oracle Parallel Server 8i – three server billing database• Production support of Oracle Multi-Master Advanced Replication and Snapshots• Training of DBA team members• Tuning of databases, including disk array planning• Oracle Standards documentation, backup strategies and QA of internal and 3rd party code• Oracle Utilities – Import, Export, RMAN, SQL*Loader, SQL*Plus

London, United Kingdom

Provided Production and Development DBA support on Oracle8i, Oracle8 and Oracle7 systems including: • Support of Documentum Oracle databases• Set-up and Support of Oracle Forms Servers for java web-based access• Planned and implemented backup strategies for Window NT and Sun Solaris servers• Provided tuning advice to PL/SQL and Forms Developers• Tuned existing database servers, configured new servers and improved network throughput• Supported 19+ databases over 5 servers• Oracle Utilities – Import, Export, SQL*Plus• Provided support for Oracle Financials and Windows NT users• Reconfigured and set-up Multi-Master Oracle Advanced Replication

London, United Kingdom

Provided Production and Development DBA support on Oracle8i, Oracle8 and Oracle7 including:• Supported 24x7 High Availability Digital/Compaq TRU64 Oracle systems• Provided PL/SQL, SQL and tuning advice to developers• Set-up and supported Oracle Advanced replication and snapshot replication• Supported Java and XML development projects within Oracle8i• Provided advice on Oracle Financials 11i Implementation• Implemented standard environment and monitoring Unix scripts over multiple Unix systems• Provided Production and Development support on 12 Digital/Compaq TRU64 Unix systems, 2 Digital VMS and 2 Windows NT systems containing over 26 Databases• Supported and provided advice to developers on Data Warehouse performance and configuration• Installed and supported OAS (Oracle Application Server) including Oracle Forms Server providing a Web Interface using Jinitiator (Oracle Java Front-End)• Installed and Supported Oracle IFS (Internet File System) on Windows NT and Unix• Installed and supported OWS (Oracle Web Server)• Oracle Utilities – Import, Export, SQL*Loader, SQL*Plus