BERNARD JAMES “B.J.” LACHANCE

*** ****** ******* ******

Ruskin, FL 33570

603-***-****

SUMMARY

Amazon AWS Associate Solutions Architect

Oracle Associate Architect: Oracle Cloud Infrastructure

Oracle Certified Professional Certification in Oracle 11g Database Administration.

AWS/Oracle cloud architect --Well versed in respective cloud technologies and architecture especially AWS and Oracle OCI

Experienced Unix/Linux Systems Administrator and Oracle DBA: including bash/korn scripting, Unix/Linux kernel parameter tuning. Deep experience with Unix/Linux based performance monitoring.

Strong DBA Skills with databases/tools performance tuning/troubleshooting/diagnosis. (TOAD/OEM/Cloud Control 13c).

Excellent Skills in administering Oracle Databases in multiple configurations and environments. Extensive use of RMAN for DB Clone operations, Physical DataGuard Standby, incremental and full backups using both control file based and Recovery Catalog configurations.

Strong written and spoken English language skills with extensive technical documentation experience.

Strong MS Visio and PowerPoint Presentation skills.

EDUCATION & TRAINING

• Bachelor of Arts Bates College, Lewiston ME

PROFESSIONAL EXPERIENCE

Oracle Corporation Burlington, MA

November 2017 - present

Senior Solutions Consultant

•Provide pre-sales engineering support to Oracle Small Medium Business (SMB) Sales Organization

•Provide solution architecture for DB/Middle tier customer configurations migrating to the cloud.

•Demonstrate migrations of Oracle platforms from on premise to Oracle Cloud

•Conduct competitive analysis and comparison of Oracle Cloud to Azure, AWS, other cloud players.

Bentley University Waltham, MA

July 2017 – November 2017

Senior Oracle DBA

•Support Banner Application databases along with other version 10-11 Oracle databases.

•Installed, configured Oracle 12 V5 Cloud Control on virtual system.

•Coordinate and perform Physical to Virtual migrations of Oracle platforms (VMware).

•Install and configure KnowledgeSync messaging software

•Unix shell scripting for daily job automation

IKA Systems Southborough, MA

November 2015 – June 2017

Lead DBA

•Lead interdisciplinary group of 4 Oracle/MS SQL DBA’s

•Manage monitor maintain 326 separate Oracle DB instances.

•Coordinate and perform Physical to Virtual migrations of Oracle platforms (VMware).

•Perform Database security audits and remediation.

•Perform 11g to 12c Oracle Database upgrades utilizing Oracle12c Pluggable Database technology.

•Provide DBA development support for multiple Agile teams.

Eagle Investment Systems, Wellesley, MA

March 2014 – November 2015

Managing Consultant

•Architectural review of Oracle Database servers deployed on Eagle Access, a financial services SAS platform.

•Recommend best practices and performance tuning actions to optimize performance and reliability of Eagle software running on the Eagle Access platform.

•Evaluate Oracle performance on EMC VMware using Extreme I/O solid state SAN storage. (CMP -- Cloud Management Platform)

•Roll out Oracle Cloud Control 12 as a management, job control and monitoring platform for Eagle Access.

•Optimize Linux OS for optimal Oracle performance such as enabling Huge Pages and tuning other kernel parameters associated with Oracle performance.

•Introduce and champion Oracle ASM/Grid Infrastructure as a HA/high performance storage and availability architecture.

•Perform proof of concepts with database HA options such as DataGuard, Shareplex and RAC including evaluation of Exadata X3 hardware platform.

Pega Systems, Cambridge, MA

December 2013 – March 2014

Lead Oracle DBA/Architect (consultant)

•Architectural review of Oracle Database servers deployed on Amazon Web services

•Recommend best practices and performance tuning actions to optimize performance and reliability of Pega System CRM software running on the Amazon Cloud

Verisk Health, Waltham, MA

July 2012 – November 2013

Lead Oracle DBA/Architect (consultant)

•Designed and built 3 node Oracle 11g RAC Cluster

•Patching and upgrades of Oracle RDBMS/Clusterware/ASM

•ASM storage management, Oracle OEM Grid Control, RMAN/shell scripting.

•Use Oracle Advanced Compression for OLTP for both storage space saving and better query performance. Compress 50 TB database to 26 TB with this technology

•Configure monitor RMAN catalog based DB backup. Standby archive log management for DataGuard Physical Standby DB’’s.

•Use RMAN parallel process and compression features.

•Developer support and data masking and pruning for QA/test databases

