Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

JOHN RIDGWAY

Houston,TX

Summary

Experienced with managing intricate database environments to ensure peak performance and reliability. Utilizes SQL optimization and performance tuning techniques to support business needs. Track record of implementing high-availability solutions and robust data security measures to safeguard critical information.

Overview

25
25
years of professional experience
1
1
Certification

Work History

Assistant Vice President II

Corebridge Financial
11.2024 - Current
  • Role: Senior Oracle DBA - Database Engineering
  • Set standards and policies for security, consistency, and auditability for databases across MS SQL, Oracle RDS, Oracle Exadata, Snowflake, and Aurora (Postgres).
  • Evaluating Autonomous Database (ADB) use and identifying use cases from the database catalog.
  • Scheduling and coordination of patches.
  • Scheduling and coordination of DR activities using Dataguard and secondary CoLo location.
  • Created a strategy for moving to the ExaCC frame located within AWS.
  • Application tuning. For example, ALIP extract cycle went from 4 hours to less than 1 hour. Use of OEM, AWR, Parallelism, SQL Profiles, SQL Plan Manager, Stats, Extended Stats, and Histograms.
  • Centralized database account setup by integration of Sailpoint tool to administer 100 Oracle databases. Use of PL/SQL, application design, dbms_scheduler

Assistant Vice President II

Corebridge Financial
09.2022 - 10.2024
  • Role: Senior Oracle DBA - Database Operations
  • Build out a DBA operations team of 12 resources supporting Oracle, MS SQL Server, Snowflake, Aurora Postgres.
  • Organized team activities via Jira and KanBan.
  • Set up knowledge stores on Confluence to capture and standardize processes.
  • Trained and mentored team members on how to do database diagnostics and triage.
  • Upgraded the Oracle databases to 19c.
  • Migrated the Oracle database to an ExaCC X9 in a CoLo to move out of a private data center.
  • Created a real-time syncing database between the vendor’s site and our CoLo utilizing Oracle’s materialized view replication.
  • Developed methodology in conjunction with Oracle Services to do large scale testing of thousands of SQL queries to identify degraded SQL. This later became standard for Oracle with its other clients. Use of SQL Tuning Sets, Database Clones, OEM, SQL Tuner.
  • Conducted and Reviewed SOX auditing.
  • Scheduling and coordination of patches.

Assistant Vice President II

AIG Retirement Services
01.2018 - 08.2022
  • Role: Senior Oracle DBA
  • Migrated Oracle databases to be multi-node RAC on ExaCC X7.
  • Worked closely with setting up the AMS (application management services) teams so that they could effectively respond to issues.
  • Respond and participate in P1/P2 support calls for application performance issues.
  • Trained both application and DBA resources.
  • Implemented Oracle redaction to safeguard PII data.
  • Implemented new standards to stabilize and make future Oracle upgrades easier. Using auto stats gathering and other newer automated features. Identify and remove customized database parameters.

Consulting DBA

AIG Retirement Services
01.2005 - 12.2017
  • Roles: Senior Oracle DBA/Application Technical Lead
  • Sponsorfit project – Moved report workload originally designed against Oracle database to using Snowflake in AWS. Reports went from overnight batch generated to being viewable in less than 5 seconds. Created a series of dashboards to serve up retirement plan metrics for employers. Use of Oracle, Snowflake, Cassandra, Talend, and PowerBI.
  • Out of Balance detection (OOB) – Created a process that verifies every account fund combination balance with transactional activity.
  • Business Event Management (BEM) – Tied together actions in disparate systems to show real-time flow of disbursement information.
  • Performed the Oracle 12c upgrade from Oracle 11r2.
  • Identification and solution for processes that have become degraded.
  • Technical design for Valic Online, Valic Online Mobile, Plan Sponsor, Agent Data Store, Contact Data Store, Beneficiary Management
  • Help create a DevOps CI/CD framework utilizing Liquidbase, Jenkins, GitHub, and Artifactory to push out changes for Oracle.
  • Conducted training for developers on best database programming techniques and how to debug, tune, and trace.

Consulting Programmer Analyst

AIG Retirement Services
01.2000 - 01.2005
  • Designed and created an Operational Datastore (Lighthouse) that links the legacy mainframe admin system and the Oracle open system web application framework. 800 tables, 10 TB.
  • Created custom job system using dbms_scheduler to control the execution of 2000 processes. System was capable of notifications and automatic restarts.
  • Performed code rewrite of the premium intake system (Retirement Manager) to reduce its average file process time from 10 minutes to less than 30 seconds. Use of Set Theory, Bulk processing techniques, and SQL Loader.
  • Created data structures and procedures to present financial transaction information to clients accurately.

Education

Bachelor of Business Administration - Management Information Systems

Texas A&M University
College Station, TX
12.1992

Skills

  • Oracle 8i – 19c, Exadata X7, X9, ExaCC, RAC, Multi-node databases

  • Snowflake, Sybase, MS SQL, Aurora Postgres, Cassandra, IMS, DB2

  • SQL, T-SQL, PL/SQL, Bulk Operations, SQL Loader

  • Dbms_scheduler, dbms_sql, dbms_sqltune

  • Oracle Unified Auditing

  • OEM, AWR, SQL Profiles, Stats, Histograms, SPM, Dynamic CPU Scaling

  • Oracle database clones

  • Oracle Dataguard

  • Oracle Autonomous Databases (ADB) – familiar with limitations

  • Oracle Golden Gate – used in a POC

  • Talend

  • Warehouse Design and Architecture, ETL, ELT, capacity planning

  • Jira, Confluence, Kanban

  • SQL query optimization

  • Database troubleshooting

  • Data modeling techniques

  • Data integration strategies

  • Agile methodology

  • Relational database management

  • Data privacy compliance

  • Data audits

  • ETL process development

  • Continuous integration and deployment

  • Data warehousing solutions

  • Query execution plans

  • Data testing

  • Performance monitoring tools

  • Problem-solving

  • SQL programming

Certification

  • Agile Basics
  • AWS Cloud Basics
  • Snowflake Hands-on Essentials – Data Warehouse Certification

Timeline

Assistant Vice President II

Corebridge Financial
11.2024 - Current

Assistant Vice President II

Corebridge Financial
09.2022 - 10.2024

Assistant Vice President II

AIG Retirement Services
01.2018 - 08.2022

Consulting DBA

AIG Retirement Services
01.2005 - 12.2017

Consulting Programmer Analyst

AIG Retirement Services
01.2000 - 01.2005

Bachelor of Business Administration - Management Information Systems

Texas A&M University

Similar Profiles

CREATE PROFILE