Peter Deshan Email & Phone Number

Building/marketing a commercial dynamic security program that runs on top of Windows and Linux Servers that monitors all the event logs and protects servers from illegal and/or brute force attacks by dynamically managing firewalls and blocking any IPs that attempt to login or get to resources using algorithms that measure activity over settable periods and other controls. It can stop a DOS attack quickly and automatically. The interface can share blacklists across the server farm and has interfaces to add any eventIDs and automate across the enterprise. It also has automation to report these IPs to international Blacklist databases.

Paulshof, Gauteng, Za

Cloud Architecture 15+yrsManagement Experience 20+ yrsDatabase Architect 20+yrsData Warehousing 20+yrsPerformance Guru 25+yrsSr. Oracle DBA v7.1-12 Grid Control, AMM, ASMM, ADDM, RAC 24yrsSr. SQL Server DBA v6.5-2019 25 yrs, SSIS, DTS, SSRS, SSAS MySQL 5 yrs, DB2 5 years, Sybase, InformixOracle Data Guard, Sun Cluster, ASM, RAC, Standby, RMANOracle Certified professional Database, Network, Unix AdminVeritas Storage Foundation 4.3 HA, Veritas Clustering 15 yearsMS Clustering 15+ yearsVMWare 4.x 6.x 10 yearsSUN RAC clusteringQuest Spotlight, Foglight, Iwatch, Central 20+yrsShareplex & Golden Gate Real time replication DbArtisan, Idera, Toad Suite, BMC Patrol, profilerApplication Performance Engineering 15yrsSystems/Storage Architect 20+yrsSr. Windows Admin (25+ Yrs)Sr. Unix Admin 15 yrs, Linux 8 yrsVMWare 10 years, Windows HyperV 5 yrsVeritas Clustering 10yrs, Windows Clustering(15 yrs)Database Replication, mirroring, log shipping 15 yrsEMC SRDF, Timefinder, BCVsNovell, Lantastic Admin 8yrsSoftware Development Visual Basic, Visual Studio (20 yrs)PLSQL and Transact SQL ETL & DB conversions (SQL & Oracle) 12 yrs SQL<>Oracle, DB2<> Oracle, DB2<>SQLWebsphere, JBOSS, IIS, Apache 7 yearsLoadRunner other simulatorsITIL v3 7 yearsErwin Data Modeler 2-9, TOAD Data Modeler, ERStudio, Oracle Designer, reverse/forward database engineering, Veritas Netbackup 4.5 , Backup Exec, Litespeed, SQLSafeEMC Clarion, Symmetrix 3000 and 3500, DMX and VmaxHitachi USP, 9980, Netapps F940/740Windows NT,2000, 2003,2008, 7, 8, 2012UNIX (AIX, Solaris, HPUX)Novell v1-4 Visual Basic 1-6, 10 yrs, .Net 6 yrs , VB .Net, C++, Fortran, AssemblyTransact SQL, Oracle PL/SQL, Shell scripts, vbscript PeopleSoft, Vantive, Peregrine, Remedy, Blue OceanMS Office Suite,Project,Visio,Publisher, Photoshop, CS3-CS6 SuiteTechnical documentation creation, editing, analysis and presentationData Center Facilities, UPS, AC

Limelette, Walloon Region, Be

Built/deployed Quality Management/Quality control software, Database and Systems infrastructure buildouts and deployments, vendor interfaces, reporting BI and instrument/Process Control automation modules. Visual Studio .NET 2012-2019 and SQL Server 2012-2019, Wonderware, Rockwell. Building commercial modules for quality management software. QMSQC integrates Laboratory Information Management Systems (LIMS), Built-in Instrumental interfaces for direct and data pump interfaces/APIs, Process Interfaces to PLC process systems AVEVA/Wonderware Rockwell and others, Electronic Laboratory Notebook (ELN), Laboratory Execution System (LES), Scientific Data Management System (SDMS) capabilities, Silo QC and blending systems.

