Larry Spence Email & Phone Number

St. Louis, Missouri, Us

• Managed multiple production and non-prod Postgres (10 and 11) database systems on AWS.• Used Pg_admin and DBeaver for Postgres database management. • Implemented new database layout that consolidated multiple database instances into app database instances with internal databases for non-prod environments to reduce the number of database instances needed and better separation of applications.• Used AWS DMS (Database Migration Service) to clone and refresh various databases from Postgres schema to schema.• Utilized multiple AWS technologies including: Aurora Postgres, DMS, Secrets, Cloudwatch, CloudFormation, CloudShell, AWS CLI, Lambda functions and Route 53.• Utilized several Cloud technologies including: CyberArk, Confluence/Conjure, Jira Kanban, Stash, Bitbucket, GIT, Citrix, Azure Desktop and Cherwell.

Dallas, Texas, Us

• Managed production and non-prod Postgres (10,11,12) database systems on the IBM Cloud.• Migrated the Oracle databases to Postgres using ora2pg.• Used pg_admin, PEM (Postgres Enterprise Manager) and Datadog for monitoring. • Designed scripts to monitor the database and troubleshoot performance issues.• Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.

Dallas, Texas, Us

• Oracleo Managed Oracle DBA Team for over 300 databaseso As senior DBA, managed dozens of databases for applications including DW, Informatica, Avaya, VOD, Tibco, IBM Websphere, Spotfire, Camp (C2C), Tollgrade Loopcare, Net Optimize and ViryaNet databases.o Managed multiple production and non-prod Oracle (8.0 to 12c r2) DB systems on Linux and Solaris from a few GB to 27 TB.o Tasks were DB optimization and performance tuning, backup/recovery, restoration testing, DB installation, upgrades, migrations, cloning, and monitoring.o Performed DB tuning at all levels by optimizing server, storage, database and SQL.o Deployed HA in Cloud using Physical Data Guard.o Utilized SANs, Solaris LDOMSs/zones/containers and VMware.o Performed upgrades: 11g to 12c and 12c r1 to 12c r2.o Used OEM Grid Control, DPA (Ignite), AWR, Statspack, RMAN, Data Pump, SQL Dev, Spotlight, Toad,etc.o Cloned/refreshed DBs using RMAN, Data Guard, Data Pump, and EXP/IMP.o Performed PSU patching of Grid and DB homes.o Administered partitioning. o Administered ASM and Grid Infrastructure using crsctl, svrctl and asmcmd.o Converted databases from file system to ASM.• Postgreso Managed multiple prod and non-prod Postgres (8.1,8.4,9.6,10.4) DB systems on Linux.o Administered dozens of DBs for apps including Apigee, Avaya, Eware and BSAS4 databases. o Designed scripts to monitor the DB and troubleshoot performance issues.o Authored scripts for backup/recovery, monitoring, performance tuning, reporting etc.o Worked with app team to tune queries. Developed scripts to identify long running queries.o Used pg_admin for monitoring.o Performed backup and recovery using pg_dump and psql.o Cloned and refreshed DBs.• MySQL/Mariao Managed multiple prod and non-prod MySQL (5.5,5.6) and Maria DBs on Linux.o Apps including Matrix, Emptoris Spend and TV Everywhere. o Authored scripts for backup and recovery, DB dupl, monitoring, performance tuning, reporting.o Performed backup and recovery.

• Managed multiple production and non-prod Oracle (8.0 to 11g r2) and Postgres (8.1) DB systems on Linux Solaris, AIX and HP/UX from a few GB to 27 TB.• Tasks included database optimization and performance tuning, database sizing and growth projections, backup and recovery procedures, restoral testing, database installation and upgrades, monitoring and maintaining the databases and resolve locking issues. • Utilized various tools and technologies like Dell and Sun servers, SANs, virtualization (Solaris zones/containers and VMware), VCS, ZFS pools, etc.• Used Oracle tools and related software including OEM Grid Control, AWR, Statspack, RMAN, Data Pump, SQL Developer, etc.• Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.• Administered ASM and Grid Infrastructure using ASMlib, oracleasm, svrctl and asmcmd.• Performed database tuning at all levels by optimizing server, storage, database and SQL.• Designed scripts that collected tuning metrics on all production databases.• Performed backup and recovery for Oracle (RMAN), MySQL and Postgres.• Performed backup and recovery using SAN snap (Timefinder and SRDF) for databases. • Cloned and refreshed various database instances RMAN, Data Pump and EXP/IMP.• Managed OEM repository. Designed custom reports that pulled metrics from OEM on backups, DB growth, etc.• Was Oracle DBA Team Lead over team which managed over 250 databases for apps including DW, Informatica, Sterling, Blade Logic, Avaya, CADTEL and ViryaNet databases.

Dallas, Texas, Us

• Managed 7 production and 23 non-prod Oracle DBs systems on Linux and Windows.• Managed databases ranging from a few GB to 1 TB which included OLTP, BI, Data Warehouse, Informatica and E-Business Suite (EBS)/Oracle Applications (11i, R12) databases on Oracle 10gR2 and 11gR2.• Utilized various tools and technologies like Dell and Sun servers, EMC CLARiiON and Isilon SANs, VMware, Evault, Extra Putty, Visio, etc.• Administered ASM and Grid Infrastructure using ASMlib, oracleasm, svrctl and asmcmd.• Responsible for proactive and reactive monitoring and tuning of databases and apps.• Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.• Performed backup and recovery using RMAN for OLTP, BI, Data Warehouse and Oracle Applications databases.• Cloned and refreshed various database instances using RMAN and Data Pump.• Architected and deployed complete HA disaster recovery solutions using RAC, Golden Gate, Oracle Physical Data Guard and RMAN for local and offsite DR.• Administered two node RAC cluster.• Provided first and second level support for Oracle databases in a 24x7 environment.• Centralized management of all RMAN jobs inside of the OEM and RMAN repositories.• Managed the Wholesale High Availability project from end to end. Duties included develop business case, project plans, schedules, Visios and coordination with management, development, system administrators and QA.• Utilized RHAT, SUSE, Oracle Enterprise Linux and Windows operating systems.• Managed 4 production and 2 non-prod MySQL DBs systems on Linux. Performed backup and recovery, replication to slaves, database tuning, troubleshooting of database issues.

• Worked on Oracle 10gR2• Managed databases ranging from a few GB to 500 GB which included OLTP and Data Warehouse databases.• Administered two node RAC cluster.• Provided first and second level support for Oracle databases in a 24x7 environment.• Responsible for proactive and reactive monitoring and tuning of databases and apps. • Authored scripts for backup and recovery, monitoring, performance tuning, reporting etc.• Used Oracle tools and related software including OEM DB Control, SQL Developer, SQL*Plus, Oracle Performance Pack, Data Pump, RMAN, Statspack, TKPROF and custom designed scripts written in SQL and PL/SQL for monitoring and optimization. • Utilized RHAT, SUSE and Windows operating systems.Other projects included database administration and development on a variety of systems utilizing ORACLE.References Available upon Request

Master Of Science (Ms), Information Systems

Master Of Business Administration (Mba), Information Systems