JAMES BENJAMIN ADAMS

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

Bethel Park, PA 15102

808-***-****

E-Mail: acv1qq@r.postjobfree.com

SUMMARY:

Innovative, results-oriented Information Technology Professional with over twenty years of achievements, using technology to solve business problems. Experienced in Requirements Analysis, Systems Analysis, Business Process Management and Project Management; delivering business solutions to customers increasing their operational efficiency and improved bottom-line results. Acquired extensive technical knowledge in the areas of: Database Systems, Database Modeling, Database Architectures, Database Administration, Oracle RAC and Data Guard Administration, MySQL/Postgres Replication, Database Performance Tuning, SQL and Stored Procedure programming, Database Backup and Recovery, Object Orientation, Middleware Architectures, Service Oriented Architectures (SOA), Web Services, XML, SOAP, UML, CASE tools and Workflow solutions. Graduated from Regis University with a Masters Degree in Database Technologies. My goal is to attain a DBA position using my Oracle, MySQL or Postgres knowledge, helping companies leverage technology to improve business results.

EDUCATION:

January 2010 - Regis University, Denver, Colorado

July 2013 M.S. Database Technologies, GPA 3.97

At Regis, developed hands on proficiencies in the following:

Oracle Database Administration 10g/11g, including RAC and Data Guard.

Oracle Performance Tuning 10g/11g

Oracle Backup and Recovery 11g

Database Practicum using Oracle 11g, Linux, Apex and OEM

SQL and PL/SQL Programming 10g/11g

Database Design and Architectures

Middleware Architectures

August 1984 - George Mason University, Fairfax, Virginia

May 1987 B.S. Business Administration – Major: Decision Sciences (Concentration in Management Information Systems)

WORK EXPERIENCE:

September 2014 - Regis University; Denver, Colorado

Present Worked as an Affiliate Faculty in the College of Computer and Information Science at Regis University teaching the following graduate level database courses at Regis:

Database Concepts - Oracle

Database Architecture - Oracle

Oracle 12c Database Administration

Data Warehousing

Oracle PL/SQL Programming

September 2013 - PNC Bank; Pittsburgh, Pennsylvania

Present Worked as a contractor and then as an employee of PNC Bank since March of 2014, as a Senior Database Administrator, Architect, providing Oracle and MySQL database administration support to PNC Bank assisting various clients. Detailed accomplishments, responsibilities and tasks include the following:

PNC Bank (Continued)

Worked as a support DBA performing support and 24x7 on-call service for Oracle RAC and Data Guard environments and MySQL Replication typologies.

Performed performance tuning of Oracle RAC, Data Guard and MySQL databases in all environments.

Architected, installed, configured and supported MySQL 5.5, 5.6 and 5.7 in Test, QA, Production and DR environments supporting Service Now environment.

Installed, configured, troubleshooted and supported Oracle 11g and 12c RAC and Data Guard environments.

Developed MySQL installation, configuration, troubleshooting, replication failover, and DR documentation.

Setup and managed MySQL replication active master, passive master and slave environments in QA and production environments.

Setup MySQL logical and MySQL and Oracle RMAN physical backup and recovery processes on training, test, QA and production servers.

Setup and maintained monitoring and alerting of Oracle and MySQL database servers in OEM 11g and 12c, and MySQL MEM.

Developed and implemented Oracle and MySQL backup retention strategies and policies for PNC.

Developed and implemented MySQL HA and DR architectures for PNC using MHA.

March 2013 - ResolvIT Consulting; Cincinnati, Ohio

September 2013 Worked as a contractor at General Electric (GE), as a Database Administrator, Database Architect, providing Postgres, MySQL and Oracle database administration and development support to GE and their business units. Detailed accomplishments, responsibilities and tasks include the following:

Pushed production fixes and changes onto Oracle, MySQL and Postgres servers.

Performed DBMS configuration changes on Postgres and MySQL production environments.

Installed Postgres 9.1, 9.2 and MySQL 5.5 and 5.6 on internal and client servers.

Upgraded Postgres and MySQL DBMSs, performing both major and minor version upgrades.

Setup and managed streaming replication and WAL archiving between Postgres master and slave (hot standby servers).

Setup and managed MySQL replication in between MySQL master and slaves.

Setup Postgres logical and physical backup and recovery processes on client servers.

Worked as a 24/7 on-call DBA; responded and resolved Postgres and MySQL production incidents.

Performed performance tuning of MySQL and Postgres databases.

Setup and maintained monitoring and alerting of production Postgres database servers.

Developed Postgres and MySQL backup retention strategies and policies for GE clients.

Developed Postgres and MySQL HA and DR Architectures for GE clients.

Performed security audit of Postgres DBMS environment.

August 2012 - OmniTI Computer Consulting; Fulton, Maryland

