John Ridgway Email and Phone Number

Manage work for the retirement services business unit for database services, including the support of Oracle, Microsoft SQL Server, and Snowflake databases. Ensures database availability and preparation for disaster recovery. Ensures the team of DBAs uses CI/CD techniques to push changes out to the different environments. Support auditing SOX compliance requirements. Actively lead incident calls regarding various applications regarding database performance and data analysis. Performs root cause analysis and helps create solutions for more resilient systems. Works with business owners to bring new technologies into the company and demonstrate their value add. Collaborates with application development teams to design data solutions to leverage the technology stack most economically. Architecting, capacity planning, and testing moving an on-premise data center to a colocation data center to leverage other cloud services better.

Oracle, SQL, PL/SQL, AWS, Snowflake, ExaCC, RAC, Talend, PowerBIThe coordination point between the Retirement Services Database Area and Business, Audit, and IT areas. • Train database resources (DBAs) on environment and procedures.• Manage DBA Services Area by setting goals and incremental pathways to success.• Consult and coordinate activities to stabilize the Oracle ExaCC environment.• Coordinate and plan patching activities for ExaCC frames. • Collaborate with Audit to resolve compliance issues.• Capacity planning. • Planning migration strategy for the on-premises data center to CoLo data center.• Performance tuning on Snowflake, AWS Aurora, and Oracle.• Coordinate activities between App DBA, Cloud DBAs, and Horizontal DBAs.• Debug and problem-solve application performance issues.• Engineering solutions for ExaCC, Snowflake, and Aurora.

Oracle, SQL, PL/SQL, AWS, Snowflake, ExaCC, RAC, Talend, PowerBIFacilitate communications between multiple technical areas, including application architecture, cloud architecture, data architecture, and numerous business areas. We determined the best-suited platforms and the schema design for business data.• Triage unstable systems to find root causes and solutions.• Tuning SQL and PL/SQL from extensive knowledge of CBO and different layers of statistics. • Establish guidelines and procedures to stabilize the Oracle ExaCC environment. • Develop processes to track and determine the appropriate size of the ExaCC environment. Case example: Reduction from two 26 CPU nodes to two 10 CPU nodes. Created a path for further CPU reductions.• Finding high-resource queries in Snowflake and ways to tune them to save on production costs.• Upgrading Oracle 12c to 19c under budget and on time.• Using Oracle SQL Tuning Sets and RAC Replay to find performance issues.• Created SQL volume tester to evaluate high-velocity queries with randomized inputs. • I participated in an application modernization effort to move all on-premise application components to AWS PCF. • Helped with migration strategy planning to move on-premise Exadata to the CoLo data center.• Determined Snowflake column and query usage patterns.• Building dashboards in Snowsight for Snowflake.• Provided solutions for both legacy and new application constructs to leverage the databases to achieve not only the best performance but also the best value.• Enhanced automated monitoring of ad hoc queries. Queries with performance issues trigger an email sending proactive help and a trace to help with tuning directly to the developer.• Implemented Oracle Redaction to mask sensitive data in production environments.• Created a training curriculum for both developers and DBAs.• Led the effort to create a PowerBI dashboard for Call Center Analytics.

OCTOBER 2018 – NOVEMBER 2020SENIOR DATA ARCHITECTOracle, SQL, PL/SQL, AWS, Snowflake, Goldengate, ExaCC, RAC, Talend, PowerBI, Cassandra (NoSQL)They were using technical expertise and business knowledge to architect high-performance solutions. They migrated a 20-year Oracle reporting platform to Snowflake to allow customers near-instant access to reporting. The new platform and schema design yielded higher performance and a lower cost of ownership. Designed solutions leveraging existing Oracle infrastructure bridged with a cloud-based rules engine (Drools) to handle vesting calculations.• I led the technical team in moving the reporting workload from Oracle to AWS/Snowflake using S3, Talend, and PowerBI.• Made enhancements to query and application monitoring on Oracle to give real-time alerts with full traces to support teams.• POC involving Oracle Goldengate and Snowflake pipelines to apply real-time data changes.• Performed diagnostics and resolutions to issues with migration from Oracle to ExaCC (Exadata).• Creation of replication framework between Oracle instances to sync data quickly and easily configurable.• Worked with project teams to deliver KPIs via Cassandra NoSQL database.

Oracle, SQL, PL/SQL, CI/CD - GitHub, Datical, JenkinsMy primary role was as a consulting database administrator, doing database performance tuning, change management, and plotting future database strategies. I have participated in projects helping design and perform custom in-house applications. The applications ran on various platforms, including fat client, web, SSRS reports, Cognos, Talend, and Hadoop. Became the go-to person for application and business knowledge because of my involvement in various applications serving multiple business units. • Create an ETL/ELT framework in Oracle PL/SQL to ingest tens of millions of rows of data in a cycle window of only an hour.• CI/CD Oracle code pipelines using Github/Jenkins/Datical.• Creating an automated system that monitors nightly ETL jobs and manages corrective actions.• Creation of a monitoring and alert system for batch jobs and queries.• Created coding standards for SQL and PL/SQL• SQL and Database performance specialist.

Oracle, SQL, PL/SQL Designed and implemented a data factory in Oracle to ingest data from multiple sources. The Data Factory published data to downstream OLTP systems but acted as a traditional Data Warehouse. They migrated many of the mainframe reporting processes to Oracle. They created a reporting system for group clients to run and retrieve reports. They made a job scheduling system that controlled all aspects of process dependencies and ran processes to the database. • Data Factory – over 800 tables, 5 TB, Transactional table with 5.5 Billion rows in the most enormous table.• Lead a team of developers for the construction of the data factory.

Cobol, IMS, SybaseDesigned and created a standard remitter system in Sybase that was integrated with a mainframe Cobol admin system.

Cobol, Easytrieve, IMS, DB2, Sybase, VBSupported and modified mainframe administration system. Supported mainframe premium application and designed a replacement system in Sybase. Worked on a new DB2 compensation system and was responsible for tuning the batch processes from 12+ hours to 20 minutes. Developing new reporting platforms to migrate mainframe reporting to open systems via data gateways.