Eric D Peterson Email & Phone Number

Kirkland, Wa, Us

Supporting client with MySQL. Performance Tuning, Administration, deployments, etc...

Bellevue, Washington, United States

● Administered 20+ MySQL and Aurora DB instances as well as assisted Developers in writing and tuning SQL, ensuring the health of DB instance and replication● Facilitated upgrade and migration of MySQL 5.6 to RDS MySQL 5.7 with zero data loss● Provided direction and technical support during transition from EC2 hosted to AWS RDS and then again to AWS Aurora 2 through expert troubleshooting and project management● Mentored Developers on how to write better and faster code on many different projects to enhance team skills and knowledge

Bellevue, Washington, United States

● Collaborated with cross-functional teams to use Amazon Data Migration Services (DMS) to move 12 TBs of data in real-time to Amazon Kinesis / Redshift, maintaining data integrity● Played a key role on project to remove 50-90% of old unneeded/unused data from production to free up database storage space● Completed programming and monitored health of DB instances● Supported development and release for Oracle 11g as well as provided upgrade to 19c● Reviewed code prior to release to ensure smooth release/rollback process● Identified and resolved technical issues during high activity projects to support team in meeting delivery deadlines

Bellevue, Wa

● Oversaw MySQL and Aurora DB instances as well as performed SQL tuning for database management● Partnered with Developers to write more efficient code to maximize productivity and database functionality● Monitored performance of all AWS databases with CloudWatch and CloudTrails with historical monitoring through SolarWinds DPA

Bellevue, Wa

● Assisted deprecation of internal service with Amazon AWS by investigating data model and application process● Wrote code (MySQL v.5.5) to create/modify data and ensure smooth migration with zero customer data loss● Created new system for Colorado Dept. of Human Services by employing OracleXE to create a developer database● Developed two stored procedures for data searching beyond limitations of basic code

Seattle, Wa

● Built production and pre-production databases of Oracle (11gR2) and MySQL (v.5.5), using physical data guard and RMAN for backup processes● Coordinated with Developers and QA team on improvements with current and upcoming code releases● Maintained PCI compliance of CDE systems and provided reports for successful annual PCI audit● Upgraded MySQL system from v.5.0 to v.5.5 with minimal downtime and no loss of data● Migrated RealPlayer / RealTimes system data to 3rd party and shut down all DBs, resulting in significant cost savings by removing all on-premise servers and infrastructure

Seattle, Wa

● Maintained production and pre-production databases of Oracle (11gR2) and MySQL (v.5.6), forecasting future issues and responding to critical events for minimal system downtime● Collaborated with Developers to write / rewrite queries for optimal use in various applications● Reviewed and modified backup processes using Data Guard and RMAN to create schedules and security for backup information● Created and updated DBA team wiki for documentation, training, processes, releases, and statuses ● Served as Member of PCI Compliance team and consistently passed quarterly audits as a result of high attention to detail and internal controls● Migrated operations from AIX (big endian) to Linux (little endian) all Oracle databases with no loss of data

● Provided support for Oracle (10g & 11gR1) production systems by overseeing maintenance, performance, and data recovery● Utilized KornShell, SQL, and anonymous PL/SQL to retrieve, analyze, process, and report data● Played a key role as Primary Designer, collaborating with Developers, DBAs, and Program Managers on a new system for storage of video metadata● Developed an ETL process to migrate large amounts of data using AWK, KSH, SQL, & PL/SQL (including stored procedures and triggers), with verification and validation of data before loading

As, Math

Bachelor Of Science (B.S.), Computer Science