Matthew Beasley
Database Administration
Austin,TX
Summary
Knowledgeable SQL Server Administrator and Systems Admin with proven background in senior leadership roles, driving strategic initiatives and fostering organizational growth. Successfully led cross-functional teams to achieve key business objectives, enhancing operational efficiency and stakeholder satisfaction. Demonstrated expertise in project management and strategic planning.
Overview
26
26
years of professional experience
Work History
Senior Director, Systems Development, Database Administrator, FTP Administrator
FIDx
Remote
01.2018 - 04.2024
- Designed and Implemented database management activities to ensure adherence to established information security standards.
- Analyzed security frameworks through routine audits and assessments, addressing potential vulnerabilities with targeted corrective actions.
- Engineered a geographically dispersed database solution by collaborating with cross-functional teams, optimizing uptime and reinforcing data integrity for sustained business growth.
- Executed meticulous management of DTCC data operations, encompassing FTP transfers, data parsing, processing, and the generation of files for DTCC submission.
- Integrated advanced systems to strengthen advisor capabilities in providing comprehensive income protection and retirement solutions.
- Directed the integration of cross-functional teams to advance the execution of strategic initiatives in accordance with organizational priorities.
- Analyzed data to identify opportunities for process optimization, resulting in improved operational workflows.
- Reviewed performance metrics to implement strategies for ongoing operational efficiency enhancements.
- Conducted thorough assessments and established best practices for risk management, reinforcing compliance with applicable regulations.
- Executed risk management strategies through threat identification, contingency plan development, and mitigation strategy implementation to enhance organizational resilience.
Database Architect, Administrator, and Developer
Solutions3000
04.2017 - 12.2017
- Analyzed and recommended improvements for DTCC processes and reporting systems at National Western Life Insurance.
- Developed and optimized complex SQL scripts and coding solutions for effective file processing and comprehensive reporting within database environments.
- Executed data extraction from IBM mainframe systems and transformed exports for efficient processing within SQL Server and its supporting subsystems.
- Advised clients in financial and insurance sectors on best practices and innovative strategies to drive business success.
- Optimized database queries, resulting in improved application response times and resource utilization.
- Mentored junior architects on best practices for database design and management techniques.
Database & Infrastructure Architect IV
Everi Holdings Inc.
04.2015 - 10.2016
- Architected a complex data environment utilizing more than 40 data sources and over 300 data schemas from more than 40 financial institutions including the likes of ING, Citigroup, Pershing, National Securities Clearing Corporation (The Dow Jones). Transfers secured using a variety of industry standard methods including SSL to PGP to dedicated VPN circuits.
- Design and implement database schemas providing data to front end applications written in ASP.NET, PowerShell, and VB Script, JavaScript, and C#.
- Develop DTS and SSIS packages utilizing custom VB Scripts to parse partner specific complex file formats used to provide business unit reporting utilizing SSAS, MDX, Cognos, SSRS, and Excel B.I. tools.
- Primary point of contact between infrastructure operations and front end developers, data-tier developers, and business unit leaders to determine reporting requirements and designs to engineer the most comprehensive reporting applications possible.
- Coordinate deployment milestones across dependent code bases, projects, and affected teams, working closely with project managers, production support and change management departments to effectively communicate project deployment details to both the business and technical teams from beginning to end of all projects.
- Design, implement, and manage DOS Batch scripts that send and receive more than 300 files a day to 12 different locations utilizing FTP, SSL, and PGP. Files are then parsed, loaded, and reported on with DTS and SSIS packages.
- Everi Holdings Inc. offers entertainment and financial services within the gaming industry.
Senior Database Architect
National Financial Partners
10.2000 - 04.2015
- Manage, maintain, harden and report on access and utilization on 12 production SQL servers and 10 development database servers with more than 3 terabytes of data including 3 clusters utilizing Microsoft Cluster Services and active/passive SQL servers for maximum uptime and reliability - All servers installed from the OS up to being placed in racks by myself. These servers transfer more than 100 gigabytes of data daily between 3 of the main production SQL clusters.
- Established comprehensive database development and usage standards to ensure compliance with SOX, HIPAA, and ACORD regulations.
- Executed strategic insurance wealth management and retirement planning initiatives, ensuring nationwide client satisfaction and support.
Senior Database Administrator
Dell
Round Rock, TX
03.1998 - 10.2000
- Architected and launched a data warehouse (2 TB) dedicated to clickstream data analysis for dell.com, ensuring efficient processing of more than 10 gigabytes of log files each day.
- Administered and optimized terabyte-sized databases on multiple servers to support efficient OLAP cube design.
- Architected a horizontally partitioned view utilizing two terabytes of storage across four servers, integrating a fibre channel fabric for improved data management.
- Engaged with business and infrastructure teams to identify user requirements, supporting effective data warehouse design and implementation.
- Administered 30 SQL Servers including NT Administration on all boxes. My responsibilities encompassed hardware, software, security, and maintenance of all servers. Maintained 24X7 uptime for all servers.
- Dell is a multinational computer technology company that develops, sells, repairs, and supports computers, servers, and storage and related products and services.
Education
The University of Texas at Austin
Austin, TX01-1995
Skills
- SQL Server administration SQL 65 to SQL 2026; Azure Infrastructure Administration; SQL DTS 2000; SSIS; SQL Server SSIS; SQL reporting services; SQL clustering on bare metal including distributed failovers; Azure SQL clustering and failover;
- Technologies: Windows and Windows Server going back to Windows 30 and Windows NT; command line scripting; VBScript; Redgate SQL Sentry, Embarcadero ERStudio, FTP server administrator, PGP
- Data analytics
- Extensive Reporting expertise
- Administrative oversight and management
Languages
Languages: English
Interests
Building and designing high end computer systems; Data Hoarding; Automotive repair and customization; Remote control drones, planes, helicopters, trucks, and cars
Timeline
Senior Director, Systems Development, Database Administrator, FTP Administrator
FIDx
01.2018 - 04.2024
Database Architect, Administrator, and Developer
Solutions3000
04.2017 - 12.2017
Database & Infrastructure Architect IV
Everi Holdings Inc.
04.2015 - 10.2016
Senior Database Architect
National Financial Partners
10.2000 - 04.2015
Senior Database Administrator
Dell
03.1998 - 10.2000
The University of Texas at Austin