Cathy Carr, Senior Oracle Database Administrator

Address: ** ***** **. ******* ** 03449 • Cell Phone: 201-***-**** • Email:ad3g3t@r.postjobfree.com Key Skills

Oracle, PostgresSQL and MS SQL Server DBA. Database technical support engineer. Oracle GoldenGate expert. Oracle APPS DBA. Developer for SQL, PL/SQL and Shell scripting. Database design, modeling, problem analysis, and tuning.

Professional Experience

Sep 2021 – Present • Oracle Corporation • Nashua NH Sr. Oracle Database Administrator

Created Automatous databases (ATPs) and migrated data from Oracle on-premise databases to the Autonomous databases through export/import tool, and also testing the Oracle GoldenGate service for ADW database migration. Used GitLab pipelines to provision Autonomous databases on Kubernetes. Built the multi-tenant secure Oracle 19c database with TDE and TLS implementation, also built its HA/DR system. Migrated major production database from PostgreSQL to Oracle database in Oracle Cloud using Oracle GoldenGate. Setup system configuration, database configuration, and secure network configuration for the migration. Developed PL/SQL scripts and Shell scripts for sensitive data scrub. Worked as a PostgreSQL DBA. Mentored Junior engineers. Oct 2018 – Aug 2021 • Eagle Investment • Wellesley MA Sr. Oracle Database Administrator

Supported 90+ major investment firms for their accounting databases. Performed RMAN backup and recovery, HR/DR system setup, GoldenGate system setup for data streaming from Oracle database to MS SQL Server database, database refreshes and rebuilds, database performance tuning, SQL tuning and shell scripting. Mentored Junior engineers. Jan 2007 – Oct 2018 • Oracle Corporation • New York, NY Principal Advanced Support Engineer

Worked in Oracle ACS (Advanced Customer Support) for 11 years. Provided on-site support for Oracle clients, such as Bank of New York/Mellon, American Eagle Outfitters, Federal Reserve, IRS, Fidelity, etc. Later provided technical support through Service Request (SR) Ticket system. When customers open SRs, we collected information through phone calls and remote screen shares, then resolved the issue through research and analysis.

July 2006 – Jan 2007 • Core Services, Inc. • Union, NJ Senior Oracle APPs DBA

Tested the setup of Oracle RAC system in Oracle 10g. Performed RAC failover test. Handled all performance issues at OS level, database level as well as application level. Upgraded and troubleshot Oracle discoverer.

October 2002 – May 2006 • Smiths Medical ASD, Inc. • Keene, NH Oracle APPs DBA

Supported and resolved all issues for the global Oracle application system which was using Oracle 10g database, 11.5.10 E-business suite and HTTP Sever. Upgraded Oracle application from 11.5.7 to 11.5.9. Upgraded production database from version 10g to 11g. Performed application cloning and applied patches in a shared APPL TOP of the middle tier. Performed tuning for databases, SQL statements, and Oracle Forms and Reports.

August 2000 – May 2002 • New York Times Digital • New York, NY Oracle DBA, independent consultant

Performed data schema modeling and database architecture design for the database behind nytimes.com web site. Setup, redesigned and rebuilt the entire database system, including setting up data warehouse system. Created data mapping and transferring process among different types of databases, i.e., converted MS SQL Server database to Oracle database using migration workbench. Setup and maintained HR/DR databases. Performed database backup using RMAN through Solaris Legato Network system, found lost data using log miner etc. Performed database tuning and query tuning.

April 2000 – August 2000 • Snickelways Interactive, New York, NY Oracle DBA/Developer, independent consultant

Hired as a database expert to work with a team of 12 software developers for building an Ecommerce web site in a foreign language (Portuguese). Changed database character set. Designed the schema in Erwin. Guided the developers to program in PL/SQL using OEM V2.0.4. Installed and customized Oracle 8i database on Windows NT system. Set up Oracle InterMedia Text search to allow article search in the database. Performed database tuning using OEM Tuning Pack. Certifications

Oracle Autonomous Database Cloud 2022 Professional. Exam 1Z0-931-22 Oracle Cloud Infrastructure 2020 Architect Associate. Exam 1Z0-1072-20 Microsoft Azure Fundamentals. Exam AZ-900

Oracle Certified Professional for Oracle 12c. Exam 1Z0-063, 1Z0-069 Education

University Of Maine • Orono, ME • Master of Engineering in Civil Engineering University Of Maine • Orono, ME • Master of Science in Mechanical Engineering Peking University • Beijing, China • Bachelor of Science in Mathematics and Mechanics