•Oracle Enterprise Manager Cloud Control 12c installation/configuration on Hypervisor VM’s

•Oracle Enterprise Linux support and administration,

• Red Hat Enterprise Linux support and administration,

PowerAdvocate LLC, Boston, MA

July 2010 – March 2012

Sr Oracle DBA / Solaris Systems Administrator (FTE)

•Production DBA support and performance tuning of Oracle 11g (11.2.0.1) OLTP/OLAP databases on Solaris 10 Sparc 64 platforms.

•Patching and upgrades of Oracle RDBMS/Clusterware/ASM

•ASM storage management, Oracle OEM Grid Control, RMAN/shell scripting.

•Use Oracle Advanced Compression for OLTP for both storage space saving and better query performance.

•Configure monitor RMAN catalog based DB backup. Standby archive log management for DataGuard Physical Standby DB’s.

•Use RMAN parallel process and compression features.

•Developer support and data masking and pruning for QA/test databases

•Oracle Enterprise Manager Grid Control installation/configuration on Hypervisor VM’s

•Solaris 10 System Administration / Sun StorageTek SAN administration

•Oracle Enterprise Linux and Red Hat Enterprise Linux support and administration,

Epsilon Corporation, Wakefield, MA

December 2010 –July 2010

Senior Oracle DBA (consultant)

•Production DBA support and performance tuning of 1.5 and 1.4 TB Oracle 11g RAC DSS databases

•Performed extensive index, partition and init.ora tuning, to increase batch performance times by factors of up to 3X.

•ASM storage management, Oracle OEM Grid Control (10g), RMAN backup /shell scripting.

•Performed Oracle 11gR2 software installation and customized database creation using DBCA on ASM managed SAN storage.

•Migrated/Upgraded existing Windows X86_64 based Oracle 10g Databases to new Solaris platform using Data Pump via Network Link

•Configured 2 local Oracle 11g Physical Data Guard instances and one WAN based DataGuard standby database.

•Installed and configured Oracle Enterprise Manager Grid Control 11g on a virtual 32 bit Windows 2008 R2 server. Configured 11g Grid Control agents on Sparc(64) Servers. Configured RMAN and Data Pump backup jobs within OEM Grid Control to support production environment

Mobile Messenger, Watertown, MA

April 2010 – July 2010

Sr Oracle DBA (consultant part time)

•Reviewed current Oracle OLTP (2.3 TB)/DW(%.6 TB) environments for performance and High Availability options. Proposed Oracle Data Guard logical Standby for initial HA strategy.

• Implemented Oracle Enterprise Manager Grid Control for monitoring, alerting and job control for existing production servers. ( ~ 35 targets)

•Monitored Daily DB health and RMAN jobs.

•Secondary role included administering MySQL and MS SQL datastores.

Red Hat Software Westford, MA

September 2009 – April 2010

Sr Oracle DBA (consultant)

•Researched and authored 2 Red Hat Reference Architecture documents regarding Oracle RDBMS migrations and upgrades from Windows platforms to RHEL 5.x platforms ( 10g to 11g R1, 11g R1 to 11g R2).

•Researched and demonstrated Red Hat JBoss Application server inter-operability with Oracle data sources including Oracle RDBMS 11gR1

Harvard Business School Cambridge MA

April 2008 – July 2009

Sr Oracle DBA (consultant)

•Project/technical lead for the schema consolidation, migration and upgrade of HBS’s primary data stores.

•Migrated HBS’s existing Oracle 9i databases from various Solaris and Linux platforms to a centralized Linux Advanced Server x86_64 10g R3 RAC cluster environment

•Installed and configured a 2 OMS Oracle Enterprise Manager Grid Control system that monitors, manages all DB enabled job control and database backups

•Installed and configured both physical and logical Oracle 10g DataGuard instances using DGMGRL and OEM as monitoring interfaces

•Performed rolling upgrades of RAC cluster (CPU patches) with DataGuard logical standby

•Performed specific use case migrations /upgrades of 10g schemas/dbs to 11g schemas/databases

•Performed init.ora, partitioning and index experiments in a lab/test environment. Migrated some of these to production for performance gains

•Configured OEM to monitor/manage BEA Web Logic Application Servers

•Configured OEM for remote monitoring and management of MS SQL Server databases using the OEM SQL Server plugin

•Customized OEM monitoring templates for production, QA and development levels of monitoring and alerting

•Performed security audits and remediation based on customized OEM security policy templates and reporting

Biogen Idec Cambridge, MA

September 2007 – April 2008