February 2013 Worked as a contractor at OmniTI, as a Developer and Database Administrator, providing Postgres, MySQL and Oracle database administration and development support to OmniTI and their clients. Detailed accomplishments, responsibilities and tasks include the following:

Migrated Oracle 8i batch job stored procedures, triggers and function to Postgres 9.2 functions and triggers, and re-implemented supporting cron jobs, shell scripts and Perl modules for an OmniTI’s client.

Pushed production fixes and changes onto Oracle, MySQL and Postgres servers.

Performed DBMS configuration changes on Postgres production environments.

Installed Postgres 9.1 and 9.2 on internal and client servers.

Upgraded Postgres DBMSs, performing both major and minor version upgrades (some server configurations in a Chef environment).

Setup streaming replication and WAL archiving between Postgres master and slave (hot standby servers).

Setup Postgres backup and recovery processes on client servers

Worked as a 24/7 on-call DBA; responded and resolved Oracle, Postgres and MySQL production incidents.

Performed performance tuning of MySQL and Postgres databases.

Setup and maintained monitoring of production Postgres and MySQL database servers.

September 2011 - ResolvIT Consulting; Vienna, Virginia

August 2012 Worked as a contractor at Time Warner Cable (TWC). Database Developer/ DBA/ Architect, providing MySQL and Oracle 11g database development support to TWC on the Budget Outlook and Analysis Tool (BOAT) project. Detailed accomplishments, responsibilities and tasks include the following:

Developed and maintained automated SQL data creation and update scripts and associated stored procedures, functions and triggers to update the database in term of: internal functional, organizational and permission data and their associated archive logs.

Developed and maintained reusable stored procedures, functions and triggers supporting UI programmers on BOAT.

Developed and maintained SQL ETL scripts to load new PeopleSoft Purchase Authorization Data into BOAT, and other scripts to compare PeopleSoft Budgeting and Purchase Authorization data against BOAT data to determine discrepancies and the type of discrepancies existing between the two systems.

Evaluated MySQL 5.5 Replication vs. Clustering Architecture; then proposed replication architecture and assisted in development in replication solution and their associated test plans.

Developed foreign key integrity constraints supporting the MySQL 5.5 Replication environment using InnoDB database engine.

Developed BOAT MySQL to Oracle 11g Migration Requirements and Migration Plan.

Managed database structure changes for the BOAT database.

Evaluated and Recommended MySQL to Oracle Migration Tool.

Developed Oracle Database Migration Architecture.

ResolvIT Consulting (Continued)

Developed Oracle triggers to replace application components for Audit and Data Archiving functions.

Developed and Maintained the BOAT Entity Relationship Models (ERDs) and Data Element Dictionary.

August 2005 - Worked in clinical positions in the Healthcare field during this period, gaining clinical

October 2010 experience while attending nursing school. Pursued nursing due to my desire to help people, worked in the field for 5 years, ultimately deciding nursing was not right for me as a career. Details of each position are available on request.

August 2001 - Adams Consulting; Kamuela, Hawaii; Warrenton, Virginia; Arvada, Colorado

June 2005 Owner of Adams Consulting, which provided web development, search engine optimization and web marketing services. Adams Consulting served clients primarily in the Hospitality and Real Estate industries. Detailed responsibilities and accomplishments include:

Implemented new user interface and features on client websites, improving client services, image and customer support.

Designed, developed and maintained small databases for various clients in the real-estate, insurance and property management markets using MySQL

Developed SQL queries and stored procedures in MySQL.

Performed basic database administration tasks in MySQL, such as administering users, assigning permissions, performance tuning and backup and recovery.

Increased client sales by increasing relevant traffic to sites through search engine optimization, link popularity services, and web marketing.

Ensured the timely completion of web development and search engine optimization (SEO) projects on schedule and within budget.

March 2000 - Microsoft – MSN Search; Redmond, Washington

July 2001 Worked as an employee and contractor at Microsoft. Program Manager, provided management support to Microsoft at MSN Search. Detailed accomplishments, responsibilities and tasks include the following:

Successfully managed the implementation of operational monitoring tools, including site level, partner and international monitoring for MSN Search. These developed features improved Microsoft’s ability to identify and correct operational runtime issues.

Effectively managed the implementation of performance and proxy services to decouple providers from the MSN Search service, improving site stability.

Performed capacity planning for MSN Search, supporting the U.S., International markets environments; this enabled Microsoft to systematically build out front-end and back-end server capacity, maintaining optimum service levels to clients.

Worked successfully to manage site escalations, architecture changes, new releases and hot fixes, solving both in-house and partner issues, improving uptime and site stability.

Successfully managed operating system upgrades on production servers for MSN Search while maintaining service levels.

Successfully coordinated data center moves for MSN Search maintaining 100% uptime.

