Paddy Loughnane

Experience

• 

  AIB

  Jan 1989 - Jan 1996

  DBA - DB2 and IMS
• 

  Orygen

  Jan 1996 - Jan 2003

  Senior Consultant / DBA (Oracle)

  As a Senior Consultant with Orygen , I had responsibility for the design , development and implementation of Oracle based solutions and provision of Oracle DBA services to range of customers including Bank of Ireland, AIB, STS(Norway), Pershing and ETS (both USA)

• 

  AIB

  Jan 2003 - Jan 2007

  Senior Data Warehouse Developer

  As a Senior Developer on AIB's Enterprise Data Warehouse (Teradata), my responsibilities included- Logical Data Modelling using ERWin- Physical Database Design- ETL Design and Development

• 

  AIB

  Jan 2008 - Apr 2015

  Senior DBA - Teradata, Oracle, DB2 and IMS

  As Teradata DBA, my responsibilities included :- Logical Data Modelling and Physical Database Design and Tuning- Database Space Management- SQL Performance Monitoring and Tuning- Database Backup and Recovery Design and Implementation using TARA and BAR DSA- Workload Management using TASM- User and Access Rights Management- Teradata DBMS Upgrade Planning and Deployment- Issue Management with Teradata- User TrainingAs DB2 DBA, I had responsibility for :- Plan and implement DBRM to Package migration- Manage DBA aspects of DB2 system upgrades- Physical database design and performance tuning- SQL Performance Review and Tuning- Database Backup and Recovery design and implementation- Manage schema changes across multiple environments As IMS DBA, my responsibilities included :- Manage DBA aspects of IMS system upgrades- Review and improve database backup and recovery procedures- Design and implement improved database availability- Manage change to IMS Database Control BlocksProvide 24*7 on call across all database technolgies supporting AIBs critical retail banking channels Show less

• 

  Wipro

  May 2015 - Dec 2015

  Senior DBA - Teradata, Oracle, DB2 and IMS

  In support of AIB critical Retail and Data Warehouse system , responsibilities across multiple database technologies include:• Plan and deploy DBMS upgrades• Physical database design and tuning• SQL performance monitoring and tuning• Design and implement database backup and recovery procedures• Manage database storage and capacity• Deploy database and application schema changes• Manage user and database security• Manage DBMS workload and resource allocation• Manage DBMS issues with vendors• Provide 24*7 on call support for AIB’s critical production systems including Branch, Phone, ATM and Internet Banking channels• Adhere to AIB’s strict change, incident and security management standards and procedures Show less

• 

  Triangle Technology Services

  Jan 2016 - now

  Architect, Information Management & Data Analytics, IBM Software Division