Sam Brewster Email & Phone Number

Lansing, MI, US

United States

United States

Middleware Technical Lead for Michigan Child Support Enforcement System for State of Michigan with Gainwell Technologies. Gainwell Technologies is dedicated to empowering our clients through technology to deliver health and human services programs that enable successful health outcomes for beneficiaries nationwide. For more information, visit.

Lansing, Michigan Area

Data Team Manager of a team database administrators, middleware administrators and data modeler at the State of Michigan on the Child Support Enforcement System.

• B2B Business Intelligence – Data Migration Oracle Application Database Administrator
• Providing Oracle application DBA support by creating database schemas and objects for an Oracle 10g RAC database in the development, pre-production and production environments. Also developed PL/SQL procedures.
• Participated in the development of ETL data mapping documents and supporting proof of Concept, component, system integration and user acceptance testing phases.

Provided Oracle Database consulting services at the State of Michigan Business Services supporting the development of a B2B web application using an Oracle 11g RAC database.

Providing Oracle Application Database Administration support for B2C project.

Business Intelligence Extract Transform Load (ETL) for B2B application during development phase of the project by assisting with analyzing data, data mapping, migration and cleansing of data extracted from Lotus Notes to an Oracle 9.2.0.6 database instance.

Provided DBA support for 33 B2C application and global components for multiple database instances in the development, preproduction and production environment for Oracle versions 8.1.5, 8.1.6, 8.1.7, Oracle Parallel Server, 9.2.0.5, and Oracle 11i apps version 11.5.5. System dba support included creating database instances using various language encoding.

Oracle Application Database Administrator for B2B application. Developed data model for B2B application during design phase. Developed and maintained multiple databases for development. Provided application DBA support for production environment of 8.0.5 and 8.1.6 database versions. Assisted with sql and pl/sql performance tuning. Developed Java server.

Provided 7x24x365 support for global purchasing system.Performed adhoc reporting and provided support for development team for a XDB DB2 database emulator and DB2. Researched root cause and provided estimates for production incidents. Supported development and user acceptance testing for each release by creating test data for the XDB and DB2 database.

Information Analyst for development of plant reporting applications. Developed applications in C, FoxPro, Visual Basic, Java, HTML, SQL, PL/SQL, JCL and Sync Sort. Provided support during User Acceptance Testing phases and also during the implementation phases of the applications.

Business Relations Analyst for plant floor operations. Provided 7x24x365 support for plant floor operations and communication networks. Performed operations support of plant floor systems that included performing backup and archiving of Digital PDP and Vax systems, general preventative maintenance, communication network monitoring and tuning, and user.