Peter C. King

603-***-****

SUMMARY:

** ***** ** ********** ********** and implementing Oracle database applications

Thorough understanding of Design, Development and implementation of Data Warehouse, including database normalization, Star-Schema, Facts and Dimensions

Developed Database Objects, Tables, Functions, Procedures, Views, Materialized Views

Developed and Deployed Custom Databases for Federal Government, DoD Contracts, Municipalities, Biotechnology, Computer Engineering, Accounting, and E-Commerce Clients

Designed and developed Annual Reports using Cognos Impromptu and OBIEE

Integrated Databases for 16 Departments using Heterogenous Services, APEX, and BI Publisher

25 years of experience implementing IBM Informix Online Engine and Standard Edition

15 years of development with 4GL, HTMLDB, APEX 5.0 APEX 5.1, J2EE, Dreamweaver

Experience with 4Js and Genero Informix Database Client/Server, CityView, HTMLDB

Installed and configured servers ESRI SDE and other 3rd party database applications

Extensive experience with Cognos Impromptu 7 and Oracle Business Intelligence reporting, including OBIEE and BI Publisher, and ad-hoc reporting with SQL Developer, SQL, SQL Plus

Expert understanding of Microsoft Access, Excel, and Open Database Connectivity ODBC

Extensive use of FTP, SFTP, SSH, DOS, PuTTy, UNIX, and Linux Command Line

Excellent understanding of Database Architecture, Design, Implementation and Testing

Excellent experience working with web technologies like HTML, HTMLDB, JavaScript, CSS

Extensive programming experience in Database technology, including ODBC, JDBC, Javascript

Hands on knowledge & experience in Business Intelligence, OBIEE 10G, 11G

Solid experience with Database Connectivity 3-tier, ODBC, JDBC, tnsnames.ora and listener.ora

Excellent understanding & hands on experience in reading complex data models

Developed and Deployed Java WAR files and JAR files to Weblogic Server

Installed, secured, and configured AWS cloud servers and Amazon AWS virtual servers (Linux)

Installed and deployed Oracle 11g, 12c, 13c database setup and maintenance on Oracle Cloud

Excellent working knowledge in database security and role-based security using Active Directory

Hands on experience in deploying web and J2EE enterprise applications on Apache Tomcat, Application Server 9i, WebLogic 10g, 11g, 13c Application Servers

Knowledge and hands-on experience with SSL/TLS Certificates on J2EE Servers

Configured Load Balancers and Oracle Traffic Director OTD for SSL and DNS

Extensive use of methodologies like Agile, Scrum and Waterfall

Experience with Linux Bash Shell Scripting, CRON jobs, WinSCP, Putty, SSH/TLS

Extensive experience in Unix, LINUX and Windows Server Command Line

Outstanding communication and inter-personal skills

Exceptional analytical and problem-solving skills

TECHNICAL SKILLS:

Languages

Java, SQL, PL/SQL, 4GL, HTMLDB

J2EE Technologies

APEX, JAR, WAR, JDBC, Java Security, SSL/TLS Encryption, Hash Algorithms

Mark-up/XML Technologies

HTML5, JavaScript, CSS, XML, JQuery, JSON

Tools & Framework

SQL Plus, SQL Developer, ORDS Rest Data Services, Putty, PuTTyGen, SFTP

Web services

SOAP, Restful, ORDS, FTP, SFTP

Web/App Servers

Application Server, Weblogic Server, Glassfish, ORDS J2EE & Standalone

Database

Oracle 8i, 9i, 10g, 11g, 12C, SQL-Server, IBM Informix, MS Access, Pervasive

Database Integration

Integrated Oracle, Informix, Pervasive, SQL Server, Excel, and Access

Modeling/ CASE Tools

Oracle BI Repository, Visio, Microsoft Project

Testing Tools/ Others

ORDS, Putty, SQL Plus, SQL Developer, FTP, SFTP

OS & Environment

Windows, Sun Solaris, UNIX, Linux, Firewall, DNS, SSL, AD, LDAP

Professional Experience:

Jan 16 - Present

KIllerDB, L.L.C.

Role: Owner, Project Manager, Database Developer

Description: Custom Database Development, and Cloud Services

Responsibilities:

Involved in all phases of development using SQL and PL/SQL, APEX, J2EE, DBaaS, JCS

Master of Development of the User Interfaces using HTML, CSS, APEX, Javascript

Wrote Stored Procedures and complicated queries for Oracle 11g and 12c

Created tables, triggers, stored procedures, SQL queries, joins, integrity constraints and views for multiple databases, primarily Oracle using SQL Developer tool.

Installed, secured, and configured AWS cloud servers and Amazon AWS virtual servers (Linux)

Experienced working with database setup and maintenance on Oracle Cloud Services

Involved in Bug fixing of various modules that were raised by the testing teams in the application during the Integration testing phase.

Implemented PL/SQL procedures and views in Oracle SQL Developer, and SQL Plus

Debugged for Errors, using debug tool, SQL and PL/SQL

Performed deployment of applications on Oracle Weblogic Application Server.

Worked on UNIX, Linux environment for development

Environment: Java, HTML, CSS, JavaScript, JQuery, XML, SOA, RESTful Services, Oracle Java Cloud Services, DBaaS, SaaS, JCS

June 1998 – Sept 2015

City of Keene, NH

Role: Database Administrator

