•Team of 4 DBAs in London •24*7 production support including weekends •Production and development support ,mainly SQL server and Sybase, with some Oracle •MS SQL 2000-2008, MS Replication , MS Reporting services [2005-2008], MSAS [2005-2008] •Sybase [12.x-15.x], Sybase Replication [12.x-15.x] •Defined and documented SQL 2008 Standards , including build checklists [SQL/SSAS/SSRS] •Defined and documented use of SQL 2008 Shared Data Services environment •Tested and documented a procedure to recover SQL 2008 services fully from Tape backups •Updated scripts for admin and maintenance of SQL 2008 •Enhanced monitoring of SQL 2008 by employing Policies •Several P+T exercises carried out [SQL server and Sybase]

•Team of 4 DBAs in London •Production and development support ,mainly SQL server , with some Oracle •MS SQL 2000-2008, MS Replication , MS Reporting services [2005-2008], MSAS [2005-2008] •Set up shrunken Test environments to use partial data from production (Replication and Litespeed restores) •Developer support to upgrade from SQL2005 to SQL2008 (inc SSAS and SSRS) •SQL Server builds (mainly 2008) •Defined and documented standards, inc. Storage layout (SAN and Local disks) •Defined and documented security standards •Defined a build checklist and pre production build checks •Review of monitoring tools and development of new tools •Review of e-gaming data warehouse (1.5TB) system in terms of overnight load [ETL] process/long running queries , Statistics , Index rebuilds and Server configuration . •P+T and advice on best practices for T-SQL. •Resolving BAU issues (SQL bugs, corruptions and system errors) •Built DBA maintenance tasks

•Team of 10 SQL DBA’s in London and 20 Off shore supporting 350+ servers and 150TB •24*7 production support including weekends •MS SQL 2000-2005, MS Replication , MS Reporting services •Developed Web based DBA/Infrastructure management tools (for MS/Sybase/Oracle/Windows/Unix) •Upgraded a major reporting system from 32 bit / SQL 2000/Reporting Services 2000 to 64 bit/SQL 2005/Reporting services 2005 •Co-Ordinator and execution of server moves between Data Centers •Architectural advice and implementation of Project management system utilizing SQL Server/Reporting and Analysis Services 2005 •P+T •Production troubleshooting •Developed and rolled out a Development database automated refresh process using Litespeed

"Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. The company provides unmatched convenience in the United States, serving more than 59 million consumer and small business relationships with more than 6,100 retail banking offices, more than 18,000 ATMs and award-winning online banking with more than 25 million active users. "

•Leading Team of 5 DBA’s (Sybase, SQL and Oracle) in London •Sybase (11.9.2 – 12.5.4), MS SQL (2000 – 2005), Oracle (9 and 10) •Main DBA contact for CAB, TAg and project kick offs •Scheduling of work requests, power down and DR weekends •24*7 production support including weekends •BAU (builds, upgrades ,general requests and troubleshooting) •Reviewing and updating DBA standards and security Docs •Introduction of weekend work plans •Refinement of release procedures for DBA’s •Liaising with DBMS vendors for license issues , renewals and User group membership •Updating and maintaining cost models for yearly budgets •Publishing standards and findings to the DBA Focus group (Global) •Introduction of Litespeed (including proposal, testing, costing and presentation to TAg) •Involvement with RMAN and RAC from a tracking and high level aspect •Outage, follow up and root cuase analysis •Scheduling Server upgrades (Sybase 12.5.4, SQL 2000 SP4, Oracle 10.2.0.3) •Data Centre move co-ordination , tracking and scheduling •DBA monthly management reports