Sr Oracle DBA- Production Support (consultant)

•Senior production support DBA role servicing customer requests for account creation, maintenance, database space management and monitoring using Sarbanes Oxley (SOX) DBA security best practices and FDA/WHO compliant validation procedures

•Upgraded/configured Oracle Enterprise Manager 10.2.x.x environment supporting nearly 100 Unix (HPUX/Solaris) /Linux servers and nearly 300 Database targets ranging from Oracle 8i to Oracle 10G R2

•Performance tuned a .6 TB financial Oracle 9i/Informatica data warehouse using Oracle partitioning (range/hash composite partitioning) and parallel query server as well as file based I/O distribution and tuning init.ora parameters

•Performed installation and configuration of Oracle Adverse Reporting System (AERS) 4.6 Including Oracle application server infrastructure and database ( Windows 2003 based)

Dreyfuss Energy IT LLC Trumbull, CT

September 2007 – November 2007

Sr Oracle DBA (part time consultant)

•Rapid prototyping/proof of concept ( ~30 Hours) that demonstrated Oracle RAC 10g R2 running on Red Hat Advanced Server 4.0 on SUN SMP AMD based server hardware and Network Appliance SAN storage. (2 server nodes)

•Setup and configured OCS (Oracle Cluster Services) and ASM disk management as well as the Oracle/OS dependencies such as semaphores, hang check timer, secure rsh and raw device management (for the OCR and Voting disk as well as reliably presenting the same raw device names to ASM between reboots --UUID)

•Demonstrated Advanced Queue behavior in a RAC environment as well as basic TAF (Transparent Application Failover-) capabilities within the RAC service oriented architecture

BJs Wholesale Club Framingham, MA

June 2007 – August 2007

Sr Oracle DBA (consultant)

•Installed and Configured Oracle Enterprise Manager 10G release 3 on IBM AIX servers for Sarbanes-Oxley Compliance (SOX) remediation and reporting

•Researched, identified and documented specific DOD compliance points from the DOD Security Implementation Guide (STIG) and then mapped these back to specific security checks OEM provides

•Created custom OEM GC monitoring template based on these compliance points/security checks and applied this to Oracle databases, instances and listeners ranging in release levels from 8i to 10g

•Configured OEM 10gR3 Agent running on AIX 5.3 server to service remote targets on AIX 4.3 servers ( 10g Agent doesn’t run on AIX 4.3)

TriCore Solutions Quincy, MA

January 2007 – June 2007

Sr Oracle DBA (consultant)

•Led design/deployment of 3 Node Solaris 9/Oracle10g R2 RAC Cluster supporting 5 Production database instances for 24x7 Web Based online travel/cruise reservation system

•Configured 1 terabyte of Oracle ASM managed SAN storage

•Prepared Sun OS 5.9 Operating system for RAC installation including setting kernel parameters (etc/system), SAN Storage, shared raw device. setup/permissions, user and group administration, RSH/SSH connectivity and inter-connect networking issues

•Installed Oracle 10g R2 base/patches for CRS, RDBMS and OEM agent software

•Configured 5 oracle RAC database instances in corresponding setup in 2 node lab environment.

•Installed, configured and deployed Oracle Enterprise Manager Grid Control Console and Agents in both DEV and Prod environments to monitor, manage and maintain RAC clusters

•Installed, configured and patched Oracle Business Intelligence Discoverer and required Oracle Apps Infrastructure

Salem State College Salem, MA

December 2006 – January 2007

Sr Oracle DBA (consultant)

•Performed various basic Solaris 8/ Oracle 8i/ PeopleSoft 7.5 and 8.0 Maint/Admin tasks to PeopleSoft FIN, HR and SA modules

•Installed and Configured Oracle HTML database (APEX)

•Managed SSL security and CA certificates with Oracle Wallet Manager

ChartOne Systems Burlington, MA

January 2006 – December 2006

Sr Oracle DBA

•Performed various and sundry Solaris 8/ Oracle 8i/ PeopleSoft 8.8 Admin Tasks on .5 Terabyte PeopleSoft Database

•Configured multi node Tuxedo application server tier. This tuned and stabilized existing app server layer such that previous daily crashes haven’t occurred in 4 months

•Configured and tuned PIA tier of PeopleSoft Application suite based on BEA Web Logic Web servers

•Debugged and configured various MicroFocus Cobol license server issues

•Installed Oracle 9i db test and migration server environments for pending oracle 9i upgrade

