Brian Fountain

Operations Systems Analyst at Goodwin Procter LLP

Location
Greater Boston Area
Industry
Information Technology and Services

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Brian Fountain know in common
  • Get introduced to Brian Fountain
  • Contact Brian Fountain directly

View Brian's full profile

Brian Fountain's Overview

Current
  • Operations Systems Analyst at Goodwin Procter LLP
Past
  • Database Systems Analyst at Goodwin Procter LLP
  • Database Administrator / Developer at Benchmark Assisted Living
  • Database Administrator at Agri-mark
  • Senior Application Database Admin/Developer/Analyst at Partners HealthCare
  • Senior Application Developer/Analyst at Coventry Healthcare
  • Senior Database Administrator at Acme Packet Inc
  • DBA and SW QA Domain Analyst III/ SQL development at Kronos
  • Software Quality Assurance Engineer at McKesson
  • Database Administrator/ QA Engineer at Lightbridge
  • Help Desk at AT&T
  • Help Desk at AT&T
Education
Connections

329 connections

Brian Fountain's Summary

HP iManage Certified Systems Engineer
IDOL Essentials Certification
Desksite 8.5 / 9
Worksite 8.5 / 9
WCS Worksite Communication Server
Filesite
Email Management (EMM)
Matter Centricity (MCC)
Legal Key
FileMaker Pro
FIM - Firm Identity Manager (Microsoft)
Milan (Prosperoware)
Copitrak/Scantrak
SQL 2012
SQL 2012 High availability and Disaster recovery
SQL Server 2000
SQL Server 2005
SQL Server 2005 Integration Services
SQL Server 2005 Reporting Services
SQL Server 2008
SQL Server 2008 Integration Services
SQL Server 2008 Reporting Services
SQL Server 2008R2
WSS 3.0
Microsoft Office Sharepoint Server 2007 Administration(MOSS)
EMS Event Management Software
Expert Image
PowerShell
Windows 7,Vista,XP,98,8
Windows Server NT, 2000, 2003, 2008,2008 R2
Oracle 8,8i,9i
SQL
PL/SQL
T-SQL
HTML
ASP
Changepoint
Microsoft Team Foundation Server
DB Pro - Visual Studio for Database Developers
Embaccadero
TOAD
Crystal Reports
Replication
Backup and Recovery
Security
Capacity Planning
Networking
Programming/Development
Sarbanes Oxley

Brian Fountain's Experience

Operations Systems Analyst

Goodwin Procter LLP

Partnership; 1001-5000 employees; Law Practice industry

July 2013Present (1 year 3 months) 53 State Street Boston,MA

Management and support of all of the firm's major applications (3rd Tier)
User management, security, application configuration, servers

Database Systems Analyst

Goodwin Procter LLP

Partnership; 1001-5000 employees; Law Practice industry

December 2011July 2013 (1 year 8 months) 53 State Street Boston, MA

Database Administration (Troubleshoot & fix failed SQL jobs, security issues, database backup and restores)
SSIS package development
SSRS report development
Imanage
DeskSite
Worksite server setup, installation, configuration
DMS (communication server,Utility Server, DMS Server)

Database Administrator / Developer

Benchmark Assisted Living

Privately Held; 1001-5000 employees; Hospital & Health Care industry

20112011 (less than a year)

SSIS, SSRS, Database Administration

Database Administrator

Agri-mark

March 2010November 2010 (9 months)

Implemented Maintenance plans for all SQL Servers in company network
Implemented backup strategies to all application SQL servers.
Performance tuning of SQL server running SQL2000, 2005, and 2008
Planned, Configured and Built entire SharePoint farm environment.
4 server SharePoint environment including 1 index/search server, 2 front end load-balanced web servers and 1 database server running SQL server 2008 SR2.
Performed hardware configurations, networking to keep SQL server inside domain and front end servers in a DMZ to allow for remote access.
Did all of the software installation for SQL and SharePoint, configurations, site development and SQL reporting services integrations.

Senior Application Database Admin/Developer/Analyst

Partners HealthCare

Nonprofit; 10,001+ employees; Hospital & Health Care industry

September 2009December 2009 (4 months)

