Database Engineer / Manager, Systems Architect
Resume:
SHAWN A ODOM
RIO HATO, COCLE, PANAMA +1-615-***-****
DETAILS
Rio Hato, Cocle
Panama
*******.******@*****.***
COMPETENCIES
Database Technologies
Systems Architecture
Storage Technologies
Performance Tuning
Automation Efficiencies
Management Skills
Critical thinking and problem
solving
Communication and Presentation
Customer Service Skills
HOBBIES
Scuba diving, Golf, Astronomy
PROFILE
Over thirty years of experience in the architecture, design, and management of large-scale distributed relational database and storage systems. Proficient in the methods of database modeling, supporting 24x7 OLTP and DSS enterprise systems, SAN storage administration, and managing database administrative resources for both on-prem and cloud-based environments.
EMPLOYMENT HISTORY
Manager - Technology at Ascension Technologies, REMOTE October 2010 — November 2024
Initial position as a DBA consultant began with supporting SQL Server, Oracle, and MySQL database systems for the TNNAS ministry in Nashville, TN. Initiatives involved the following:
• Made performance improvements with proper tuning methods.
• Stabilized and improved database backups.
• Remediated unsupported and abandoned environments.
• Upgraded database software to latest versions.
• Implemented security hardening measures.
Promoted to a position of DBA Team Lead, with continued support of database systems for the TNNAS ministry, as well as utilizing four additional DBA resources to begin support for many other ministry sites across Ascension’s landscape. Additional initiatives involved the following:
• Coordinated DBA resource assignments for improved team efficiency and effectiveness.
• Expanded the DBA team in-scope support to 32 ministry sites from only three.
• Worked with management to expand the DBA team to 12 positions.
• Implemented primary and secondary ministry site assignments for improved customer reliability and communication with dedicated DBA resource availability.
• Created a formalized primary and secondary On-Call schedule for 24/7 support.
• Deployed and stabilized Veritas Netbackup to manage all SQL Server and Oracle database backups, with increased involvement in DR exercises for testing restore/recovery procedures.
• Deployed and stabilized conversion of 1700+ on-prem database platforms to Microsoft Hyper-V and VMware virtualization clusters as VM servers. Promoted to a position of DBA Team Manager, with carry-over of DBA Team Lead agendas and goals. Additional initiatives involved the following:
• Expanded the DBA team in-scope support into the cloud-based environments of Microsoft Azure, MongoDB, and Google GCP/Big Query, with emphasis on creating a separately functioning Cloud DBA team.
• Worked with management to expand the DBA team to 18 positions.
• Adjusted the primary and secondary ministry site assignments to accommodate database platform growth in SQL Server to 3000+, and with Oracle, MySQL, and PostgreSQL accounting for an additional 200 platforms.
• Coordinated efforts for a SQL Server on Linux POC and subsequent implementation.
• Coordinated conversion of all database backups from Veritas Netbackup to utilizing Dell/EMC Networker and PPDM solutions to achieve Five 9s reliability.
• Collaborated with the Enterprise Server team to implement an improved Windows server patch maintenance workflow and schedule, inclusive of SQL Server patching.
• Collaborated with the Enterprise Server team for a project to convert VMs from Hyper-V to VMware VSAN virtualization cluster technology.
• Kickstarted and expanded priority for a company-wide project to remediate 2008 and older versions of Windows Server O/S and SQL Server database platforms. Currently working to kickstart a new, perpetual project to remediate 2012 and 2014 versioned SQL Server platforms, as well as 11g and 12c versioned Oracle platforms.
• Collaborated with the Enterprise Server and Infrastructure teams to develop and implement an improved server decommissioning workflow and framework to mitigate incidents with accidental decommissioning of servers.
• Collaborated with executive management to improve upon company-wide standards, processes, and technological direction. HCL Outsourcing - August 2020 to Present
Participated in interviewing multiple company bids for an IT outsourcing initiative with executive management for 3 days at corporate headquarters in St Louis, Missouri. Final decision to offer HCL the opportunity required a reduction of DBA team associates to 7, with plans to expand with an additional 12 HCL DBA resources. Initiatives involved the following:
• Completed 8 weeks of Knowledge Transfer (KT) sessions to educate the HCL DBA team in the areas of on-prem database technologies supported, standards, processes, methodologies, customer service and communications, company culture, etc.
• Expanded HCL DBA support initiatives with increased collaboration on Cloud DBA team activities and goals.
• Provided the HCL DBA resources with opportunities to expand their knowledge with challenging project work, available training, and involvement in top priority company missions.
Sr Database Architect at Dollar General Corp, Nashville TN February 2008 — May 2010
• Provided support for newly developed database environments utilizing Oracle 10g EE, 10g EE RAC technology, and new 11g EE. Oracle components utilized included Clusterware, ASM, Partitioning, and Grid Control for management. Server hardware configuration consisted of HP Superdome, IBM RISC, and HP DL580 server technologies utilizing HP-UX, AIX, and RHEL 5 operating systems, respectively.
• Provided support for Microsoft SQL Server versions 2005 and 2008 for various ancillary systems. Tasks included managing backups using Symantec BackupExec, performance tuning using the Microsoft performance dashboard tool within the management studio app, and SQL tuning as needed.
• Developed and managed architectures to support proper disk storage configurations, proper utilization of hardware resources, and manageable procedures for database maintenance and tuning.
• Developed and managed procedures for database backup and recovery using the Oracle RMAN utility and the HP Data Protector storage management software.
• Worked with development staff to provide daily support for various application systems in areas of database object management, development database resource management, SQL tuning and code review.
• Assisted with developing a business continuance strategy to improve disaster recovery response times and efficiencies, as well as to reduce the overall cost of disaster recovery requirements.
Sr Database Architect at Landmark Digital Services (BMI Music), Nashville TN September 2005 — February 2008
• Primary initiative: Reverse-engineer the database platform supporting the Shazam music recognition product in the UK, improving with an Oracle RAC database platform to support additional features, functionality, and performance.
• Provided support for newly developed database environments utilizing Oracle 10g RAC technology. Oracle components utilized include Clusterware, ASM, Partitioning, and Grid Control for management. Server configuration consisted of Dell 9850 quad CPU Intel Xeon technology hosting the Novell SUSE (SLES 9.1 SP3) linux operating system.
• Developed architectures to support proper disk storage configurations, proper utilization of hardware resources, and manageable procedures for database maintenance and tuning.
• Developed and implemented effective data modeling standards and database design
• Provided assistance with the capacity management of 700+ terabytes of Fibre and SATA SAN storage. Consisted of monitoring database storage utilization metrics and forecasting storage requirements in support of system growth.
• Developed procedures for database backup and recovery using the Oracle RMAN utility and the Veritas NetBackup storage management software.
• Developed change management procedures to organize changes made to the database schema in support of application development requirements.
• Implemented Oracle Data Guard for a High Availability / Disaster Recovery initiative EDUCATION
B.S., Computer Information Systems and Accounting, Murray State University August 1988 — May 1993
President of DPMA Chapter (2 years)
President of Accounting Society (4 years)
Pi Kappa Alpha social fraternity
TECHNICAL PROFICIENCIES
RDBMS: Oracle/RAC, SQL Server/AlwaysOn, MySQL, PostgreSQL, Informix Cloud: Microsoft Azure, GCP CloudSQL/BigQuery
Virtualization Clusters: VMware VSAN/VxRail, Microsoft Hyper-V Linux OS: Redhat, CentOS, Ubuntu
Unix OS: Solaris, HP-UX, AIX
SAN Storage: Exadata, EMC, Hitachi, SSD/NVMe
Monitoring: Oracle OEM, Solarwinds, Idera
Backup/Recovery: Netbackup, Networker, Dell PPDM
Contact this candidate