John K.
Education:
BS
Computer Science
Purdue University
1982 : 1990
BS
Computer Science
Indiana University–Purdue University Indianapolis
1982 : 1990
Experience:
2017 : Present
Charles Schwab
Sr Information Security Engineer
2015 : 2017
American Express
IT Info Security Specialist
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.
2012 : 2015
Pegasus Solutions
Lead Database Architect / Exadata Administrator
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 V2
Implemented several security improvements
Reorganized multi-tier storage architecture
Architected resource management for Exadata
Managed extensive Exadata patching/upgrade
2011 : 2012
Wolters Kluwer Pharma Solutions
Lead Database Architect
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.
2004 : 2011
Coventry Health Care, an Aetna Company
Database Consultant (Team Lead)
Company: Charles Schwab
Years of Experience: 36
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.