As a technical project manager within the Stantec Constructors Group IT department I am focused on IT project delivery to the business, mainly focused around the IFS (ERP) application system.The most recent projects I have worked on:Audit (Sarbanes Oxley)Due to a company acquisition in 2017, MWH had to achieve SOX compliance. This involved reviewing our existing ITGC policies and procedures with three specific areas 1) Access Control 2) IT Operations 3) Change Management. Over a period of about ten months I worked closely with the technical leads in each area and our Internal Audit and External Audit teams during walkthroughs, interim testing and year-end testing. We successfully reviewed, improved and created policies and procedures within each of the in-scope audited controls. As the nominated POC for our auditors I was responsible for providing evidence when requested and answering further questions to ensure we achieved compliance.As well as a Project Manager I fulfil a Change Manager role for the companies ERP system. I am responsible for delivering changes in ITIL service managed frameworks and conforming to Sarbanes Oxley (SOX) auditing standards. Changes with varying complexity and severity follow an approval process with the wider IT team. I liaise with the CAB to gain approval for scheduled changes, perform a monthly review of all changes, improving the change management process to ensure the continuation of SOX compliance.

As a Database Engineer for the EAME region at MWH, I was responsible for supporting and maintaining the database infrastructure. I play a critical part in delivering strategic technical evolvement as well as leading and executing critical IT projects and initiatives. A sample of my recent projects include: 1. SQL Server migration to Azure. 2. Project Technical Lead to remove all global SQL Server 2005 servers prior to the out of support deadline in April 2016. 3. Design and implementation of robust HA\DR Oracle database solution for critical ERP application.

The Health and Social Care division of Civica specialises in producing software for health service and local authorities across the UK and Canada. The main application is Paris, which is an integrated case management system for managing all aspects of community based health and social care. The Group supplies more than 250 NHS organisations in the UK. Within this division I am an Oracle & SQL Server DBA providing technical expertise and advice both for customers and internally to the business. This is primarily as an Oracle & SQL Server DBA but am also responsible for the delivery of technical services. Duties include:Implementation, support and monitoring of hosted customer's high-availability systems.Troubleshooting, tuning, and data fixing application database issues in an Oracle environment.Proactively work with account\project managers based on customer requirements.Periodically build new releases of the Paris application through Team Foundation Server.Supporting managed services customers ensuring of their on-going maintenance and upkeep.Supporting the internal database systems for the software development and testing teams.Installations and upgrades of Oracle or SQL Server database instances on customer sites and internally.Liaise with the software development team on database design, as part of the Paris design and analysis processGeneral troubleshooting of 3-tier distributed installations (Windows, DCOM, Oracle).Oracle 11g and 12c DatabaseOracle 12c Cloud ControlMicrosoft SQL Server 2008R2Windows Server 2008 / 2012Linux

Maintain and develop the database infrastructure for MWH's enterprise application systems. Support internal customers, developers and iNet team. Lead expertise in Oracle database and Oracle technologies.Monitor health checks, analyse, and tune database performance. Identify problems, run diagnostics, resolve issues to enhance/optimize processing, and project capacity needsMonitor database jobs, correting job failures and data issues - SQLPlus, T-SQL, Play key role in iNet projects, supporting application upgrades.Lead in database security, Patch and upgrade databases.Develop and maintain the backup/recovery maintenance plans.Oracle 10g DatabaseOracle 10g Application Server (Infrastructure and Middle Tier)SQL Server 2000, 2005Windows O/S 2000, 2005Cluster Services (MSCS, Oracle FailSafe)RMAN Backups*sqlplus

Responsible for the technical implementation and support of MWH standard applications and other associated applications and systems. Provision of 2nd / 3rd Tier technical support MWH Enterprise applications. Management and maintenance of applications including event monitoring and resolution, incident management, change management, release management, performance monitoring and tuning, user administration, security administration and documentation. Liaison with vendors, internal developers, and internal project teams and assisting in the development, testing and implementation of application enhancements. Participation in a global application support model / process / team. Database - Oracle 10g / SQL Server 2000 / 2005Windows O/S 2000, 2005 Cluster Environments (MSCS, Oracle Failsafe)Citrix Presentation Server 4.5VMWareNetwork and Communication Technologies (LAN,WAN, TCP/IP)Internet Application Technologies (IIS,Websphere)Primavera P6

Provide application and technical support for a software company primarily producing a web-based Oracle 9i Forms financial application running on a Sun Solaris OS. Supported external department managers and end users within 15 financial organisations based around the UK and abroad. Provided help to queries, supplied data corrections and solutions caused by software faults whilst working on projects in a variety of business and development roles. Carried out anti-money laundering system project. Updated an existing application to ASP.net and SQL Server through liaison with 3rd party developers. Developed new improved methods of analysis and business functionality. Full system testing and creation of user documentation. Develop deployment strategies and present pre-sale customer demonstrations. Oracle PL/SQL and *SQL Plus Microsoft SQL Server 2000 / 2005Application SupportWindows Server 2003 Windows XP Professional