Terry McDaniel
Atlanta,GA
Overview
50
50
years of professional experience
Work History
SQL Database Manager
Delaware Nation Industries
12.2023 - 09.2025
- Developed a complete database maintenance environment using an activities table to spawn maintenance jobs on schedule.
- Developed and managed job performance and reports.
- Managed Datamart data builds
- Supported a content management system
- Used SQL Extended Events to monitor for tuning opportunities
- Tuning management included job scheduling as well as implementing an index cleanup routine.
- Commercial Computer Services
Database Manager/Data Architect
NTT Data Services
08.2017 - 12.2023
- Serve as NTT DBA Manager for a team of 7 DBAs
- Install SQL Server 2000, 2005, 2008, 2012, 2016, 2017,2019 in a VMWARE environment
- Support MySQL databases on Windows and Linux and AZURE.
- Monitor SQL server using IDERA Diagnostic Manager, SENTRYONE and scripts
- Manage 340 instances with a total of 150TB of allocated space
- Manage the backup and recovery processes.
- Use best practices to recommend database file architecture for incoming database applications
- Apply changes to environment from developers
- Use best practices to recommend query optimization to developers.
- Work closely with applications development teams to ensure proper data modeling and design paradigms are applied in the creation and ongoing maintenance of respective databases, to ensure efficient data access in application programs, and to review test benchmarks
- Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
- Assist in the definition and resolution of database problems.
- Development and maintain procedures for always-on availability and log shipping incorporating the current shop backup utility IDERA Sql Safe and standard SQL Backups.
- Recommend and implement data archival procedures to developers.
- Commercial Computer Services
Senior SQL Server DBA – DBA Team Lead
Unisys Corp.
10.2015 - 08.2017
- Serve as DBA Team Lead for a team of 7 DBAs
- Install SQL Server 2000, 2005, 2008, 2012, 2016 in a clustered environment
- Monitor SQL server using IDERA Diagnostic Manager and scripts
- Manage 266 instances with a total of 96TB of allocated space
- Manage the backup and recovery processes.
- Use best practices to recommend database file architecture for incoming database applications
- Apply changes to environment from developers
- Use best practices to recommend query optimization to developers.
- Work closely with applications development teams to ensure proper data modeling and design paradigms are applied in the creation and ongoing maintenance of respective databases, to ensure efficient data access in application programs, and to review test benchmarks
- Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
- Assist in the definition and resolution of database problems.
- Development and maintain procedures for always-on availability and log shipping incorporating the current shop backup utility IDERA Sql Safe.
- Recommend and implement data archival procedures to developers.
- Commercial Computer Services
Senior SQL Server DBA – DBA Team Lead
Hewlett Packard Corporation
06.2012 - 10.2015
- Serve as DBA Team Lead for a team of 6 senior DBAs
- Install SQL Server 2000, 2005, 2008, 2012 in a clustered environment
- Monitor SQL server using IDERA Diagnostic Manager and scripts
- Manage 266 instances with a total of 96TB of allocated space
- Manage the backup and recovery processes.
- Use best practices to recommend database file architecture for incoming database applications
- Apply changes to environment from developers
- Use best practices to recommend query optimization to developers.
- Work closely with applications development teams to ensure proper data modeling and design paradigms are applied in the creation and ongoing maintenance of respective databases, to ensure efficient data access in application programs, and to review test benchmarks
- Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
- Assist in the definition and resolution of database problems.
- Development and maintain procedures for always-on availability and log shipping incorporating the current shop backup utility IDERA Sql Safe.
- Recommend and implement data archival procedures to developers.
- Commercial Computer Services
Senior SQL Server DBA - DBA Team Lead
Unisys Corp.
03.2007 - 06.2012
- Serve as DBA Team Lead for a team of 6 senior DBAs
- Install SQL Server 2000, 2005 and 2008 in a clustered environment
- Monitor SQL server using NetIQ, Quest Spotlight, and scripts
- Manage 15 instances with a total of 15TB of allocated space
- Manage the backup and recovery processes for approximately 105 production instances. Backups total around 6TB per night compressed.
- Use best practices to recommend database file architecture for incoming database applications
- Apply changes to environment from developers
- Use best practices to recommend query optimization to developers.
- Work closely with applications development teams to ensure proper data modeling and design paradigms are applied in the creation and ongoing maintenance of respective databases, to ensure efficient data access in application programs, and to review test benchmarks
- Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
- Assist in the definition and resolution of database problems.
- Recommend and implement data archival procedures to developers.
- Commercial Computer Services
Senior SQL Server DBA
Sysdba Corp.
11.2006 - 03.2007
- Install SQL Server 2000, 2005 in a clustered environment
- Monitor SQL server using NetIQ, Quest Spotlight, and scripts
- Manage 5 instances with a total of 10 TB of allocated space
- Manage the backup and recovery process for approximately 100 production instances. Backups total around 5TB per night compressed.
- Apply changes to environment from developers
- Use best practices to recommend query optimization to developers.
- Work closely with applications development teams to ensure proper data modeling and design paradigms are applied in the creation and ongoing maintenance of respective databases, to ensure efficient data access in application programs, and to review test benchmarks
- Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
- Assist in the definition and resolution of database problems
- Commercial Computer Services
Database Administrator
Ceridian Corporation
04.2002 - 11.2006
- Provided production database support to MSSQL Server 2000 , SQL Server 2005, Oracle 10g, and DB2_LUW database systems
- Installed and configured Microsoft SQL Server on development and production servers.
- Created DR plan and performed backups in support of that plan.
- Monitor Server Performance using SQL tools. Tuned server performance
- Performed upgrades and installed patches and hot fixes as required
- Managed SQL Maintenance Plans for each server including backups, index rebuilds, and consistency checks
- Created and monitored SQL jobs on all servers.
- Created jobs to move updates from development to production
- Public Sector
Senior Database Administrator
American Financial Group
04.1997 - 04.2002
- Supported the MSSQL SERVER databases for the Agency Interfaces and Decision Support functions of the AFG Auto Insurance Companies - 12 production MSSQL servers with 130 databases in approximately 500GB.
- Installed and tuned MSSQL Server (2000, 7.0, 6.5) on Windows 2000 and Windows NT4 servers.
- Performed database upgrades from SQL 6.5 to SQL 7.0 and from SQL 6.5 to SQL 2000.
- Recommended, implemented and supported transactional replication on the Nextgen agency interface application MSSQL Server database to remove the query only decision support functions from the oltp database and to also provide a failover database that could become the oltp in case of a disaster. The replicated database is 60GB large and replication must be manually synchronized.
- Devised, implemented and tested backup and restore schemes for all MSSQL Server databases in the company. Wrote scripts to backup and optimize the databases.
- Supported the Oracle Database for a $50million+ Auto Insurance Claims Application. This OLTP application processes claims transactions and is also used for document (FileNet) and workflow management. It is running on a three-tier environment: Visual Basic 6 on the front-end, Microsoft MTS on the middle-tier, and Oracle 8i on the back-end on HP 9000 series servers.
- Participated in logical-to-physical conversion of the enterprise logical model for the claims application.
- Prepared management reports that outline the hardware and software configuration, standards, processes, procedure and best practices relevant to the database administration group.
- Commercial Insurance
Support Analyst
Geac Host Technologies
11.1994 - 04.1997
- Provided application, installation, and technical support for DBS Purchasing/Inventory/Remote Inventory Control systems.
- Responsibilities included developing corrective code, telephone support, in-house system installation and maintenance, on-site customer training, on-call after-hours technical support and bulletin/new release testing.
- Remote Inventory Control system required C language coding and PC Workstation and LAN understanding and knowledge.
- Formerly Dun & Bradstreet
Staff Programmer
IBM Corp.
12.1988 - 11.1994
- Significantly reduced lines of code and improved performance of ICF Catalog Component of the MVS operating system by incorporating a table lookup with a binary search routine to replace cumbersome code to handle the retrieval and modification of the field management elements.
- Revised and enhanced the ICF CATALOG code to support the Hierarchical Storage Manager data integrity problem correction, the Backout White Open feature, the Optical Access Method and others, using PLX370, PL/AS, ASSEMBLER languages.
- Serviced ICF Catalog using the telephone and RETAIN to communicate with the customer, IPCS to analyze dumps and SPA to code and deliver the bug fixes.
Senior Software Engineer
Management Science America, Inc.
01.1985 - 12.1988
- Developed, tested, packaged and installed at beta sites seven releases of the MSA General Ledger (now GEAC) for IMS/CICS in COBOL.
- Set a record for shortest development and delivery time for the CICS/DLI version of the MSA General Ledger as required by an aggressive sales program.
- Completed beta site installations in locations as distant as Hong Kong.
Computer Project Leader
La. Dept. of Trans. and Development
02.1976 - 01.1985
- Developed and maintained the Purchasing, Inventory, Weights and Permits, and Real Estate Acquisition Management systems using CICS/DLI, VSAM and COBOL.
- Managed the projects to develop these systems
- Managed as many as five programmers.
Education
B.S. - Computer Science
Skills
- ETL processes
- Customer support
- SQL proficiency
- Relational databases
- System monitoring
- Database design
- Backup and recovery
- Data warehousing
- Network administration
- Database administration
- Data migration
- Database security
- Data modeling
- Performance tuning
- NoSQL databases
- Business intelligence
- Software development
- Big data management
- Query optimization
- Operating systems
- Data privacy compliance
- Version control
- Data integration
- Python programming
- Quality assurance
- Troubleshooting
- Master data management
- Report development
- Data security
- Statistical analysis
- Machine learning
- DBMS
- Infrastructure allocation
- Data resource management
- Data architecture
- Information integrity
- Teamwork
- Teamwork and collaboration
- Problem-solving
- Problem-solving abilities
- Time management
- Multitasking
- Multitasking Abilities
- Excellent communication
- Organizational skills
- Team leadership
- Attention to detail
- Adaptability and flexibility
- Self motivation
- Time management abilities
- Data visualization
- Decision-making
- Team collaboration
- Effective communication
- Active listening
- Critical thinking
- Problem-solving aptitude
- Reliability
- Adaptability
- Professionalism
- Interpersonal skills
- Team building
- Strategic planning
- Relationship building
- Linux operating system
- Analytical thinking
- Task prioritization
- Analytical skills
- Interpersonal communication
- SQL programming
- Written communication
- Continuous improvement
- Goal setting
- Object-oriented programming
- Server management
- Data analysis
- Project management
- Data recovery
- Data management
- Database development
- Technical documentation
- Systems administration
- Implementing security measures
- Database maintenance
- Python
- Compiling data
- Data encryption
- Disaster recovery
- Continuous process improvement
- Professional demeanor
- System analysis
- Running backups
- Relational database management
- Infrastructure planning
- Information protection
Timeline
SQL Database Manager - Delaware Nation Industries
12.2023 - 09.2025
Database Manager/Data Architect - NTT Data Services
08.2017 - 12.2023
Senior SQL Server DBA – DBA Team Lead - Unisys Corp.
10.2015 - 08.2017
Senior SQL Server DBA – DBA Team Lead - Hewlett Packard Corporation
06.2012 - 10.2015
Senior SQL Server DBA - DBA Team Lead - Unisys Corp.
03.2007 - 06.2012
Senior SQL Server DBA - Sysdba Corp.
11.2006 - 03.2007
Database Administrator - Ceridian Corporation
04.2002 - 11.2006
Senior Database Administrator - American Financial Group
04.1997 - 04.2002
Support Analyst - Geac Host Technologies
11.1994 - 04.1997
Staff Programmer - IBM Corp.
12.1988 - 11.1994
Senior Software Engineer - Management Science America, Inc.
01.1985 - 12.1988
Computer Project Leader - La. Dept. of Trans. and Development
02.1976 - 01.1985
University of Southwestern Louisiana - B.S., Computer Science