QMSQC integrates: Laboratory Information Management System (LIMS) Deep charting and COA transmission technologies Built-in Instrumental interfaces for direct and data pump interfaces/APIs Process Interfaces to IOT, AVEVA/Wonderware Rockwell and other process factory systems Electronic Laboratory Notebook (ELN) Laboratory Execution System (LES) Scientific Data Management System (SDMS) capabilities, many more, see QMSQC.com

Kingsport, Tennessee, Us

(Contract, Jan 2014 to 2020)-Performed all DBA operational activities for 30+ Oracle 11g-9i instances, and 60+ SQL Server 2012-2005 instances in Windows and Linux VMWARE virtualized environments, and AIX.-Review current practices, recommend system, database and architectural changes to optimize infrastructure, determine health status of current systems, recommend resolutions and Roadmaps-Build a central monitoring and management infrastructure that was not currently in place for both Oracle and SQL Server database environments.

DBA Architect 8 week project to convert a mission critical SQL Server 2000 database to SQL 2012 and associated Access databases with a proposed migration plan with no disruption to the business. Worked with GNC corporate office to document and stage the conversion including designing and automating the database conversion and upgrade with jobs, stored procs, DSNs, linked servers, security changes, and a new Control M job system.

Review short and long term architectural and operational options on large core databases to insure Data Manageability within rapidly growing production Databases. Design purging/archiving, logical/physical redesign, review partitioned views with horizontal scale out vs. table partitioning, schema changes, amendments to stored procedures, functions. Design nibbler code routines and provide third party design reviews.

Enterprise Solutions Architect sub on federal IDIQ Task orders to migrate and consolidate 17 data centers into the Cloud for the Veterans Administration. Develop methods for decomposing applications into component workloads that have different Risk and Compliance profiles for seamless, smooth and efficient cloud migration of actual servers, apps, databases and systems to be completed in move groups or stages.

•Work with System Operations, DBA’s and Development staff in analysis of chronic performance issues in mission critical apps to recommend a comprehensive plan to proactively address scalability in the current Oracle databases and user applications.•Lay out an initial remediation plan followed by a 2-5 year Architectural Roadmap with design.•Review storage and data replication design, Redhat Linux on VMWARE deployment configurations, memory configurations, schema docs, Oracle Global Parameters, table partitioning options, and Physical Infrastructures.•Review Application Architecture including batch and web applications.•Deliver written analysis and recommendations with a Roadmap for long-term, future directions for tuning database structures that support batch processes, web processes and remain to work with DBA's and Dev staff to deploy actual changes.

Blue Bell, Pennsylvania, Us

● Conceptualized, architected, and designed integrated enterprise solutions for large federal engagements. Subject matter expert in data center infrastructure, transformations and cloud solutions supporting bid and proposals on large contracts.● Worked on several data center consolidation, virtualization, Cloud, Virtual and Private Cloud technology engagements developing proposals with intelligence gathering, competitive assessments and market trend research. Designed and integrated complex, leading-edge, and business critical solutions for large contracts to architect and price entire technology solutions for federal government customers.● SME in high availability architecture, cloud migrations, data center SLM, SLRs, SLAs, servers, storage, databases, data warehouses, performance and capacity planning●Developed past performance and technology and application based papers

Skaneateles Falls, New York, Us