Write Technical design specs for Partners LMR Acute Care project to streamline design and development process.
Transform data from multiple sources and migrate to other databases while enforcing new data type conditions and cleansing records that do not meet the conditions.
Write complex SQL and TSQL statements accessing large record sets with minimal impact on performance.

Senior Application Developer/Analyst

Coventry Healthcare

Information Technology and Services industry

June 2008January 2009 (8 months)

Lead on finding a solution for near flawless SQL code deployments
Tuning of Developer SQL and T-SQL scripts before promotion to QA
Hosted SQL code reviews before releases, to brainstorm on best possible uses of SQL.
Database Administrator for Development, Load Test & Smoke SQL Servers
Field custom requests from management for ad-hoc scripts, aproduction assistance.
Use of Microsoft Team Foundation Server/Share point and Visual Studio Team Edition for Database Professionals (DB Pro)
SQL Code deployments to 3+ environments up to 3x a week
Performance tuning using Database Engine Tuning Advisor and SQL Server Profiler
Control object permissions, SQL Server account permissions, domain accounts, etc. for development team to keep within Sarbanes Oxley Standards. Done with minimal impact to the dev team's performance from restrictions placed
SQL and T-SQL code development to create/modify SQL Server objects (Stored Procs, Tables, Views, Indexes, keys, users)
Develop custom packages using SSIS for data loads, integration, workflow, data warehouse processes, etc
Designed and created a complex custom SSIS ETL package to unify Parent company's Billing information with legacy billing systems within company. This reduced manual processes, freeing up man hours, billable time and efficency.

Senior Database Administrator

Acme Packet Inc

Public Company; 501-1000 employees; APKT; Telecommunications industry

July 2006June 2008 (2 years)

Implemented redundancy procedures from ground up to replicate data to standby systems, including creating backups & restoration to standby servers.
Database maintenance on all SQL Server application, development and test databases (approximately 30 servers/ 50 databases); including performance tuning, rebuilding indexes, integrity checks, security & disaster recovery planning
Account management - Identify and audit on a regular basis all SQL server accounts (Windows and login based) and validate security permissions
Developed a central reporting server using SQL Server Business Intelligence Studio (SSRS)
Application / System admin for MRP (SyteLine) application. This responsibility includes, but not limited to: Creating user accounts and assigning permissions, Modifying forms using WinStudio, Creating New forms using WinStudio, Modifying Crystal Reports, License Management, security administration
Detailed documentation for Sarbanes - Oxley compliancy. Including security, disaster recovery, & maintenance procedures.
Assist with Overflow of Help Desk tickets when needed
Converted manufacturing MS Access Database to SQL server 2005; maintaining indexes, users, replication and security
Performed changeover of track it application from msdb database to MS SQL 2005.
Schedule backups and Maintain Equity Edge application database running on Oracle 9i.
Performance tuning using Database Engine Tuning Advisor and SQL Server Profiler.

DBA and SW QA Domain Analyst III/ SQL development

Kronos

Privately Held; 1001-5000 employees; Computer Software industry

February 2004July 2006 (2 years 6 months) Chelmsford, MA

Database Administration for Production, Development and Test instances running on MS SQL Server 2000 and Oracle 8i,9i,10G
Administration tasks include, but not limited to: Performance Tuning, Patch applications, software upgrades, security planning and implementation, Backup and recovery.
Write SQL, PL/SQL queries against the backend databases for 4 SQL Server, and 2 Oracle Databases to gather statistics and validate fixes.
Data Analysis for Oracle Applications Databases, as well as legacy system databases
Work with Oracle and MS SQL Server tools such as OEM, Enterprise Manager, TOAD, Embarcadero rapid SQL
Work with development teams, to troubleshoot database and application problems.
Validate code changes made by developers and DBA on database changes (Stored Procedures, Batch Jobs, Server Configurations)
Troubleshoot, diagnose, and test issues relating to the Web Methods Enterprise Service Bus. (6 internal IS applications integrated with Oracle 11i via an ESB)
Perform testing in Oracle and Legacy Applications to ensure integration.

Software Quality Assurance Engineer

McKesson

Public Company; 10,001+ employees; MCK; Hospital & Health Care industry

November 2003February 2004 (4 months)