Description: Managed implementation of Enterprise Database Applications for 16 departments. Fund Accounting, Revenue Collection, Payroll, HR, Purchasing, for Fire, Police, City Clerks, Code Enforcement, Health Inspections, Airport, Public Works, Planning, Emergency Management, Emergency Operations Center (EOC), City Council, City Manager, Finance, IT, IMS, Facilities, and Engineering

Managed UNIX Servers, hardware upgrades, Sun Solaris, HP-UX, SANS Migrations, Windows Server NT, 2000, 2003, 2008, 2012, Developed Annual Reports, Finance, HR, Payroll, A/P, A/R, Utility Billing, Expenditure and Revenue YTD Status Reports, Ad-Hoc Reports, Client Software, and Database Connectivity. Developed database applications in Oracle 8i, 9i, 10g, 11g, 12C

Responsibilities:

Responsible for database development and database applications implementations

Installed and integrated 3rd party database applications, GIS, AA, CAMA, Tax, Utility Billing

End-to-end Project Management, including customization of product based on the department requirements, meeting delivery deadlines on development, testing, implementation phases of the system and consulting providers, 3rd party integration, and custom modifications

Used IIS, Apache, APEX, and Application Servers to generate web pages

Designing and editing GUI with Drupal, Adobe, HTML, OBIEE, BI Publisher

Deployed applications in J2EE using Oracle Weblogic Server

Managed Architecture, design and development of Custom and 3rd Party Database Applications

Developed Public and Private web applications using Sungard, Informix, Oracle Database Server, ESRI GIS Server (Maps), Cognos Impromptu, Oracle OBIEE and BI Publisher

Managed roles and permissions of users with LDAP and Active Directory

Created Packages, Stored Procedures, and Functions, using PL/SQL and SQL Developer

Integrated database applications using CSV, FTP, ODBC, JDBC

Built Data Warehouses in BI Repository using Star Schemas, Facts and Dimensions

Managed Network Connectivity and DB links to multiple database servers

Conduct knowledge sharing sessions among the team members in technical areas

Environment: Java, J2EE, HTML, CSS, Javascript, REST Data Services, Oracle Client, Informix Client 4Js and Genero, SDE Server, GIS Server and GIS Desktop, SQL, SQL Plus, SQL Developer, iSQL

January 2002 – July 2015

Town of Peterborough

Database Consultant

Description: Managed UNIX Servers, hardware upgrades, SCO and Windows Servers, Database Applications, Developed Annual Reports, Finance, HR, Payroll, A/P, A/R, Utility Billing, Expenditure and Revenue YTD Status Reports, Ad-Hoc Reports, Client Software, and Database Connectivity

Responsibilities:

Responsible for database development and database applications implementations

Installed and integrated 3rd party database applications, GIS, AA, CAMA, Tax, Utility Billing

End-to-end Project Management, including customization of product based on the department requirements, meeting delivery deadlines on development, testing, implementation phases of the system, working with consultants, and 3rd party providers, and custom modifications

Responsible for database integration with banks, mortgage companies, and lock box services

Used IIS, Apache, APEX, Weblogic Server, and Application Server to build web applications

Designing and editing Annual Reports with Cognos Impromptu

Managed Architecture, design and development of Custom and 3rd Party Database Applications

Developed Public and Private web applications using Sungard, Informix, Oracle Database Server, ESRI GIS Server (Maps), Cognos Impromptu, Oracle SQL Developer

Integrated database applications using CSV, FTP, ODBC, JDBC, Client Server

Managed Network Connectivity and DB links to multiple database servers

Conduct knowledge sharing sessions among the team members in technical areas

Environment: Java, J2EE, HTML, CSS, Javascript, REST Data Services, Oracle Client, Informix Client 4Js and Genero, SDE Server, GIS Server and GIS Desktop, SQL, SQL Plus, SQL Developer, iSQL

December 1993 – June 1998

NewBank, Inc.

Process Mapping Administrator/Systems Administrator/Database Administrator

Description:

Responsibilities:

Responsible for Oracle Financials Applications implementation, database development, client software configurations, and Ad-Hoc Reporting using Cognos Impromptu

MAPP – Make a Process Productive Coordination and Administration

Convert Electronic Publisher from Microfilm/Microfiche to CD-ROM and WEB

June 1984 – Sept 1991

Halifax Engineering Corporation

Field Engineer/Project Manager

Responsibilities: Computer Services Contracts with US Army Corps of Engineers, Rockwell/Rocketdyne, U.S. Naval Oceanographic Office, U.S. Air Force, DoD, U.S. Naval Air Command, and various DoD, and other Departments and Agencies in the Washington DC area

Responsibilities:

Management of Fixed Price and T&M Computer Services Contracts. Hardware and Inventory Database for 20,000 Computers at the Pentagon, Stennis Space Center, Michoud Space Shuttle Assembly Facility (Main Tank)

June 1989 – June 1994

Pan Am World Services/Range and Test Services National Space Technology Laboratories (NSTL)

Stennis Space Center MS

Electronics Technician/Field Engineer

Responsibilities: Support for NASA, Rockwell/Rocketdyne Space Shuttle Main Engine Test Facility. Electronic Communications, Power, Control, Lighting, Video, Liquid Hydrogen, Liquid Oxygen, and Nitrogen Pressure, Control and Instrumentation, Emergency Backup Power

Contact this candidate