John K. Email & Phone Number

Phoenix, Az, Us

Reston, Virginia, Us

Westlake, Texas, Us

Develop and manage cybersecurity operations tools, including configuring and maintaining Chronicle and Splunk SIEM (Security Information and Event Management) platforms.In BigQuery developed RBA (Risk based analysis) system taking many low-risk SIEM findings to produce SOC alerts.Use Bigquery for ETL, data analytics, building datamart and reporting.Develop full stack web apps using various technologies.Implement Agile processes, particularly using JIRA by facilitating story writing, sprint planning, backlog grooming, and ensuring smooth project execution through Agile methodologies.

New York, Ny, Us

Implement, configure, tune Guardium database activity monitoring (DAM) for mainframe systems.Perform analysis of results.

New York, New York, Us

Provide leadership in design, implementation, integration, administration and management of Oracle, SQL Server, MySQL, Cassandra and Hadoop database technologies. Develop architecture detailing appropriate usages for various data storage technologies. Develop Oracle database strategy including 12c version upgrade, evaluate and recommend additional Oracle Enterprise Edition options/features relevant to company’s environment. Provide strategic direction, evaluation and recommendation of overall database technology strategy and roadmap to influence IT decision making. Maintain database architectures to ensure performance, availability, integrity and security of databases. Identify, evaluate and recommend hardware and/or software technologies to achieve desired database performance. Proactive database performance monitoring and capacity utilization to provide database high availability and redundancy. Provide mentoring regarding database architecture and administration. Installed, configured and migrated existing database (11g) from 10 node Solaris platform to 8 node cluster Exadata X2-2 with zero down time using RMAN and Goldengate. Perform Exadata database machine administration and Oracle database administration.Migrated and upgraded 10g databases to Exadata running 11g using Data-Pump. Installed, configured and use Oracle Enterprise Manager 12c for monitoring Exadata machines and databases.Restructured and optimized database increasing performance.

Blue Bell, Pennsylvania, Us

Architected and implemented Backup/Recovery strategy using ZFS appliance backup to disk using incremental merge as well as tape system.Migrated and upgraded Oracle version 9i and 10g to 11g databases using RMAN and Data-Pump.Directed the upgrading of 24 node cluster Exadata V2Implemented several security improvementsReorganized multi-tier storage architectureArchitected resource management for ExadataManaged extensive Exadata patching/upgrade

London, Gb

Managed team of ten Database Administrators- Implemented several Oracle 10g/11g RAC clusters on IBM AIX 5.3 and Red Hat Linux- Developed Oracle 10g RAC architecture and standards.- Migrated Oracle 9i databases to 10g RAC using ASM and 10g to 11g.- Integrate the components of SX into Oracle Cluster ware providing a highly available architecture with monitoring, restart, and failover to alternate nodes. Added additional nodes to existing grid.- Database administration for the Oracle RDBMS (11g, 10g, 9i). Installed Oracle software, applied patches, performed upgrades, established physical file layout. Monitored systems, performed troubleshooting and database/application performance tuning and optimization.- Performed backup and recovery task via RMAN.- Participated on 24x7 rotating on-call environment.- Obtained security clearance and worked with classified data on secured systems using Oracle Database Vault.- Oversaw database auditing procedures and processes SOX and SAS 70 which included controls to insure compliance with all regulatory requirements including HIPAA for Oracle, DB2 SQL-Server and Sybase databases.

Implemented multiple Oracle 10g clusters running Redhat Linux for development, testing, and production as one of ten 10g Early Adoption Program companies that will be presented at Oracle World 2004.Implemented Grid Control / OEM 10g.Tested and implemented new 10g features: ASM (Automatic Storage Management), AWR (Automatic Workload Repository), ADDM (Automatic Database Diagnostic Monitor & SQL Tuning Advisor), Automatic Segment Management, Automatic Shared Memory Management, Flashback Versions Query.Oracle Database administration. Installed Oracle software, created instances, applied patches, performed upgrades, established physical file layout, created tables, indexes, triggers, and packages using PL/SQL. Created roles and administered user access and security. Monitored systems, performed troubleshooting and database/application performance tuning and optimization. Performed backup and recovery tasks.24x7 rotating on-call environment.

Independence, Oh, Us

Database administration for the Oracle RDBMS (9i, 8.i). Installed Oracle software, created instances, applied patches, performed upgrades, established physical file layout, created tables, indexes, triggers, and packages using PL/SQL. Created roles and administered user access and security. Monitored systems, performed troubleshooting and database/application performance tuning and optimization. Performed backup and recovery tasks.Implemented multiple Oracle 9i RAC clusters using OCFS on Redhat Linux for development, testing, and production. Completely setup servers from installing OS, setting kernel parameters, to setting up user accounts and permissions.Migrated from 8i on Sun/Solaris to 9i RAC on Redhat Linux.Administrated production databases, as well as development versions.Performed logical and physical data modeling, normalization/denormalization. Translated business requirements (rules) into creation of database objects: tables, indexes, constraints,triggers, stored procedures, packages, and materialized views.Performance tuned key application OneStep resulting in over a 10x increase in throughput by tuning Linux system parameters, utilizing IOT (index organized tables), hash partitioning, application server connection pool tuning, and PL/SQL code modifications.Designed and developed data warehouse for actuarial analysis.24x7 on-call environment.

Developed stored procedures, triggers, and packages in PL/SQLDeveloped extensively SQL and PL/SQL code that produced and processed XML.

Directed the following groups: information infrastructure, application development, information operations, and telecommunications.Information Infrastructure involved the managing of servers, storage, networking, and all connected devices including desktop, laptops, and printers. This included system administration and Oracle database administrationApplication Development covered responsibility for the company's core operational software. This included accounting, order entry, distribution, purchasing, inventory, and manufacturing. Oracle tools were used for developing user forms and reports.Telecommunications involved managing voice and data telecommunication for multiple sites consisting of phone switches, voice mail, internet connectivity, web site hosting, EDI, cell phones, and local/long distance/toll free phone service contracts.Database administration for the Oracle RDBMS (8.x, 7.x, 6.x). Installed Oracle software, created instances, applied patches, performed upgrades, established physical file layout, created tables, indexes, triggers, and packages using PL/SQL. Created roles and administered user access and security. Monitored systems, performed troubleshooting and database/application performance tuning and optimization. Performed backup and recovery tasks.Performed logical and physical data modeling, normalization/denormalization. Translated business requirements (rules) into creation of database objects: tables, indexes, constraints, triggers, stored procedures, packages, and materialized views.Integrated the Oracle database with internal shop floor systems using SQL*Loader, SQL*Plus, and ODBC. Exchanged data via email, ftp, and EDI with external organizations including vendors, customers, and government agencies.

Global, Us

Designed the logical schema, established relational dependencies, and implemented the physical database.Performed database administration for the development and test version of the database.Handled specification review, documentation requirements, and version control. Produced and published E/R (entity/relationship) diagrams.Developed encryption algorithm password security.

Bs, Computer Science

Bs, Computer Science