Effectively coordinated the rollout of major releases and hot fixes into the production environment at MSN Search, maintaining 100% availability during each rollout.

Implemented service level agreements with eShop, Yellow pages and Editorial groups, improving service levels provided to MSN Search.

Microsoft (Continued)

Worked on a Request for Proposal (RFP) solicited to full text search providers for MSN Search Asian markets, the awarded contract improved Search services to those markets.

November 1998 - Advanced Technology Systems; Washington, DC

March 2000 Principle Systems Analyst, worked to support the Department of Housing and Urban Development (HUD). At HUD developed business requirements and systems specifications, providing Systems Development Life-cycle (SDLC) support for the development of the Real Estate Management System (REMS). Detailed work experience included:

Successfully developed business requirements, system specifications, and conceptual and logical database modules in support of the REMS.

Effectively packaged requirements and system specification for REMS into components to deal with the challenges of changing business requirements.

Gathered the business requirements and developed integration specifications between the REMS and other departmental systems.

Performed database modeling, report development, and business logic of triggers and stored procedures, using Sybase.

Supported the programming effort, and assisted the test team in functional and system testing of multiple releases of REMS.

October 1997 - Platinum Technology; Redwood City, CA

October 1998. As a Product Specialist, provided sales support for the following Platinum products: Paradigm Plus for object oriented analysis and design; CCC/Harvest for configuration management; Process Continuum for process/project management, and ADvisor for integrated decision support of project, component and configuration management information. Detailed responsibilities and accomplishments included:

Increased sales by successfully gathering client business and technical requirements; qualifying client opportunities, and determining business cases and technical product fit based on customer requirements.

Developed and presented effective product demonstrations which were tailored to client’s business cases and technical requirements.

Provided proposal support, developing technical sections of proposals and solving client and sales staff questions and issues.

Provided product installations and short duration training support to clients.

Improved sales by educating sales staff on the business benefits of our product suite, client qualification methods and the competitive advantages of our products.

August 1996 - Accenture; Washington, DC

October 1997 Technology manager in the Utilities market unit. Management responsibilities included: project management, client reporting, personnel evaluations, mentoring and counseling. Technical responsibilities included analysis and design of existing systems and the development of new architectures to support client and market business needs. Detailed accomplishments and responsibilities were:

Effectively managed multiple engagements by delivering them on-time and within budget; implementing solutions improving clients’ business results.

Developed a web-based solution, enabling executive management to identify engagement opportunities to improve the competitiveness of Utility clients’ e-commerce solutions.

Accenture (Continued)

Successfully demonstrated web service architecture, web enabling existing Customer Information Systems (CISs) improving the competitiveness of product and service offerings.

Lead the development of a web enabled prototype of a Sales Force Automation product for the utility industry using Siebel CRM software and Oracle DBMS.

Managed the development of “As-Is” and “To-Be” enterprise technology architectures, aligning these architectures to clients’ business processes, objectives and strategies.

Performed gap analysis between “As-Is” and “To-Be” architectures, enabling clients to identify and prioritize technology initiatives to close identified gaps.

Managed the vendor evaluation of knowledge based inference engines to improve work management of distribution work crews.

July 1995 - Xerox, XSoft Division; Boston, MA

August 1996 Worked as a Solutions Consultant for the North American business sales team. Provided technical sales support for XSoft's workflow product InConcert. Supported clients in the areas of project management, Business Process Re-Engineering (BPR), workflow analysis, design and implementation of workflow based applications. Detailed tasks and accomplishes were:

Improved client cycle-times on client engagements by re-implementing business processes in a streamlined manner, using the InConcert workflow product.

Developed reusable prototype workflow applications tailored to unique client requirements using Visual Basic, InConcert and Oracle DBMS.

Increased sales by successfully translating requirements; qualifying clients, and developing business cases and technical product matches based on customer needs.

Developed and presented effective product demonstrations which were tailored to client’s business cases and technical requirements.

Provided proposal support, writing proposals, and solving client and sales staff issues throughout the sales process.

November 1993 - KPMG Peat Marwick; Washington, DC

July 1995 Worked as a management and systems consultant in the Federal Services practice at KPMG. Worked on multiple engagements providing management consulting services, and technical and development support in the following areas:

Evaluated alternative workflow solutions for the Department of Defense (DOD), providing informed recommendations to management.

Developed analysis and design specifications, including conceptual and logical database models on multiple KPMG projects, improving business processes.

Provided project management, SDLC and technical oversight support services to the Defense Logistics Agency (DLA) on the Executive Information System (EIS) project, improving project schedules and reducing risk.

Provided technical oversight of the ETL process for the DLA EIS project.

Designed, developed, and implemented Windows based client/ server features, providing critical performance indicators to the DLA EIS using Oracle and Visual Basic.

