Development DBA

**********@*****.*** +353-**-***-****

BRIAN HOURIGAN

SKILL SUMMARY

DATABASE TECHNOLOGIES

Oracle 10g, 11g, 12c. Oracle Exadata, Oracle Cloud, Erwin, Oracle Enterprise Manager.

DATABASE KNOWLEDGE

Datamodelling, Data Normalization, Multi-Tenancy DB Architecture, SQL Performance Tuning, Table/Index compression, Adaptive SQL Plan Management and Optimizer Statistics Management, Partitioning, Real Application Cluster and RMAN Backup.

LANGUAGES/SCRIPTING

SQL, Shell scripting, Bash scripting, Python, Java, PHP, XML/XSL

ENTERPRISE OPERATING SYSTEMS

Red Hat Enterprise Linux 5.4, 5.9., 6.5, Windows Server 2003, 2007, Solaris 5.10 & 5.11

FINANCIAL BUSINESS SKILLS

SWIFT Messaging (ISO 15022 & ISO 20022 series), Securities Trading, Corporate Action Processing & Announcement Capture, Cash forecasting and settlement.

EXPERIENCE

Development DBA

Markit (formerly Information Mosaic), Dublin, Ireland

February 2014 – present

●Executed successful project to purge redundant end of life Corporate Action data from product schemas using list & composite partitioning and created solution for space reclamation after data truncation/purge. Successfully deployed and implemented this on site with several tier 1 capital client UAT and Production environments.

●Successful implementation as part of Dev Ops team for Product POC against Oracle Exadata for proof of high throughput allocation processing and security/settlement trade processing volumes.

●Currently involved in project to transition current internal Feature Branch/Release Branch Database architecture to Multitenancy DB Architecture for fast provisioning, quick re-deployment and consolidation of DBs

●POC for Oracle FarSync Protection Mode capabilities - testing main DR topologies - maximum availability, maximum protection, maximum performance topologies for primary, far-sync and standby databases.

●Currently acting in a technical consultancy capacity for upgrade of a tier 1 capital client's technical stack and upgrade of product across their global infrastructure.

●Part of Product POC for Oracle Cloud with relation to development of a new SaaS solution for Tier 3 and Tier 4 financial institutions.

●Developing a solution extending on existing Java classes in product for log and trace file collection within application front-end (DB related log files and breakdown of certain volume processing/errors reported in schema).

●Develop DDL & DML for forward development DB releases on continuous Integration J2EE environments (Trunk mainline with several feature/release branches)

●Analysis of AWRs, Trace and Alert logs for Performance issues /environment issues such as contention, time model stats, OS stats performance and SQL plan management/optimization.

●Performance and SQL Tuning for NFR and development teams to ensure optimized transactional behaviour

●Support Client Production DBAs deployment and administration of product software in Production Environments for various Tier 1 capital investment financial institutions, global custodians and stock exchanges across the globe.

●Creation of DB Escrow - Build Assured Verification releases for clients.

●Part of Design Authority for software development products, involved in designing the schema layout and data normalization of software products.

●Acting as primary DBA for Production Support SQL to remedy product production defects in; includes developing PL/SQL scripts and analysing production defects with respect to Oracle/WebLogic/WebSphere.

●Provide Database administration for internal Development, UAT, Unit-test (build automation), BPM and Test Databases.

Technical Support Analyst (Managed Services)

Information Mosaic, Dublin, Ireland

April 2012 – February 2014

●Completed project to build a client’s managed services UAT Environment - Oracle DB server, IBM MQ & WebSphere middleware stack, application servers and external interfaces to external data centre hosted by Client.

●Successfully completed project to migrate a client’s Production Environment; IBM Middleware, Oracle DB server, application servers and external interfaces to new network. Also developed migration technical implementation plan, integration documentation, support documentation and test plan for project.

●Developed and implemented XML based application batch jobs to remedy defects on enterprise bridge application for client’s SWIFT 2013 release.

Integration Support

WorldNet TPS, Dun Laoghaire, Ireland

January 2011 – March 2012

●Successfully migrated and re-integrated large number of merchants from a partner e-commerce gateway.

●Updated plug-ins for supported shopping carts/e-commerce packages for payment gateway integration.

●Primary role to assist various Merchant Services and developers integrate e-commerce sites into payment gateway API.

IT Support Administrator

BBC Worldwide Americas, New York, USA

September 2009 – July 2010

●Projects include BBC Latin Americas Miami Office Server Deployment/Data Migration.

●Part of team to manage and troubleshoot Microsoft Exchange servers, SSCM and Active Directory for BBC Worldwide Americas.

Service Support Engineer

IT Division - University of Limerick, Limerick, Ireland

September 2008 – June 2009

January 2007 – October 2007

●Served on team of six to performed remote and local hardware diagnostics on university LAN.

●Acted as support specialist in assisting Help Desk troubleshooting issues and as support engineer for Windows based systems.

EMR Engineer

Dell Computers EMEA HQ, Limerick, Ireland

April 2005 – October 2006

●Part of EMR tech team repairing server and desktop failures on EMEA production line.

●Primary Engineer assigned to repair and troubleshoot USA bound production units.

●Monitored the extended software testing of Dell servers and desktop units on production line.

EDUCATION

University of Limerick, BSc in Information Technology & Telecommunications

September 2004 – August 2008

GPA 3.3/4.0

●Studies focused in software application development, IT project management, database design and implementation, specialized electives in Artificial Intelligence and Neural Networking. Final year project on study and development of a GIS (geographical information system) application.

Christian Brother’s School, Sexton Street, Limerick City

September 1999 – June 2004

ADDITIONAL TRAINING/CERTIFICATION

Oracle Database 11g Administrator Certified Associate

●1Z0-051 Oracle DB 11g: SQL Fundamentals 1

●1Z0-052 Oracle DB 11g: Administration 1

Currently completing Investment Operations Certificate from Chartered Institute for Securities and Investments

I also have formal 12c/11g development & Architecture training with Oracle Development EMEA centre in Ireland.

Contact this candidate