Senior Database Administrator / Technical Lead

Sandra Arnold

Cottontown, *****, Tennessee, 865-***-****, **************@*****.***

SUMMARY Dedicated Technical Lead with over 10 years of database administration experience across MySQL, PostgreSQL, and MongoDB environments. Expertise includes providing critical support, performance tuning, and disaster recovery solutions, significantly improving operational efficiency. Notable achievements involve winning the ORNL Significant Event Award and leading successful data center migrations. With a strong commitment to optimizing database performance, ready to drive success in fast-paced environments and ensure robust data management for potential employers. WORK EXPERIENCE

11/2019 – 02/2024 Technical Lead, WiPro Limited Nashville Spearheaded MySQL and MariaDB Database Support for MySQL Operations at Change Healthcare/Optum Insight as the Lead MySQL DBA Orchestrated On-Call support for MySQL/MariaDB databases Assisted in mitigating identified risks associated with MySQL/MariaDB instances

Provided support for Software Engineers, enhancing project outcomes Facilitated Disaster Recovery Tests, ensuring business continuity Executed monthly restoration tests of MariaDB/MySQL backups, validating data integrity

Conducted quarterly MySQL/MariaDB Account Audits to ensure compliance Monitored database instances for performance events, proactively addressing issues

Managed daily backups for all database instances, safeguarding critical data Delivered monthly Operational reports to stakeholders, providing visibility into database health

Technologies used: MySQL 4.1, 5.0, 5.1, MariaDB 5.5, 10.3, 10.5; Aurora MySQL and PostgreSQL, PostgreSQL RDS

Operating Systems: CentOS 4 and 6; RedHat 6, 7, and 8; SUSE Linux 10 and 11

07/2014 – 10/2019 Senior Database Administrator, TiVo San Jose Note: Company changed name on September 8, 2016 from Rovi Corporation to TiVo

Contracted with ProRecruiters at TiVo from July 2014 to October 2014 Delivered database support for MySQL, MongoDB, MariaDB, and PostgreSQL

Executed On-Call support for MySQL, MongoDB, and PostgreSQL, ensuring high availability

Facilitated backup and recovery support, optimizing data retention methods Oversaw database software upgrades, enhancing functionality Monitored database performance, resolving issues to maintain efficiency Provided MongoDB support for shard cluster, replica set, and standalone database environments, ensuring reliability across versions 2.2, 2.4, 3.0, 3.4, and 3.6

Managed MySQL support for standalone, Master-Slave, and Master-Master environments across versions 5.0, 5.1, 5.5, 5.6, and 5.7 Handled PostgreSQL database support, ensuring optimal configuration Administered MariaDB support for Zabbix Monitoring software Leveraged OS expertise in Windows, RedHat, CentOS, and AWS Provided database support for Jira DC, Jira, Confluence, TestRail, Crucible, Bamboo

Assisted in two data center migrations, integrating MySQL and MS SQL databases.

01/2013 – 06/2014 Data Warehouse/Database Administrator, Oak Ridge National Laboratory (ORNL)

Oak Ridge

(Contractor: Martin Federal)

Delivered Data Warehouse support for all databases in the CMS project at ORNL, including Oracle, MySQL, Microsoft SQL Server, PostgreSQL, GreenPlum, Neo4j, and MongoDB

Executed installation of software, crafting robust backup and recovery procedures, securing databases according to DISA and CIS security controls, and supporting development teams

Provided architecture support for Greenplum Database, which involved installation, database creation, schema development, table and index setup, and performance tuning

Served on the team recognized with an ORNL Significant Event Award for obtaining 'Authorization to Operate' for the Centers for Medicare and Medicaid Services regarding ORNL Knowledge Discovery Infrastructure

(KDI)

Participated as a member of the Change Control Board for the CMS project at ORNL. Database versions: Oracle 11gR2, Greenplum 4.2, PostgreSQL 9.1, MySQL 5.5, Microsoft SQL Server 2008 Release 2, MongoDB 2.4, and Neo4j 1.9.

03/2003 – 01/2013 Senior Database Administrator, Department of Energy/Office of Scientific and Technical Information

Oak Ridge

(Contractor: Information International Associates (IIA)) Jun 2012—Jan 2013

(Contractor: NCI Information Systems, Inc) (Contract Changed to IIA) Mar 2003—May 2012

Delivered comprehensive database administration support for all DOE/OSTI Oracle, MySQL, Microsoft SQL Server, and PostgreSQL databases Executed backup and recovery support, performance tuning, ensuring database security, and software installation and patch management Configured and implemented a Hot Standby with Streaming Replication solution for PostgreSQL Production databases

Installed and configured Oracle Enterprise Manager Grid Control on Red Hat Linux platform

Provided Oracle Intermedia/Text index support, enhancing data retrieval capabilities

Assumed the roles of Information Systems Security Manager (ISSM) and Information Systems Security Officer (ISSO) for all databases, ensuring compliance and security integrity. Operating systems included: Sun Solaris, Red Hat Linux, and MS Windows. Supported databases: Oracle versions 8.0.5, 8.1.4, 9, 10g Release 2, and 11g Release 2, as well as PostgreSQL versions 8.4 and 9.0, and Microsoft SQL Server versions 2000, 2005, and 2008 Release 2, with MySQL versions 5.0 and 5.1.

07/2001 – 12/2002 Database Administrator, Medibuy, Inc Nashville 07/2000 – 06/2001 Database Administrator, Strategic Staffing Solutions Nashville Contracted to Bridgestone/Firestone, Inc, Nashville, TN from July 2000 to May 2001.

10/1997 – 07/2000 Database Administrator, Goody’s Family Clothing Knoxville 04/1995 – 10/1997 Systems Analyst, Phillips Consumer Electronics Knoxville Contract Programmer, Midwest Technical, Inc Oak Ridge Contract Programmer at Alcoa Recycling

Systems Analyst, Technical Staffing Solutions Knoxville Systems Analyst at Bendix Atlantic Inflator Company Systems Analyst, Science Applications International Corporation

(SAIC)

Oak Ridge

Information Systems Analyst I and II, State of TN, Department of Health and Environment

Nashville

EDUCATION

Nashville State Technical Institute

Associate of Science, Business Data Processing

Nashville

SKILLS MySQL MariaDB

Oracle Microsoft SQL Server

Greenplum PostgreSQL

AWS Aurora MySQL AWS Aurora PostgreSQL

AWS PostgreSQL RDS Neo4j

MongoDB Linux

Windows Solaris

Unix AIX

AWS Lawson

Oracle Enterprise Manager Grid

Control

Erwin

Python JavaScript

PL/SQL C

Perl SQL

Linux scripting Problem Solving

Quick Learner Security

Backup Procedures Development

Production Environments

LANGUAGES English

CERTIFICATES AWS Certified Cloud Practitioner

AWS

09/2022

MongoDB Diagnostics and Debugging

MongoDB University

10/2017

MongoDB Advanced Deployment and Operations

MongoDB University

12/2015

MongoDB for DBAs

MongoDB University

2013

An Introduction to Interactive Programming in Python Coursera Rice University

2013

Introduction to PostgreSQL Administration Training EnterpriseDB

2010

Security 509 Securing Oracle

The SANS Institute

2007

Oracle Database 10g: New Features for Administrators Oracle Corporation

2005

Oracle9i Database Administration Fundamentals I R2 Oracle Corporation

2004

Contact this candidate