Curriculum Vitae
Personal DETAILSName: Conor Brophy Homepage: www.conorbrophy.com
Telephone: +353 (0)872692431
aCADEMIC RECORD
College: University of Dublin, Trinity College.Degree: BA in Computer Science - First Class Honours. Received a “Gold Medal” award for my final year exam results.
Key Technical Skills – Oracle (UNIX and NT) and SQL Server Databases
· Oracle DBA – Oracle 7.3.4 – 11.2.0.2 (11G certified) 17 years experience, RAC, Streams, Scripting (Korn, Perl, sed, awk), Terabyte size dbs, Data Pump.
· SQL Server DBA – 7, 2000, 2005, 2008R2 (2008 certified) 6 years experience.
· Production (Business Critical) / Developer DBA - Installations, Migrations, Upgrades.
· Oracle Developer – PL/SQL, SQL, Forms 4.5, Reports.
· SQL Server Developer – T-SQL, Analysis Services, DTS, SSIS, VBScript.
· Performance Tuning – Expert Skills - SQL Tuning, Data Model Issues, System Tuning.
· Data Warehousing – Table Partitioning (Oracle and SQL Server), Streams, Indexing Strategies.
· Backup and Recovery – Expert B&R skills, VLDBs, RMAN, 3rd mirror splitting, Data Guard.
· Database Design – ERwin, Oracle Designer, Very Large Databases.
Other DB and SOftware engineering Skills
· Sybase general administration and implementation of change requests.
· Extensive experience with Visual Basic, C, C++ and Grady Booch OO Design.
· Part-time IT auditor of projects. I have a deep interest in the software development process and have helped projects throughout my career with software development issues.
· I have lectured on the Computer Science degree course in Trinity College Dublin.
· Excellent system analysis skills. E.g. Part of billing strategic design team in BT.
Work Experience Summary – main contracts
Jun 11–Present: IBM (Technology Company) – Production and Development DBA.
Jul 09–Dec 10: RBS Global Banking (Investment Bank) – Production and Development DBA.
Dec 06–Jun 08: Abbey (Retail Bank) – Production and Development DBA.
Jun 01–Dec 06: Credit Suisse (Investment bank) – Production and Development DBA.
Aug 99–Dec 00: Gerrard Group (Futures & Derivatives Traders) – Production DBA.
Mar 99–Aug 99: Andersen consulting and Prudential Insurance – DB Performance Consultant.
Apr 97–May 98: Electricity Supply Board. (Irish Electricity Supplier) – Oracle Consultant.
Oct 92–Apr 97: British Telecom - Software Engineering Division – Software Engineer.
Work Experience details
June 2011 – Present / IBM (Technology Company) – Dublin - Contract Position
Title / Production and Development DBA for Bank of Ireland Account
Technical / · Oracle 9i, 10g and 11g on Windows 2008, AIX 6.1 and Solaris 10 (some VMs).
· SQL Server 7, 2000, 2005, 2008.
· DOS shell scripting
Primary
Activities / 1. Was responsible for the complete rebuild of the main business critical production SQL Server 2008 failover cluster (17 instances at different Service Pack levels).
2. Upgraded and migrated legacy SQL Server databases.
3. Database consultant for new “Efficiency” project in the bank which included building multiple Windows Oracle clusters from scratch and supporting the development teams with any database issues.
4. Supported and rebuilt Standby Database for key financial system.
5. Installed and managed Oracle 11G ASM.
6. Cloned production ORACLE_HOMEs and databases for test servers.
7. Migrated legacy Oracle databases to different operating system.
8. Defined new backup scripts and infrastructure for the tape storage solution that was being migrated from Data Protector to Tivoli Storage Manager
Note: Took time off in early 2011 to study and to go travelling.
July 2009 – Dec 2010 / Royal Bank Scotland (Investment Bank) – London - Contract Position
Title / Production and Development DBA
Technical / · Oracle 8i, 9i, 10g and 11g on Red Hat Linux Rel. 4&5 and Solaris 8&10.
· Oracle RAC, Streams, ASM, Datapump, LDAP and RMAN Duplicate (cloning).
· Korn Shell Scripting.
Primary
Activities / 1. Responsible for one of the most important databases in the bank. It was a replicated database with sites in New York, London and Hong Kong and it used Oracle Streams, RAC and ASM in its implementation.
2. Was one of the key “troubleshooters” for database related issues on the Oracle DBA team. The issues ranged from performance issues to large database design issues.
3. Provided consultancy on migrating applications between using Oracle and SQL Server databases.
4. Developed and implemented a new strategy for the creation of testing environments using RMAN cloning functionality. This meant working very closely with application teams to develop bespoke solutions.
5. Was responsible for the rollout of a completely new database infrastructure across the Oracle estate.
Feb 2009 – May 2009 / Trinity College Dublin – Lecturing Position Note: I gave this course at the same time I was working for Aer Lingus.
Title of Course / Software Engineering Group Project (I devised this course)
Course Details / · Real-world Customers – Each team was allocated a real-world company (i.e. Intune Networks, Dublin Fire Brigade, Google, “Right to Sight” charity, and AIB Investment Banking).
· Consultancy – The teams had to go in as consultants and develop an IT solution based on a high level company requirement.
· Guest speakers from Microsoft and Intune Networks.
Some of the other skills developed in the course were:
· Team Working - Class was divided up into random teams of five people.
· Presentation Skills – A presentation skills consultant (my brother - www.barrybrophy.com) lectured the students on presentation skills and provided feedback on the student’s presentations.
Achievements / One of the projects won the prestigious Imagine Cup in Ireland and the team presented their project at the international finals in Cairo, Egypt.
Oct 2008 – July 2009 / Aer Lingus (Airline) – Dublin - Contract Position
Title / Oracle and Sybase Production and Development DBA
Technical / · Oracle 10.2.0.4 on AIX 12.5.3.
· Sybase 12.5.3.
· Korn Shell Scripting.
· Sybase Transact-SQL Programming.
· PL/SQL Development.
Primary
Activities / 1. Development and implementation of DR strategy for the Sybase databases including developing T-SQL procedures.
2. Developed PL/SQL package.
3. Development of Korn shell and SQL scripts to move revenue data to data warehouse to be analyzed by Oracle Essbase 6.5.
4. Upgrading of company wide Oracle export/import scripts to use Data Pump.
5. Database consultant for development teams e.g. SQL tuning, partitioning.
6. General DBA production support.
Dec 2006 – Jun 2008 / Abbey (Retail Bank) – Milton Keynes - Contract Position
Title / Oracle and SQL Server Production and Development DBA
Technical / · Oracle 7.3.4 to 10.2.0.3 on Solaris and Windows 2003.
· SQL Server 7, 2000, 2005 - DTS, SSIS, Replication, Analysis Services.
· Microsoft BizTalk Server 2004 SP2 / 2006 Release 2.
· Sybase 12.5.3.
· Perl and VBScript Scripting.
· PL/SQL and T-SQL Development.
Primary
Activities / 1. Responsible for all database aspects of a major rollout of the Microsoft BizTalk Server within Abbey, which included in-depth performance tuning and developing a standard build with a customized SQL Server backup strategy.
2. Streamlined OLAP business regulatory system which included development of dynamic T-SQL procedures.
3. Database consultant for development teams e.g. SQL tuning.
4. Sybase general administration and first-line support.
July 2001 – Dec 2006 / Credit Suisse (Investment Bank) – London - Contract PositionNote: Took time off in 2005/2006 to go travelling. Taken back on afterwards by Credit Suisse
Title / Oracle and SQL Server Production and Development DBA
Technical / · Oracle 8.x, Oracle 9.x, Oracle 10.2.0.2.
· SQL Server 7, 2000, 2005.
· RAC, RMAN, Partitioning, Streams, Terabyte size databases, Data Guard.
· DTS, Analysis Services, SQL Server Replication.
· Solaris 2.8, RedHat Linux AS2.1/3.0, SUSE.
· Sun Enterprise E4500, E4800, E5500 and E6800 servers, EMC Symmetrix Units, Clariion and Egenera blades/frames, Veritas Cluster.
· ERwin, PowerCenter, FTI StreetBooks/Reference v4.08, PeopleSoft Financials version 8.18, DBArtisan 8.0.0, DB Control, cntl-m, Veritas Netbackup, Clearcase.
Primary
Activities / 1. Production DBA and Developer DBA (also PL/SQL and T-SQL development).
2. One of the first people to install Oracle 9i Rel2 RAC and Oracle 10g RAC in bank.
3. Developed and implemented strategy for bank to migrate to using Oracle 10g from Oracle 8i/9i and Sybase.
4. Implementation of SQL Server releases and provided consultancy to SQL Server application teams.
5. Installed and maintained Peoplesoft 6.1 application server.
6. Korn and Perl shell scripting of DBA related tasks.
7. General Sybase administration. Implemented change requests and Oracle Transparent Gateway to Sybase.
8. Major involvement in project meeting the BASEL II (regulatory) requirements:
q Developed partitioning and AQ strategy. Sole developer of PL/SQL code to implement the partitioning strategy.
q Implemented, and was responsible for, the backup and recovery strategy for the largest database in the bank, using 3rd mirror split from prod, using RMAN on backup server.
q Worked with data modeller to produce accurate sizing for database (8TB).
9. Senior consultant on all Oracle related issues.
Aug 1999 – Dec 2000 / Gerrard Group (Derivatives Traders) – City of London - Contract Position
Title / Oracle DBA / Consultant
Technical / · Oracle 7.3.4, 8.1.6.
· SOLARIS 2.6 and NT servers.
· Data Warehouse System.
· Korn Shell Scripting.
Primary
Activities: / 1. Day-to-day production administration and supporting development teams.
2. Proving consultancy on database development issues. E.g. PL/SQL, database design, locking strategies etc.
3. Performing Oracle 8i migrations.
4. PL/SQL programming / scripting.
5. Developed disaster recovery strategy.
Mar 1999 – Aug 1999 / Andersen Consulting (project for Prudential Insurance) – Central London -Contract Position
Title / Oracle Performance Tuning Consultant
Project / New Contact / Lead Management System for Prudential.
Largest Oracle database system to be released in the UK that year.
Technical / · Oracle 7.3.4, 8.0.4 on HP V-Class 2250 servers.
· Two 1 Tb databases with one servicing 1600 online users, the other used for Data Analysis (Data Warehouse).
· HP-UX Version 11 64-bit. EMC Symmetrix Units.
· Applications: SIEBEL 99 (V5.0.2.19) and Seagate Crystal Reports.
Primary
Activities: / 1. Responsible for investigating and solving any database related problems during testing and transitional support (mainly performance problems).
2. Excellent Performance Tuning / Problem Solving Experience. Expert on both Server Tuning and SQL tuning.
3. PL/SQL programming / Korn shell scripting.
Sept 1998 – Mar 1999 / Scottish Office (Scottish Government Body) - Edinburgh – Contract Position
Title / Production DBA
Project / DBA on Business Critical Financial System (which was responsible for the majority of payments made by the Scottish Office)
Technical: / Oracle 7.1.6/7.2.3 on ICL/DRS 6000 Machine (UNIX) and Oracle 8.0.3 on NT 4.0.
Primary
Activity: / Designed and implemented strategic performance and organisational improvements on the database. E.g. Implemented database reorg and archiving strategy.
Apr 1997 – May 1998 / Electricity Supply Board (Irish Electricity Supplier) – Dublin – Contract Position
Title / Oracle Consultant.
Project / Development of a power station maintenance tracking system.
Technical: / ORACLE V7.3.4, Forms 4.5 / Reports 2.5 on Windows NT4. SQL and PL/SQL development.
Primary
Activities: / 1. Designed the database (entity relationship modelling). Used the Designer 2000 CASE tool (including tables, views, triggers, roles etc).
2. Developed the application front-end using Forms 4.5 and PL/SQL.
Oct 1992 –
Apr 1997 / British Telecom (Telecommunications Company) – Glasgow - Permanent Position
Title / Software Engineer
Project / A range of software development and design projects.
Technical: / ORACLE, C++, OO Analysis and Design, Visual Basic, Thread Programming (DCE).
Oracle Developer-DBA / Software Engineer / Systems Analyst /
Software Development Auditor and Team Leader.
Primary
Activities: / Service Management - I was involved extensively in BT service management projects, especially with the (world class) billing architecture that BT was migrating towards. I was a systems analyst on the billing strategic design team. I also designed in Grady Booch and developed in C++ a tool to compare standing billing pricing data.
Debt Management – I designed and developed in Visual Basic an application to automate the debt management process for personal customers in BT.
Auditor of Projects – I developed quality procedures for small scale projects because I believed the existing general procedures were inadequate for the task. These procedures were adopted by all the software engineering centres in BT. Because of my work in this area I asked to become a part time member of the quality team and I used to regularly audit and support projects within the Glasgow Engineering Centre.
TRAINING
I embrace the challenge of keeping my IT skills up-to-date. I have put myself on the following instructor-led Oracle courses:
· Oracle 8 – New Features for Administrators
· Oracle 10g – New Features for Administrators
· Oracle 11g – New Features for Administrators
and the following instructor-led SQL Server courses:
· Implementing and Maintaining a Microsoft SQL Server 2005 Database
· Designing High Availability Database Solutions Using Microsoft SQL Server 2005
· SQL Server 2008 New Features
When I was with BT I went on a Grady Booch OO design and a C++ course.
I own a library of IT books (not just on databases) and I am constantly buying and studying new references.
Real-world software development
I have a practical, real-world approach to applying my computer skills and I have had an excellent relationship with all the customers I have worked with.
Interests
I enjoy hill walking around Ireland. I am member of the internet based “Dublin Hillwalking Group”. I swim regularly and I cycle all around Dublin. I have an “Advanced Open Water” scuba-diving licence and I have dived at some of the best dive sites in the world (warm waters only!). I also enjoy improving my knowledge and understanding of current world affairs.
I have been lucky enough to travel extensively and I have written a book about my travels (www.conorbrophy.com/book).
Languages
Good conversational Spanish.
Diploma from the Cervantes Institute: “Spanish as a Foreign Language” intermediate level.
CONOR bROPHY • Oracle & SQL Server consultant
www.conorbrophy.com • TEl: +353 (0)872692431