John K.

John K. Email and Phone Number

Lead Technical Specialist @ Advanced Information Technologies, LLC
Phoenix, AZ, US
John K.'s Location
Greater Phoenix Area, United States, United States
John K.'s Contact Details
About John K.

Information Technology professional with extensive experience in a variety of industries having broad expertise in several areas and technologies including: Managing and supervising IT departments and staff. Skilled in finding the best return on investment of IT budget. Skilled in relating with both technical and non-technical personnel to maintain communication. Creating and administrating Oracle databases for development, testing, quality assurance, and high performance production environments. Exceptional record of performance tuning at the database, server, SQL, and application level. Oracle instance creation, configuration, administration, monitoring, and performance tuning to provide the highest availability and responsiveness possible while maintaining security, accessibility, and data integrity. Vast experience of Oracle in 24x7 production environments as well as supporting development and testing environments. Several years of experience with Oracle Exadata V2 and X2-2. Experienced in backup and recovery procedures. Performed numerous database migrations, consolidations, and upgrades using Imp/Exp, Data-Pump, and RMAN. Installation of Oracle software, applying patches, performing version upgrades, and migrated between different hardware architecture and operating systems. Experienced in Goldengate, Data-Guard, Delphix and Guardium. Extensive programming experience in PL/SQL. Communicates clearly and comfortably with individuals of differing knowledge, experience, and levels of responsibility. Translates technical information or business goals to individuals not accustomed to dealing with those topics ranging from plant workers to managers to executives to members of the board of directors. Often facilitates discussions by minimizing misunderstandings and focusing on common objectives. Team experience as both a member and leader focusing on cooperative efforts with all members facilitating cross discipline discussions and solutions.

John K.'s Current Company Details
Advanced Information Technologies, LLC

Advanced Information Technologies, Llc

View
Lead Technical Specialist
Phoenix, AZ, US
John K. Work Experience Details
  • Advanced Information Technologies, Llc
    Lead Technical Specialist
    Advanced Information Technologies, Llc
    Phoenix, Az, Us
  • Amyx, Inc.
    Database Developer
    Amyx, Inc. Jul 2024 - Present
    Reston, Virginia, Us
    View
  • Charles Schwab
    Sr Information Security Engineer
    Charles Schwab Apr 2017 - Jul 2024
    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.
    View
  • American Express
    It Info Security Specialist
    American Express Apr 2015 - Apr 2017
    New York, Ny, Us
    Implement, configure, tune Guardium database activity monitoring (DAM) for mainframe systems.Perform analysis of results.
    View
  • Pegasus Solutions
    Lead Database Architect / Exadata Administrator
    Pegasus Solutions Mar 2012 - Feb 2015
    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.
    View
  • Wolters Kluwer Pharma Solutions
    Lead Database Architect
    Wolters Kluwer Pharma Solutions Apr 2011 - Mar 2012
    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
    View
  • Coventry Health Care, An Aetna Company
    Database Consultant (Team Lead)
    Coventry Health Care, An Aetna Company Dec 2004 - Apr 2011
    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.
    View
  • Ohio Savings Bank
    Lead Oracle Dba
    Ohio Savings Bank May 2004 - Dec 2004
    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.
  • Bristol West Insurance
    Lead Oracle Dba
    Bristol West Insurance Oct 2002 - May 2004
    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.
    View
  • Ohio Savings Bank / Amtrust
    Pl / Sql Developer
    Ohio Savings Bank / Amtrust Nov 2001 - Oct 2002
    Developed stored procedures, triggers, and packages in PL/SQLDeveloped extensively SQL and PL/SQL code that produced and processed XML.
  • Superior Dairy
    Manager It Systems
    Superior Dairy Oct 1990 - Aug 2001
    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.
  • Csc - Computer Sciences Corporation
    Database Specialist
    Csc - Computer Sciences Corporation 1988 - Oct 1990
    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.
    View

John K. Skills

Goldengate Hardware Architecture Patch Management Pools Corrective Actions Infrastructure Insurance Vendors Exadata Rdbms Oracle Forms Cost Oracle Database Grid Computing Rman Oracle Rac System Upgrades Refreshes Streams Iot Executive Positions Multiple Sites Indexes Performance Tuning Addm Savings Adoption Exp Database Applications Non Technical Database Architecture Facilitation Business Requirements Clusters Database Triggers Databases Accessibility Connected Devices Gateway Management Design Olap Computer Science Security Shop Floor Desktop Computers Odbc Storage Architecture Integration Data Backup Version Control Pegasus Database Administration Rules Dealing Auditing Data Storage Monitors Database Security Hosting Sql*plus Accounting Linux Algorithms Human Resources 6.x Zfs Ibm Aix Awr Sae Networking Data Guard Node Sun Microsystems Troubleshooting System Telecommunications Cell Disciplinary Staff Management Data Recovery Healthcare Responsiveness Layout Voice Switches Oracle Dba Team Leadership Reports Strategy Red Hat Linux Supervision Inventory Variety Of Industries Merge Consolidation Cooperative Data Modeling Xml Tables Toll Free Testing Encryption Imp Edi Disk Pl/sql Disaster Recovery Sla Printers Actuarial Science Solaris Scheduling Documentation Informatics High Availability Administrating System Monitoring Flashback High Performance Computing Board Of Directors Analysis Shell Scripting Constraints Materialized Views Information Technology R Physical Data Modeling Appliance Platinum Ad Hoc Reporting Sql Loader C 24x7 It Infrastructure Design Configurations Operating Systems Query Writing Logistics Applications Hipaa On Call Debate Long Distance Communication Resource Management Stored Procedures System Administration Vast Quality Assurance Regulatory Requirements Operations Logic Programming Government Agencies Repository Ohio Technical Information Oracle Database Administration Partition Ocfs Bill Of Materials Permissions Failover Project Planning Security Clearance Sarbanes Oxley Act Sql Oltp Oracle Developer Suite Programming Experience Ftp Empathy Tape Database Design Data Integrity Vldb Guardium Unix Data Migration Laptops Servers Responsibility Internal Audit Habits Usa Storage Management Phoenix Distribution Data Warehousing Purchasing Code Google Groups Oracle Enterprise Manager Normalization Army Software Installation Dba Shared Memory Forms Gold Investments Alternate Connectivity System Design Hp Ux Diagnostics Software Dairy Performance Reviews Sas Oracle Compliance Cluster Kernel Throughput Manufacturing Internal Controls Vault Voice Mail Budgets 10x Optimization Specification Review Cpoe Problem Solving Software Development Meetings Diagrams Delivery Automatic Mrp Architecture Schema Oracle Asm Dbms

John K. Education Details

  • Purdue University
    Purdue University
    Computer Science
  • Indiana University Indianapolis
    Indiana University Indianapolis
    Computer Science

Frequently Asked Questions about John K.

What company does John K. work for?

John K. works for Advanced Information Technologies, Llc

What is John K.'s role at the current company?

John K.'s current role is Lead Technical Specialist.

What is John K.'s email address?

John K.'s email address is jm****@****ail.com

What schools did John K. attend?

John K. attended Purdue University, Indiana University Indianapolis.

What skills is John K. known for?

John K. has skills like Goldengate, Hardware Architecture, Patch Management, Pools, Corrective Actions, Infrastructure, Insurance, Vendors, Exadata, Rdbms, Oracle Forms, Cost.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.