Research / fix data inconsistencies in DM® Disease Monitor database.
Load & performance testing on Oracle Database (8,9i) and SQL Server 7.0
Front End application testing.

Database Administrator/ QA Engineer

Lightbridge

Public Company; 201-500 employees; LTBG; Telecommunications industry

November 2000November 2003 (3 years 1 month)

Oracle and SQL Server Database Administration of 13 different Oracle & 3 SQL Server environments for the Quality Assurance Department in both Unix and Microsoft Server 2000
Validate and apply database patches, upgrade scripts, stored procedure changes developed by production DBA group to the QA databases
Use of GUI tools such as Embarcadero, Toad, Oracle Enterprise Manager and command line interface to administer databases.
Oracle & SQL Server database resource and administrator for quality assurance team.
Backup (use of IMP & EXP utilities), Sizing, Tuning of large transactional based databases (100 GB+)
Building new Database environments for Quality Assurance team using both database create scripts and enterprise manager.
Provided On-Call support on a bi-weekly basis.







SKills & Tools


PL / SQL
T-SQL
SQL
HTML
DHTML
ASP
VB Script
Visual Basic 4
Erwin
Network Protocols (TCP/IP)
Server Administration (Unix, NT, 2000)
SQL Server Enterprise Manager, 2005 Management Studio
Oracle Applications (Order Management, Collections, A/R, GL, HR, Shipping)
Web Methods Enterprise Service Bus (ESB)
Data Warehouse / EDW / OLAP
SyteLine
Changepoint
Clarify
Track It!
SQL Server 2000/2005/2008 R2
Omnify
XNET
Microsoft Team Foundation Server
Share point
Microsoft Visual Studio for Database Developers (a.k.a. - "DBPro")
Microsoft SSIS
Microsoft SSRS
Microsoft SSAS
Crystal Reports 6 (modifying and writing reports)
Microsoft Office SharePoint Server 2007 (MOSS)
WSS 3.0
DSI
Teleform
Active Directory

Help Desk

AT&T

Public Company; 10,001+ employees; T; Telecommunications industry

19991999 (less than a year)

Help Desk

AT&T

Public Company; 10,001+ employees; T; Telecommunications industry

19991999 (less than a year)

Brian Fountain's Volunteer Experience & Causes

  • Volunteer Experience

    • Goodwin Procter Day of service

      Franklin Park Zoo
      • Animal Welfare
      August 2014 August 2014 (1 month)

      Assisting with crowds management, exhibits, directions, etc for Zoo's free admission day.

  • Volunteer Interests

    • Causes I care about:

      • Animal Welfare
      • Children
      • Civil Rights and Social Action
      • Education
      • Environment
      • Human Rights
      • Poverty Alleviation
      • Science and Technology
      • Social Services

Brian Fountain's Projects

  • Email Management and Matter Centricity Implementation

    • March 2013 to Present
    Team Members: Brian Fountain

    Configure, Implement, Test & Deploy 5 HP Autonomy Worksite DMS Servers, 3 Utility Servers, 6 Communication servers (EMM,EFS,EAS)
    Workspace Management and Matter Centricity (MCC)
    Milan integration
    IDOL Indexing implementation
    2000 + users
    250 Million Emails to process
    Full Worksite Adminstration post-deployment

Brian Fountain's Skills & Expertise

  1. Microsoft SQL Server
  2. SharePoint
  3. Databases
  4. T-SQL
  5. SSIS
  6. Disaster Recovery
  7. Windows Server
  8. SSRS
  9. SQL
  10. Oracle
  11. Database Administration
  12. Unix
  13. Data Warehousing
  14. PL/SQL
  15. Visual Studio
  16. Integration
  17. Active Directory
  18. SDLC
  19. Software Development
  20. ETL
  21. Performance Tuning
  22. Business Intelligence
  23. Networking

View All (23) Skills View Fewer Skills

Brian Fountain's Education

Merrimack College

19941995

Peabody High School

19901994

Contact Brian for:

  • career opportunities
  • job inquiries
  • expertise requests
  • reference requests
  • getting back in touch

View Brian Fountain’s full profile to...

  • See who you and Brian Fountain know in common
  • Get introduced to Brian Fountain
  • Contact Brian Fountain directly

View Brian's full profile

Not the Brian Fountain you were looking for? View more »