Pam Brisjar
Overview
22
22
years of professional experience
Work History
Senior Database Administrator
Keane, Inc.
04.2010 - 01.2018
- Senior SQL Server database administrator for a variety of both web-based and client-server applications in a wide variety of environments.
- Frequent interaction with technical team members, business users and outside vendors to aid in defining needs and troubleshooting issues.
- Troubleshoot and customize SQL Server side of Acuity and AcuExchange application.
- Initial development of reporting database as well as performance enhancement of Crystal Reports queries for Customer Focus.
- Administer and troubleshoot Employer and Member web portal database loads and queries.
- Basic development and troubleshooting of DB2 queries for data transfer between MHS/Data warehouse and the various SQL Server-based applications.
- Various database administrative tasks as required to run the business.
- Client: BCBSVT Berlin, VT
Senior Database Engineer
eGain, Inc.
Mountain View, CA
10.2008 - 03.2010
- Senior database architect and developer for CRM system running on SQL Server and Oracle back ends.
- Optimization of legacy stored procedure code including implementation of ANSI standards and CTE usage.
- Design, develop and maintain data warehouse and reporting solution.
- Translation of T-SQL code to PL/SQL as well as the reverse.
- Design and implementation of table partitioning archival process.
- Administration of multiple VLDB systems utilizing clustering, replication and mirroring.
- Senior DBA / team lead for hosted customers.
- Mountain View, CA
Database Architect / Consultant
Taos Mountain, Inc.
Santa Clara, CA
08.2007 - 09.2008
- Design and administer VLDB (3+ TB) OLAP system for real-time analytics, report generation via SSRS and SSAS cubes.
- Set up high-availability infrastructure including mirroring, log shipping, snapshots and custom solutions.
- Identify and fix database corruption and performance issues.
- Conduct technical screenings of SQL Server DBA candidates.
- Establish maintenance protocols and scripts for clients.
- Advise engineering team on SQL Server / T-SQL best practices.
- Develop disaster recovery and troubleshooting scripts for support staff.
- Training of 2nd-tier support on SQL Server 2000 and 2005 administration focusing on configuration and troubleshooting.
- Translate Oracle PL/SQL scripts into SQL Server T-SQL.
- Santa Clara, CA
Database Engineer
Akimbo Systems, Inc.
San Mateo, CA
08.2006 - 08.2007
- Principal engineer for design, development and maintenance of data warehouse.
- Included use of SSIS and XML for ETL processes and SSRS for reporting.
- Primary architect for design, documentation and development of MS SQL Server 2000 to 2005 conversion projects.
- Developed migration standards documentation, enhanced database design and queries to take advantage of 2005 features.
- Audited for SQL Server 2005 code compliance.
- Maintenance and modification of Visual Studio C# .NET applications for interface with 2005 database.
- Performance enhancement engineer for MS SQL Server 2005 OLTP systems in a 24/7 production environment.
- Established standards and protocols for database design and development.
- Maintenance and administration of Windows OS environment including Networking, File sharing, User Accounts, Domains, Active Directory.
- San Mateo, CA
Senior Database Developer, Project Team Lead
TekSystems, Inc.
Boise, ID
03.2006 - 08.2006
- Project lead for design, documentation and development of Sybase to MS SQL Server 2005 conversion projects using SSIS for data transfer.
- Included development of migration standards documentation, database design and Sybase SQL to T-SQL conversion.
- Performance enhancement project lead for Sybase and MS SQL Server 2005 VLDB systems in a high-volume 24/7 manufacturing environment.
- Reverse-engineering and documentation for data warehousing and conversion projects.
- Lead for database design and development standards initiative.
- Client: Micron, Inc., Boise, ID
Senior Database Developer, Project Team Lead
SolutionsIQ
Portland, OR
08.2005 - 03.2006
- Project Manager/Business Analyst/Architect/Lead Developer for Cash Application project designed to bring company closer to Sarbanes-Oxley compliance.
- This was a project developed entirely within SQL Server 2000.
- Project was to do credit card and e-check payment transaction reconciliation for Accounting.
- Designed, developed and maintained databases for extraction and reporting of financial data.
- Created DTS packages with VB scripting, stored procedures and functions for importing and exporting of data contained in XML files.
- Creation of some initial proof of concept reports using SS 2005 reporting services.
- Documentation and analysis of systems with ER Studio and Red Gate.
- Manager and mentor to junior team members.
- Client: Vesta Corporation, Portland, OR
Senior Database Developer, Project Team Lead; DBA
Qmedtrix, Inc.
Portland, OR
09.2003 - 05.2005
- Architect and team lead for Gold Standard database/data warehousing project.
- Designed and developed SQL Server Data Dictionary application utilizing SQL Server 2000 metadata queries and extended properties.
- Created data transformation/translation DTS packages and scripts for data warehouse/reporting project.
- Research, analyze and design SQL Server databases and applications for optimum performance.
- Administer Multi-Server SQL Server 2000 database system.
- Full life-cycle development of medical billing auditing software applications with XML import/export feature.
- Managed teams of three to seven developers.
- All projects used Rational Rose for design process.
- Portland, OR
Database Designer / Analyst, Project Team Lead
Beluga Software Cooperative
Olympia, WA
10.2001 - 08.2003
- Designed and developed relational database framework in SQL Server for business rules enforcement engine including GUI maintenance portion.
- Create scripts and protocols for ADABAS to Oracle 8 data transformation project.
- Full life-cycle development of several GUI modules of Washington State Children's Administration application (Three-tiered Delphi application connecting to Oracle, Paradox and ADABAS back ends) as lead programmer within an iterative development process.
- Lead JAD sessions with end-users and management to gather and refine requirements.
- Rational Rose and Requisite Pro used for product development life cycle.
- Olympia, WA
Consultant / Programmer
Independent Contractor
Ellensburg, WA
02.2000 - 07.2001
- De-bugging and maintenance of software auditing application using Delphi 4, COM and SQL Server 7. Primary responsibility was database design and access layer.
- Weight loss tracker for Nursing Home administrator using Delphi, XML and Oracle 8 including on line documentation.
- Full life-cycle development of drug / testing tracker application from client specs for psychiatric services center using Java, XML and SQL Server.
- Above projects required multiple JAD sessions with clients in order to gather requirements and refine product and systems.
- Ellensburg, WA
Senior Developer / Database Analyst, Team lead
Attest Systems, Inc
Novato, CA
05.1999 - 02.2000
- Designed and developed database migration (Paradox to SQL Server) tool with XML.
- Developed local (Paradox) and client/server (SQL Server) versions of hardware and software auditing tool.
- Created custom tool for translating data from Paradox to SQL Server 7.
- Rational Rose used for design process.
- Novato, CA
Application Developer, Reports Project Lead
Bay Logics, Inc.
Novato, CA
04.1999 - 05.1999
- Developed and maintained knowledge base / SQL for Oracle, DB2 and SQL Server back ends.
- Developed Delphi 4 Client/Server front-end for second-party report program (IQ/Objects) with Windows 32 API calls and COM.
- Manager / Project Lead for reports development team.
- Novato, CA
Application Developer, Team Lead
Voice Data Solutions
Raleigh, NC
03.1997 - 03.1999
- Technical Lead and managers for various projects (hotel reservations agency, benefits center, POS/Retail, utilities, inspections/permits) involving full life-cycle development (including JAD sessions) using Delphi 3 Client/Server and C++ connecting to DB2 and Oracle 8 databases residing on local servers as well as mainframe, using SQL queries to view and update database tables.
- Designed and developed an IVR prototyping tool using Delphi 3 Client/Server, which permits user to fully design an IVR and generate ready-to-use Rexx code.
- Developed web application using Delphi 3 Client/Server and HTML 4.0 to interact with a DB2 database.
- Raleigh, NC
Help Desk Consultant
Computer Task Group
Elmira, NY
02.1996 - 03.1997
- Workstation support for IBM internal help desk, supporting both Windows 95 and OS/2 Warp 4.
- Elmira, NY
Timeline
Senior Database Administrator
Keane, Inc.
04.2010 - 01.2018
Senior Database Engineer
eGain, Inc.
10.2008 - 03.2010
Database Architect / Consultant
Taos Mountain, Inc.
08.2007 - 09.2008
Database Engineer
Akimbo Systems, Inc.
08.2006 - 08.2007
Senior Database Developer, Project Team Lead
TekSystems, Inc.
03.2006 - 08.2006
Senior Database Developer, Project Team Lead
SolutionsIQ
08.2005 - 03.2006
Senior Database Developer, Project Team Lead; DBA
Qmedtrix, Inc.
09.2003 - 05.2005
Database Designer / Analyst, Project Team Lead
Beluga Software Cooperative
10.2001 - 08.2003
Consultant / Programmer
Independent Contractor
02.2000 - 07.2001
Senior Developer / Database Analyst, Team lead
Attest Systems, Inc
05.1999 - 02.2000
Application Developer, Reports Project Lead
Bay Logics, Inc.
04.1999 - 05.1999
Application Developer, Team Lead
Voice Data Solutions
03.1997 - 03.1999
Help Desk Consultant
Computer Task Group
02.1996 - 03.1997