Donald Lyons
Technology Operations Analyst Senior/Senior Database Administrator
San Antonio,TX
Summary
Database professional with extensive experiencing managing databases of all sizes. Developed scripts to extract and process data from multiple data sources to allow for faster resolution of critical issues. Promoted Agile fundamentals to create stories using Jira with Kanban and Scrum methodologies. Automated processes to pull schema and data to migrate and load databases. Experienced in all aspects of database administration; MSSQL, Oracle, SAP Hanna and Sybase. Involved in design, development, monitoring, backup and recovery of database systems.
Overview
35
35
years of professional experience
1
1
Certification
Work History
Technology Operations Analyst Senior/Senior Database Administrator
Capital Group Companies
05.2005 - 04.2023
- Monitor and provide 24/7 situational awareness for IT and business environment.
- Communicate with all levels of staff to support resolutions of major and critical issues. Reducing number of incidents by 60%.
- Utilize multiple tools to ensure that nightly batch cycle is completed per service level agreements.
- Research areas in operations control environment to apply continuous improvement best practices.
- Perform duties of disaster and recovery lead.
- Utilize Jira to create and track Kanban stories.
- Developed process to pull and load data from different file formats and systems to produce augmented and accurate email communications.
- Design Python scripts using APIs to extract data from Haver and Data Stream data sources.
- Transformed data to produce charts on economic global conditions.
- Verify that documentation is current and reviewed by all team members.
- Automate compliance tracking for all documents in team library.
- Developed learning pathways for Splunk, Agile and incident resolution.
- Mentored team members in both technical and non-technical areas of career development.
- Enhanced compliance process for data security new contractors and trained offshore resources in daily database operations.
- Facilitated meetings with all levels of personnel, concerning daily operations.
- Monitored and communicated status of all database environments.
- Configured and maintained database security access program using security application.
- Provided input into compliance and risk issues pertaining to Capital Group.
- Processed security user access reports.
- Maintained user passwords and developed scripts to remove users in bulk.
- Installed and configured Sybase and Oracle database servers.
- Responsible for troubleshooting, performance and tuning.
- Migrated data between servers.
- Patch and upgrade Oracle and Sybase systems.
- Developed scripts to automate process to reduce probability of errors or loss of data.
- Gained strong leadership skills by managing projects. from start to finish
Sybase/Oracle DBA
Blue Cross Blue Shield of Louisiana
03.2004 - 05.2005
- Installed and configured Sybase for optimum performance.
- Designed and developed scripts to monitor error logs and databases for size and system reliability.
- Interfaced with developers to increase their knowledge of Sybase and Oracle.
- Provided development and production 24x7 support.
Oracle DBA
AT&T Wireless
08.1999 - 03.2004
- Installed new instances of Oracle.
- Performed daily maintenance including backup and recovery.
- Responsible for data migration from production to reporting server.
- Managed group of ten database administrators in daily production and operation of sixty database servers.
- Responsible for set up and maintenance of replication servers including data warehouse and warm standby environments.
- Worked with developers and consultants to achieve high level of database integrity.
- Successfully performed duties of liaison between performance and database teams.
Systems Senior DBA/UNIX SA
Accelerated Data
01.1998 - 07.1999
- Responsible for total operation of ten production servers and three development severs.
- Supervised and trained junior DBAs, developers and consultants in system operations.
- Worked with developers to increase speed of data access.
- Performed system administration task for UNIX system including partitioning disk and monitoring systems resources.
DBA/SA
Blackstone contracting
10.1996 - 12.1997
- Responsible for data migration from Sybase SQL Server to Sybase IQ servers.
- Wrote Perl scripts to automate migration process.
- Developed replication subscriptions and replications definitions to enhance data warehousing process.
- Subject matter expert for operation and maintenance of twelve database servers.
- Developed automated backup procedure to improve reliability of backups.
- Wrote stored procedures and triggers to verify database integrity.
- Redesigned and enhanced existing stored procedures.
- Environments: Sybase SQL Server running on a HP 9000 using UNIX, C and Perl.
Database Administrator
Time Warner Communications
05.1995 - 10.1996
- Responsible for development and operation of over twenty database servers.
- Performance and tuning, backup and monitoring of databases.
- Designed, developed and maintained decision support/data warehouse system. Including setup of replication system objects.
- Monitored replication server between corporate headquarters and remote divisions.
- Environment: Sybase SQL Server running on Sun Solaris using UNIX and C.
Database Consultant/Programmer/Analyst
Greenbrier and Russell
11.1994 - 05.1995
- Produced data entry and order tracking system using PowerBuilder and Sybase.
- Advised developers and database administrators in various database issues.
- Environment: Sybase SQL Server running on DEC ALPHA, Using VMS in PowerBuilder.
Database Administrator
Dillon Companies INC.
05.1992 - 11.1994
- Designed and implemented both physical and logical database models.
- Performed daily database operations including backups and restores.
- Involved 164 tables multiple stored procedures and required 10 gigabytes of disk space.
- Wrote stored procedures; triggers and rules to ensure database integrity.
- Environment: Sybase SQL Server, Informix, Powerbuilder, C, Desktop, DBA, UNIX shell scripts on NCR UNIX systems.
System Analyst
Colorado Interstate Gas
11.1991 - 05.1992
- Designed, developed and implemented methods of transferring data between IBM mainframe and Compaq System Pro running UNIX.
- Developed in UNIX shell script using FTP and FOCUS.
- Environment: Compaq System Pro running UNIX.
System Analyst
GTE Telecom
12.1987 - 11.1991
- Designed, installed and maintained software systems.
- Programmed Informix 4gl and Sql utilizing forms, query and reporting features.
- Systems were developed using Informix 4gl, SQL, C and UNIX shell scripts.
- Environment: UNIX shell scripts, Informix 4gl, SQL, and C.
Education
BS Computer Science -
The University of West Florida
Pensacola, FL12.1986
AWS Certified Cloud Practitioner -
Udemy
Capital Group2021
Leadership And Communications Classes -
Onsite Training
Capital Group 2022
ITIL certified in ITIL Fundamentals -
Onsite Training
Capital Group12.2015
Operational Support and Analysis -
Onsite Training
Capital Group2015
Release Control and Validation -
Onsite Training
Capital Group2015
Data analytic pathways -
Udemy, Pluralsight
San Antonio2023
Skills
- AWS
- Autosys
- DBMS
- ETL
- HP-UX
- AIX
- Json
- Linux
- MSSQL
- Windows
- Python
- R
- Agile
- Scrum
- PowerShell
Custom
Extra Curricular: Professional DevelopmentToastmasters member/officerVP Membership 7/19 - 7/20VP Public Relations 7/17 - 7/18President 7/15 - 7/16Sargent-at-arms 7/14 - 7/15
Languages
- English
Certification
Toastmasters:
- Competent Communicator
- Competent Leader
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Technology Operations Analyst Senior/Senior Database Administrator
Capital Group Companies
05.2005 - 04.2023
Sybase/Oracle DBA
Blue Cross Blue Shield of Louisiana
03.2004 - 05.2005
Oracle DBA
AT&T Wireless
08.1999 - 03.2004
Systems Senior DBA/UNIX SA
Accelerated Data
01.1998 - 07.1999
DBA/SA
Blackstone contracting
10.1996 - 12.1997
Database Administrator
Time Warner Communications
05.1995 - 10.1996
Database Consultant/Programmer/Analyst
Greenbrier and Russell
11.1994 - 05.1995
Database Administrator
Dillon Companies INC.
05.1992 - 11.1994
System Analyst
Colorado Interstate Gas
11.1991 - 05.1992
System Analyst
GTE Telecom
12.1987 - 11.1991
BS Computer Science -
The University of West Florida
AWS Certified Cloud Practitioner -
Udemy
Leadership And Communications Classes -
Onsite Training
ITIL certified in ITIL Fundamentals -
Onsite Training
Operational Support and Analysis -
Onsite Training
Release Control and Validation -
Onsite Training
Data analytic pathways -
Udemy, Pluralsight
Similar Profiles
Shelby BurnsShelby Burns
Executive Assistant at THE CAPITAL GROUP COMPANIES, INCExecutive Assistant at THE CAPITAL GROUP COMPANIES, INC
Alana SheltonAlana Shelton
Business Support Senior Representative at CAPITAL GROUP COMPANIES, INCBusiness Support Senior Representative at CAPITAL GROUP COMPANIES, INC
Shinail Marie MannShinail Marie Mann
Janitorial Assistant at CAPITAL GROUP COMPANIES, INCJanitorial Assistant at CAPITAL GROUP COMPANIES, INC
JOSHUA HERNANDEZJOSHUA HERNANDEZ
Maintance Inspector at Mesa SolutionsMaintance Inspector at Mesa Solutions
ISAIAH YANASISAIAH YANAS
Electrician Apprentice at IBEW Local 60Electrician Apprentice at IBEW Local 60