•Accomplished huge online user performance gains by optimizing I/O and Solaris kernel parameters such that a 32 GB RAM Sun server could use 16GB SGA instead of the 3.7 GB SGA /etc/system setting previously allowed

•Demonstrated huge batch processing performance gains by partitioning several multimillion row tables, enabling parallel query servers and optimizing disk I/O properly

•Implemented Oracle Enterprise Manager Grid Control 10g release 2 ( upgraded from 1st installation of 10g R1) for 14 nodes running various versions of oracle 8i and 9i on both Windows 2000 and Solaris 8-9 Servers. Initial 10g R1 OEM grid Control installation was on Windows 2K server. Migrated OEM repository to Solaris Platform and upgraded both OEM console and all agents to 10g R2

•Ran all DB backup jobs via RMAN administered through OEM

Upromise, Inc Needham, MA

October 2005 – January 2006

Sr Oracle DBA (consultant)

•24x7 Support of Oracle 10g R1 3 node Linux RAC DSS cluster and Oracle 9i Solaris Veritas (Dataguard) cluster running web enabled financial OLTP system

•Managed oracle tars ( Service requests) for several production critical bugs

•Scripted and debugged various shell programs to support customized application

•Managed several large .7 Terabyte data transfers from one live system to another

•Installed, debugged and configured ASM/Oracle 10g RAC on Linux test servers

Monster TMP World Wide Maynard, MA

June 2005 – October 2005

Sr Oracle DBA (consultant)

•Installed configured and optimized Oracle 10g (release 1 and 2) for 32 bit Intel Linux .

•Configured various Oracle 10g OEM backup jobs, event monitoring and auditing functions of the OEM interface as well as hand scripting actual DDL for custom partitioning Designed highly optimized 300 GB + data mart schema using Oracle hash range partitioning, index organized tables (IOT), materialized views and other Oracle 10g OLAP/DW features

•Installed/configured Oracle Transparent Gateway for MS SQL (TG4MSQL) gateways for high performance heterogeneous connectivity-- achieved rates of 65 million rows transferred per hour (single stream) on Wintel based XEON 2way 2GB hardware

•Used Oracle Data Warehouse Builder (10G) to create various mappings and process flows to populate Oracle Data Mart

•Tuned and troubleshot a 4 node Linux RAC experiencing severe performance problems

•Used Oracle Designer to create/document/deploy terabyte data mart logical/ physical schema

•Set OEM based RMAN backup processes

State Of Massachusetts Boston, MA

February 2004 – June 2005

Sr Oracle DBA (consultant)

•Oracle DBA tasks on Win 2K platforms. Installed and tested Oracle 10g on Windows 2003 64 bit

•Perform various day to day production support tasks for very large (by NT standards at least -- 800 users) voter registration database

•Used Erwin data modeling tool to reverse engineer existing schemas and create organizational data dictionary

Ascential Software Westborough, MA

February 2004 – November 2004

Sr Oracle DBA (part time)

•Provided Oracle DBA architecture and technical support/documentation for Ascentials in house development and testing of their DataStage product. Created 2 node IBM AIX 4.3x and 5L Oracle 9i RAC installations for this purpose

•Performed DBA mentoring and knowledge transfer for Ascential Datastage employees

•Installed Oracle 9i Linux RAC ( OCFS) configuration on 3 node IBM blade server

Kwajalein Range Services Republic of the Marshall Islands

November 2002 – September 2003

Sr Oracle DBA (consultant)

•Implemented Oracle 9i RAC on Suse Linux Advanced Server (Raw Devices)

•Setup Oracle modplsql gateway, HTTP server and supported development of PSP/Intermedia Text based document storage/retrieval system

•Administered Digital UNIX and Solaris 8 servers

Fast Search and Transfer Wellesly, MA

November 2001 – April 2002

Sr Oracle DBA (consultant)

•Installed, configured and tuned Oracle 8i (release 3) on Intel based Linux systems (Red Hat, Debian) and Free BSD. Developed stored procedures and DB triggers using Oracle Procedure Builder and TOAD for large search engine database

•Used Oracle Designer 2k to design, implement and document new schema while supporting staff of 11 Java developers. Wrote various bash scripts to start stop monitor and tune Oracle RDBMS and networking. Wrote various SQL Loader control files and data cleansing perl scripts to insert large amounts of URL based data in new database

•Installed and configured Oracle 9i on both Win 2k and Red Hat 7.1 beta environments

Yankee Book Peddler Contoocook, NH

July 2001 – October 2001

Sr Oracle DBA (consultant)