•Managed Team of 14 DBA’s •Change Control board DBA liaison •Scheduling of work requests •Main point of contact for all BAU DBA issues (assisting and follow up with Root cause analysis and recommendations •Responding to critical needs of Business areas •Introduction of Daily/weekly checks, and monthly availability reporting of DB server uptime •Introduction of weekly status reporting and task tracking •Improvements in DBA infrastructure (backups, DB settings, Build standards and KPI data collection and reporting

•Team of 14 Sybase and SQL DBA’s •24*7 production support including weekends •Sybase Dataservers (11.9-12.5.3) , Sybase Repservers (12.5) •P+T •Production troubleshooting •Audit point remediation

•Team of 5 Sybase and SQL DBA’s •24*7 production support including weekends •Support of main Sybase application called Global Condor, consisting of Replication server 12.1 and ASE 12.5. Consolidated environment with over 50 Databases / Apps and many MS SQL 6.5-2000 based systems •Major P+T exercises done on Replication , to solve long standing issues •Dealt with and fixed many BAU issues •Advised on, and Implemented, Sybase DTM (XA/SYB2PC replacement) •Support of MS SQL Servers from 6.5 to 2000 •Supported developers in porting of Osiris MS SQL App to Sybase •Developed standards and build procedures for MS SQL servers •Developed and implemented custom log shipping for MS SQL servers •Developed and implemented a complete management and monitoring of MS SQL servers solution •Advised on and configured/rolled out tools such as Quest’s Spotlight/Foglight for Sybase and MS SQL •Solutions for Audit points against Sybase and SQL •Data collection , reporting and remediation of privileged accounts for Compliance and Audit purposes covering : MS SQL, Sybase, Oracle, UDB, Wintel and Unix

"J.P. Morgan is a leader in financial services, offering innovative and intelligent solutions to clients in more than 100 countries with one of the most comprehensive global product platforms available. We have been helping our clients to do business and manage their wealth for more than 200 years and we keep their interests foremost in our minds at all times. This combination of product strength, intellectual capital and character sets us apart as an industry leader."

•Manage a mixed team of 9 Sybase and SQL DBA’s •Support Sybase 100+ servers (Fidessa,Murex,Infinity,Devon…),MS SQL 300+ servers •Sybase versions up to ASE 12.5 , replication 11.5.1 , and MS SQL Versions up to 2000 •Part of on-call out of hours support rota •Spot any weaknesses in overnight failures or setups , advise and work with Development teams to resolve •Escalate problems to Sybase/ Microsoft as necessary and follow up •Manage Audit requirements (ABN Global , Sarbanes Oxley are some examples) •Recommend tools / procedures that can be developed to comply with Audit •Develop / enhance DBA utilities (ksh scripts on Unix/NT , Sybase compressed Dumps, SQL backups using Litespeed …) •Developed a web based DBA server inventory management tool •Developed many DBA procedures •Developed standards for MS Reporting services install and support

•Part of a 35 strong Global Support DBA team (Sybase,Oracle and MS SQL Server) •Supporting 450 Sybase servers (ASE 11.0.3.3 – 11.9.2.3 , Rep server 11.0.3.3 – 11.5.1) •Supporting 500+ MS SQL servers (6.5, 7 and 2000) On-call (24*7 both Sybase & MS SQL) •Developed Database Capacity and Forecasting Web Reports for SQL server down to Filegroup level, and Oracle down to Table Space Level. •Developed Web reports for KPI’s using metrics collected by HP DBPSI for Oracle, Sybase and MS SQL server. This included writing the code for Oracle in PL/SQL. •Ran the HP DBSPI project for the DBA group in terms of Testing, documentation, Build and configure and Custom reports. •Developed a Standard Audit Build for SQL server 2000 (using server side traces) and all related documentation. •Migrated a SQL 7 application to Sybase 12 •Worked on the SQL slammer weekend to get patches applied to SQL 2K •Specified Infrastructure needed for DBA’s to support many MS SQL servers •Implemented an MS SQL DBA maintenance and config database (Inc porting of data from Excel o MS SQL) •Fixing and enhancing DBA utils to reduce callout’s and provide more functionality •Designed and implemented solutions to close of many Audit points (password expiry, ‘sa’ password change, reporting to show over privileged accounts, auditing of security related functions, failed logins , auditing of DBA activity, KPI’s) •Designed and implemented many early warning type of reports (out of dump/load space, databases not dumped , Warm Standby latency and table/index fragmentation in order to schedule index rebuilds , jobs failed/disabled, threshold not defined/breached, User defined XP’s etc ) •Porting of applications from Sybase to MS SQL Server 2000 on Win 2000 •Primary DBA for several projects including Devon FX •Implemented Password expiry for Sybase 11 •Advised on strategies to make housekeeping more efficient •Identified missing processes and put them in place •Corrected failing housekeeping jobs •Advised on possibilities to comply with security requirements based on audit findings •Release management and Developer support •Several Performance tuning exercises undertaken with good results •Investigation and implementation of DBA tools (Historical server, Monitor server and Monitor clients) •Investigation and implementation of Sybase/Oracle plugins to ITO6 (Enterprise Management system)

•Managing 7 DBA’s (4 Oracle, 2 Sybase/MS SQL server, 1 Ingres) •Put together Standards for Oracle and MS SQL server •Part of a Central DBA team covering different business areas (GATS, FINCON, FX ..) managing 44 Sybase servers with a large number of users worldwide and some VLDB’s, 16 MS SQL Servers, 50 Oracle Instances and 6 Ingres servers. •Primary DBA for FX environment for Sybase Data and Replications servers for Global Financial Centers •On call (24*7)

•Migration of Magestic from JPM. This was a specialised Instruments vault management and tracking system for the GATS business of Citibank. The system was written in Powerbuilder using Sybase as the Database server, and ESQL/C for the SWIFT messaging. •Assisting in ISS (VMS and Ingres) migration from JPM •Setting up the UNIX and SYBASE environments. This covered Development, System Testing, UAT, Production, Contingency and Y2K •General DBA and performance issues for Sybase (Magestic), and on Ingres (ISS) •Full Y2K setup and user support, such as captive accounts for refresh purposes . Part of the Y2K testing team as the Sybase DBA. •Out of hours support •UNIX and NT system administration , setting up accounts and environments and system management such as system backup and regular re-boots.