● R&D project to create a new product line with wireless vital sign hospital devices with continuous and episodic central monitoring and integration into hospital patient data systems. ●Worked with Dev and Architect teams to review architecture/design of product releases, UML from logical/physical model designs, coding/stored proc bottlenecks, data replication, performance, scalability. Worked with performance testing teams in mockups and stress tests using simulation software to provide tuning, configuration, design recommendations, analytical performance benchmarks to report key metrics for successful product launch. Defined many NFR’s: Accessibility, Audit/Control, Availability (SLA), Backup, Capacity, Deployment, Disaster recovery, Resource Consumption, Efficiency, Extensibility, Failure Mgt, Fault tolerance, Licensing, Interoperability, Maintainability, Network topology, Operability, Performance / response time, Platform compatibility, Price, Portability, Quality, recoverability (MTTR), Reliability (MTBF), Resilience, Resource constraints (HW on design), Response time, Robustness, Safety, Scalability, Security, Compatibility, Stability, Supportability, Testability, Usability. Used Quest tools, Rational Rose, Erwin, TOAD data modeler, SQLEM, statistical and analytical methods.● Hardware sizing projections based on empirical metrics, SQL Server 2008 R2 HA, DR, Database & Engineering Architectural designs with views to minimize licensing costs.● Design of merge replication with disconnected scenarios, architectural design reviews with Microsoft Sync framework, Windows Synchronization Mgr, RemoteApp, RMO, RDS, and VDI.● Resolving best architectural business decisions with the contextual variation of continuous and episodic devices designed to work in stand-alone deployments, and scalable with multi-central stations with high availability, while exploiting commonalities between products.

Marietta, Georgia, Us

Short contract to lead a 60 Server SQL Server 2000/2005 to SQL 2008 critical production consolidation project on to a virtual VMWARE ESX environment. Coded an Asset Inventory Collection program for all Instance, memory, and physical information in Transact SQL in one week, moderated server consolidation/upgrade and scope meetings, generated architectural and conversion documents. Addressed License limitations and cost/benefit analysis with existing hardware configurations, documented SQL Server standards and best practices, setup instructions, support turnover procedures, and architected design criteria to work with high resource contention in a virtual VMWare environment

Contract to assist in server and data center architecture to develop standard server provisioning procedures, to alleviate chronic performance issues on SQL Server 2005-2008R2 database systems at hosted data center and at client customer's sites. Worked with systems and development teams to quickly resolve numerous production storage, systems design, performance database issues, maintenance, and to develop a documented provisioned infrastructure. Mentored a Junior group of Engineers and DBA's.

Atlanta, Ga, Us

