Lynn

Senior Oracle Database Engineer with an active Public Trust Clearance and AWS Solutions Architect Associate certification. Extensive experience managing large scale database environments across Oracle 11g through 23ai and PostgreSQL. Specialist in troubleshooting RAC clusters and replication systems across On-Prem and RDS platforms.

Sr Engr Cslt-Database, Sr Engr Cslt-SRE at VERIZON WIRELESS (2019-04 – 2026-01)

• Triaged database alerts, identified root causes, and implemented corrective actions for a large fleet of On-Prem (RAC/Non-RAC) and AWS RDS Oracle Databases to ensure system stability and performance.
• Managed and resolved complex technical failures in Data Guard, Golden Gate, and Shareplex.
• Identified and tuned long running queries using SPM, OEM, AWR, ASH and Performance Insights.
• Handled 12 different Database projects on Oracle versions 12c and 19c on RAC and RDS.
• Performed RAC and RDS Database upgrades from 12c to 19c for projects supported.
• Engineered and executed a 2TB database migration from RAC to RDS using data pump.
• Led the migration of 5TB RAC 2 node cluster database from old SAN storage to new SAN storage.
• Completed Golden Gate upgrades from 12c to 19c on AWS EC2 instances. Tested upgrades, adjusted Json templates, YAML files, Jenkins Jobs and S3 buckets.
• Performed Golden Gate troubleshooting including ETL rollovers, start/stop extracts/replicates, re-created extracts/replicates, downgraded integrated replicates into classic to overcome performance issues.
• Executed EC2 quarterly rehydration's for 2 Golden Gate Hubs for 4 RDS databases with bi-directional Golden Gate.
• Managed several PostgreSQL databases in AWS, performing releases, troubleshooting and SSL Certificate upgrades.
• Created and automated custom growth stats, automated reports and pivot tables for 200+ Iconic Databases as part of Storage Analysis Tasks.
• Reduced storage alerts by automating database growth analysis for 200+ Iconic Databases by collecting growth statistics and automation of storage related reports.
• Reduced database alerts by analyzing alert stats and presenting actionable data through pivot tables and charts.
• Follow up on all aspects of storage including ordering more storage and partition maintenance checks.
• Proactively expanded storage capacity and resolved technical issues for AWS RDS Oracle instances.
• Worked on special projects to ensure a set of specific Oracle RAC Clusters had the same consistent settings across those environments.
• Performed all aspects of security including implementing and troubleshooting Oracle Vault, Sox Audits, unified audit trail implementation/queries and log4j remediations.
• Held a Public Trust Clearance (Received 5/23/25), supporting Federal Database requirements.

Senior Database Administrator at TECH MAHINDRA (2017-03 – 2018-11)

Client - AT&T/DIRECTV

• Managed 15+ concurrent Oracle Projects (9i-12c), administering Linux-based databases.
• Directed and worked on a high-priority PSU patching initiative for 200+ databases, coordinating a team of 4 DBAs to complete all updates within a 30-day window.
• Managed and contributed a high-priority PSU patching initiative of 200+ databases, directing a team of four DBAs successfully completing all patching in 30 days.
• Performed Oracle and Golden Gate upgrades (11g-12c) as required.
• Configured and deployed new databases using cloud automation.
• Optimized RMAN backups, adjusting configurations and shell scripts as needed.
• Performed Monitoring tasks including adjusting thresholds for OEM, Patrol, and custom alerting scripts.
• Creation of shell scripts for automating export jobs, queries and space reporting.
• Configured RMAN backups including troubleshooting and adjusting backups as needed.
• Implemented Security policies, resolved Security violations and executed FGA auditing in production databases.
• Responsible for general health of standby databases, troubleshooting issues, checking lags, gap resolution, re-creating standby logs and re-creating standbys using RMAN.
• Setup custom monitoring of DIRECTV databases. The tasks included working with the Monitoring Team and other DBAs to ensure custom monitoring was in place.
• Worked with Offshore DBAs as needed to resolve issues during on-call and planned outages.
• Adjusted alert thresholds for OEM, Patrol and custom monitoring as needed.
• Configured Data Guard Broker on a subset of supported databases.
• Collaborated with Oracle Consultants on Exadata RAC migration preparation.
• Engineered storage solutions for 70TB customer databases, managing a 28TB table with 1TB daily growth; secured 20TB of emergency storage and coordinated with application teams on partition retention.

Senior Analyst 1 at DIRECTV/AT&T (1998-08 – 2017-02)

• Performed on-call duties in 24/7 production environment and on-call rotation.
• Responsible for 55 dev, test and production databases on Oracle version 8i to 12c with database sizes up to 7TB.
• Performed upgrades from 8i to 12c on all supported databases.
• Automated and implemented partition maintenance scripts for range, hash and composite table partitions for 2 separate VLDB's.
• Worked on Data Warehouse database migrations of 4 TB Oracle Database with over 1500 data files.
• Troubleshooted Golden Gate and RAC issues during on-call rotations.
• Responsible for refreshing dev/test environments from production using RMAN, NetBackup, BCV's, Snap clones, and CTAS scripting.
• Worked with Unix Admins on implementation of EMC BCV backup and recovery strategy for Data Warehouse and large Data Repository databases. Both databases had nightly sync and split jobs.
• Responsible for PSU patching 2 times per year for all supported oracle databases. Including being the facilitator for the entire group's patching activities as chosen by DBA Manager.
• Performed health checks for all databases on regular intervals or upon request.
• Supported several SQL Server databases, including installation, troubleshooting and support for 7 years of SQL Server 2000 and 2005 versions.
• Participated in 3 separate Data Center migrations.
• Implemented Active Data Guard on production database for reporting purposes.
• Installation of Ingrian row level encryption software on Oracle 10g and SQL Server 2005 databases.
• Implemented TDE on many tables in Oracle 10g database using SQL and Unix Shell scripts.
• Performed switchovers on Data guard databases for Data Center migration, or on request.
• Support two very large databases with Informatica for several years, including database migrations to new servers, upgrades and complicated BCV restores from tape.
• Performed database SOX audits, provided database information to Auditors as needed/required.
• Participated in database restore exercises, including testing, documenting and performing RMAN restores.
• Worked with Delphix Support and other colleagues to set up and install Delphix to take advantage of storage savings, and fast refreshes for many reporting and test databases.
• Refreshed reporting and test databases with Delphix.
• Researched masking features of Delphix to apply to databases with PCI data.