I was lead DBA on 2 Oracle datawarehouse development projects where I demonstrated to the project managers and development teams the ways in which early DBA involvement can ensure the creation of robust, scalable and manageable databases. I designed and implemented processes for QA and change control of the data models and database DDL.I designed, implemented and documented processes to cover various day-to-day database activities including replication of database schemas for test purposes and the population and management of a central "database of databases". I project-managed and delegated to junior team members as required.I researched and tested many new features of the Oracle database and shared this knowledge with other team members through documentation and training. I extended this knowledge-sharing in 2016 by presenting at two UK Oracle User Group (UKOUG) events.The initial contract was extended a number of times and evolved to encompass a wide range of responsibilities within the DBA team including:- QA of first-cut logical data models- Use of CA Erwin Data Modeller and ModelMart to manage the data models- Generation, management and deployment of DDL in the various environments- Identification and resolution of issues with security, performance, space etc- Installation of Oracle software, configuration and creation of new databases- Developing, refining and implementing database standards and procedures- Resolution of production issues related to the organisation's Oracle, SQL Server and Sybase databases, including 24-hour support on a rota basis.- Review, enhancement and debugging of PL/SQL code used for various internal housekeeping tasks.

Following my move to France, and in response to an observation that there were large numbers of ex-pats living in area with little or no French language skills, I created a company (Alpine Helpline) to provide translation, interpretation and administrative assistance to English-speakers who lack the necessary French language skills to perform certain tasks themselves, from arranging phone and internet installations to completing the formalities to obtain state health-care and pensions.

Working within a team of 7 DBAs, managing around 150 Oracle databases, primarily data warehouses, on IBM AIX Unix servers. Principal Accountabilities:Maintaining the security of the database environmentsIdentification & Resolution of database problemsRoll-out of Oracle software & patches, database upgradesDevelopment, maintenance, QA and rollout of internal housekeeping scriptsConfiguration and builds of new databasesDevelopment, enhancement and deployment of database standards & proceduresProviding support for production systems both during office hours and out-of-hoursCreation of guidelines for DBA involvement with development projects.Key achievements:SQL Server Team Leader in addition to my existing Oracle DBA roles and responsibilities from Nov 2003. Managing the strategic direction of SQL Server database administration within Europe, offering technical guidance to other team members and delegating tasks as appropriate.Creation of "Trends Analysis" Database: Management of a project to create a database to capure essential information and metrics about each of the databases supported by the team. Creation and review of the data model, implementation of the database and procedures needed to capture the required information.Common Data Model: Involved in a project to create a data model to capture the organisation's global data, reviewing logical data models and liaising with Subject Matter Experts within the business to define additional requirements.Security Enhancements: Creation and documentation of a database security policy and process to "audit" the security of a database. Implementation of this process for a number of applications; assessing the inherent security risks, determining ways in which they could be resolved and implementing the changes.

Management of the development and production databases for a multi-national financial organisation account with various responsabilities including writing SQL and K-Shell database administration scripts and SQL performance tuning.