●Lead DBA/Systems Architect, Analyst/Performance Specialist in Data Center. SQL Servers (2000-2008), Oracle Database servers (Oracle 10g R2 some 11g ). Multiple projects including systems architecture, operations and diagnostics for BioSense (40+ terabyte Data Warehouse). (Dell, HP, Sun, EMC hardware)●Initially, sole DBA and 100% hands-on for over a year until budget allowed hire and mentoring of elite, large DBA and Engineering team.●Led physical architecture, capacity planning, solutions design, multiple migrations, deployments of databases, data warehouses. Managed daily production activities and performance tuning on production, staging, & development servers. Moderated major issues/events and was the “go-to guy” on complex issues with multiple permutations across operational & development contractual lines. Used proven time-based monitoring techniques (base-line daily monitoring, scripts, OEM, SCOM, NetIQ, & Quest Spotlight) ●Provided admin/support services for DEV, Informatica, SAS, BI and other data cubes. ●Designed/built highly available database and application solutions using Veritas clustering, EMC Symmetrix SRDF, Clarion, Sun E25K, 2900’s,Opteron,Dell. Designed backup, recovery (RMAN, SQLSafe), high availability (Veritas on EMC, some VM later), and disaster recovery (SRDF, log shipping. ●Coordinated NetIQ Monitoring/Analysis Center reporting for over 600 servers. Later morphed into SCOM, home grown monitoring, and diagnostics using Quest tools. •Authored short and long term capacity trending analyses, allocated, de-allocated & redistributed storage designs.●Created benchmark performance studies comparing database/platform technologies and advised on future technologies. ●3rd level support, Data Marts, DW issues/architecture. ●Safeguarded the alignment of delivered infrastructure with the predefined requirements for functionality and quality, often requiring a very bold approach in very political worlds.

Chicago, Illinois, Us

Senior and Lead DBA on SQL Server and Oracle databases, DBA and Data/Storage Architect on all SQL Server 2000-2008 environments (some MS Cluster & Data Mirrors) and Oracle 8i, 9i and 10g Data Warehouse and Production Environments (Sun/Unix, IBM AIX and Win2000,Win2003, Win2008). •Lead DBA Architect on three complete Data Center Moves through acquisitions. Performed design, installation, and implementation of new servers, database environments, and storage units, EMC, Clarion, Hitachi SAN units. Support and troubleshoot ETL and reporting tool environments, cubes, and transforms for Informatica and Cognos. Reorganization of corporate infrastructure, design and implementation of enterprise backup//recovery, and design and support of Data Warehouse production and development environments. •Converted over 50 Oracle, SQL Server, DB2 databases to new SAP, SQL Server, or Oracle to support company purchases. Consolidated Oracle and SQL databases and servers. •Performed scaling, physical architecture, proactive performance management and implementation for projects including Data Warehouse, Supply Chain Management, Plant Production and Scanning, Contract Management, and numerous others in Windows 2000/2003 and AIX Unix environments. Worked on Integration of EMC Clarion SAN and infrastructure redesign and database physical reorganization for all SQL Server and Oracle environments. Established formal quantitative performance baseline measurements through the use of monitoring and linked them to server design and capacity planning and proactive versus reactive system management techniques.•Led the design of a new IT operational management infrastructure, including proper change control procedures, supporting documentation, and directed the design of a change control custom program automation tool. Executed Sarbanes-Oxley security and operational requirements, worked on mentoring of junior DBA’s and Strategic IT corporate restructuring after new company purchases.

•Hired as a system DBA performance /stability specialist for a poorly performing, mission critical Windows/SQL Server environment. Created a stable corporate database computing environment within two months of hire after over two years of unsolved chronic problems. Work included some backend physical and logical redesign, minimizing I/O contention, stored procedure performance research and correction, configuration changes with parameter switches, performance monitoring and identification of locking and large processes that were bringing the system down. It also required the reorganization of batch schedules, discussion of political issues to get to the root issues, operational changes, and establishing new internal infrastructure procedures including developer activities, ad-hoc reporting, and batch processes. The system was stabilized and performed well. •Work also included general internal architectural redesign, system and network administration, backup and recovery, troubleshooting of Windows 2000 web servers, file servers, network issues, some redesign and maintenance coding of custom Visual Basic 6.0 applications and ASP web pages. Environment is x86 Win2000 including Terminal servers and Citrix, SQL Server 2000 backend with some processes using COM+ middle tier with Visual Basic front-end and others using ASP pages.

•Managed all corporate database instances for a large insurance conglomerate ($600 million annual revenue) including 41 instances of 64 bit Oracle 8.17 databases and a one terabyte data Warehouse. Distributed environment included 15 N-Class MC ServiceGaurd HPUX11, on EMC Symmetrix. Managed over 125 databases on Microsoft SQL Server 6.5, 7.0, and SQL2000 on X86(Windows 2000) and Alpha platforms (Compaq, HP, Dell). Databases were used for Claims, Policy, Material Damages, Tax data, and include Development and QC environments.•Initially created a formal and elite DBA operational and development group of seven DBAs. Instituted procedures and standards, hired, cross-trained, automated paging, alerts, monitoring & set new physical standards for instances, availability, performance, PLSQL Coding and naming standards. Physically rebuilt databases minimizing I/O contention, isolated performance bottlenecks, rebuilt physical models, and fostered logical/physical database denormalization rebuilds that simplified the application and improved performance. •Implemented new backend databases on major Claims project ($50million) which moved all of mainframe claims production to UNIX distributed systems and maintained 100.0% uptime since implementation. Performed a complete system upgrade to 8.17, standardized instances for storage parameters, object naming, and tablespaces.•Led the technical aspects and managed development of the conversion of most Visual Basic application database calls to stored procedures as well as database model cleanup and changes. Corporate management model was SW-CMM (Carnegie Mellon Capability Maturity Model). •Interfaced with UNIX group on maintenance, operations, and architectural objectives. Worked with all groups on development issues, performance specifications and enhancements. Participated in all IT management meetings and brainstorming. Work terminated after a corporate merger and 75% DOWNSIZING.

• Performed overdue architecture/DBA functionalities by initially scaling the B2B employee benefits administration application which used Active Server Pages and Cold Fusion by first porting the database and application to Oracle 8.17 from SQL Server 7.0 and then designing a new high availability backend architecture utilizing Sun and Clarion/EMC hardware. Work concluded with implementation of architecture and database conversion. Also designed and developed a low-cost Sun-Startup development platform to aid the developers to make this transition. • Built a DBA group to support development and production and designed a new data warehouse and backend architecture to separate DSS from OLTP queries.

London, Gb

•Performed a dual role as manager of an advanced technologies customer and research oriented computer laboratory and the senior Oracle DBA / Backend Architect consulting specialist for the US South/Latin America region. Laboratory work included configuration testing and new operating system testing, sales proof of concept, release beta tests, high-end customer support, and architectural, configurable network computing design.•Consulting specialist engagements included Oracle and SQL Server database performance and architectural audits either before go-live or troubleshooting on many systems after several failed attempts by other business consultants in the field. Provided immediate, direct database support to customers and also researched version incompatibilities, bugs, etc.•Built an advanced technologies lab to perform benchmarking, proof of concept, systems scalability, and release installation and configuration testing. Hardware includes HP9000’s, Compaq Proliants, IBM 704 & AS400’s, and numerous NT Intel & Alpha systems. Designed 100mb infrastructure network & Cybex connectivity.•Published technical documents on architecture, performance tuning, and scalability. •Managed lab events and personnel, scheduled hardware, personnel, and business partners for projects. Coordinated results and wrote technical summary reports.

•Lead Oracle DBA/Architect and Lead Software/Systems Engineer on a large, smart credit card (credit cards with microprocessors) MBNA banking loyalty application pilot at corporate MBNA Bank offices. Performed multiple roles including DBA, Visual Basic 5.0 programmer, and NT 4.0 Network and Systems engineer.•Developed a Credit Card Management System and supported development of a Credit Card Terminal Transaction Collection System using Visual Basic 5 on a Oracle 7.3.4 database including complex cryptographic (DES), & low level security command routines (bits and bytes), database physical and logical models, system administration routines, and backup and recovery procedures on a Compaq Proliant NT server network.•Built/maintained NT 4.0 Network/Server infrastructure for new office relocation from DC.

Windsor, Berkshire, Gb

•Distributed Systems Project Manager for Peoplesoft Financials/HR Implementation. •Distributed Systems Project Manager for Desktop Upgrade project.•Project Manager for Enterprise Infrastructure Problem Management System (Vantive on Oracle).•Served as infrastructure development manager, Lead Programmer/DBA for Support Infrastructure Automation Project for 3500 hotels and 1500 person infrastructure.•Programmed in Vantive 3-tier Client-Server, VB5, Crystal Reports, VBA scripts, & Oracle Stored Procedures on a Oracle 7.3.4 / SunUnix platform with NT and Win95 clients. •Developed personnel management intranet custom software (VB 5).•Developed internal messaging groupware software for 24hr call center that allowed 2-way instant messaging•Developed data models for all implementations. Built and tuned Oracle databases in UNIX and NT environments managing growth with new architecture and minimal downtime. •Authored Oracle/Sybase/Informix link/data conversion programs, automated vendor communications for seamless problem transfer between systems, authored dissimilar database link programs, authored directory & messaging programs, and Crystal/Oracle Reports. Engineered and implemented Server Architecture including Sun UNIX and Intel x86 NT platforms. Built/loaded/maintained (over 100) Intel NT /Win95 systems, Sun UNIX systems, and Novell 3.12 systems.•Managed & performed Oracle DBA and development activities on infrastructure systems.• Managed Novell Netware 3.12 Servers, NT 4.0 servers, Legato Backup, & performed 3rd level support, training & infrastructure development

•Worked as a staff scientist automating industrial and research projects including control, monitoring, and data logging of chemical, physical, and biological processes. Authored software, designed, specified, and interfaced major laboratory and industrial instrumentation. •Designed and supported client/server network solutions for an R & D / Engineering group (Windows on a DEC Pathworks, VAX VMS platform). Integrated hardware and software automation of laboratory instrumentation and pilot plant equipment, data acquisition and reporting, and systems control. Provided 2nd and 3rd level support for 20+ Scientists & technical professionals in computers, electronics, process monitoring, and data acquisition. Systems building, upgrade and repair.•Authored specialized technical programs (over 100) and created databases for laboratory instrument, production and pilot plant database acquisition, control, and reporting, including some programs for customer and plant QC. •Performed software and configuration support•Served also as Senior Analytical Chemist -directed all operations for ICP, HPLC, GC, AA, IC, & IR instruments in a modern lab including methodology development, technical validity /integrity of legally defensible data, & systems 24 hr automation. Built/Trained teams, designed procedures & systems, statistical methodologies, & data massage techniques. Division Information Specialist for literature, patent searches, and presentations•Senior Scientist/Project Manager on several projects including colorant processes, product manufacture specs, research on new chemicals and products, etc. •Elected and served as national industry technical committee chairman for 8 years. Chaired national meetings and presented/moderated numerous technical papers, computerized many new standards and processes setting new protocols.

Crawley, Sussex, Gb

•Managed all technical aspects of a chemical company including IT, R & D, Engineering, Technical Services, QC, & Environmental. •Authored a frontier program incorporating sensor and batch intelligence and hardware for first PC based graphic monitoring, calculation, inventory, and control system for fully automatic vacuum-pressure treated wood systems.•Set up Novell network, integrated plant PLCs for high level monitoring & control. Supported hardware/software for network clients. •Authored a statistical program to determine interlaboratory analytical precision which became a standard in the AWPA industry & surpassed all current ASTM methodologies. •Design of control panels, chemical transfer systems, batch, flow, & temperature controls.•Design/Automation of valves, scrubber systems, ventilation systems, pumps, rinse systems, agitators, boilers, material handling systems, sampling systems, level controls, load cells, pressure, vacuum, pH/conductivity, proximity sensors, signal conditioners. •Automated analytical calculations including batch processing and chemical transfer through computer program development. Integrated laboratory and plant monitoring and automated tank sampling.Analytical methodology development included inductively coupled argon plasma, atomic absorption, colorimetric, volumetric, conductometric, gravimetric, potentiometric, and X-ray Fluorescence techniques.•Directed design & installation of capital, production & process control equipment (control panels, PLCs, batch & flow controls, reactors, pumps, piping, filters, & material handling equipment. Drafted process layout, piping, & electrical circuit designs/drawings for internal & customer systems.•Development of an unconventional mixing process•Development of a wood colorants and treating plant processes.•Development of alternative raw material sources using industrial waste products from copper refining operations and incorporation into new preservative formulations.

Reston, Va, Us

2 appointments•Performed Inductively coupled argon plasma (ICP, AA) and atomic absorption determinations for most elements. Designed / tweaked analytical methodologies including borohydride arsenic determinations. •Extensive exposure mini-computers and the first PCs on the market. Analyzed data using statistical programs.

Phd Graduate Work, Analytical Chemistry, Spectral Analysis

Bachelors, Chemistry, Biology, Physics

Education record