•Redesigned and supported very large Oracle 8.1.7 / Win 2K 24x7web enabled database currently supporting over 200 worldwide concurrent users doing bibliographic research

•Used Oracle 8.1.7 OEM monitoring and management tools to document system load and present to senior management a 2 year hardware capacity planning document. Designed and implemented extensive data modeling changes as well as Oracle specific enhancements such as hash based table partitioning

•Lead PL/SQL Development of over 30 PL/SQL packages formerly performed by VB applications

•Implemented Intermedia Text on six large key word tables (each with over 10 million rows and varchar2(500) columns )

•Increased key word query performance on key queries by close to 10x. Migrated development schema objects to production database

Sun Microsystems Burlington, MA

October 1999 – July 2001

Sr Oracle DBA (consultant)

•Designed and implemented large database I/O subsystems for Oracle 8i RDBMS OLTP benchmarking (TPC-C) for Sun prototype equipment 'Daktari' (8 SPARC processor work group servers)

•Conducted competitive analysis of Intel/NT based systems running MS SQL Server 7.0. Used Intel Vtune to profile instruction sets of both Oracle 8i and MS SQL 7.0 running the TPC-C benchmark

•Installed and configured and tuned Oracle 11 -11i Applications suite on Solaris 8 platforms for high user count simulations and load testing

Yankee Book Peddler Contoocook, NH

April 1999 – October 1999

Sr Oracle DBA (consultant)

•Architected migration of an MS NT 4.0 based 30 GB, 150 user, Oracle 7.3.3 database from a dual Intel Pentium CPU system to a 4 CPU Xeon based Netfinity server attached to an EMC2 Open systems storage server. Re-designed OFA compliant file layout for fault tolerance and performance

•Performed SQL tracing using TKPROF. Planned migration to Oracle 8I and mentored full time staff on advanced DBA tasks and Oracle 8 enhancements

•Tuned existing application code and created PL/SQL based application modules for additional application functionality

•Used Erwin data modeling tool to document existing db schemas and enhance with additional relational integrity

Partners Health Care System Chestnut Hill, MA

March 1999 – May 1999

Sr Oracle DBA (consultant)

•Installed Oracle Enterprise Server version 8.0.5 on a Sun ES450 server running Solaris version 2.6

•Assisted in the design and configuration of the Unix kernel and I/O subsystem to support a 2 GB+ data mart

•Used NT based Oracle Designer 2000 version 2.03 to create a database design based on assorted and various legacy database feeds including HL7 based data dumps

•Used Perl and Oracle SQL Loader (v8.x) utilities to format and populate fact and reference tables

•Installed and configured Oracle Enterprise Manager and Enterprise Server 8.0.5 on a Windows NT 4.0 (set-vice pack 4) Compaq Proliant Server for both OEM repository support and Solaris server based development

Digital Equipment Corporation Nashua, NH

April 1997 – February 1999

Sr Oracle DBA (consultant)

•Played key role in the architecture and implementation of a Digital UNIX based 13 terabyte Oracle 8.0.3.1 multi-node Oracle Parallel Server (OPS) database for benchmarking using industry standard TPC - C (OLTP) metric

•Installed, configured and tuned Digital Unix version 4.Od and above on ALPHA 8400 and 1000 series Very Large Memory (VLM) platforms. Installed, configured Digital TruCluster Memory Channel software

•Installed and configured Oracle 8.0.x for NT on Digital 8400 and 4100 series NT platforms.

•Created large TPC - C based databases and worked closely with Oracle development staff to debug and test Alpha/Oracle VLM functionality on NT

•Planned, implemented and administered I/O subsystems for both Alpha Unix and NT platforms that host 30, 100 and 300 gigabyte TPC-D Oracle 8 databases

Town and Country, Inc. Chelsea, MA

December 1996 – April 1997

Sr Oracle DBA (consultant)

•Migrated and upgraded 2 gigabyte Oracle 7.1x database from a Novell 3.12 platform to Oracle 7.3 RDBMS running on a MS NT 4.01 server

•Designed and administered NTFS based disk layout to optimize Oracle 1/0

•Created TCL based startup, shutdown and backup scripts

•Used Erwin/ERX version 2.6 to document, migrate and enhance non-Oracle schemas.

•Developed Star Schema based data warehouse

CERTIFICATION

Completed Oracle Certified Professional 11g

Advanced Oracle Training in DataGuard, 11g Performance Tuning and 12c Cloud Control

Oracle OCI Associate Architect Certification

Oracle ADW Certified

Amazon Associate Architect Cerification

Contact this candidate