September 1990 - Siemens Nixdorf Information Systems AG; Frankfurt, Germany

November 1993 Worked as a Systems Consultant providing technical development and sales support. Worked on a development team to define an object oriented methodology and it’s supporting CASE Tool, development environment and workflow solutions, and marketed these solutions to clients. Details tasks included:

Assisted in development of an object oriented development methodology.

Siemens Nixdorf (Continued)

Defined requirements and design specifications for object oriented CASE Tool.

Developed tutorial and workshop training materials to support the training of clients, internal project staff, and software partners on the methodology and CASE Tool.

Provided training to clients, internal project staff and software partners on the methodology and CASE tool.

Implemented multiple prototypes for clients in pre and post sales cycles using Smalltalk and Sybase.

Provided technical sales support by developing and presenting various development products tailored to fit client’s business cases and technical requirements.

SUMMARY OF WORK EXPERIENCE:

Project/Program Management

UML, OMT, Booch, Jacobson Object Oriented Analysis and Design (OOA and OOD) Methodologies

Systems Requirement Analysis

InConcert and WorkParty PC – workflow management products

Relational Database Design

ColdFusion 4.0

SQL Database Programming Oracle /MS SQL Server/ Sybase / Informix/MySQL/ Postgres

Crystal Reports

Database Administration - Oracle 10 and 11g/ 12c MySQL5.1 and 5.5/ Postgres 8.5 to 9.2.2

Structured Systems Design

Business Process Re-engineering

Oracle RAC and Data Guard 11g and 12c

OOA and OOD with UML 1.0/2.0

Oracle Enterprise Manager (OEM) 10g,11g and 12c

Test Plans and Test Cases

Technical Architecture Design

Systems Documentation

Structured Programming Visual Basic 3.0 & 4.0/ VBScript/ Visual InterDev 1.0 & 6.0/ HTML3.2/COBOL/ Access

Systems Implementations

Host Communications Software 3270 Microsoft DCA

Proposal Writing

Object Oriented Programming (OOP) Smalltalk/V PM & Windows/ COM/ DCOM ActiveX/ CORBA 2.0

Users Documentation/ Systems Training

Linux/UNIX/ VMS/ Windows 2000/XP/VISTA/7

Paradigm Plus/ MooD/Rational RequisitePro OOA and OOD CASE Tools

Training Plans and Curriculums

CCC/Harvest Configuration Management Tool

Information Engineering Facility (IEF) CASE Tool

Process Continuum Process/ Project Management Tool

Technical Sales Support

LAN Administration

Database Administration - MS SQL Server/ Sybase/ Informix/ Oracle 10 and 11g

Siebel 3.0/4.0 Sales Force Automation package

ABT Project Workbench/MS Project

Development of Test Plans, Test Cases for Unit, Functional, System and Integration testing.

Software Selection/ Evaluation

Inference Engines (Rule/ Constraint)

LBMS Process Engineer (Process Management Tool)

IDEF0,1,2 Business Process and Semantic Data Modeling

RAID – Microsoft Bug Tracking

Erwin and Visio Pro Modeling Tools

Web Position Gold

WordTracker and Keyword Density Analyzer

Arelis – Reciprocal Link Software (Link Popularity)

Web Development (Visual Studio .NET)

Search Engine Optimization

Model View Controller (MVC)

Web Portal Marketing

Search Engine Marketing

SUMMARY OF EDUCATION:

Database Design

Effective Written Communications (KPMG)

Database Architecture

Oracle 10g/11g SQL PL/SQL Programming

Database Concepts

Database Administration - Oracle 11g

Performance Tuning - Oracle 11g

International Consulting Skills (KPMG)

C, C++, Java, NetBeans Programming

Object Oriented Analysis and Design Object Oriented Project Management

Structured Systems Analysis and Design

Backup and Recovery - Oracle 11g

Information Engineering Facility (IEF) CASE Tool (Texas Instruments)

Middleware and Database Applications

Simple Object Access Protocol (SOAP) Version 1.2

Extensible Markup Language (XML) 1.1

InConcert and WorkParty PC - workflow management products (Xerox and Siemens)

Sybase SQL Programming

Danish

Scrum/ Agile Methods

German

Smalltalk/V Programming

Buyer Focused Sales Training (Xerox)

Visual Basic 3.0/4.0

Delivering Client Value (Accenture)

ColdFusion 4.0

Paradigm Plus OOA and OOD CASE Tool (Platinum Technology)

Modula II Programming

Siebel 4.0 Sales Force Automation (Siebel)

COBOL Programming

AC Methods (Accenture)

Data Communication

CCC/Harvest – CM Tool (Platinum Technology)

PM Boot Camp (Microsoft)

Project Management Fundamentals (Accenture))

Contact this candidate